Change Tax Class globally

27 Nov 2006, 9:27 AM

New Zenner

Join Date:: Apr 2006
Posts:: 10
Plugin Contributions:: 0

Change Tax Class globally

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

27 Nov 2006, 1:51 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Change Tax Class globally

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