Prestashop update all prices with SQL (fully working)

I had to update all prices of shop made with PrestaShop. Found some tutorials where in that crazy database prices are saved, but none fully working example in one place. I was updating from prices written in Lithuanian Litas to Euros. 1 Euro = 3.4528 Litas So my solution:

UPDATE ps_product_attribute_shop SET price = price * 0.2896200185356812
UPDATE ps_product_attribute SET price = price * 0.2896200185356812
UPDATE ps_product_shop SET price = price*0.2896200185356812
UPDATE ps_product SET price = price*0.2896200185356812

Cheers! You can visit the shop here: Gerų indų parduotuvė

No comments:

Post a Comment

You can ask IT questions in comments!