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()

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()

    ->setPageSize(10) // only get 10 products 
    ->setCurPage(1)  // first page (means limit 0,10)
  • 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 '19 at 13:54
  • setPageSize is not working for me – Sagar Parikh Dec 26 '19 at 10:55
  • If you add setPageSize and setCurPage it will make 2 queries instead of one. Firstly it will count how many rows there are, and then will make query with limit. This might negate any speedup from adding limit. To make only one query you need to use $collection->getSelect()->limit(3) – Volvox May 26 '20 at 23:08

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.