Tax is charged on top of the product price including tax

[HAIRWEBSHOP]

Hello,

We just migrated from WooCommerce to Prestashop.

 

It would seem that all prices have been migrated including tax.
If we want to add a tax rule of 21%, it will add up to the final price, instead of just calculating it.

 

Would it be save to decrease prices by 21% using SQL?

Edited April 21, 2016 by HAIRWEBSHOP (see edit history)

[HAIRWEBSHOP]

I tried using:

UPDATE ps_product_shop SET price = price / 1.21;
UPDATE ps_product SET price = price / 1.21;

Which works fine for single products, but for product with combinations, it has no effect.

[HAIRWEBSHOP]

Nevermind, I found the other tables as well.
If anyone here experiencing the same problem, here's a solution using SQL:

 

1.21 = Reduce price by 21%

 

Update percentage price for products
 

UPDATE hw_product_shop SET price = price / 1.21

UPDATE hw_product SET price = price / 1.21

 

Update percentage price for products with combinations

 

UPDATE hw_product_attribute_shop SET price = price / 1.21

UPDATE hw_product_attribute SET price = price / 1.21

Edited April 21, 2016 by HAIRWEBSHOP (see edit history)