Change all products to taxable goods

[tootie_rutz]

Is there a way to "flip a switch" and all products would have a tax class of TAXABLE GOODS. They are currently set to NONE.

Any ideas?

[barco57]

you need to run the following query in phpmyadmin

UPDATE `zen_products` SET `products_tax_class_id`=1 WHERE `products_tax_class_id`=''

the zen_ maybe needed to be changed to match the prefix on your tables
that would be two single quotes

[Ajeh]

Personally, I'd cheat on this ...

If you want ALL products to be taxable ...

Go to Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=1; 

This will fix it with or without prefixes as it is built to manage that for you ...

[kgmmusic]

Tried Ajeh's SQL patch and it worked for me.

Thanks a million!!!

[PaulineNMU]

<3 <3 <3!

[CnTGifts]

That didnt work for me

[DrByte]

That didnt work for me

Then your active tax class isn't number "1". Change the "1" to whatever your active/desired tax class is.

Or just change every product manually.

[Get Em Fast]

Personally, I'd cheat on this ...

If you want ALL products to be taxable ...

Go to Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=1; 

This will fix it with or without prefixes as it is built to manage that for you ...

Thanks Ajeh, this also works GREAT to remove the tax class on a vast amount of products if you change the 1 to a 0 like:

UPDATE products SET products_tax_class_id=0; 

[kmichel]

Ajeh, you rock!!!! muchas, MUCHAS gracias!!!!!

[Terra1069]

Oh I love you!!! Thank you so much! It worked like a charm!!