:::: MENU ::::

Magento 2 sort collection by given ids

Magento 2 sort collection by given ids

Today we discuss how in Magento 2 sort collection by give ids. Sometime we need to get product collection by given ids form example random ids 5,4,13. We take the example of product collection and filter it by give ids. You can use this on any kind of collection like order collection, category collection and any custom collection too. So here is our example.

protected $_productCollectionFactory;
public function __construct(
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productFactory
    ) {
         $this->_productCollectionFactory = $productFactory;
    public function getProductCollection()
        $productCollection = $this->_productCollectionFactory->create();
        $productCollection->getSelect()->order(new \Zend_Db_Expr('FIELD(entity_id,' . implode(',', $productIds).')'));
        return $productCollection;

Note: You can sort any collection following this example.

Author: Qaisar Satti
Category: Magento 2
Last Modified: July 12, 2018

One Comment

  • Reply Aleksandr Aleksandr |

    It works for me

    $collection->getSelect()->order(new \Zend_Db_Expr(‘FIELD(e.entity_id,’ . implode(‘,’, $this->featureProductsArray).’)’));

    Whole code is

    $collection = $this->_productCollectionFactory->create();
    $collection->addFieldToFilter(‘sku’,[‘in’ => $featureProductsArray]);
    $collection->addAttributeToFilter(‘visibility’, \Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH);
    $collection->getSelect()->order(new \Zend_Db_Expr(‘FIELD(e.entity_id,’ . implode(‘,’, $this->featureProductsArray).’)’));
    $items = $collection->load();

So, what do you think ?