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: