Hi,
I have to change all the prices in my eshop to different currency. Is there some easy way how to change all at once or do I have to do change price on every product in administration?
Thanks, I really need it!
Printable View
Hi,
I have to change all the prices in my eshop to different currency. Is there some easy way how to change all at once or do I have to do change price on every product in administration?
Thanks, I really need it!
The quickest way is to run and sql patch on the WHOLE database.
YOU MUST BACKUP YOUR DATABASE FIRST
Go to Tools >> Install SQL Patches
Then run the following:
Obviously use your own conversion rate, where here I've used a rate of 1.5.Code:update products set products_price = products_prie * '1.5';
Next, just set the default currency to be which ever currency you have chosen to use.
Please note: This is a general how-to and is given as a hint, not a complete solution. I only say this because I don't know your exact circumstances. Please ensure you realise the consequences of using this solution before you run the patch.
Absolute
If you're converting from Euro to SKK, then that is fine. If you are converting from SKK to Euro, then you want to convert the other way.
This means if you had a product for 1SKK, then it would be on the site for 30.13€.Code:update products set products_price = products_prie * '30.126';
Absolute
Database backup size could be right. Depends on how you are exporting, and the type of SQL statements you are using.
The SQL looks fine if that is the corrected exchange rate.
Absolute
Ok, I put it there and I got just this.
1054 Neznáme pole /unknown field/ 'products_prie' v 'field list'
in:
[UPDATE zen_products set products_price = products_prie * '0.03319393';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Ah, looks like only problem was that you left "c" in price. Now it works! Realy thank you, this is awesome. I was trying to do that for long time and this is very easy! :clap: