Showing results for 
Search instead for 
Did you mean: 

Magento 2.4.2-p1 default source stock problem


Re: Magento 2.4.2-p1 default source stock problem

Hi @Marcus


This could be in a good direction.

Yes, the salable qty is always 0 despite the qty has positive value.


Yes, we use the migration tool to migrate from a Magento 1 website. Despite we only needed the categories tree we used migration tool to do that and then we removed all we didn't need.
So, what you say has sense for me.


I have the "inventory_stock" table with the default source and then 3 more EMPTY tables (1, 2, 3)


Screenshot at Nov 09 09-43-54.png


I'm going to create the view table to check it. I have no views now:

Screenshot at Nov 09 09-47-26.png


Best regards

Re: Magento 2.4.2-p1 default source stock problem

Hi @marcus


I've tried to create the view after removing the inventory_stock_1 table with this:


VIEW `inventory_stock_1`
      legacy_stock_status.qty quantity,
      legacy_stock_status.stock_status is_salable,
    FROM `cataloginventory_stock_status` `legacy_stock_status`
      INNER JOIN `catalog_product_entity` product
        ON legacy_stock_status.product_id = product.entity_id;

But then the salable doesn't fix.
The view table keeps empty and the cataloginventory_stock_status is too empty. I suppose there is the problem.


I've tried too creating a new product (just to discard was a problem with my initial test product) but is the same problem, the salable qty never change from 0.


Do you know what more can I try?


Thank you very much.

Re: Magento 2.4.2-p1 default source stock problem

You check in the cataloginventory_stock table, see the number behind website_id =


If it's website_id =1 change it to =0 and reindex

LitExtension - #1 Shopping Cart Migration Expert

LitExtension helps store owners and agencies migrate all important data from one eCommerce platform to another accurately, securely and at the highest speed.

Visit website:

Re: Magento 2.4.2-p1 default source stock problem

Thank you very much @LitE...

That works!!

Could you tell me why could be happened? Could be from the migration tools usage or something related or Is there any known source about that? Any reference link just to read more about?


Best regards.

Re: Magento 2.4.2-p1 default source stock problem

Helpful for me