Hello,
I currently have thousands of products in euro. I use only one currency in my shop.
I am about to move my shop to a different country where USD are only used. I would like to switch shop from euro to USD completely, no multi-curency selection on front-end. Creating a US dollars currency in virtuemart is not hard, but going through each product manually and changing product currency from euro to USD, considering that i have thousands of items, is insane.
My question is: is there a plugin or SQL command that would allow me to change currency for all products at once from euro to USD according to a specified exchange rate?
Thanks a lot and holiday greetings everyone.
On the Shop/Vendor tab change the shop currency to USD. The existing cost prices in the BE will show the price in Euro, but is converted into USD for other BE prices and display n USD on the front end.
but your product price will need to change as well or are u keeping a 1:1 €->$ price ?
then just in the xxxx_virtuemart_product_prices .. backup first
UPDATE `xxxx_virtuemart_product_prices` SET `product_currency`= 144
The product prices are automatically converted to the USD prices according to the exchange rates - which may change daily. I have used this for a client store where he buys almost all products in Euros, but retails only in GBP. He just has to enter the Eu cost price when entering products and VM does the conversions. Or for products bought in GBP he sets the cost currency for that product to GBP.
Quote from: GJC Web Design on December 22, 2015, 11:09:24 AM
but your product price will need to change as well or are u keeping a 1:1 €->$ price ?
No, unfortunately is not 1:1, so i guess I'll experiment with jenkinhill's suggestion.
Thank you guys :) I'll get back as soon as I'll complete the change.
you can also do a multiply query directly in the DB
Thanks a lot everyone, jenkinhill your advice worked perfectly.
Regards.