Fluent Commerce Logo
Docs

Top 10 Short Picked Products Metric

Essential knowledge

Intended Audience:

Business User

Author:

Movyn John

Changed on:

13 Nov 2025

Overview

Learn about the Top 10 Short Picked Products Metric in Fluent Analytics

Key points

  • Short picks directly impact customer satisfaction
  • May indicate demand forecasting errors or supply chain issues
  • Product-specific patterns can guide targeted improvements

What it measures

Top 10 products with the highest volume of corrected inventory within the time period.

No alt provided

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

Technical details

Formula: 

SUM(inventoryQuantity.qty) where type = {CORRECTION_TYPE}
grouped by product,
ordered by SUM DESC,
limited to top 10
within the selected time period

Configuration:

  • TYPE_CORRECTION: Type definitions for inventory quantity sales (default: SALE)

Reference Parameters:

  • `retailer.ref`: Filters the metric to inventory positions from the selected retailer
  • `location.ref`: Filters the metric to inventory positions for the selected location