Sort all products by "Most Recent" like "Latest Products"

Is there a simple way to make all products within the category pages display as most recently first? The same way most recent products are displayed first within the "latest products" module?

Thank you.

THIS "HACK" WILL BE CHANGE THE DEFAULT LOOK IN YOUR CATEGORY LIKE LOOK (like you click on sort by: button)

Search this in:

catalog\controller\product\category.tpl

if (isset($this->request->get['sort'])) {
$sort = $this->request->get['sort'];
} else {
$sort = 'p.sort_order'; <--- change to: p.model !!!!!!!!!!!
}

if (isset($this->request->get['order'])) {
$order = $this->request->get['order'];
} else {
$order = 'ASC'; <--- change to DESC !!!!!!!!!!!!!!!
}


If you want try with another option :
p.sort_order-ASC = default sort
pd.name ASC">Name (A - Z)
pd.name DESC">Name (Z - A)
p.price ASC">Price (Low > High)
p.price DESC">Price (High > Low)
rating DESC">Rating (Highest)
rating ASC">Rating (Lowest)
p.model ASC">Model (A - Z)
p.model DESC">Model (Z - A)

Thank you very much for your reply but this doesn't quite get me the results I'm looking for.

There is no way to make all products appear the same way "latest products" do? Newest to Oldest.

Never mind, I feel quite silly. I just did "p.date_added" and "DESC" the same as shown in the latest products module. Very easy =]

For anyone else who wants their products to show in order by the date added the same as the latest product module it's simply this:

catalog/controller/product/category.php

if (isset($this->request->get['sort'])) {
$sort = $this->request->get['sort'];
} else {
$sort = 'p.date_added'; <--- (Change from p.sort_order)
}

if (isset($this->request->get['order'])) {
$order = $this->request->get['order'];
} else {
$order = 'DESC'; <--- (Change from ASC)
}

You did the same that i told you Respect man

Thank you !

I did exactly what you did and it worked. Also i went a step further and changed the language in the file:
/catalog/language/english/product/category.php

From " Default" to "Latest Added"

Here's a vQmod, tested in version 1.5.1.3, which will change the default sort order to show most recent items first on category and manufacturer pages.

DJM wrote:Here's a vQmod, tested in version 1.5.1.3, which will change the default sort order to show most recent items first on category and manufacturer pages.

You are the man, this has been driving mad for ages, many thanks

Jimmy

Awesome work. Have added to my site!

works even on 2.3.2