I have a problem with Salable Quantity in Magento 2.3
After importing products, entering the catalog and no product has Salable Quantity. I do not know why.
If I enter to edit the product and without changing anything I save it, the product appears with the Salable Quantity field. Why? If I just save, I don’t change anything?
I’m frustrated.
I import products with a .csv file with these fields.
sku: VAL-LIGA-12
attribute_set_code: Default
product_type: simple
product_online: 1
qty: 100
is_in_stock: 1
I appreciate any help to import products with the Salable Quantity field.
I enclose a screenshot.
Regards.
2
Answers
Your issue looks similar to mine.
I removed MSI when installing Magento 2 – Then after purchasing an ebay plugin we needed MSI – so then I re-installed it – and like you – my "Saleable Quantity" was blank – not 0 – blank.
My product with blank saleable quantity
After a load of googling and looking at other posts – I found I’d f****d the db.
My ‘inventory_source_item’ was empty – so to fix this I found a post on here:
The SQL provided fixed the ‘inventory_source_item’ table.
^ Important: here ‘default’ is the source_code of your stock source – if yours is like mine then the SQL should work as is, otherwise change ‘default’ to ‘yourstocksourcecode’ ^
My stock sources
but still my "Saleable Quantity" was blank.
Then I noticed the ‘inventory_source_item_link’ table was empty. I simply inserted 1 row:
and now my Saleable Quantity is there 🥳 1 row doesn’t have it because its just the grouped product…
My products showing saleable quantity
It’s also worth pointing out – after the final SQL I re-indexed to make sure it would be there:
In my case, I disabled extension "php bin/magento module:disable BoostMyShop_AdvancedStock" and stock issue resolved.
Thanks,