I have tried to run the following command to compensate the inventory reservation.

bin/magento inventory:reservation:create-compensations -r 

But it got stuck as in the below image.

enter image description here

It would be very helpful if anyone has a solution to this issue.


This command is waiting for you to tell it what compensations to create. See https://devdocs.magento.com/guides/v2.3/inventory/inventory-cli-reference.html for more detail, but generally what you want to do after truncating the inventory_reservations table is to pipe the output of list-inconsistencies into create-compensations:

bin/magento inventory:reservation:list-inconsistencies -r | bin/magento inventory:reservation:create-compensations

However, if you have a 3rd party manually modifying orders or qty directly in the database then you just need to turn off MSI because it can't track what it doesn't know about.

| improve this answer | |

You can truncate inventory_reservation table it will resolve your issue.

You can find more details here. https://github.com/magento/inventory/issues/2046

The one always take backup before performing direct SQL :)

| improve this answer | |
  • Thanks for your solution. But I need a permanent solution to this issue. It is not practical to truncate the table as I am getting average of 100 orders daily. – dhanus Dec 21 '19 at 6:56
  • If you follow order process then it will not create issue for you. Weird count is due to some order havent been completed and MSI reserved those qty once order placed. As this is for dev environment you shouldn't execute this in production. For permanent solution you can cancel orders which needs to be if you cant then it will start behaving weird in production as well. – anonymous Dec 23 '19 at 6:10
  • I have truncated the inventory_reservation table two times. After that also issue recurred. That's why I posted the question. – dhanus Dec 23 '19 at 7:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.