Magento – Magento 2.3 stock update in DB level

magento2.3manage-stock

I'm Currently using magento2.3, i have added a cron job to update products stock every 20 min from external inventory which will create a CSV file to magento directory, i will read this file and loop
to the quantity and create a SQL query to update it to cataloginventory_stock_item table and run reindex.

Quantity get updated but not showing add to cart in front-end , after product save manually from admin it's working fine. It is proper method to update qty or else there is any other method for performance using this method, because our store having more then 20K+ products

Best Answer

Please try the below code if it helps instead of updating the stock directly to the database table.

Use the Magento\CatalogInventory\Api\StockRegistryInterface to update the product qty.

public function updateQty($qty,$sku) {
    $stockItem = $stockRegistry->getStockItemBySku($sku);
    $stockItem->setQty($qty);
    $stockItem->setIsInStock((bool)$qty);
    $stockRegistry->updateStockItemBySku($sku, $stockItem);
}

OR try the below sql query for update stock:

UPDATE cataloginventory_stock_item item_stock, cataloginventory_stock_status status_stock
SET item_stock.qty = '$qty', item_stock.is_in_stock = IF('$qty'>0, 1,0),
status_stock.qty = '$qty', status_stock.stock_status = IF('$qty'>0, 1,0)
WHERE item_stock.product_id = '$product_id' AND item_stock.product_id = status_stock.product_id

Hope this helps!

Related Solutions

Magento2 API Stock Update – How to Manage Stock with JSON

Using this documentation : Magento Commerce for B2B v2.2, I was able successfully create API calls for the stockItem.

This is a PUT operation, make sure that you get the correct item_id for that product.

/V1/products/{productSku}/stockItems/{itemId}

item_id from GET Product API:

"stock_item": { "item_id": 4721, "qty": 1234, "is_in_stock": true }

Also, regarding the underscores, I think it would be safer to follow what is in the documentation, but based on my experience, both works:

PS. I use Postman for testing the APIs.

Magento 2.3 – Update Source Stock

You need to create sourceItem objects, therefore I have injected a factory for that in your constructor. You can use the following code - it should work for you. since the constructor has changes, you might need to remove the corresponding generated file for your class

<?php
namespace <vendor>/<module>;

use Magento\InventoryApi\Api\SourceItemsSaveInterface;
use Magento\InventoryApi\Api\Data\SourceItemInterfaceFactory;

class Temp
{
   protected $_sourceItemsSaveInterface;

   protected $_sourceItemFactory;

   public function __construct(
       SourceItemsSaveInterface $sourceItemsSaveInterface,
       SourceItemInterfaceFactory $sourceItemFactory
   )
   {
       $this->_sourceItemsSaveInterface = $sourceItemsSaveInterface;
       $this->_sourceItemFactory = $sourceItemFactory;
   }

   public function testFunction() {

       //create the sourceItem using the factory
       $sourceItem = $this->_sourceItemFactory->create();
       $sourceItem->setSourceCode('source');
       $sourceItem->setSku('12345678');
       $sourceItem->setQuantity(50);
       $sourceItem->setStatus(1);

       //pass the sourceItem as an array element, you can add more source items in the same call as further array elements
       $this->_sourceItemsSaveInterface->execute([$sourceItem]);
   }
}

I hope that helps.

Best Answer

Related Solutions

Magento2 API Stock Update – How to Manage Stock with JSON

Magento 2.3 – Update Source Stock

Related Topic