cancel
Showing results for 
Search instead for 
Did you mean: 

Afer Magento upgrade Saleable qty is 0

SOLVED

Afer Magento upgrade Saleable qty is 0

I have upgraded magento from 1.9 to 2.3 and after up-gradation the saleable qty is 0.

I have 8000 products and it is difficult to change the saleable qty for each product from admin. Can anyone please help me so that I quickly update the saleable quantity of all the products.

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Afer Magento upgrade Saleable qty is 0

Hello @alexedeyop641f ,

Please execute the following sql query:

 

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS SELECT distinct `legacy_stock_status`.`product_id` AS `product_id`, `legacy_stock_status`.`website_id` AS `website_id`, `legacy_stock_status`.`stock_id` AS `stock_id`, `legacy_stock_status`.`qty` AS `quantity`, `legacy_stock_status`.`stock_status` AS `is_salable`, `product`.`sku` AS `sku` FROM ( `cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on ((`legacy_stock_status`.`product_id` = `product`.`entity_id`)) );

where root: db user

localhost: db host

If this helps you, please accept it as solution and give kudos.

Regards.

 

View solution in original post

2 REPLIES 2

Re: Afer Magento upgrade Saleable qty is 0

Hello @alexedeyop641f ,

Please execute the following sql query:

 

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS SELECT distinct `legacy_stock_status`.`product_id` AS `product_id`, `legacy_stock_status`.`website_id` AS `website_id`, `legacy_stock_status`.`stock_id` AS `stock_id`, `legacy_stock_status`.`qty` AS `quantity`, `legacy_stock_status`.`stock_status` AS `is_salable`, `product`.`sku` AS `sku` FROM ( `cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on ((`legacy_stock_status`.`product_id` = `product`.`entity_id`)) );

where root: db user

localhost: db host

If this helps you, please accept it as solution and give kudos.

Regards.

 

Re: Afer Magento upgrade Saleable qty is 0

Thank you @vishi_gulati