Newest product first - sort product by date

[Jeet Kune Do]

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


Did you have some suggestions?

[kobra]

Your options are at

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

[Jeet Kune Do]

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

[jamielife]

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.

[sharontan]

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

[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?

[schumi]

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?

Hello Ajeh,

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

Thanks very much.

--Schumi

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

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

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

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

[Ajeh]

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;