coupons expired not showing inactive

[CoolCarPartsOnline]

What if the coupon is inactive and you change it's status to active in database "coupons table"? shouldn't that make it work again? Is there any other tables that effect the coupons?

Note: Coupon has categories restrictions.

[Ajeh]

If you manually were to change the Discount Coupon to Active where Status reads: Y

then it would come back to life one day ... just like Frosty ...

err ... umm ... yes it would then be able to be made Active and current when the expiration date is fixed ...

[CoolCarPartsOnline]

Thanks

Then it's gotta be something else on my site making it not work.

[Ajeh]

Does the message when you use it say:
This coupon has expired

or do you see some other message when it fails?

[CoolCarPartsOnline]

Actually the message displays a successful message

"Congratulations you have redeemed the Discount Coupon"

But the price doesn't change and the total stays the same.

[Ajeh]

What are all the settings on the Discount Coupon that you are using?

[CoolCarPartsOnline]

Same as other coupons... We do have custom work done to the site, it might of affected it. I have to dig deep into it.

[kavlito]

This is exactly what I have been trying to resolve. If any of my coupons have expired, they should show in the Inactive Coupons. I do not want them showing as Active when they are inactive. This is extremely confusing for my customer service reps. We are using coupon codes extensively and it's getting very difficult to manage them when they do not show under the correct status. Unfortunately, I do not know enough about PHP coding to make the necessary changes. These posts are from 2006 and it seems have been dismissed.

Also, re: 'any coupon should be able to be active again simply by changing the dates and/or setting its status back to "active".
', I found this: http://www.numinix.com/blog/2010/10/...coupon-active/

One thing I've done to help me manage my coupon codes is to change the displayed sort order by Expires date in decending order so that I see my most recent "active" coupons first.

In admin/coupon_admin.php, I added ORDER BY coupon_expires_date DESC around lines 1020 & 1022. See mods in red below:

if ($status != '*') {
      $cc_query_raw = "select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from " . TABLE_COUPONS ." where coupon_active='" . zen_db_input($status) . "' and coupon_type != 'G' ORDER BY coupon_expire_date DESC";
    } else {
      $cc_query_raw = "select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from " . TABLE_COUPONS . " where coupon_type != 'G' ORDER BY coupon_expire_date DESC";
    }

P.S., "air quotes" are necessary when using the terms "active" and "inactive" in the context of coupon codes as their actual meanings seem to be skewed. ;)