Product Tax class

[canemasters]

I was noticing that my customers in Nevada were not being charged sales tax automatically. I checked my zones, everything was right. Then I noticed that every one of my products tax class was set to "NONE". So I set one to "TAXABLE GOODS" and did a test order to see if it would charge me tax. Well, it did it correct, but then I realized that All 200+ of my products need this done as well.... !!!!!
Is there any way to set all of the products on my site to "TAXABLE GOODS" without visiting each and every single product? Maybe a little sql db script or something??

Thank you.

[Kim]

Somewhere on the forum is the SQL to do a bulk update of the tax. A search should find it.

[canemasters]

This worked for me.


UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;

Just throw that in under tools / Install SQL Patches. Worked like a charm!