Enable TAX in ALL products?

[tristarcctv]

Can someone help me enable tax in ALL products in my catalog at once, rather than going back to each and every one and selecting TAX CLASS from drop down menu?

I'll really appreciate any help.

Thank you

[Ajeh]

Set one Product Manually to the right Tax ...

Check in the database table products and find that product and see what the value is for the:
products_tax_class_id

Once you know what it is, and you want to update ALL products in your shop to use this ID, you can run the following in the Tools ... Install SQL Patches ...

UPDATE products SET products_tax_class_id = XX;

where XX is the value for the Tax setting that you want to use ...

NOTE: backing up your database is always a good idea ...

[tristarcctv]

Wow. That worked like a charm. Thank you so much!

[Ajeh]

You are most welcome ... thanks for the update that you were able to reset all of your Tax settings on your Product ...