This Table ( inventory_source_item ) is Empty and which all my product show out of stock, Can anyone, please help me solve this issue
-
Let me know as per your requirement whether you want to migrate catalog data?– Nagaraju KasaCommented Nov 1, 2019 at 6:55
-
Thank you for reply my error is solve– DK ThakurCommented Nov 1, 2019 at 7:04
-
let me know what is the issue plz– Nagaraju KasaCommented Nov 1, 2019 at 7:07
-
(inventory_source_item) this table is empty after migration and show all my products is out of stock– DK ThakurCommented Nov 1, 2019 at 7:15
-
You can import CSV with stock status to resolve this issue.– anonymousCommented Nov 1, 2019 at 8:22
|
Show 2 more comments
1 Answer
You can use the following query to build out the inventory_source_item table based on the legacy cataloginventory_stock_status table:
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`)))
