Database query needed to update tax rule for a product

[jamess]

Hi there,

I only have one tax rule, but all 380 of my products that were imported are not set to it. I'd like to batch set them. I had read to update id_tax_rules_group in the products table, but doing so did not update my products.  Right now if I open and save them, they are updated, but that's going to take a while. Any ideas?

Best regards,

James

 

[triplei]

I know this is a late answer to this question.  But I just had the same issue and I wanted to contribute in case someone else has this problem.  You will find another table called

ps_product_shop  there you will see "id_tax_rules_group"; you can change your tax rule defaults for each product here.

 

Thanks,

AutoInclude.com Support Team

Automotive Business Directory