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ė