Zen Cart Logo
Forums / Currencies & Sales Taxes, VAT, GST, etc. / Enable TAX in ALL products?

Enable TAX in ALL products?

Locked

Views: 2,457

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
13 Oct 2008, 8:14 PM
#1
tristarcctv avatar

tristarcctv

New Zenner

Join Date:
May 2008
Posts:
3
Plugin Contributions:
0

Enable TAX in ALL products?

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

13 Oct 2008, 8:31 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Enable TAX in ALL products?

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 ...

13 Oct 2008, 8:37 PM
#3
tristarcctv avatar

tristarcctv

New Zenner

Join Date:
May 2008
Posts:
3
Plugin Contributions:
0

Re: Enable TAX in ALL products?

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

14 Oct 2008, 3:34 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Enable TAX in ALL products?

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