AD0-E716 · Question #40
When checking the cron logs, an Adobe Commerce developer sees that the following job occurs daily: main.INFO: Cron Dob inventory_cleanup_reservations is successfully finished. However, the…
The correct answer is B. Only reservations no longer needed are removed by the cron job. The reason why there are records remaining in the inventory_reservation table is that only reservations no longer needed are removed by the cron job. The inventory_reservation table tracks the quantity of each product in each order and creates a reservation for each product…
Question
When checking the cron logs, an Adobe Commerce developer sees that the following job occurs daily: main.INFO: Cron Dob inventory_cleanup_reservations is successfully finished. However, the inventory_reservation table in the database is not emptied. Why are there records remaining in the inventory_reservation table?
Options
- AOnly reservations matching canceled orders are removed by the cron job.
- BOnly reservations no longer needed are removed by the cron job.
- CThe "Auto Cleanup" feature from Multi Source Inventory was disabled in configuration.
How the community answered
(42 responses)- A2% (1)
- B93% (39)
- C5% (2)
Explanation
The reason why there are records remaining in the inventory_reservation table is that only reservations no longer needed are removed by the cron job. The inventory_reservation table tracks the quantity of each product in each order and creates a reservation for each product when an order is placed, shipped, cancelled or refunded. The initial reservation has a negative quantity value and the subsequent reservations have positive values. When the order is complete, the sum of all reservations for the product is zero. The cron job removes only those reservations that have a zero sum from the table, leaving behind any reservations that are still needed for incomplete orders. Verified Reference: [Magento 2.4 DevDocs] [Magento Stack Exchange]
Topics
Community Discussion
No community discussion yet for this question.