resourceConnection = $resourceConnection; $this->getProductIdsBySkus = $getProductIdsBySkus; } /** * @param array $skus * @return void * @throws \Magento\Framework\Exception\NoSuchEntityException */ 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, ] ); } }