Magento 2 get out of stock products in collection

Question

I am trying to get all the products from the collection(both in stock and out of stock) but with no luck at all. The setting on admin needs to hide the out of stock products from frontend but I want to show them in a specific page.

This is my code:

$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection');
$productCollection->addAttributeToSelect('*');
$productCollection->load();

This brings the in stock products only. How can I modify it to bring and the out of stock as well?

Thanks

Answer 1

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

Answer 2

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

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

$collection = $productCollection->create() ->setFlag('has_stock_status_filter', true)->load() ->addAttributeToSelect('*') ->load(); print_r($collection->getData());

Answer 3

public function __construct(
    \Magento\Backend\Block\Template\Context $context,        
    \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,        
    array $data = []
)
{    
    $this->_productCollectionFactory = $productCollectionFactory;    
    parent::__construct($context, $data);
}

 public function getProductCollection()
{
    $collection = $this->_productCollectionFactory->create();
    $collection->addAttributeToSelect('*');
    $collection->setFlag('has_stock_status_filter', true)->load();
    $collection->setPageSize(3); // fetching only 3 products
    return $collection;
}

Answer 4

Use below code to filter "Out of Stock" product:

$productCollection =
$objectManager->create('Magento\Catalog\Model\Product\LinkFactory');
$productCollection->create()->getProductCollection()->addAttributeToSelect('*')
->addAttributeToFilter('status', array('eq' =>
\Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED));
$productCollection->joinField( 'qty', 'cataloginventory_stock_item',
'product_id=entity_id', '{{table}}.stock_id=1');