Magento – Mass Delete Tax Rate

tax

Is there a way to mass delete tax rates from Magento backend?

The Magento documentation shows that in Magento GO, each tax rate has a checkbox that you can use to mass delete rates. http://www.magentocommerce.com/knowledge-base/entry/deleting-tax-rates. This checkbox doesn't appear next to tax rates on my Magento Community edition.

When I import new tax rates, they don't overrwite the current tax rates, they create new ones. This has resulted in thousands of tax rates. I want to clear them all out and start from scratch.

Is there a way to edit the database to clean out the tax rate information?

Best Answer

There are 5 tables with all rates.

Im not sure what happens with old orders, and what you wanna do with that.

but can you can truncate this tables, and see if that fix your problem.

tax_calculation     
tax_calculation_rate
tax_calculation_rate_title
tax_calculation_rule
tax_class
Related Topic