I have 20 products in a category. But when I open the same category on frontend it shows 11 products. I logged the query and directly fired on the database, it correctly shows 20 records. But for the same query result is 11 on category page. What could be the reason.

  • Checked Quantity of product !!! they all 20 products have quantity and status in stock ? Mar 29, 2017 at 10:48
  • yes I did checked. Mar 29, 2017 at 10:59

1 Answer 1


There may be many reasons for it. Few which I can list

  1. Product is out of stock
  2. Product status is Disabled
  3. Product visibility does not include Catalog
  4. Product is not assigned to that particular website
  • we have already looked into these possibilities. But they are set correctly. Still the products are not getting displayed properly. And moreover, why the same query gives proper result when fired on database?. Mar 29, 2017 at 10:58

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.