How to change all prices to different currency?

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:

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

Quote:

---

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?

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.

Code:

---

update products set products_price = products_prie * '30.126';

---

This means if you had a product for 1SKK, then it would be on the site for 30.13€.

Absolute

Quote:

---

Originally Posted by 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.

Code:

---

update products set products_price = products_prie * '30.126';

---

This means if you had a product for 1SKK, then it would be on the site for 30.13€.

Absolute

---

Oh, sorry. I wrote it wrong. One Euro is 30.126 SKK!

And how about size of my backup? Is it ok?

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

Quote:

---

Originally Posted by 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: