cancel
Showing results for 
Search instead for 
Did you mean: 

Downloadable product showing out of stock after migrating 1.9 to 2.3

Downloadable product showing out of stock after migrating 1.9 to 2.3

Hi

I migrated magento 1.9.0.1 to 2.3.2 using data migration tool. Before the migration I was able to create a downloadable product with add to cart button on M2. But after migrating, upgrading, compiling and re indexing although I am getting my M1 downloadable products just fine but I am no longer able to create an IN STOCK downloadable product in migrated M2. Has anyone experienced the same problem ?

 

I tried "default" attribute set as well "Migration_Default" attribute set but the product is always showing OUT OF STOCK on front end.

 

The Stock Status dropdown is not showing when creating product. It was showing before the migration.

1 REPLY 1

Re: Downloadable product showing out of stock after migrating 1.9 to 2.3

There is small update in query

 

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`))) ON DUPLICATE KEY UPDATE quantity = VALUES(quantity), status = VALUES(status)