We have created a category page and assigned some products to that category page.

We have also assigned some out-of-stock products.

But when we sort products by price the out-of-stock products show at end of the list.

How can we show the out-of-stock product in the proper position based on the sort order?

enter image description here

  • The same issue I am facing, if you get answer please let me know ?
    – Dotsquares
    Jan 19 at 12:36
  • @Dotsquares Yes, I have found the issue, Check my answer. Feb 25 at 7:23

1 Answer 1


I just found this issue, There is a default is_salable sort order added in elasticsearch that's why out-of-stock products showing at end of the listing.

You can able to remove that sort order by overriding the below file and removing line #213.


On line #213 the below code was added in elasticsearch

$sortOrders = array_merge(['is_salable' => \Magento\Framework\DB\Select::SQL_DESC], $sortOrders);

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.