Magento 2.4.2-p1 default source stock problem

[Toni]

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)

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

Best regards

[Toni]

Hi @marcus

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

CREATE
SQL SECURITY INVOKER
VIEW `inventory_stock_1`
  AS
    SELECT
    DISTINCT    
      legacy_stock_status.product_id,
      legacy_stock_status.website_id,
      legacy_stock_status.stock_id,
      legacy_stock_status.qty quantity,
      legacy_stock_status.stock_status is_salable,
      product.sku
    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.

[LitExtension Expert · Accepted solution]

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

[Toni]

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.

[P M D Jagtap]

Helpful for me