Product Stock Issue

[Ansarul146]

Hi All

I have export the product data see its already set out_of_stock_qty=0 some product still set out_of_stock_qty=1 check example . can anyone help me to resolve the issue to set all data set out_of_stock_qty=0 in SQL

You can have a look : https://prnt.sc/rizexw

[Rahul Gupta]

@Ansarul146 Please try to run the below query and let me know if you stuck.

UPDATE cataloginventory_stock_item item_stock, cataloginventory_stock_status status_stock
SET item_stock.qty = 0, item_stock.is_in_stock = 0,
status_stock.qty = 0, status_stock.stock_status = 0
WHERE item_stock.product_id in (SELECT entity_id FROM catalog_product_entity) AND item_stock.product_id = status_stock.product_id

Thanks