turn on tax option for all products at once

[spencermjax]

I have a store already set up with about 1500 products. I currently do not have the tax feature set on any of the products. If I wanted to activate that, is there an easy way to "flip the sitch" for the different categories without having to go into each product individually?

 

Example:

Tax is not selected on any products

I have 3 categories (diamonds, rings, necklaces)

I want all products in category rings and category necklaces to have the tax applied.

I do not want to go to each product an select from the dorpdown box to apply tax to that item.

 

Can it be done straight through the database with an SQL statement that would activate the tax option for all products in category B & C but not A.

 

I hope I have been clear & not too repetitive.

[Guest]

I have exactly the same question. I also would be interested in advice anyone has regarding this matter.

[Guest]

yes, you could do:

update (products_to_categories p2c left join products p on (p.products_id=p2c.products_id)) set p.products_tax_class_id = 1 where p2c.categories_id in (4,10)

 

just specify the correct categories identifiers applicable to your store.

[spencermjax]

and in what file would I do that?

[Guest]

using the phpmyadmin tool or if you have already a module that processes queries with osc admin you could simply execute it.