Magento 2.3.X: Data Migration – product show out of stock after migration

Try backup the inventory_source_item table and use the below query:
[sql]
insert into `inventory_source_item`
(source_code, sku, quantity, status)
select ‘default’, sku, qty, stock_status from (`cataloginventory_stock_status` as `lg` join `catalog_product_entity` as `prd` on((`lg`.`product_id` = `prd`.`entity_id`)))
[/sql]

Leave a Comment

Your email address will not be published. Required fields are marked *

*