- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Reset saleable qty
Any solution this problem?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.