Originally Posted by
Absolute
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:
Code:
update products set products_price = products_prie * '1.5';
Obviously use your own conversion rate, where here I've used a rate of 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
Ok, so just to be sure. If all my porducts are in skk and one skk is 30.126 € than I will have to run
Code:
update products set products_price = products_prie * '0.03319393';
Is that all right? And also, is 1.7 MB adequate size of whole database backup?
Bookmarks