Main currency change without manually updating every product price

[MrrD]

Hi!

 

My country is changing official currency to euros on 1 january 2014.

Is there any way to change a default currency in Prestashop (1.4) without updating/changing every product price manually after that, maybe somehow through DB or module?

[MrrD]

Anyone?

[didje3]

Im have the same problem

[El Patron]

there are mass update module on addon's there might also be mass update modules by third party developers.  Personally I don't know how anyone with more than a handful of products can manage a shop without a mass update module.

 

here is an example from search (but there are several more so make sure to look around)

http://addons.prestashop.com/en/bulk-update-prestashop-modules/5013-mass-update-price.html

 

and of course you could do this with mysql commands but you may find in the long run having a mass updater useful for day to day operation of your shop

[benjamin utterback]

Store Manager is probably the best module because it does mass updates along with many other things. I personally recommend it and vouch for the support of eMagicOne. Check it out here, http://addons.prestashop.com/en/administration-tools-prestashop-modules/2937-store-manager-for-prestashop.html

[vekia]

and what about mysql query? you can change price for all products with one query

for example 1lvl costs 1.43€

UPDATE ps_product_shop set price =price*1.43

you can do the same with ny other "price" field, remember about special prices (for products) and other tables, where the price field appear, for example - voucher codes