Magento – Magento 2: Sort order and limit product collection

magento2product-collection

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

Best Answer

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

Related Solutions

Magento – Get product collection filter by from and to date in magento2.

Inject class \Magento\Framework\Stdlib\DateTime\DateTime $stdlibDateTime
For example your collection have field from_date and to_date

    // init current time now
    $currentTime = $this->stdlibDateTime->date();

    // Filter datetime
    $collections = $this->getResourceCollection()
        ->addFieldToFilter('from_date', ['lteq' => $currentTime])
        ->addFieldToFilter('to_date', ['gteq' => $currentTime])
        ->setOrder('sort_order', 'ASC')
        ->getData();

Magento – Magento 2 get out of stock products in collection

If it helps anyone, this is the only way I've managed to get all products, including out of stock products, in a loop for updating the stock values.

I needed to use ->getAllIds() to get an array of all of the products IDs, and then load each product individually rather than loop through the whole collection.

$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$productCollectionIds = $productCollection->create()->getAllIds();

foreach ($productCollectionIds as $productId) {
    try {
        $product = $objectManager->create('Magento\Catalog\Model\Product')->load($productId);
        // do actions with product
    } catch (Exception $e) {
        $e->getMessage();
    }
}

Best Answer

Related Solutions

Magento – Get product collection filter by from and to date in magento2.

Magento – Magento 2 get out of stock products in collection

Related Topic