cancel
Showing results for 
Search instead for 
Did you mean: 

Saleable Quantity - Can this be reset?

Saleable Quantity - Can this be reset?

Hi

 

I have a product that has a quantity of 1 and a saleable quantity of 0. Is it possible to reset the saleable quantity so that it shows 1 (same value as the quantity)?

Screenshot 2024-01-04 112208.png

I don't have any outstanding orders for this product so the quantity and saleable quantity should be the same.

 

I've checked the database and I can see that in the stock_reservation table the item has a quantity of 1 reserved, so I know this is causing the issue.

Screenshot 2024-01-04 113306.png

 

What is the best way to solve the problem?

Can I delete the row from the stock_reservation table or would this cause other issues?

 

My Magento version is 2.4.6-p1

 

Thanks
Paul

1 REPLY 1

Re: Saleable Quantity - Can this be reset?

You can delete the row from the stock_reservation table, we did that before without any issues.

 

But it would be best to find the cause of that reservation, probably some order that isn't shipped or canceled.

Founder at https://agency418.com