cancel
Showing results for 
Search instead for 
Did you mean: 

Magento does not query all active products in category

Magento does not query all active products in category

I have a Magento installation which worked fine, till now.

  • It has 3 storeviews;
  • 2 storeviews are already online and work fine
  • The third one is in development

In the third store I'm adding products, but after a number it stops showing in the frontend.

  • I checked where it went wrong, and it's in the middle of a category
  • I checked visibility and all additional options on categories and products

Next I did:

  • Duplicating an product which is already visible in the frontend, the duplicate didn't show up

I checked if the theme was broken so I queried the complete root category in list.phtml: - In the 2 correct stores the count of products visible is the same as the count of products displayed in the backend under category management - In the third store, category management says there are 137 products while the count in the frontend ends at 93.

I used this to query the complete root category and counted it:

 

$cat_ID = 41
$category = Mage::getModel('catalog/category')->load($cat_ID);
  $productCollection = $category->getProductCollection();
  $productCollection
          ->addStoreFilter()
          ->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds())
          ->addMinimalPrice()
          ->addFinalPrice()
          ->addTaxPercents()
          ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
          ->addUrlRewrite();

It seems that it just stops the query at 93 entries. I disabled and enabled products but it doesn't make any difference to the 30+ products which are not shown for an unknown reason.. I flushed caches and indexes so that isn't the case. Settings for products are exactly the same since I tested it by duplicating.

 

What else can I try?