Product Tax Classes

[Chadduck]

Sometime back when I first started setting up OSC v4 I discovered that ALL of the products were displaying (in the front end) the prices including sales tax.  As a very uninitiated beginner with the software I discovered that the way to eliminate the prices from doing this was to ensure that they didn't indicate a tax class.  While this solved the immediate problem (at the time) it has now become BIG headache since all the products now have a tax class of - - none - -.

So now that I have the Tax zones, class, and rates in place - IS there a simple SQL command that be issued to change ALL of the 5000+ products products to the Taxable Goods label in one command? OR must it be done individually?

BJ

Edited May 2 by Chadduck

[Chadduck]

RESOLVED

After tinkering around within phpMyAdmin and the Products table I was able to construct an SQL query that worked for my Sales tax.  The command I used was

UPDATE `products` SET `products_tax_class_id` = '6' WHERE `products_tax_class_id` <> 6;

Bear in mind that YOUR tax tables may, and probably will, use a different `products_tax_class_id` value.  You'll likely need to pick a product within YOUR store assign it the correct Tax Class.  Then check what the value is in the products table of your database for the product that you changed.  Then change another product manually in the table and verify that it worked within the Store's admin for that product. 

Once you know what the correct `products_tax_class_id` SHOULD BE simply use the command above substituting YOUR value for the value that I used.  In other words

UPDATE `products` SET `products_tax_class_id` = ' [YOUR VALUE] ' WHERE `products_tax_class_id` <> [YOUR VALUE] ;

Make certain that you remove the extra spaces that I inserted before and after [YOUR VALUE] .

GOOD LUCK and I hope that this HELPS someone.

BJ

Edited May 3 by Chadduck