I would like to share a case....
In the case that the VAT changes in a country but you want to keep the prices the same, the following steps must be taken in Prestashop because the "final" prices are not stored in the database.
For example if the VAT changes from 19% to 22% ....and want to keep the prices the same.
1. First step is to change the VAT from 19% to 22% through the administration (locality > taxes).
2. Then through phpmyadmin run if is a single store: UPDATE `ps_product` SET `price` = (`price`/1.22) * 1.19
or if is a multistore: UPDATE `ps_product_shop` SET `price` = (`price`/1.22) * 1.19
In the case that the VAT changes in a country but you want to keep the prices the same, the following steps must be taken in Prestashop because the "final" prices are not stored in the database.
For example if the VAT changes from 19% to 22% ....and want to keep the prices the same.
1. First step is to change the VAT from 19% to 22% through the administration (locality > taxes).
2. Then through phpmyadmin run if is a single store: UPDATE `ps_product` SET `price` = (`price`/1.22) * 1.19
or if is a multistore: UPDATE `ps_product_shop` SET `price` = (`price`/1.22) * 1.19