Magento 2 : Get Product Collection

In this technical blog, we will see different ways of get product collection in Magento 2. Nowadays, Somewhere in every project developers need to get product collection with many conditions. In other words, There are lots of ways and filters available to get product collection for details of products. Here, we will see how to get product collection with filters, sorting, etc.

First of all, let’s do how to load product collection. To create custom module, you can click here.

1) Load product collection :

[dm_code_snippet background=”no” background-mobile=”no” slim=”no” line-numbers=”no” bg-color=”#fff” theme=”dark” language=”php” wrapped=”yes” height=”” copy-text=”Copy Code” copy-confirmed=”Copied”]

<?php
/**
 * Created By : Rohan Hapani
 */
namespace RH\HelloWorld\Block;

class HelloWorld extends \Magento\Framework\View\Element\Template
{
    protected $productCollectionFactory;
    protected $categoryFactory;

    public function __construct(
        \Magento\Framework\View\Element\Template\Context $context,
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,
        \Magento\Catalog\Model\CategoryFactory $categoryFactory,
        array $data = []
    ) {
        $this->productCollectionFactory = $productCollectionFactory;
        $this->categoryFactory = $categoryFactory;
        parent::__construct($context, $data);
    }

    public function getProductCollection()
    {
        $collection = $this->productCollectionFactory->create();
        $collection->setPageSize(3);
        foreach ($collection as $product)
        {
            print_r($product->getData());
        }
        return $collection;
    }
}

[/dm_code_snippet]

Firstly, change below all types of code as per requirement in getProductCollection() function.

2) Load product collection with specific attribute :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect(['name','sku']);
$collection->setPageSize(3);
foreach ($collection as $product)
{
    print_r($product->getData());
}

[/dm_code_snippet]

3) Load product collection with all attribute :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->setPageSize(3);
foreach ($collection as $product)
{
    print_r($product->getData());
}

[/dm_code_snippet]

4) Get product collection by multiple categories :

$categories = [1,2,3]; //category ids array
$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->addCategoriesFilter(['in' => $categories]);
return $collection;

[/dm_code_snippet]

5) Get product collection by specific category :

$categoryId = '1';
$category = $this->categoryFactory->create()->load($categoryId);
$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->addCategoryFilter($category);
$collection->addAttributeToFilter('visibility', \Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH);
$collection->addAttributeToFilter('status',\Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED);
return $collection;

[/dm_code_snippet]

6) Get product collection by product type :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->addAttributeToFilter('type_id', ['eq' => 'simple']);
$collection->getSelect()->order('created_at', \Magento\Framework\DB\Select::SQL_DESC);
$collection->getSelect()->limit(10);
return $collection;

[/dm_code_snippet]

You can add below text also as value of type_id for different product type filter :

simple = Filter of simple product
configurable = Filter of configurable product
grouped = Filter of grouped product
virtual = Filter of virtual product
bundle = Filter of bundle product

7) Get product collection by store id :

$storeid = 1;
$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->addStoreFilter($storeid);
return $collection;

[/dm_code_snippet]

8) Get product collection by website ids :

$website_ids = [1,2];
$collection = $this->productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->addStoreFilter($storeid);
$collection->addWebsiteFilter($websiteIds);
return $collection;

[/dm_code_snippet]

9) Filter Product Collection :

Is equal to :

[dm_code_snippet background=”no” background-mobile=”no” slim=”no” line-numbers=”no” bg-color=”#fff” theme=”dark” language=”php” wrapped=”no” height=”” copy-text=”Copy Code” copy-confirmed=”Copied”]

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('status', ['eq' => 1]);

[/dm_code_snippet]

Is not equal to :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('status', ['neq' => 1]);

[/dm_code_snippet]

Greater than :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('price', ['gt' => 100]);

[/dm_code_snippet]

Greater than equal to :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('price', ['gteq' => 100]);

[/dm_code_snippet]

Less than :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('price', ['lt' => 100]);

[/dm_code_snippet]

Less than equal to :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('price', ['lteq' => 100]);

[/dm_code_snippet]

Like :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('sku', ['like' => '%Bag%']);

[/dm_code_snippet]

Not Like :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('sku', ['nlike' => '%Bag%']);

[/dm_code_snippet]

In Array :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('entity_id', ['in' => [1,2]]);

[/dm_code_snippet]

Not in Array :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('entity_id', ['nin' => [1,2]]);

[/dm_code_snippet]

NULL :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('description', ['null' => true]);

[/dm_code_snippet]

NOT NULL :

$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('description', ['notnull' => true]);

[/dm_code_snippet]

Sort Product Collection :

Order by ASC :

$collection = $this->productCollectionFactory->create();
$collection->setOrder('sku', 'ASC');

[/dm_code_snippet]

$collection = $this->productCollectionFactory->create();
$collection->getSelect->order('sku', 'ASC');

[/dm_code_snippet]

Order by DESC :

$collection = $this->productCollectionFactory->create();
$collection->setOrder('sku', 'DESC');

[/dm_code_snippet]

$collection = $this->productCollectionFactory->create();
$collection->getSelect->order('sku', 'DESC');

[/dm_code_snippet]

Set Limit Product Collection :

$collection = $this->productCollectionFactory->create();
$collection->setPageSize(50)->load();

[/dm_code_snippet]

Set Limit Product Collection with Current Page :

$collection = $this->productCollectionFactory->create();
$collection->setPageSize(50)->setCurPage(2)->load();

[/dm_code_snippet]

Count Product Collection :

$collection = $this->productCollectionFactory->create();
echo $collection->count();

[/dm_code_snippet]

Group by Product Collection :

$collection = $this->productCollectionFactory->create();
$collection->getSelect()->group('entity_id');

[/dm_code_snippet]

Print Collection Query :

$collection = $this->productCollectionFactory->create();
echo $collection->getSelect()->__toString();

[/dm_code_snippet]

I hope this technical blog helped you find all ways of get product collection in Magento 2. Save this page for your future reference. In case, I missed anything or need to add some information, always feel free to leave a comment in this blog, I’ll get back with proper solution 🙂

Tagged collection, magento2, product

Rohan Hapani

Magento Tutorial | PHP Tutorial | Android Tutorial

1) Load product collection :

2) Load product collection with specific attribute :

3) Load product collection with all attribute :

4) Get product collection by multiple categories :

5) Get product collection by specific category :

6) Get product collection by product type :

7) Get product collection by store id :

8) Get product collection by website ids :

9) Filter Product Collection :

Is equal to :

Is not equal to :

Greater than :

Greater than equal to :

Less than :

Less than equal to :

Like :

Not Like :

In Array :

Not in Array :

NULL :

NOT NULL :

Sort Product Collection :

Order by ASC :

Order by DESC :

Set Limit Product Collection :

Set Limit Product Collection with Current Page :

Count Product Collection :

Group by Product Collection :

Print Collection Query :

Related Posts

Magento 2 : Create UI Component Grid and Form

How to convert old script to declarative schema in Magento 2

How to Pass Custom Data in Checkout in Magento 2