Mass tax class change?

Hello,

Was just wondering if there is an easy way to make sure ALL products are TAXABLE GOODS by default. I've already set it up so it selects it automatically for new products but I just found that there are many products that still have NONE selected. Is there an easy way to change this on all products without going into each product?

Thanks! :P

Using Easy Populate, download your database, edit it locally (copying and pasting the tax class) and upload it back to the live site. It's very quick and easy. Read through the EP support thread first if you've never used it before.

Rob

Alternatively you can run an UPDATE query in SQL on the table/field that you want to change. It may save you time and frustration of installing a mod...

ooh thanks for your replies :)

I'll look into the easy populate mod.

I'd do it with SQL but don't know how to write queries.

UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;

<3

thanks so much!

So do I go to: Admin > Tools > Install SQL Patches the paste into the "Enter the query
to be executed:" box then click Send? I just want to be completely sure. And yes I've backed up my site and database. THANKS!
UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;