Zen Cart Logo
Forums / General Questions / Setting the TAX CLASS for multiple items at once

Setting the TAX CLASS for multiple items at once

Views: 981

Results 1 to 3 of 3
24 Feb 2011, 2:37 PM
#1
homer_j_simpson137 avatar

homer_j_simpson137

New Zenner

Join Date:
Aug 2010
Posts:
6
Plugin Contributions:
0

Setting the TAX CLASS for multiple items at once

OK, I started adding products and forgot to set the TAX CLASS to "Taxable Goods". I have since found out that I can set a default TAX CLASS for when entering in a new item but this doesn't help my current items. I now have over 100 products in my store and am wondering if there is a way to change all the product listings at once to have the TAX CLASS of "Taxable Goods". If not, I'm going to have to go to each product and make the change....WOW. Not looking forward to this.

Thanks for any help.

---Mike

24 Feb 2011, 2:47 PM
#2
dutchy avatar

dutchy

Zen Follower

Join Date:
May 2010
Location:
London
Posts:
324
Plugin Contributions:
0

Re: Setting the TAX CLASS for multiple items at once

try easy populate

24 Feb 2011, 3:48 PM
#3
ajeh avatar

ajeh

Oba-san

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

Re: Setting the TAX CLASS for multiple items at once

Check in the products table to see what the valid:
products_tax_class_id

is that you need ...

Then, if you want to change ALL Products in the products table to use this, backup your database and you can run the SQL:

UPDATE products SET products_tax_class_id = XX;

where XX is the products_tax_class_id that you need ...