Setting the TAX CLASS for multiple items at once

[homer-j-simpson137]

OK, I started adding products and forgot to set the TAX CLASS to "Taxable Goods". I have since found out that I can set a default TAX CLASS for when entering in a new item but this doesn't help my current items. I now have over 100 products in my store and am wondering if there is a way to change all the product listings at once to have the TAX CLASS of "Taxable Goods". If not, I'm going to have to go to each product and make the change....WOW. Not looking forward to this.

Thanks for any help.

---Mike

[dutchy]

try easy populate

[Ajeh]

Check in the products table to see what the valid:
products_tax_class_id

is that you need ...

Then, if you want to change ALL Products in the products table to use this, backup your database and you can run the SQL:

UPDATE products SET products_tax_class_id = XX;

where XX is the products_tax_class_id that you need ...