Move Out Of Stock Products To The End Of Pages

[andy_77]

Like to show the out of stock products at the end of pages, and have been achieving this, thanks to a very old post on here from over 10 years ago (details below):

https://www.zen-cart.com/showthread....ists-how-to-do

For some reason I can't seem to get this to work, using the current default_filter.php file from the latest version of Zencart V2.1.0 which can be found under:

includes > index_filters > default_filter.php

Added the following line of code to line 111, in version 2.1.0 default_filter.php file:

$order_by .= " order by IF( p.products_quantity >0, 1, 0 ) DESC , p.products_sort_order , pd.products_name";

Had to revert to the older default_filter.php file from Zencart V1.5.8a, to be able to show the out of stock products at the end of pages in version 2.1.0, using the suggestion from this old post on here.

Not sure if anyone has any suggestions for the best way to achieve this, using the latest default_filter.php file?

Kind Regards,

Andy

[brittainmark]

You will also need to modify all the order by statements on lines 124-142 inclusive.

A better alternative would be to crate an observer to use the notifier 'NOTIFY_PRODUCT_LISTING_QUERY_STRING' and modify the order by clause in that. see https://docs.zen-cart.com/dev/code/notifiers/ for details.

If you do this you will not have to change the core files and save yourself the rewrite every time you upgrage zen cart.

[andy_77]

Thanks brittainmark,

Kind Regards,

Andy