Display out of stock products at the end of the catalog.

[yofisim]

I would like to display the out of stock products at the end of my catalog.
This functionality was available in M 1.9 (and maybe before), and for some reason it is not available anymore, not in system configuration nor store configuration options.

Preconditions

1. Magento 2.1.1
2. Apache Webserver
3. PHP 7.0

Steps to reproduce

1. Have a catalog with products, some in stock, and others out of stock.
2. Try to display the out of stock products at the end of the catalog, on category products, or homepage.

Expected result

1. A functionnality to allow out of stock products to be displayed at the end.

Actual result

1. In stock and out of stock products are melted together.

[odubovyk]

Cannot reproduce the issue, "out of stock" products are at the end.
Write more detailed steps to reproduce.

[yofisim]

@odubovyk It's actually the issue. Out of stocks products and in-stock products are on mixed together. I want to display out of stock products at the end of the catalog.

Please check here: http://vps307618.ovh.net/chaise-chesterfield

You will see the out of stock products mixed with in stock products.

[odubovyk]

I believe, current info is not enough, as I've said we need more details of steps to reproduce.
Please see steps to reproduce section in https://github.com/magento/magento2/wiki/Issue-reporting-guidelines.

[veloraven]

According to contributor guide, tickets without response for two weeks should be closed.
If this issue still reproducible please feel free to create the new one: format new issue according to the Issue reporting guidelines: with steps to reproduce, actual result and expected result and specify Magento version.

[MMaKenZi]

i think this issue is so important,
the meaning of this issue is this :
Show in stock products first and out of stock products last

i will explain by an example

it happened sometimes that whole products of a category are out of stock, by the only option provided by magento, they all will be hidden, so if a user try to browse site by categories menu, he will just see "no products found!" and say what a stupid shop is this that created some empty categories!

but if the user be able to see the out of stock products, can contact admin for some other products and don't think about the stupidity of the shop anymore :D

this example was just for importance of out of stock products,
but think you are in a category which on it's first page, you have for example 10 in stock products and 10 out of stock products, absolutely a customer which enter a shop, just want to see the in stock products, so they should be listed first, and as I explained the importance of out of stock products, they should be listed at last

so I think the best option is this:
first in stock products be visible and after them out of stock products

is this clear now?

My tested version is 2.1.9
PHP is 7.0.22
with nginx webserver

[MMaKenZi]

Shouldn't be opened again?

[orlangur]

@MMaKenZi, nope, as far as I can say.

GitHub is intended for bug reports, please use Community Forums for other suggestions like improvements or feature requests.

[yofisim]

I left M2 for Prestashop, I think everyone knows the reason why.
It is definitely a bug, not a feature request. I mean who will want to display out of stock products, who cannot be ordered, mixed with in-stock products.

Anyway, a nasty trick I did in the past was to add a "custom field" (don't remember the exact nomination for M2), to each product.

Each product who is in stock gets value 1
Each product who is out of stock gets value 2

Then you can sort the catalog (from the admin) to display products with custom field value == 1 first, and all the others after.

If you have a lot of products, like us in the past (more than 50k), you should then make a CSV import with the field already set and value applied.

Matters of hours, but was working pretty well back in time.

Good luck