Product Listing Descending Sort Order

[wolf99]

I noticed a few threads that touched on this subject but none that I could properly understand that directly dealt with it, so here goes.

I have my products loaded (v1.3.5) with sort order given as loading 10,20,30,...etc.
Now realise that when updates come in, they will be placed at the back of old products, basically, how can I make all my normal product listings sort into reverse sort order? (i.e. 610, then 600, then 590 etc.)

I guess It would also work if I was able to make the listings sort by added date, with most recent showing first

anyone able to tell me how to do this??

thanks

[Ajeh]

To reverse it ... you would need to leave the setting blank and then customize the code in the:
/includes/index_filters/default_filter.php

There is a section that sets the blank which is converted to 20a to:

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
//       $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
          $listing_sql .= " order by p.products_sort_order, pd.products_name";
          break; 

Switch the commented line so you are using the desc ...

NOTE: There is not an override for this file ...

You will need to decide if there is a benefit to this on searches ...
/includes/modules/pages/advanced_search_result/header_php.php

This is the code:

    } else {
      // sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER ia left blank
      // for reverse, descending order use:
      //       $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
      $order_str .= " order by p.products_sort_order, pd.products_name";
      break; 

Note the $listing_sql needs to be changed to $order_str if you make the change here ...

[wolf99]

Thanks Ajeh, works a treat

[Ajeh]

You are most welcome ... glad that this worked for you ...