search
top

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.

<?php

	$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	    

	$collection->addStoreFilter();     	    

	if(!empty($collection))

	{

    		foreach ($collection as $_product): 

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

		endforeach;

	}else 

    	{

    		echo 'No products exists';

	}       	    

	

?>

Hope this is helpful


19 Responses to “Specific Category Products Magento”

  1. sabaq ahmad says:

    anyone tell me where i add this code?

  2. The blog is absolutely fantastic. Lots of great information and inspiration, both of which we all need. Thanks.

  3. Sudipto Karmoker says:

    Script is correct for get product collection by single category id.

    Thanks a lot.

  4. Rahul says:

    Good Job Zahid!! Keep it up

  5. adi says:

    Hello this is a very helpfull posti love that its solve my problem

  6. Alejandro says:

    Hi,
    I’m new to Magento, how do you implement this code.

    Regards
    Alejandro.

  7. Deven says:

    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.

  8. Suman says:

    Sir
    Your blog Really help me

    Thanks For your support

  9. laeeq says:

    Hi,
    Really This Very help full.

  10. Rakes says:

    Thanks very nice blog….

    :)

  11. Jitendra says:

    Hi,
    Really This Very help full.

    Funtastic job.

  12. Hassan Ali SHahzad says:

    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”.

  13. Zahid says:

    How to filter color in you example?

    • Pragnesh says:

      @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

top