Newest product first - sort product by date

I would like that my products is sorted by date. The newest product should appear first.

Did you have some suggestions?

Your options are at

admin > config > layout settings > Categories/Products Display Sort Order

There isn't any option to sort by date, only by name, quantity and price.

I would like to do this too, my products seem to do what they want... sometimes its by sort order, sometimes not. Date added would be much nicer.

Hey, so what's the answer? How to sort by date? NEed help too..

There are a number of places where the Products are listed ...

Could you give more details on where you are trying to get Products listed by date? :unsure:

Ajeh:

There are a number of places where the Products are listed ...

Could you give more details on where you are trying to get Products listed by date? :unsure:

Hello Ajeh,

I just want them sorted by date added in the search results any time, how should i do?

Thanks very much.

--Schumi

You would need to change the:
$order_str

in the file:
/includes/modules/pages/advanced_search_results/header_php.php

most likely around line 454:

$listing_sql = $select_str . $from_str . $where_str . $order_str;

Ajeh:

You would need to change the:
$order_str

in the file:
/includes/modules/pages/advanced_search_results/header_php.php

most likely around line 454:

$listing_sql = $select_str . $from_str . $where_str . $order_str;

Thanks the reply.

I found out the code in header_php.php, but i don't know where to put the code or change the $order_str with "p.products_date_added"

I try to put it everywhere but then error happened :blush:

Please check the code there:

// if set to nothing use products_sort_order and PRODUCTS_LIST_NAME is off
if (PRODUCT_LISTING_DEFAULT_SORT_ORDER == '') {
$_GET['sort'] = '20a';
}
} else {
$sort_col = substr($_GET['sort'], 0 , 1);
$sort_order = substr($_GET['sort'], 1);
$order_str = ' order by ';
switch ($column_list[$sort_col-1]) {
case 'PRODUCT_LIST_MODEL':
$order_str .= "p.products_model " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
break;
case 'PRODUCT_LIST_NAME':
$order_str .= "pd.products_name " . ($sort_order == 'd' ? "desc" : "");
break;
case 'PRODUCT_LIST_MANUFACTURER':
$order_str .= "m.manufacturers_name " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
break;
case 'PRODUCT_LIST_QUANTITY':
$order_str .= "p.products_quantity " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
break;
case 'PRODUCT_LIST_IMAGE':
$order_str .= "pd.products_name";
break;
case 'PRODUCT_LIST_WEIGHT':
$order_str .= "p.products_weight " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
break;
case 'PRODUCT_LIST_PRICE':
// $order_str .= "final_price " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
$order_str .= "p.products_price_sorter " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
break;
}
}

$listing_sql = $select_str . $from_str . $where_str . $order_str;
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_ORDERBY_STRING', $listing_sql);

Could you help me?

Have a nice christmas!
--Schumi

The sort order is defined by the contents of the:
$order_str

If you want the display order to be different than any of the existing sort orders, you can change its content before that line so it contains an ORDER BY statement to match your needs ...

Something like adding the line in red:

$order_str = " ORDER BY p.products_date_added DESC, pd.products_name ";
$listing_sql = $select_str . $from_str . $where_str . $order_str;

Hello! Thanks for the info - I successfully implemented on the Advanced Search results page. Very cool!

How could I go about sorting all products on the product index display page by newest added? example: when users click a category (with no subcategories) and see all my products sorted by name, or price, or quantity (as set in "Config > Layout Settings > Categories/Products Display Sort Order")... I would like to have them sorted by date added instead - being newest first listed at the top?

What page should be modified? I hunted around in "includes > modules > product_listing.php" but can't really understand it...

Help anyone?
Thanks in advance - this is really important for my store.
Ada

The Product Listing when navigating the Categories does not, by default, have a choice for products_date_added ...

Again, the code would need to be customized for this ...

You would have to make similar customization to the:
/includes/index_filters/default_filter.php