Sales Tax not working

[cathobby]

I have my cart set up to charge sales tax in my home state but it is not doing so in the orders that have come in.
This is becoming a problem because I can not change the amount the person authorized on their credit card and I am having to pay the tax myself! HELP!!!

[Jamie]

Tax is only applied to categories that have the "tax items" field set to yes. It looks like none of your categories have this set.

-Jamie

[cathobby]

Ok, now my next question is how to I mass set the fields to yes? I have over 2K categories, I can't do it one by one!!!!!
Any suggestions??

[Jamie]

Hi,

You can do that via a MySQL query:


UPDATE Categories SET Tax_Items = "yes";

If you have phpMyAdmin, paste the query in the Query field, and click submit. If you have direct shell access to MySQL, just enter the query at the MySQL prompt and hit enter.

Thanks,
Jamie