Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Display products sorted by date added?


Recommended Posts

Just change the sort order in the query. In default.php locate the order by clause. In my file it's line 200.

          $listing_sql .= " order by pd.products_name";

Replace with

          $listing_sql .= " order by p.products_date_added";

Or maybe, more recent first?

          $listing_sql .= " order by p.products_date_added desc";

Christian Lescuyer

Link to comment
Share on other sites

I want to define a different date for EVERY product in my spreadsheet and use this to sort my entire catalog in the manual order I have the products set up in my spread sheet.


In Excel you can create a date then just grab the cell and drag it down and it will automatically add one day/or second to each succeeding cell, thereby creating an incrementing field I can sort by.


The Admin says date_expected, but the database and Easy Populate field available to me is date_available. I am HOPING they are the same thing? Any way all my attempts to get the catalog to sort by date have FAILED and I have exported back out of the catalog to make sure the date went in and it did: date only, no time.


This seems like it should be very simple, but I'd like some feedback!!



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...