Coupon Admin Sort How to?

[coolscrapbook]

Please accept my apologies if the answer is right in my face, but I have been searching this forum and my Admin menus, and simply cannot find how to change the sorting on my Coupon Admin page. I would like my coupons in my Admin to sort by date added so the most recent one is listed on the top. Because i have so many coupons created, and when I want to see the most recent, it's all sorted by price or name or something other than what I need.

Anyone know this answer to this? Thank you in advance.

[DrByte]

You'll have to edit the SQL statements in the /admin/coupon_admin.php file to change the sort order.
I've not tested this suggestion, but you could try this:

Around line 1016 you'll see this block of code. Add the extra line, as shown:

    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'";
    } 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'";
    }
    $cc_query_raw .= " ORDER BY date_created";

[coolscrapbook]

You'll have to edit the SQL statements in the /admin/coupon_admin.php file to change the sort order.
I've not tested this suggestion, but you could try this:

Around line 1016 you'll see this block of code. Add the extra line, as shown:

    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'";
    } 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'";
    }
    $cc_query_raw .= " ORDER BY date_created";

Thank you for the response, and I think I'm getting closer but not there yet. Adding this extra line, sorted my coupons by dated created "yes" but now I need them in descending order, so that the newest coupon added is the 1st one listed on page1. Does that make sense? I hope there is an extra line out there that I can add to do this. "Crossy fingers..."

[DrByte]

oops ... I meant to come back and fix that ...

$cc_query_raw .= " ORDER BY date_created DESC";

[coolscrapbook]

oops ... I meant to come back and fix that ...

$cc_query_raw .= " ORDER BY date_created DESC";

Fantastic! That did it. Thank you so much. Really appreciate it.