How to get all the products including out of stock products?

Let’s say if you need to get all the products through the collection with out-of-stock products and send it in JSON format then what will you do?

Step 1: Create a front controller GetProducts.php file

<?php

namespace Magemonkeys\CustomInventory\Controller\Inventory;

use Magento\Framework\App\Action\Context;
use Magemonkeys\CustomInventory\Helper\Data;


class GetProducts extends \Magento\Framework\App\Action\Action
{
    public function __construct(
        Context $context,
        Data $helper
    ){
        $this->helper = $helper;
        parent::__construct($context);
    }

    public function execute()
    {
        $data = $this->helper->getProductData();

        header('Content-Type: application/json');

        echo json_encode(array(
            'data'=>$data,
            'meta'=> array(
                'count' => count($data)
            )
        ));

        return;

    }
}

<?php

namespace Magemonkeys\CustomInventory\Controller\Inventory;

use Magento\Framework\App\Action\Context;

use Magemonkeys\CustomInventory\Helper\Data;

class GetProducts extends \Magento\Framework\App\Action\Action

{

public function __construct(

Context $context,

Data $helper

){

$this->helper = $helper;

parent::__construct($context);

}

public function execute()

{

$data = $this->helper->getProductData();

header('Content-Type: application/json');

echo json_encode(array(

'data'=>$data,

'meta'=> array(

'count' => count($data)

)

));

return;

}

Step 2: Create a Data.php in the helper folder of your module and paste the below code into it.

<?php

namespace Magemonkeys\CustomInventory\Helper;

use Magento\Framework\App\Helper\AbstractHelper;
use Magento\Framework\App\Filesystem\DirectoryList;
use Magento\CatalogInventory\Model\Stock\StockItemRepository; // Probably deprecating this with the following
use Magento\CatalogInventory\Api\StockRegistryInterface;


class Data extends AbstractHelper
{
    private $productFactory;
    private $productCollectionFactory;
    private $stockItemRepository;
    private $inflightStatuses;
    protected $stockRegistry;


    public function __construct(
        \Magento\Catalog\Model\ProductFactory $productFactory,
        StockItemRepository $stockItemRepository, // Probably deprecating this with the following
        StockRegistryInterface $stockRegistry,
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory
    )
    {
        $this->inflightStatuses = array('processing', 'fulfillment_picking', 'incomplete', 'holded', 'on_review');
        $this->productFactory = $productFactory;
        $this->productCollectionFactory = $productCollectionFactory;
        $this->stockItemRepository = $stockItemRepository; // Probably deprecating this with the following
        $this->stockRegistry = $stockRegistry;
    }

    public function getProductData()
    {
        $data = array();

        $collection = $this->productCollectionFactory->create();
        $collection->addAttributeToSelect('*');
        $collection->setPageSize(100000);
        $collection->setFlag('has_stock_status_filter', false);


        /*echo $collection->count();
        exit;*/

        $collection->load();

        /* Start to add out of stock products in collection */
        $collection->clear();
        
        $updatedWhere = array();
        $where = $collection->getSelect()->getPart('where');
        foreach ($where as $key => $condition)
        {
            if(strpos($condition, 'stock_status_index.stock_status = 1') !== false){
                $updatedWhere[] = 'AND (stock_status_index.stock_status IN (1,0))';
            } else {
                $updatedWhere[] = $condition;
            }   
        }
        $collection->getSelect()->setPart('where', $updatedWhere);
        /* End of to add out of stock products in collection */

        $collection->load();

        foreach ($collection as $product) {

            $sku = trim($product->getSku());

            //$stockItem = $this->stockItemRepository->get($product->getId());
            $stockItem = $this->stockRegistry->getStockItemBySku($sku);


            $data[$sku] = array(
                'sku' => $sku,
                'name' => $product->getName(),
                'qty' => (int) $stockItem->getQty(),
                'in_stock' => $stockItem->getIsInStock()
            );
        }
        return $data;
    }
}

<?php

namespace Magemonkeys\CustomInventory\Helper;

use Magento\Framework\App\Helper\AbstractHelper;

use Magento\Framework\App\Filesystem\DirectoryList;

use Magento\CatalogInventory\Model\Stock\StockItemRepository; // Probably deprecating this with the following

use Magento\CatalogInventory\Api\StockRegistryInterface;

class Data extends AbstractHelper

{

private $productFactory;

private $productCollectionFactory;

private $stockItemRepository;

private $inflightStatuses;

protected $stockRegistry;

public function __construct(

\Magento\Catalog\Model\ProductFactory $productFactory,

StockItemRepository $stockItemRepository, // Probably deprecating this with the following

StockRegistryInterface $stockRegistry,

\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory

)

{

$this->inflightStatuses = array('processing', 'fulfillment_picking', 'incomplete', 'holded', 'on_review');

$this->productFactory = $productFactory;

$this->productCollectionFactory = $productCollectionFactory;

$this->stockItemRepository = $stockItemRepository; // Probably deprecating this with the following

$this->stockRegistry = $stockRegistry;

}

public function getProductData()

{

$data = array();

$collection = $this->productCollectionFactory->create();

$collection->addAttributeToSelect('*');

$collection->setPageSize(100000);

$collection->setFlag('has_stock_status_filter', false);

/*echo $collection->count();

exit;*/

$collection->load();

/* Start to add out of stock products in collection */

$collection->clear();

$updatedWhere = array();

$where = $collection->getSelect()->getPart('where');

foreach ($where as $key => $condition)

{

if(strpos($condition, 'stock_status_index.stock_status = 1') !== false){

$updatedWhere[] = 'AND (stock_status_index.stock_status IN (1,0))';

} else {

$updatedWhere[] = $condition;

}

$collection->getSelect()->setPart('where', $updatedWhere);

/* End of to add out of stock products in collection */

$collection->load();

foreach ($collection as $product) {

$sku = trim($product->getSku());

//$stockItem = $this->stockItemRepository->get($product->getId());

$stockItem = $this->stockRegistry->getStockItemBySku($sku);

$data[$sku] = array(

'sku' => $sku,

'name' => $product->getName(),

'qty' => (int) $stockItem->getQty(),

'in_stock' => $stockItem->getIsInStock()

);

}

return $data;

}

Fill the below form if you have any Magento programming need.

Add an image programmatically from any url in Magento 2
[crayon-6421750f831cf438693043/] Using above fucntion Images can be imported directly from...
Magento 2 : Override the Category view block file
Override view block using di.xml and add the below code...
How to check list of Layout XML called for a specific page in Magento 2?
You can check a list of called layout XML for...
Magento 2 : Setup PWA from Scratch
Follow the below steps to install and set up PWA...
How to remove leading zero’s from the order, invoice and shipment number in Magento 2?
If you want to remove all leading zero's from order,...

Author Info

Hire A. Patel

Let’s have a call

Fill the form & Get Installation Support