Magento – Canada Tax Rule Set up – Magento CE 1.9.0.1

ce-1.9.0.1

I have followed instructions (http://www.magentocommerce.com/knowledge-base/entry/ce18-and-ee113-tax-config-ca) to create Canada GST, HST (ON, NB, NF, & NS), then tried to create tax rules.

Whenever creating GST (HST) rule, or BC-PST rule, I received the following error even though definitely there is NO tax rule exists.

"Rules () already exist for the specified Tax Rate, Customer Tax Class and Product Tax Class combinations"

I really appreciate if anyone can help.

Best Answer

The existing answers regarding orphaned entries in the tax_calculation table are absolutely right. But there is missing practical information how to get rid of them.

You can show the orphaned entries with the following MySQL query:

SELECT * FROM `tax_calculation` WHERE `tax_calculation_rule_id` NOT IN (SELECT `tax_calculation_rule_id` FROM `tax_calculation_rule`);

You can then delete them with:

DELETE FROM `tax_calculation` WHERE `tax_calculation_rule_id` NOT IN (SELECT `tax_calculation_rule_id` FROM `tax_calculation_rule`);
Related Topic