Change General product page to mark ALL items as taxable

[carlwert]

Does anybody know how to make all items in the store as taxable without going into the product general page and changing each one at a time.

[llegrand]

If you are comfortable working directly in your database  you can change it there with an SQL statement

The table  is (your prefix) _ products
the field  is tax_class_id

1 indicates taxable if you haven't changed your tax classes.

Please remember to make a backup of your site BEFORE starting any changes.

[carlwert]

Thanks for the help. I can issue an SQL statement, can you tell me what I need to say in SQL statement? Thanks again....