we are using following extension in our site....

1)Search extension : https://mirasvit.com/magento-extensions/sphinx-search-ultimate.html . From this we can implement feature that if we search for Product all the In-stock products will display first and than out-of-stock products. Everything was fine.

Later we wanted to implement following feature.

2)Displaying out-of-stock products at last in the listing pages. : https://github.com/r-martins/Magento-OutOfStockLast .

This worked fine. But Problem happened to first feature, Means after using 2nd extension, when we search for product, than in-stock & out-of-stock products are displaying randomly.

this is our search results page : http://videomergerapp.com/catalogsearch/result/?q=hot+wheels

when we debug this page , i can see SQL query and results: http://videomergerapp.com/catalogsearch/result/?q=hot+wheels&debug

i can see all the product ids with all in-stock product ids are displaying first and than out-of-stock products ids are displaying.

but in site [ listing page ] in-stock & out-of-stock products are displaying in random order.

Please help me what i need to do for working both features in one site.

enter image description here

  • I am also looking for similar kind of solution. Please update me if you find the solution. magento.stackexchange.com/questions/95934/… Commented Jan 5, 2016 at 1:50
  • @AdarshKhatri we are using sphinx seach. i will let you know once i get solution. Commented Jan 5, 2016 at 3:29
  • why you are using the both extension they have same functionality? Commented Jan 11, 2016 at 5:12
  • One extension will display in stock products on first when we search for products in search bar. another extension display in-stock products first when we click on category links. Commented Jan 11, 2016 at 5:15
  • @AdarshKhatri did you got solution for that question? in my case it was problem with collection.php in one extension. Commented Jan 28, 2016 at 22:33

2 Answers 2


Usually such behavior means that something happend to collection between the place where you debug and end result. Try to debug collection just before it is being rendered by View - for example, in catalogsearch template


Contact Mirasvit they will resolve this for you. I have this and other modules, they have been absolutely fantastic in resolving any issue I have.

As a note, typically these kinds of questions get closed so its always important that you contact the developer to find a solution since its impossible for anyone to resolve this without looking at both modules.

  • If you cant figure it out, definitely contact them, hands down one of the best developers in terms of support and response time.
    – SR_Magento
    Commented Jan 14, 2016 at 11:13
  • you are exactly right., I have used extensions from lot of team. For me,They are the Best extension team in support. Commented Jan 14, 2016 at 13:27

Your Answer

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

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