Listing Sort Order by Date Added

v1.5.7c
It is the latest version, I have just installed.
I have Image Handler installed and that is it.
I used a one click install from my hosting company.
PHP Version: 7.4.12 (Zend: 3.4.0)

URL: https://www.aimeeharrisondesigns.com/store/

I have looked everywhere and cannot find a thread to help me with this.

I simply want to sort all my products by date added. Not alphabetically. I had an old version that did this and I cannot find the instructions to do this using my version.

If anyone can point me in the right direction, that would be great. Or tell me what needs to be changed and I will change it.

Thank you!

There's no built in way to do this. If it was me, I'd just modify includes/index_filters/default_filter.php to taste.

swguy:

There's no built in way to do this. If it was me, I'd just modify includes/index_filters/default_filter.php to taste.

That's how I do it. I replaced line #82 in that file with:

$listing_sql .= " order by p.products_date_added desc, pd.products_name";

Thank you!!

You might also need to update the SELECT to include this field depending on your database mode - not sure.

@simon1066 if you have some free time, writing this up as a documentation article (Developer's side) would be great so people who want to do this can follow a set of steps.

swguy:

@simon1066 if you have some free time, writing this up as a documentation article (Developer's side) would be great so people who want to do this can follow a set of steps.

Sure, will do.

Edit:

swguy:

You might also need to update the SELECT to include this field depending on your database mode - not sure.

Can I ask what you mean by 'database mode', is it innodb/myisam?

swguy:

@simon1066 if you have some free time, writing this up as a documentation article (Developer's side) would be great so people who want to do this can follow a set of steps.

@swguy i think it would be a good PR to be able to override the default_filter.

can we count on you for that? :D

Discussed on this page:
https://docs.zen-cart.com/user/troubleshooting/db_strict_mode/

carlwhat:

@swguy i think it would be a good PR to be able to override the default_filter.

can we count on you for that? :D

AHEM! I spend the morning documenting sort order on the store front. How 'bout you step up?

simon1066:

Sure, will do.

Edit:

Can I ask what you mean by 'database mode', is it innodb/myisam?
Not necessarily those, but in some modes, attempting to sort a data set on a field that is not being returned in the SELECT statement can cause a sql "error"... If the database mode (sql_mode) includes: ONLY_FULL_GROUP_BY then grouping by a field that is not in the select list of that query will cause an error (e.g. ORDER BY clause is not in SELECT list ......) such as if running this query: ```
SELECT products_price FROM products ORDER BY products_id;

swguy:

AHEM! I spend the morning documenting sort order on the store front. How 'bout you step up?

i was being a bit facetious.... as i never intended to disparage the work that you do.

if i were to set the odds of said change getting merged into the repo, they would not be very high, as the complexity for said change is a bit high.

as such, i will take a pass...

best.

girlboheme:

I used a one click install from my hosting company.To me, this is the most concerning part of the post.
I've yet to find a one-click that doesn't have some little difference that winds up being a big difference later.
I've often seen one-clicks whose internal settings are in direct opposition to the server setup of the host providing the one-click.:blink:

Consider getting the real zip and extracting it into a test folder. Run the install then bring over your current database. It may save you some headaches down the road.