cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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

and my problem solved

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

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

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

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

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

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

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

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

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

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

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

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

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

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/

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

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

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

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.