QuestionQ21

Working with Databases and EAV

While reviewing the cron logs, an Adobe Commerce developer observes that this job runs daily:

main.INFO: Cron Job inventory_cleanup_reservations is successfully finished.

However, the database inventory_reservation table is not cleared.

Why do records remain in the inventory_reservation table?

  • A Only reservations matching canceled orders are removed by the cron job.
  • B Only reservations no longer needed are removed by the cron job.
  • C The “Auto Cleanup” feature from Multi Source Inventory was disabled in configuration.
Explanation

The inventory_cleanup_reservations cron job deletes only complete reservation sequences that are no longer required—specifically, sequences whose reservation quantities have been fully compensated so their total is zero. Rows for reservations that remain uncompensated, such as inventory holds for open orders, are retained.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!