Is there a quick way to update stock levels in Magento 2?

Question

We need to update the stock levels of lots of products following off-site sales. Rather than click though to the details of every product, is there a way of quickly updating the stock figure from a table view without having to leave the table?

Or is the best way to export/import and amend via a spreadsheet?

I'd be grateful for any pointers.

Thanks

Answer 1

it is not good practices to update inventory direct from database table. You can import it using CSV or programmatically using below code :

$stockItem = $this->stockRegistry->getStockItem($entity_id);
$stockItem->setData('qty', $qty);
$stockItem->setData('is_in_stock', ($qty > 0 ) ? 1 : 0); 
$stockItem->save(); 

Thanks

Answer 2

Best and easy way is to update product stock is

Go to admin side -> Catalog -> Products -> Select products from the grid which you want to update stock

After that click on Action dropdown -> select Update Attrbites

after that go to Advanced Inventory tab and manage your stock like quantity etc

Answer 3

It's not best practice, but you can also use a direct SQL method which would be much quicker - though as it wouldn't trigger a product save, it wouldn't destroy the cache for those products so you would need to flush cache.

Here's the sql to show you the sku, stock position and whether its marked as in stock;

SELECT p.sku, i.qty, i.is_in_stock 
FROM dbname.cataloginventory_stock_item i, dbname.catalog_product_entity p 
WHERE p.entity_id = i.product_id 
AND i.stock_id = 1

Obviously ensure that if the stock position is greater than 0, make sure is_in_stock is set to 1, otherwise set it to 0.