Need help with Tax Rates and SQL

[pleitch]

After finally figuring out how taxes work, thank god, I made a horrible, horrible, horrible mistake.

I had multiple tax classes that had been set up by somebody else (wrongly) when only one was needed. Well I deleted the extra ones, but now all my tax rates disappeared from the tax rates pages.

I'm assuming, and hoping, it is because they are all suddenly not associated with a tax class so they aren't being displayed.

This is my first Zen Cart install so the table names, etc are still foreign to me. Is it possible to reassign a tax class via the SQL tool to the now invisible tax rates?

[DrByte]

How did you delete them ?

[pleitch]

Through the admin interface. Highlight row, delete button in sidebar.

I deleted it all didn't i? ugh.

[DrByte]

Hmmm ... at one time I thought there was a safety on that so you couldn't delete a class if there were rates tied to it. But ... the safety seems to be missing.


To stitch it back together, try running this SQL statement via Admin->Tools->Install SQL Patch:

INSERT INTO tax_class (tax_class_id, tax_class_title, tax_class_description, date_added) VALUES (1, 'Taxable Goods', 'The following types of products are included: non-food, services, etc', now());

[pleitch]

Thank you. Finally a visit from a Dr that didn't involve me having to cough for him.

You're the best DR ever.

I was able to retrieve the invisible tax rates by creating tax classes with ID's between 2-6.

thanks so much.