Product Sorting Question

[MCanes]

I have a customer who is still running Zen 1.2.4 and they want me to update their site so that when you are reviewing a category that the most recent added products to that category show first.

Is there a way via the Admin to do this or do I need to update some code somewhere to change a sort by clause or something.

Thanks.

[Ajeh]

On the Product listing this is not built in ... but you could customize it to work that way ...

You would need to change the order by in the select statement(s) ...

You might mention to your customer that the Product Listing is more for knowing the products by name or model or price etc. and that the New Product Listing is for knowing things by date and can have a filter set as to what NEW really is ...

[MCanes]

Do you happen to know which file(s) I would need to look in to chage the query?

[Ajeh]

Most likely you will work with the file:
/includes/index_filters/default_filter.php

There is a "forced" sort order for 20a to represent the products_sort_order ... this can give you an idea of a method to utilize a sorting method that is not part of the products listing titles ...

Or, you can add a new column for the title and content where the customer can revert to the sort by date ...

Be sure to keep a good backup of the original file as there are no overrides for this file ...

Read things carefully in that file as you will notice there are numerous conditions that build the select statement ...

As search on:
order by

will show you a lot of these to help get you on track ...