I am updating my sales tax rules and running into an issue I have never seen in 3 years of working with Magento. I first deleted all my Tax Zones and Rates by using DELETE FROM `tax_calculation_rate` It successfully imported the new rates through Magento.
I delete the old Tax Rule as a precausion. I create the new tax rule and highlight all the tax rates. Upon saving, it says “Code Already Exists”, and only about 100 tax rates stay highlighted. I have confirmed in my CSV file that there are no duplicate tax rates.
Does anyone have a clue how to fix this? Thank you for your help.