Update product tax rules via database

[pgazda]

Is it possible to update tax rules for all/most product via database?

I have tried to change "id_tax_rules_group" in "product" table but the change is not reflected in backoffice.

 

Prestashop version 1.5.3.1.

[pgazda]

I'll answer myself. It is not enough to just update ps_product table, also ps_product_shop table has to be udpated.

 

To change tax groups for all active products the sql queries would be:

UPDATE ps_product SET id_tax_rules_group = 1 WHERE active = 1;
UPDATE ps_product_shop SET id_tax_rules_group = 1 WHERE active = 1;