sort sub-category view by date added

When someone clicks on a subcategory, for example toys-infant. It shows a list of all infant toys. They are in alphabetical order. I would like them to list in the order they were added to the store, so that the newest products come up first.

Currently, the Product Listing is sortable by the fields that you have selected to display ... unfortunately, date added is not one of them ...

You would have to customize the code to sort by date added then product name vs one of the available fields ...

where would I look for the code that is doing the sorting?

Open the file /includes/index_filters/default_filter.php

Find the line that says (line 113 in default 1.3.7):

$listing_sql .= ' order by ';

Replace with:

$listing_sql .= ' order by p.products_date_added DESC,';

Go to Configuration -> Product Listing -> Display Product Listing Default Sort Order. Set this to anything valid, like "2a" for example. This isn't going to do anything, just activates the part of the code in default_filter.php file that does the sorting.

:blink:

that worked! Thanks. - Hunter

You rock!! Thank you so much! :)

moltar:

Open the file /includes/index_filters/default_filter.php

Find the line that says (line 113 in default 1.3.7):

$listing_sql .= ' order by ';

> 
> Replace with:
> 
> ```php
$listing_sql .= ' order by p.products_date_added DESC,';

Go to Configuration -> Product Listing -> Display Product Listing Default Sort Order. Set this to anything valid, like "2a" for example. This isn't going to do anything, just activates the part of the code in default_filter.php file that does the sorting.

:blink:

moltar:

Open the file /includes/index_filters/default_filter.php

Find the line that says (line 113 in default 1.3.7):

$listing_sql .= ' order by ';

> 
> Replace with:
> 
> ```php
$listing_sql .= ' order by p.products_date_added DESC,';

Go to Configuration -> Product Listing -> Display Product Listing Default Sort Order. Set this to anything valid, like "2a" for example. This isn't going to do anything, just activates the part of the code in default_filter.php file that does the sorting.

:blink:
I had this problem for several days
finally resolved,thank you very much,moltar

I want my most recent products showing first in the sort order on the listing display. This mod worked exactly as I wanted to get that to happen. Thank you.

Now for a follow up question: is anyone familiar with where I would change the code to do the exact same thing for the Previous/Next logic that cycles through the listing on the Product Info page?

I know that is set in the Config/Product Info/Previous Next - Sort Order where date added is not an option so I'm assuming I need to customize just like I did for the product listing page.

Thank you!

Currently, in the Configuration ... Product Info ... there is a setting for:

Previous Next - Sort Order
Products Display Order by
0= Product ID
1= Product Name
2= Model
3= Price, Product Name
4= Price, Model
5= Product Name, Model
6= Product Sort Order

You would have to customize the code further if you want it to sort by date vs any of the built in settings ...

Thank you Ajeh. That's what I thought. Can you point me to the file that contains the Previous/Next SQL statement or what I would search for in order to find it myself?

Thank you!

Kathy

You could peek at the product_prev_next.php module and see where the order is defined from the settings ...

moltar:

Open the file /includes/index_filters/default_filter.php

Find the line that says (line 113 in default 1.3.7):

$listing_sql .= ' order by ';

> 
> Replace with:
> 
> ```php
$listing_sql .= ' order by p.products_date_added DESC,';

Go to Configuration -> Product Listing -> Display Product Listing Default Sort Order. Set this to anything valid, like "2a" for example. This isn't going to do anything, just activates the part of the code in default_filter.php file that does the sorting.

:blink:

I tried this and it didn't do anything at all. Can you help me figure out why? I have the right line and everything.

I have the "all products" sorted by date, but I want each of the categories to display that way as well and right now they are sorting by name.

Thanks!

dont mind me :P, just make a note, do I can have this in file

moltar:

Open the file /includes/index_filters/default_filter.php

Find the line that says (line 113 in default 1.3.7):

$listing_sql .= ' order by ';

> 
> Replace with:
> 
> ```php
$listing_sql .= ' order by p.products_date_added DESC,';

Go to Configuration -> Product Listing -> Display Product Listing Default Sort Order. Set this to anything valid, like "2a" for example. This isn't going to do anything, just activates the part of the code in default_filter.php file that does the sorting.

:blink:

I'm using version v1.3.9d and I see a few places that have $listing_sql .= ' order by '; but there is other things around them I'm afraid I mess up. I've attached a copy of my default_filter.php What should I be replacing? My line 113 in my version looks nothing like the above.

I like if someone can help please .

ZEN 1.3.9.H

How can show first the new products added in category ?

Thanks