Taxable Goods problem

[joshlfisher]

When I initially added my items I forgot to select taxable goods. I now need to add that flag on all my products. My thought is that it would be best to do a database edit to change this, but I am unsure of the syntax to use. Could someone help me out with the SQL for this?

[Ajeh]

Double check and manual set 1 Product with the right Taxable goods ...

Peek in the products table via phpMyAdmin and see what the setting is for the field:
products_tax_class_id

10 to 1 this value is 1

If so, you can run this command in the Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=1; 

where 1 is the value you saw in the Product you set manually ...

[joshlfisher]

Marvelous! Thanks!