coupons expired not showing inactive

I have expired coupons that are staying in the active list. I checked the DB and they are listed as "Y" under coupon active. :huh:

Which database table are you looking at?

This is a little confusing ...

If you have a coupon that expires ... while the table says it is active as in coupon_active = Y ...

That is for you to be able to edit, etc. as once coupon_active = N it cannot be edited ...

However, if I try to use that coupon ... it is evaluated on the date and will not be accepted and the customer will be told that it is expired ...

linda I believe you have had too much coffee because I read your reply many times and I am not sure what your are saying. Does a coupon expire on the experation date and set coupon_active to "N" on its own, when I check the coupon list in the admin or does someone have to try and use that coupon after it has expired and is denied to get the coupon_active to change from Y to N.

After reading your post again it appears that you are stating that if coupon_active=N then I shouldn't be able to edit it. Wrong, in my case, the one coupon that I have that does show as inactive in the admin and is also listed as coupon_active=N in the DB is still able to be edited.
I assume it is still able to be edited so that I could change the dates and use it again if I wanted.

coupon_active becomes N only when you "delete" a coupon.

otherwise, expiration dates rule its usability by customers

NOTE: once you Delete the coupon to Inactive or N ...

You can hit Edit ... but never return it to Active or Y ...

Does that make more sense?

coupon_status? I thought we were talking about coupon_active.:huh:
Wouldn't "deleting" the coupon make it disappear, not just move to inactive. The coupon that shows in my inactive list in the admin went there all by itself I didn't move it, couldn't if I wanted to from the admin, and I know I wasn't in the DB playin' around.
So the question is - When a coupon expires on the date that I set does it become "inactive" and then does it show on the inactive list?
If the answer to that question is yes to both parts then the next question is - How come coupons that I have that have expired are not in the inactive list, they are still in the active list (I do realize that if someone tried to use them they would be denied based on ther expiration date).

coupon_active long night ...

Deleting just masks or hides the Discount Coupon ...

What if you made a coupon 2 months ago that expired a month ago and a customer complaining etc. you need a way to see, read etc.

For record keeping, Discount Coupons expire but they are not physically deleted or really removed for future reference ...

So you don't need to see them, you can Delete or set to Inactive ...

ok, thanks Linda got it now. Missed your post while I was typing. I now uderstand how it works. I see that inactive coupons is more of an archive of old coupons to be used as a history of coupon activity

There you go ... that is a good summary ... glad you have a better understanding of this now and so does everyone else ... thanks! :smile:

see what happens I keep typing and missing your posts:blush:
Thank to you guys for the thorough explanation. I suppose what was confusing was that all options are still available for the inactive coupons (email, edit, delete...etc)

I will have to look into that for a future release to protect you from yourself ... :cool:

protect me from myself! I think you should be trying to figure out how to protect yourself from all my typing.:lol: Now that I got myself a laptop I can ask questions anytime the mood strikes me:yes: So off I go to come up with some more :lamo:

Sorry to drudge this up... but I am confused.

I get what you are saying, with how it is SUPPOSED to work... but I'm confused with what actually happens.

See... I have NEVER "deleted" a coupon - never. Never hit that button once. Yet, I have 12 "inactive" coupons.

I also have 22 "active" coupons - most of which are expired and/or fully used.

So when does it automatically move them to inactive?

• Steven

Also - entering in an "inactive" coupon code into the discount_coupon page still shows all the info for that coupon. What exactly is the difference between active and inactive then?

To me, and I think others would agree, "inactive" should be any coupon that can't currently be used - either because the admin set it to inactive, or it has expired. I also suggest that any coupon should be able to be active again simply by changing the dates and/or setting its status back to "active".

Just suggestions.

• Steven

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.

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" ...

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 ...

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!