Top 10 Reserved Products Metric
How-to Guide
Author:
Holger Lierse
Changed on:
16 Sept 2025
Key Points
- Products with the highest levels of reserved inventory.
Steps
What it measures
Products with the highest levels of reserved inventory.
When to use this metric
- Monitor inventory allocation and reservation patterns
- Identify products with high demand or allocation issues
- Assess the impact of reservations on available inventory
- Guide inventory planning for high-demand items
How to interpret
- Good performance: Reservations align with expected order patterns
- Potential issues: Excessive reservations may indicate allocation problems
- Benchmark guidance: Reserved inventory should turn quickly into sales
Key considerations
- High reservations may indicate strong demand or allocation inefficiencies
- Reserved inventory is not available for new orders
- Reservation patterns can guide capacity planning
Technical details
Formula:
SUM(inventoryQuantity.qty) where type = {RESERVED_TYPE} grouped by product_id, ordered by SUM DESC, limited to top 10 within the selected time period
Configurable elements:
- RESERVED_TYPE: Type definitions for inventory quantity reservations (default: RESERVED)
