Magento2 Product Collection – How to Get Product Collection with Product IDs

magento2product-collection

Is it possible to get a product collection bassd on array of product ids?

Best Answer

Given an instantiated but not loaded collection $collection and an array of product ids $productIds, you can use addIdFilter() just as in Magento 1:

$collection->addIdFilter($productIds);

To instantiate a collection, you can inject a \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory and then use

$collection = $this->collectionFactory->create();

But this is not recommended practice anymore!

In Magento 2, you should not think too much in terms of collections anymore when using core modules, they are a mere implementation detail. Use the service contracts instead:

Inject Magento\Catalog\Api\ProductRepositoryInterface and \Magento\Framework\Api\SearchCriteriaBuilder
use Magento\Framework\Api\Filter;

Build a search criteria and pass it to $productRepository->getList():

$searchCriteria = $this->searchCriteriaBuilder->addFilter(new Filter([
    Filter::KEY_FIELD => 'entity_id',
    Filter::KEY_CONDITION_TYPE => 'in',
    Filter::KEY_VALUE => $productIds
]))->create();
$products = $this->productRepository->getList($searchCriteria)->getItems();

$products then is an array of products.

Related Solutions

Magento – Problem with addWebsiteFilter and addStoreFilter

In magento, addStoreFilter() does not filter the collection by multiple stores . We are able to filter the product collection by one store only.

You can see.the logic at Mage_Catalog_Model_Resource_Product_Collection.

    public function addStoreFilter($store = null)
    {
        if ($store === null) {
            $store = $this->getStoreId();
        }
        $store = Mage::app()->getStore($store);

        if (!$store->isAdmin()) {
            $this->_productLimitationFilters['store_id'] = $store->getId();
            $this->_applyProductLimitations();
        }

        return $this;
    }

Magento does not have any function which will filter the collection by mutiple store id

Magento – Get product IDs of current category page

I found the solution, so nevermind, this topic can be closed

https://stackoverflow.com/questions/12317519/magento-get-current-sort-direction-with-getcollection

if( $this->getMode()!='grid' ) {
    $limit = Mage::getStoreConfig('catalog/frontend/list_per_page'); 
}
else {
    $limit = Mage::getStoreConfig('catalog/frontend/grid_per_page');
}   
  $_productCollection= Mage::getModel('catalog/product')->getCollection()
                        ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
                         ->addAttributeToSelect('sku_base')
                         ->addStoreFilter(Mage::app()->getStore()->getId())
                         ->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds())
                         ->setPage(Mage::getBlockSingleton('page/html_pager')->getCurrentPage(), $limit)
                         ->setPageSize( $limit )
                         ->setOrder(Mage::getBlockSingleton('catalog/product_list_toolbar')->getCurrentOrder(), Mage::getBlockSingleton('catalog/product_list_toolbar')->getCurrentDirection())
                         ->load();

so, it's possible to get the current category page SortOrder and the PageNumber and use it as CollectionFilter

Best Answer

Related Solutions

Magento – Problem with addWebsiteFilter and addStoreFilter

Magento – Get product IDs of current category page

Related Topic