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?

3 Answers 3


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.

  • I don't exactly know how to use this information to accomplish what I'm after, but I'll play around some more and report back. thanks
    – user9435
    Commented Jun 21, 2014 at 1:01

Please try using the following method, but it does require some digging and know what you are doing. It will put the "select all" option to select the whole page instead of checking them one by one.


If you need tax rate tables, check out https://www.woosalestax.com. They have formatted tax rate table for all the U.S. states. Hope this help.


Please use the following script.

function deleteTaxRate() {

try {

    foreach (Mage::getModel('tax/calculation_rate')->getcollection() as $rate) {
        echo 'Tax Rate Deleted : '.$rate->getId();
catch (Exception $e) {
    echo 'Delete tax rate failed '.PHP_EOL;
    echo $e->getMessage();


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.