cancel
Showing results for 
Search instead for 
Did you mean: 

Product Stock Issue

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Product Stock Issue

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

 

 

 

1 REPLY 1

Re: Product Stock Issue

@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