cancel
Showing results for 
Search instead for 
Did you mean: 

Reset saleable qty

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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.