Get Array of Product IDs for a Given Category in Magento

categorycollection;product-collectionsql

I am trying to find the fastest way of getting a list/array of product id's for any given category id.

I understand this is quite fast $category = new Varien_Object(array('id'=>$_cat)); $positions = Mage::getResourceModel('catalog/category')->getProductsPosition($category);

but there must be a way of getting the individual id's in 1 go.

So my question is: how can I retrieve an array of productids from a category id?

(Ad. where the is_anchor attribute is respected – for this Magento this means that also underlying category products are added to the collection)

also read; http://www.blog.plazathemes.com/archives/2759

Best Answer

If you only have the category ID and do not want to load the category itself, you can use this code (given category id $categoryId):

$category = Mage::getModel('catalog/category')->setId($categoryId);
$productCollection = Mage::getResourceModel('catalog/product_collection')
    ->addCategoryFilter($category)
    ->getAllIds();

This code respects the is_anchor attribute because the filter is using the index, so as a result it returns all products that Magento would show on front-end, including products from the underlying sub-categories.

Related Solutions

Magento Categories – How to Get Magento Categories by Array of Category IDs

Based on the comments....
Instead of $_categories->getParentId()>0 try to check

$_categories->getParentId() != 1 && $_categories->getParentId() != Mage::app()->getStore()->getRootCategoryId().

This should exclude the root of all roots (id 1) and the default root category of the store.

Magento – Product Collection for Subcategories of Subcategories

From what I understood you need all the categories that have a certain level, independently of their parent category.

If I got it right, try this:

$categories = Mage::getModel('catalog/category')->getCollection();
$categories->addAttributeToFilter('level', 4);
$categories->addAttributeToFilter('is_active', 1);

This is how you know what level value you need to use.
0 - Root of all roots (not visible in the backend)
1 - Catalog Root
2 - top level categories
3+ - go lower in the category tree.

If you need only the X level categories from a certain root category add these lines to the ones above:

Let's assume that your 'Products' category id is $mainId.

$rootId = Mage::app()->getStore()->getRootCategoryId();
$path = '1/'.$rootId.'/'.$mainId.'/'; //the slash at the end is very important.
$categories->addPathsFilter($path);

Best Answer

Related Solutions

Magento Categories – How to Get Magento Categories by Array of Category IDs

Magento – Product Collection for Subcategories of Subcategories

Related Topic