Reset saleable qty

[patrick_tschumi]

Hello

I deleted all testorders and stuff. Now it looks clean exept the saleable qty. 

Is there a way to reset it that it's 1:1 the same as the normal qty?

[Vimal Kumar · Accepted solution]

Hi @patrick_tschumi,

If you haven't any real order then you can reset the following database table.

All product reservations are stored in following table.

inventory_reservation

Or you can manually update this table for wrong qty products.

for more info:
https://github.com/magento/inventory/wiki/Salable-Quantity-Calculation-and-Mechanism-of-Reservations


I hope it will help you!

[harshal_patel]

Actually issue is,

For x product,

I have 10 qty and salable qty is 10.

There are 2 order placed so.

Now I have 10 qty and salable qty is 8.

Now I have dropshipping business so I am relying on third party qty.

Now I got product list to import.. and in that x product has qty 0.

When I imported that list in admin, it becomes qty 0 and salable qty is 8.

Which is wrong, how can i make both same? because I have qty 0 so salable qty also must become 0.

Can I delete all records of inventory_reservation table? whenever I import the products?

is that feasible? and it will not harm anything? 

or is there any other solution? please suggest as soon as possible. thanks in advance.

[ismailcaakir]

Any solution this problem?

[SimpleBhaumik]

If you have not any pending orders just truncate the table "inventory_reservation". It will help and just to be safe, take a backup of this table from database.