Specific Category Products Magento

Hello All,

I am writing here the script to get product collection of a required category.

For the below mentioned script we must have the category id for which the product collection is needed.


	$catagory_model = Mage::getModel('catalog/category')->load($category_id); //where $category_id is the id of the category

	$collection = Mage::getResourceModel('catalog/product_collection');

	$collection->addCategoryFilter($catagory_model); //category filter

	$collection->addAttributeToFilter('status',1); //only enabled product

	$collection->addAttributeToSelect(array('name','url','small_image')); //add product attribute to be fetched

	//$collection->getSelect()->order('rand()'); //uncomment to get products in random order	    




    		foreach ($collection as $_product): 

			echo $_product->getName();	//get product name			




    		echo 'No products exists';




Hope this is helpful

19 thoughts on “Specific Category Products Magento

  1. Oh,Thank you very much!you save me time!!other website get products by category id solution is no use for me,but you are userful to me.

  2. This is one that I am searching from last two days.
    please change heading from “Get Category Products Magento” to “Get Product data for the specific Category”.

    1. @Zahid – You need to add the attribute code (suppose it is ‘color’)like ‘name’ in $collection->addAttributeToSelect(array(‘name’,’url’,’small_image’,’color’)); and use ‘$collection->addAttributeToFilter(‘color’,array(‘eq’=>’green’)); ‘ for filtering.

      Hope this is helpful

Leave a Reply to Pragnesh Cancel reply

Your email address will not be published. Required fields are marked *

Scroll to top