Applying Tax Classes Simultaneously to All Products

[StrictlyAutoParts]

Hey Everyone,

I just finished making tax classes for my online store in Canada.

My question now is "how do I apply the new tax classes I just created to all my existing products that have a different tax class set to it?"

Is this possible?

Help would be appreciated before I go and do it one by one (keeping in mind i have hundreds of products)


Cheers!

[Ajeh]

Browse the tax_class table in phpMyAdmin and locate the tax_class_id for the OLD tax class and the tax_class_id for the NEW tax class ...

To update all products with the OLD tax_class_id to the NEW tax_class_id you can use:

UPDATE products SET products_tax_class_id = NEW## WHERE products_tax_class_id = OLD##;

Be sure to backup your database before doing this ...

[StrictlyAutoParts]

Hey,

thanks for the reply..


I'm pretty bad at this stuff myself so if you can explain it in an even more basic term..


When I'm in "myphpadmin", I click on my store name which gives me a breakdown of everything in my cart.

Then from there I choose: (browse) carttax_class ?

Then when I click browse on "carttax_class" it gives me a bunch of the tax classes I made. How do I choose just one of them to update my whole catalog??


Thanks in Advance!

[Ajeh]

Can you look in the configure.php file, on the server, and see what your database prefix is set to? Are all of your tables prefixed with:
car

What Tax Classes do you have defined in the Zen Cart Admin for:
Locations / Taxes ... Tax Classes ...

[StrictlyAutoParts]

Hey,

My database prefix is set to:

define('DB_PREFIX', 'cart')

[StrictlyAutoParts]

My Tax Classes are as followed:


Tax Classes

ID Tax Classes Action
1 GST
4 GST/HST/PST Class Info
3 GST/PST Info
2 PST Info


The one I just inserter and want to use is the: GST/HST/PST Class


Thanks in Advance!