help setup authorize.net, currencies, SQL query maybe?

[David Dotou]

hello i have prestashop 1.6 i'm trying to setup autorize.net module from the prestateam but i'm having some problems setting up obviously;

i'm sure i'm using the right api login and transaction key;

i tried setting up the curl values in validation.php and authorizeaim.php but it's not working i get the message AIM error message wrong merchant id etc... ....

so also i also configured my api login and transaction key in the validation.php

still not working

i'm not familiar with php if i could get some help to setup please

thanks alot

Edited April 14, 2015 by David Dotou (see edit history)

[bellini13]

why not reach out to the author of the module for support?

[David Dotou]

hello bellini13 it is a module by prestashop so i thought this is the correct place to get some help since it is the prestashop/forum

i would like to contact who developed the module for help but since there's no contact info on the module just says by prestashop here I am looking for answer on how to setup this module

Edited April 11, 2015 by David Dotou (see edit history)

[bellini13]

Prestashop does not provide development support on the forums, but there are contact options to contact them.  I would suggest you contact them for assistance

Edited April 11, 2015 by bellini13 (see edit history)

[David Dotou]

ok so i filled contact form on prestashop, does anyone know of an authorize.net module that i can pay for maybe?

[bellini13]

a simple google search and you will find them

https://www.google.com/search?q=prestashop+authorize.net+module&ie=utf-8&oe=utf-8

[David Dotou]

yes of course gogol i was asking if someone tried one in particular and could say it worked anyway i guess i sort of solved this by buying a paid authorize.net module and i ran intonew error haha this never stops does it??

here's the load i setup my shop in euro  but my merchant account in authorize.net is  usd account right so i have changed shops default currency so the card could go through but all my prices fluctuacted everything thats' in euro went down what was 1 is now 0,94, i tried changing currency rate manually it worked 5 minutes then prestashop set back it automatically i guess i was causing a little problem in the system...

so i'm looking for an sql query maybe to help me fix all my prices back the way it was thanks ahead!

Edited April 14, 2015 by David Dotou (see edit history)

[David Dotou]

trying to figure this out here i found a long way to resolve this i think i have to go to each product then price take the price wich is now usd but is actualy my european price and mutliply it by usd exchange rate

so I take 1 euro x usd echange rate for each product all 300 wich is doable but how you guys do it with 10,000 products sql query maybe ?

hope i'm making myself clear.

thanks ahead

Edited April 14, 2015 by David Dotou (see edit history)

[David Dotou]

just found this How to make a bulk price adjustment using SQL in phpMyAdmin now lets figure out what i have to do to mutiply 1euro X USD exchange rate so 1,065..., i'm not very good in math or programing haha thanks for help!
 
http://www.inmotionhosting.com/support/edu/prestashop-15/340-mass-price-update
 
 

• Sample code to increase all prices by twenty percent (20%).
  UPDATE ps_product_shop SET price = price*1.20
  UPDATE ps_product SET price = price*1.20
  
  Sample code to decrease all prices by 15 cents (.25).
  UPDATE ps_product_shop SET price = price-.15
  UPDATE ps_product SET price = price-.15
  
  Sample code to increase all prices by fifty cents (.15).
  UPDATE ps_product_shop SET price = price+0.50
  UPDATE ps_product SET price = price+0.50
  
  Sample code to decrease all prices by ten percent (10%)
  UPDATE ps_product_shop SET price = price / 1.1
  UPDATE ps_product SET price = price / 1.1
• 
  Once you have entered a query with your desired price change, click the Go button at the bottom. This will activate the query and make the change. Your prices should now display with the new changes. Below is a before and after example of a price change where we increased the prices by 10%.
  
  
   

[David Dotou]

HEY ALL solved with this query in phpmyadmin all my prices back in place i still need o understand one thing if someone can shed light why is ithat when i browse my shop in euro and then i choose a prduct and want to go buy in euro it turns out as a dollar sign in the shopping cart ?

i think its because i set to shop crrency default but when i chosse the user currency option payment doesnt go through ...? i get a message syi i don't have exchange rate supported with autrize.net being number 1 payment solution it sounds hard to believe ???


FIX

UPDATE ps_product_shop SET price = price*1,065
UPDATE ps_product SET price = price*1,065

Edited April 15, 2015 by David Dotou (see edit history)