cancel
Showing results for 
Search instead for 
Did you mean: 

Reset saleable qty

SOLVED

Reset saleable qty

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Reset saleable qty

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!

View solution in original post

4 REPLIES 4

Re: Reset saleable qty

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!

Re: Reset saleable qty

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.

 

Re: Reset saleable qty

Any solution this problem?

Re: Reset saleable qty

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.