This is the fix for Coupon Admin Zencart V1.5.3. If the option “All coupons” were selected, there’s no record display. This is incorrect. The coupons table has 5 valid coupons and in status “Y” and 1 coupon in status “N”. This option should display all records no matter what status it is.

File changed: /admin/coupon_admin.php

$status_array[] = array('id' => '', 'text' => TEXT_COUPON_ALL);

Use this query instead:

$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'";