How much risk is to truncate table inventory_reservation ?

After truncate does MSI will work fine or Do i need to bang my head on keyboard !!?

  • 1
    well, I would advise to backup first before doing anything – fmsthird Jun 3 '19 at 6:18
  • That I'll obviously do but what about risk After watching MSI modules I think this table responsible for maintian qty and now I'm ready to push store to production. but products count for salable qty is mismatched. I think its due to some customer removed after placing order or incomplete order. – anonymous Jun 3 '19 at 7:39
  • @Vivek Reservation inconsistency tool may help you with these inconsistencies - github.com/magento-engcom/msi/wiki/CLI-Reference – Igor Minyaylo Jun 4 '19 at 17:20

Truncating reservation table you may break the Salability Quantity calculation for your products. Thus, it's discouraged to apply any changes to this table manually by means of direct SQL queries. Here you can read more about that - https://github.com/magento-engcom/msi/wiki/Salable-Quantity-Calculation-and-Mechanism-of-Reservations

You may run Reservation Cleanup command by CRON to make this table cleaning up periodically. More info about this here - https://github.com/magento-engcom/msi/wiki/CLI-Reference

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.