How to set the products to sort by date added?

Hi, currently all my products listing are listing alphabetically.
How can I set it to date added? As in new items on top. Old items below.

I have set the config-> all listing Display Product Display - Default Sort Order-> 6

6= Date Added desc

However, nothing changes.

Each of the Product Listings has its own settings ...

You will need to edit each one to customize them to be sorted by date ...

All Listings is the actually Listing for All of your Products when you click on the link for All Products ...

There are settings for:
Product Info
Product Listing
New Products
Featured Listing
All Listing

about the only one that would give a problem is the Product Listing as that does not have a sort order by date ...

For that, you would need to customize the code ...

I've already listed all my products up. How do I customize the code? Or I have to individually go into every product to set it to be sorted by date?

You could set the Product Listing to blank on the sort order, meaning nothing ... then customize the code:
/includes/index_filters/default_filter.php

and change the code from:

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

to read:

// 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";
// bof: customize to sort by date descending
          $listing_sql .= " order by p.products_date_added desc, p.products_sort_order, pd.products_name";
// eof: customize to sort by date descending
          break;

Now, when navigating the Categories the listing will be by date, sort order, name ...

Awesome! Thanks!

Hi, i have Product Listing Grid mod installed i tried the aboe and it dont seem to be working, does something different need to be done because of the installed mod?

Hope you can help.

Thanks

This has also helped me. thanks so much :smile:

we are using 1.3.9h version of zen. We have changed the code as per the instructions below, and still get nothing. All Alpha still. is it necessary to reset our other listings so that they should read something other than a 6. The product Listing is left blank on the sort order.

Ajeh:

You could set the Product Listing to blank on the sort order, meaning nothing ... then customize the code:
/includes/index_filters/default_filter.php

and change the code from:

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

> 
> to read:
> ```
// 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";
// bof: customize to sort by date descending
          $listing_sql .= " order by p.products_date_added desc, p.products_sort_order, pd.products_name";
// eof: customize to sort by date descending
          break;

Now, when navigating the Categories the listing will be by date, sort order, name ...

If you click on the Product Name sorter for the listing, what comes up on URL for the
sort=

and does it sort right when you have it in ascending order?

I tried this and it sorts my items correctly as by date added, however, the next and previous button need tinkering.

if i clicked on the first item (the newest added) the order of the product is the last item (ie 51/51) this makes the next button go to 1/51.

I tried a few things but to no avail.

I have the listing order using the modification from above. http://sales.michaelhulak.com/index.php?main_page=index&cPath=1

The numbers have no real value ... they change depending on sort order ...