johnxl Posted January 29, 2014 Share Posted January 29, 2014 (edited) From 1st January our country is using new currencie - EURO. Thats why in my store for six months must be two currencies Latvian Lats and EUROS. Now when clients open my site,they see default currencie - Latvian Lat But i need EURO in start page In back office when i am trying to switch Euro as default currencies , all prices calculates wrong ! Thats why i must rewrite all 400 product prices manually Is it possible to do something with that? Thanks ! Edited January 29, 2014 by johnxl (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 29, 2014 Share Posted January 29, 2014 you can change prices with one sql query, but the question is for what kind of prices you want to change it. i suppose that something like this: for example, you've got product with actual price 30 latvian lats, now you changing default currency to EUR. It's time to run query now. 1 lat = 1.43 eur - you wan to change price to: 30*1,43= 42,94 am I right? Link to comment Share on other sites More sharing options...
johnxl Posted January 30, 2014 Author Share Posted January 30, 2014 Example-!N ow I've got a default price 7.03 LVL ! In Euros it is 10 € ! When change default currencie to euro- now it shows default curencie euro - 7.03 € and 4.94 Lats. But i need 10 € and 7.03 Lats ! Link to comment Share on other sites More sharing options...
vekia Posted January 30, 2014 Share Posted January 30, 2014 that's why you have to run some sql query to increase "prices" depending on simple math calculation price_now = 7.03 price_after = 10.00 currency rate = 1.42 price_now * currency rate = price_after so we have to increase all prices (for each of product in your store) in that way Link to comment Share on other sites More sharing options...
johnxl Posted January 30, 2014 Author Share Posted January 30, 2014 Thanks! Could you please explain,detailed what I must do? Link to comment Share on other sites More sharing options...
Aurianna Posted December 8, 2015 Share Posted December 8, 2015 Hello guys My currencies dosen't work and I don't know how to fix it because it use to work before Link to comment Share on other sites More sharing options...
Recommended Posts