Magento – products show up on category page but not in collection

categoryproduct

I created a featured products slider on the home page. It was inserted via the following code:

{{block type="catalog/product_list" category_id="563" template="catalog/product/featured-products.phtml"}}

There are 24 products in the given category. They are showing up on the front end when you navigate to the featured-products.html category, but they are not all showing up for the static block on the home page. It seems they are not all in the collection. When I echo the following variable I get a 9, not a 24. I have reindexed and cleared cache. Any ideas?

<?php $_collectionSize = $_productCollection->count() ?>

Best Answer

Sounds like paging.

Are you sure, that you removed the toolbar and that the standard-limit is 9?

You can check it here:

System > Configuration > Catalog > Catalog > Shop > Items per Page (?)

I have only the german version here at the moment :-/ And I'm not sure whether this is an extension.

And you can have a look into Mage_Catalog_Block_Product_List_Toolbar there is the limit set.

Related Solutions

Product Collection for Default Category in Magento

Okay answering my own question here:

It seems the _applyProductLimitations() function of Mage_Catalog_Model_Resource_Product_Collection adds a WHERE condition automatically to the collection if the category is not an anchor.

public function addCategoryFilter(Mage_Catalog_Model_Category $category) {
        $this->_productLimitationFilters['category_id'] = $category->getId();
        if ($category->getIsAnchor()) {
            unset($this->_productLimitationFilters['category_is_anchor']);
        } else {
            $this->_productLimitationFilters['category_is_anchor'] = 1;
        }
...

If the category is not an anchor it attaches the condition here:

if (isset($filters['category_is_anchor'])) {
    $conditions[] = $this->getConnection()
        ->quoteInto('cat_index.is_parent=?', $filters['category_is_anchor']);
}

So to retrieve a list of products just in the "Default Category" or ROOT Category you can do the following.

$store_id = 1;
$root_category_id = Mage::app()->getStore(Mage::app()->getStore()->getId())->getRootCategoryId();

$collection = Mage::getResourceModel('catalog/product_collection')->setStoreId($store_id);
$model = Mage::getModel('catalog/product')->setStoreId($store_id);
$category_model = Mage::getModel('catalog/category');
$category = $category_model->load($root_category_id);
$category->setIsAnchor(true);
$collection->addCategoryFilter($category);

echo $collection->getSize();

Magento – Display category products on homepage using carousel slider

Block shortcode should have an option to specify products count. Usually it is product_count

Try to update code to

{{block type="catalog/product_list" column_count="4" category_id="3" product_count="12" template="catalog/product/list-officestationery.phtml"}}

Please note that chosen category should contain enough products.

Best Answer

Related Solutions

Product Collection for Default Category in Magento

Magento – Display category products on homepage using carousel slider

Related Topic