Top 10 Short Picked Products Metric
How-to Guide
Author:
Holger Lierse
Changed on:
16 Sept 2025
Key Points
- Products most frequently short-picked (partially fulfilled due to insufficient inventory).
Steps
What it measures
Products most frequently short-picked (partially fulfilled due to insufficient inventory).
When to use this metric
- Identify products with chronic availability issues
- Guide inventory planning and safety stock decisions
- Assess demand forecasting accuracy for specific products
- Prioritize inventory management improvement efforts
How to interpret
- Good performance: Short-pick patterns are predictable and manageable
- Potential issues: Frequent short-picks indicate inventory planning problems
- Benchmark guidance: Should trend toward zero for strategic products
Key considerations
- Short picks directly impact customer satisfaction
- May indicate demand forecasting errors or supply chain issues
- Product-specific patterns can guide targeted improvements
Technical details
Formula:
SUM(fulfilment.items.rejectedQuantity) where fulfilment.items.rejectedQuantity > 0 grouped by product_id, ordered by SUM DESC, limited to top 10
Configurable elements:
- none
