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