Magento 2 – Get Products with Quantity Less Than 5

collection;inventorymagento2product

I'm trying to get product collection, only the products which have the qty less than 5 in Magento 2, but I'm failing to load.


use Magento\Framework\App\Bootstrap; 
require DIR . '/../app/bootstrap.php'; 
$bootstrap = Bootstrap::create(BP, $_SERVER); 
$obj = $bootstrap->getObjectManager(); 
$state = $obj->get('Magento\Framework\App\State'); 
$state->setAreaCode('frontend'); 
$productCollection = $obj->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$collection = $productCollection->create()
->addAttributeToSelect('*')->load(); 
$collection->addAttributeToFilter('qty',['lt'=>5])

Best Answer

Try this:

use Magento\Framework\App\Bootstrap; 
require DIR . '/../app/bootstrap.php'; 
$bootstrap = Bootstrap::create(BP, $_SERVER); 
$obj = $bootstrap->getObjectManager(); 
$state = $obj->get('Magento\Framework\App\State'); 
$state->setAreaCode('frontend'); 
$productCollection = $obj->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory'); 
$collection = $productCollection->create()->addAttributeToSelect('*');
$collection->joinField(
'qty', 'cataloginventory_stock_item', 'qty', 'product_id=entity_id', '{{table}}.stock_id=1', 'left'
);
$collection->addAttributeToFilter('qty',['lt'=>5]) ->load();

Related Solutions

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

Magento 2 Error – Model Class Not Found in AbstractFactory.php:93

You have typo in your app/code/Ciptaloka/HelloWorld/Model/HelloWorld.php at line 3:

namespace Ciptloka\HelloWorld\Model;

It should be:

namespace Ciptaloka\HelloWorld\Model;

Notice the difference between Ciptloka and Ciptaloka.

Best Answer

Related Solutions

Magento – Magento 2 get out of stock products in collection

Magento 2 Error – Model Class Not Found in AbstractFactory.php:93

Related Topic