Home » Magento

Magento: Get Product Collection by Type

20 April 2010 Share/Bookmark

Here, I will be showing how you can get product collection from product type i.e. simple, configurable, bundle, grouped, and virtual.

Here is the code:-

$collectionSimple = Mage::getResourceModel('catalog/product_collection')
				->addAttributeToFilter('type_id', array('eq' => 'simple'));
				
$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
				->addAttributeToFilter('type_id', array('eq' => 'configurable'));
				
$collectionBundle = Mage::getResourceModel('catalog/product_collection')
				->addAttributeToFilter('type_id', array('eq' => 'bundle'));
				
$collectionGrouped = Mage::getResourceModel('catalog/product_collection')
				->addAttributeToFilter('type_id', array('eq' => 'grouped'));
				
$collectionVirtual = Mage::getResourceModel('catalog/product_collection')
				->addAttributeToFilter('type_id', array('eq' => 'virtual'));

Cheers,

From Mukesh Chapagain's Blog, post Magento: Get Product Collection by Type

email

Related posts:

  1. Magento: Get order option of configurable and bundle product in cart
  2. Magento: How to filter product collection using 2 or more category filters?
  3. Magento: Get parent id of simple product associated to configurable product
  4. Magento: Adding OR and AND query condition to collection
  5. Magento: Get sub categories and product count
  6. Magento: Overriding / Rewriting Mysql4 and Resource Eav Collection Class
  7. Magento: Sort latest product by ‘created date’ and ‘new from date’
  8. Magento: How to get all associated children product of a configurable product?
  9. Magento: Downloadable products not displayed in Associated Products tab in Grouped Product
  10. Magento: How to get most viewed products?

php magento mukesh chapagain

Get New Post by Email
RSS Feed Subscribe RSS Feed
  • VicHaunter

    Hello, very interesting, but i want to know how to filter for example simple and configurable with the same filter, or any other combination of 2 or 3 different types in the same collection.
    Is this possible? thankyou

  • Lalit Patel

    Thank you for this post. Very help full

  • Ela

    Hi ,

    I want to get the all the sku’s of the Configurable product inner products. How can i alter your method to get the sku’s of the configurable products

    $collectionconfigurable = Mage::getResourceModel(‘catalog/product_collection’)
    ->addAttributeToFilter(‘type_id’, array(‘eq’ => ‘configurable’));
    Zend_Debug::dump($collectionconfigurable);

  • Jerome Dennis D

    Hi brother i don’t know how to thank you.

    You have saved me a lot of time through your very precise articles which hit straight at the target in my magento development  and i would also like to donate you to help this blog as soon as i can :-)

    Keep rocking with your articles. Its not an exaggeration if i would say this blog is a Magento Cook Book.

    Thanks and Regards,
    Jerome Dennis D
    http://haijerome.wordpress.com

  • Yogendra M

    Hello Mukesh, can you guide if we want to sort the product type instead of filter than how can we achieve this?