BulkZeroLegacyStockItem.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\InventoryCatalog\Model\ResourceModel;

use Magento\CatalogInventory\Api\Data\StockItemInterface;
use Magento\Framework\App\ResourceConnection;
use Magento\InventoryCatalogApi\Model\GetProductIdsBySkusInterface;

class BulkZeroLegacyStockItem
{
    private $resourceConnection;

    private $getProductIdsBySkus;

    public function __construct(
        ResourceConnection $resourceConnection,
        GetProductIdsBySkusInterface $getProductIdsBySkus
    ) {
        $this->resourceConnection = $resourceConnection;
        $this->getProductIdsBySkus = $getProductIdsBySkus;
    }

    public function execute(array $skus)
    {
        $productIds = array_values($this->getProductIdsBySkus->execute($skus));

        $connection = $this->resourceConnection->getConnection();
        $connection->update(
            $this->resourceConnection->getTableName('cataloginventory_stock_item'),
            [
                StockItemInterface::QTY => 0,
                StockItemInterface::IS_IN_STOCK => 0,
            ],
            [
                StockItemInterface::PRODUCT_ID . ' IN (?)' => $productIds,
                'website_id = ?' => 0,
            ]
        );
    }
}