Sold-Out products to bottom of the page automatically

[pricediscrimination]

Hello, doesn't anyone happen to know of the possibility to make sold-out products automatically be sorted to the bottom of the product list? It's not convenient to have to set a sort order for thousands of products, but they should still be displayed in the product listing, just not in between in stock items. Any advice would be terrific. Thank you!

[pricediscrimination]

Going one step further, as desired is the ability to separate the sold-out items from the in-stock items. With a title above the break "Sold Out Items". Right now, all setting the sort order does is moves them to the end of the list. Also impossible to do with so many items.

[mc12345678]

There are utilities that can make changing the sort order simple(r). For example EasyPopulate V4 could be used setting the primary key as products_id, could export your product (by category if so desired), open the file, then for filter the product by quantity, then using the max() function identify the highest sort order currently applied, add a little to the first of the 0 quantity and number the sort order in some reasonable increment using a function (=row above+10 for example), save the file upload/import and that takes care of the first issue. The second well, depends on if you want a sold out product to show at all with non-sold out or if it has to exist starting on its own page, but thinking could review the returned data from the page split function and if a sold out product existed then to display your "above the fold" info.

Just a thought, otherwise, could create some other "field" to use and then could add it to the list of sortable fields and filter product by that on default.

A third option to have a sold-out section off of your main category so that the product there can be "viewed" (I know not exactly desirable but possible).

[DrByte]

In v1.5.x /includes/index_filters/default_filter.php is where the query is built to retrieve product-listing data.

You could add changes there, or perhaps simply just add an observer to fire when an appropriate notifier hook is triggered, to apply your filter.

(ie: first might be to change the order-by to make "products_status desc" be the first order-by clause; 2nd enhancement could be to let the visitor apply a filter and then you could check $_GET or $_POST to see if that filter has been set, and then instead of changing order-by you'd add a "where" clause for products_status = 1 for only-enabled, or make no change to "where" if the filter doesn't need to exclude sold-out items)