16

I need to sort the product collection by ID order DESC and add limit to product collection. Here is my code:

$objectManager     = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$collection        = $productCollection->create()
    ->addAttributeToSelect('*')
    ->load();
31

Just add this code addAttributeToSort('entity_id', 'desc') to your collection.

As product follows EAV structure, you can use addAttributeToSort('attribute_code', 'sort_order')

For limiting a collection use setPageSize() and setCurPage() methods:

$collection = $productCollection->create()
    ->addAttributeToSelect('*');

$collection 
    ->setPageSize(10) // only get 10 products 
    ->setCurPage(1)  // first page (means limit 0,10)
    ->load(); 
  • 1
    You have not answered the limit part. – Hashid Feb 3 '17 at 9:32
  • @Hashid updated the answer. – Roman Snitko Dec 19 '17 at 14:12
  • Great! This also fixed an issue when having 2 collection blocks on a page, one of them paging, which broke the other collection which wasn't meant to be paging. The 'setCurPage' on the latter fixed this 🥳 – 00-BBB Nov 29 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.