Display products sorted by date added?

[vladi]

Hello! Quick question...

Is it possible to display products in categories and manufecture's results sorted by date added to the catalogue. If not, may be there is a contribution?

Thanks

[Christian Lescuyer]

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

[vladi]

thanks a lot! I will try to make the change in my code.

[Guest]

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!!

:onfire:

Jay!