I am not sure if it's some kind of core-logic(unknown to me) or a bug maybe, but even though I have already deleted a coupon-code rule from "Shopping Cart Price Rules", when I search in the "salesrule_coupon" table the deleted coupon code, it still shows up.

What happens due to above scenario is that if I try to recreate the coupon-rule with same code, it doesn't allow me to do so and shows below message:

Coupon with the same code already exists.

Please enlighten me anyone and let me know how to delete coupon-rule with code completely and uniquely, so I can create coupon with same code again.

My magento version is ce-

  • I can't reproduce this in - I create the coupon rule with coupon TESTCOUPON, apply the coupon to cart to test it. Delete the coupon rule, reset cart. Add the coupon rule again with the same coupon name TESTCOUPON. I see no errors.
    – paj
    Sep 14, 2015 at 13:36

1 Answer 1


If its not showing up anywhere else other than the table, I would change it in the table -- not delete it -- to something unique. Maybe put a few numbers at the end. Random stuff. That should take care of it.

Your Answer

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

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