[magento 2.3] Product having zero salable quantity results in stock in frontend

[canvas4web]

I just changed to -- STORE > CATELOG > INVENTORY > PRODUCTS STOCK OPTIONS > BACKORDERS > Allow Qty Below 0

and my problem solved

[jamfoort]

The Salable Quantity is the stock minus the already sold quantities. So if your Quantity is 100 and an order has been placed for 50 of those products, the Salable Quantity is reduced by 50 but the regular Quantity will remain 100 until the Order is sent.

https://devdocs.magento.com/guides/v2.3/inventory/reservations.html

[SemExpert]

That does not solve the problem, it simply hides it. Since you are selling with backorders, saleable qty becomes irrevelant...

[Sarvagya Pandey]

Hello @alxr89 ,

I think you have you have imported the database from your local of different server, if that is the case then please check my answer posted https://community.magento.com/t5/Magento-2-x-Technical-Issues/After-Import-product-now-Product-Salab...

I hope this will work for you(and others which are facing same issue).

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

Regards

[alxr89]

Hi everyone, this post was about a beta of 2.3, so I think it can be closed 

[Gmsconsulting]

Im still getting the same problem, so it might be a bit premature to close it. Its an extremely frustrating problem.

[Sarvagya Pandey]

Hello
You can try solution which I have provided.
I hope that will work for you.
If it helps you please give kudos and accept it as solution.
Regards

[mounika_chawla]

To solve this issue, you will need to manually create the view in your new database by executing the below SQL. You have the solution here https://www.eglobeits.com/blog/why-salable-quantity-is-showing-zero-in-magento-2-3-product-grid/

[ankitgupta1990]

Thank you. This was exactly my problem. Solved by running the SQL query, followed by cache:flush.

[Arshad M]

Please make sure you have a view table inventory_stock_1 in your database.

This issue can come if you have migrated database from one to another so that time you may be missed to migrate view tables.