fixed sales account across site?? is this possible?

[Graveyard666]

I set up the tax zones properly, but when i entered an item into the db i didn't specify it as a taxable good

 

now that i have over 1000 items and have been online for almost 2 yrs with osc i was wondering if its possible to make all items taxable if the user lives in the state of wisconsin without having to go back and change all the "taxable good" settings per item??

[Guest]

you can run a single sql query to update all the products for the products_tax_class_id

 

example:

update products set products_tax_class_id = 1

 

make sure the identifier is valid and represents the tax class you want to assign to all products.