sort sub-category view by date added

[hpowers]

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.

[Ajeh]

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 ...

[hpowers]

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

[moltar]

Open the file [FONT="Courier New"]/includes/index_filters/default_filter.php[/FONT]

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.

[hpowers]

that worked! Thanks. - Hunter

[ksoup]

You rock!! Thank you so much! :)

Open the file [FONT="Courier New"]/includes/index_filters/default_filter.php[/FONT]

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.

[nashliu]

Open the file [FONT="Courier New"]/includes/index_filters/default_filter.php[/FONT]

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.

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

[pinkchalkstudio]

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!

[Ajeh]

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 ...

[pinkchalkstudio]

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