Deleting Old Coupon Codes?

[neparker]

We have been using coupon codes fine, but now we want to delete or clean up some of our super old ones so we can use them again - the same name for the code. Is this possible?

Simply deleting them doesn't really remove them.

[Ajeh]

You would need to do this in phpMyAdmin and look at the table:
coupons

You will find the Discount Coupons from the:
coupon_code

and you will see them marked as:
coupon_active

where N is the ones that are marked "deleted" or "expired" ...

[Ajeh]

NOTE: if you are deleting them in phpMyAdmin then you need to remove them from the:
coupons_description
coupon_restrict

before you do this ...

If you change the coupon_active to Y you can then change them via the Zen Cart Admin ...

[BlessIsaacola]

Ajeh,

I tried today to delete a coupon on the Admin side and it basically just changed the status to inactive instead of deleting it from the database. Any ideas?

Thanks!

[DrByte]

Ajeh,

I tried today to delete a coupon on the Admin side and it basically just changed the status to inactive instead of deleting it from the database. Any ideas?

Thanks!

That is by design.

[BlessIsaacola]

Thanks DrByte! In that case I need to go find a different thread to attach my issue. I was prompted to delete a coupon today when an expired coupon was accepted as valid by Zen Cart. I will go look for the best thread to pick up this issue.

Thanks!