Magento Coupon codes although deleted already, doesn't allow to create coupon with same code again

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-


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.

Similar questions

Products deleted after Attribute set was deleted
Well, this is what happened: I created a new Attribute set called "Nuevos Productos", then I added 20 products to that set. After that, I deleted the set by mistake and all the products were deleted too. How can I solve this!? Thanks!
my magento site hacked again and again
i m so so sad my site hacked 2 times yesterday . i m trying to search a developer for this but all are telling me they can't guarantee about the security i m not sure what to do next. You guys have a experience like this ? please help me if you have a answer for this i m very disappointing about my situation i have completed whole website and now i...
Cookie displaying popup again and again Magento-2
As no one helped me before. That's why I am asking again for help in creating a cookie that help to display popup only one time. What should I change in this script so that it displays popup only one time? I am using the following code ; Any help and consideration is appreciated
Magento 2 showing notification again and again even after page refresh
Magento2 Notification is showing again and again even after page refresh while should show only one time and should hide on page refresh. Please anybody can help to fix this.
Requested store is not found Magento\\Framework\\Exception\\NoSuchEntityException site shutting down again and again with this error
My magento 2.2 is going down again and again when i see log files i see this error main.CRITICAL: Requested store is not found {"exception":"[object] (Magento\Framework\Exception\NoSuchEntityException(code: 0): Requested store is not found at public_html/vendor/magento/module-store/Model/StoreRepository.php:109)"} [] i have trie...
Magento site is down again and again
My Magento site was down yesterday don't know the reason. But after searching i found manually clearing the files in cache /var/cache/ and session /var/session/ directories solve the problem. My problem is, the site is down again today and again i cleared these directories solved the issue. I need a permanent solution for this please help.

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.