Magento EE 1.13 – List All Products in Category, Including Disabled

blocksee-1.13product-collectionproduct-list

How can I show all products in a category, regardless of its status? I have a category that I want to show all products in the category, even it is disabled, invisible, out of stock, or whatever. I've made a new product/list.phtml template for this specific category and am overriding the Mage_Catalog_Block_Product_List to add a new method to accomplish this. In that method is this code

$catId = 432;  //for simplicity
$category = Mage::getModel('catalog/category')->load($catId);

return $category->getProductCollection()
    ->addAttributeToSelect('sku');

It is only retrieving enabled products. However, if I run the same code in a testing script (outside of catalog module) that loads Magento, I get all products that I'm looking for, enabled and disabled. How can I accomplish this?

Best Answer

Please use this code

$productCollection = Mage::getResourceModel('catalog/product_collection')

                        ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id=entity_id', null, 'left')
                        ->addAttributeToFilter('category_id', 3);
                       $productCollection->getSelect()->group('product_id')->distinct(true);
echo '<pre>'; print_r($productCollection->getData());

Definitely this work for you.

Related Solutions

Magento – Create Category page which displays all Special Price products

Easiest way to do this is to create a custom extension that works with an Observer and a Cronjob.

Create a category for the sales products. This way you can use the normal Magento functionalities in the frontend like layered navigation etc.

To get the products in this category automatically we will use the observer and cronjob. The observer will observe the catalog_product_save_after event that is triggered when a product is saved in the backend. When this happens you can check the special_price, special_price_from date and special_date_to date to determine if you need to put the product in the sales category or remove it from there.

The cronjob is there for the special from and to dates. Every night after midnight first empty the sales category of all the products. Then use a collection to retrieve all products that have a special price and are falling within the special from and to date. If so move them to this sales category.

Magento – Count of viewable products in a category

Yes, use this code

$products = Mage::getModel('catalog/product')->getCollection()->addAttributeToFilter('visibility', 4);

It will get you the visible products, since 4 means Catalog and search visibility. You can combine that with this to add stock check

Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($products);

Best Answer

Related Solutions

Magento – Create Category page which displays all Special Price products

Magento – Count of viewable products in a category

Related Topic