Magento: Get all category and subcategory products
Magento get all category and subcategory products which are assigned to categories at different levels. Below script will show you all the categories, and all the associated product names under each of those categories.
<?php require_once('app/Mage.php');
umask(0);
Mage::app('admin');
set_time_limit(0);
$category = Mage::getModel('catalog/category');
$tree = $category->
getTreeModel();
$tree->load();
$ids = $tree->getCollection()->getAllIds();
if ($ids)
{
foreach ($ids as $id)
{
$cat = Mage::getModel(‘catalog/category’);
$cat->load($id);
if($cat->getLevel()==3 && $cat->getIsActive()==1)
{
$category1 = Mage::getModel(‘catalog/category’)->load($cat->getId());
$products = Mage::getResourceModel(‘catalog/product_collection’)
->addAttributeToSelect(‘name’)
->addCategoryFilter($category1);
echo “**“.$cat->getName().”**
“;
foreach ($products as $product) { //print_r($product->getData());exit;
echo ” ” . $product->getName() . ” – “. $product->getSku() . “
“;
}
}
}
}
?>
Note the line which checks category getLevel()==3, you can change this line to get different subcategory levels by adjusting it.
For root category, getLevel() should be 1.
For all the main/primary categories, getLevel() should be 2.
For all the subcategories, getLevel() should be 3.
For all the subsubcategories, getLevel() should be 4.
and so on…
Above script will get you all the category and subcategories products, products assigned to each and every categories of your store.