Change Tax Class globally

[Uwantit]

Hello,

I have all my products set up to tax class - none- for the moment. As my business has now grown I will need to charge 10% GST on all items sold in Australia. I have set up the tax so that all new products added now calculate GST/TAX. Does any of you have a SQL statement that can change data in MySQL in one go???

Please respond asap.

If you want to send me an email on [email protected] then please do.

cheers all

[Ajeh]

Edit one product and set it correctly ...

Go to phpMyAdmin and check products table for that products_id and see what the setting is for:
products_tax_class_id

Now you can use in the Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=XX; 

Where XX is the value you saw on the products_id you edited for the products_tax_class_id value