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?
Solved! Go to 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!
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!
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.
Any solution this problem?
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.