Batch Change Tax Category

[Guest]

Is there a way to change the tax category on every image via sql, and if so how can I do that via phpmyadmin?

I need to change it on literally everything in my store so it would take forever to do it the one-by-one way.

-James

[Guest]

Sure, in PHPMyAdmin, simply execute this:

UPDATE CubeCart_inventory SET taxType = ## WHERE 1;

Of course if you have a prefix to your table names, you'll need to insert that. Also replace the "##" with the ID of your new tax type.

As with all manual database mods, please backup your database first. I will not be responsible if you jack it up. ;)

[Guest]

Thanks!

UPDATE CubeCart_inventory SET taxType = 2 WHERE 1;

What I did was go to the

CubeCart_taxes table, and see what my tax ID was.

Then substituted that number for 2.

Thanks for the help.