bulk "tax class" amendment

[ptholt]

I have about 4500 products in my store and have created a new tax class, however as the products were imported prior to this they are all set to a tax class of "none"

 

is there an sql query i can run against the db to change all products to a tax class of taxable goods to save editing each product?

 

thanks

 

Peter.

[ptholt]

I have about 4500 products in my store and have created a new tax class, however as the products were imported prior to this they are all set to a tax class of "none"

 

is there an sql query i can run against the db to change all products to a tax class of taxable goods to save editing each product?

 

thanks

 

Peter.

 

 

After much googling managed to find the answer to my own question so thought i would post here -

 

UPDATE `products` SET products_tax_class_id = 'xxx'

 

where xxx should be the id for the tax id you wish to use.