At a glance
Distribution of variants across inventory bands (out-of-stock, critical low, low, healthy, surplus). The fat-tail view of stock health, useful for catching slow-burn stockouts before Inventory Alerts fires.
| What it counts | COUNT(active variants) GROUP BY inventory_band(totalInventory). Bands typically: ≤0 (OOS), 1-5 (critical), 6-20 (low), 21-100 (healthy), >100 (surplus). Bands are configurable per workspace. |
| VAT / tax treatment | Not applicable, count metric. |
| Shipping | Not applicable. |
| Discounts | Not applicable. |
| Refunds | Not applicable directly; restocked refunds add inventory which may shift a variant to a higher band. |
| Cancelled / voided orders | Cancellations with restock=true return inventory to the band ladder. |
| Currency | Not applicable (count of variants). |
| Channels / sources | Inventory is store-wide; channels don’t filter the distribution. |
| Time window | RT (real-time, computed from latest indexed snapshot) |
| Alert trigger | None directly; OOS Spike Alert covers the OOS-band anomaly. |
| Roles | owner, operations |
Calculation
Calculated automatically from your Shopify data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK menswear DTC brand on Shopify, 1,420 active variants. Real-time snapshot 12 May 26.| Band | Count | Share | Note |
|---|---|---|---|
| Out of stock (≤0) | 28 | 2.0% | Includes 4 negative-stock variants |
| Critical low (1-5) | 96 | 6.8% | At-risk subset, will likely OOS in 2-7 days |
| Low (6-20) | 184 | 13.0% | Watching, reorder POs in flight |
| Healthy (21-100) | 642 | 45.2% | The bulk of catalogue |
| Surplus (>100) | 470 | 33.1% | New launches, slow-movers, end-of-season |
| Total active variants | 1,420 | 100% |
- The OOS band is the present problem. 28 variants currently OOS. Pair with Inventory Alerts for the action list. The 4 negative-stock variants are the most urgent (oversells deepening).
- The Critical Low band is the future problem. 96 variants at 1-5 units. At normal velocity, half of these will OOS within 7 days. This is where reorder POs need to land first; check Stock vs Sales Velocity for predicted-OOS dates.
- The shape tells the story. 78% in Healthy or Surplus suggests a healthy operation; <60% in those bands suggests cumulative stockout drift. A brand with 30% in Surplus and 30% in OOS+Critical+Low is poorly balanced (over-orders some SKUs, under-orders others).
- Surplus isn’t always bad. New-launch SKUs appropriately start in Surplus. Long-tail clearance items in Surplus are problems (capital tied up, warehouse space). Pair with sell-through-by-SKU to differentiate.
- POS visibility is reduced. POS sales drain inventory in real-time but the band shifts only when crossing a threshold. A variant at 6 units (Low) sells one at till and stays at 5 (Critical); the band changed without warning.
- The bands are ratios, not absolute counts. A small store with 200 variants and a giant retailer with 200,000 will have the same shape if equally healthy. Don’t compare absolute counts to peers; compare share percentages.
Sibling cards merchants should reference together
Inventory Distribution is the strategic view; the tactical companions:| Card | Why pair it with Inventory Distribution |
|---|---|
| Products with Zero/Negative Stock | The OOS-band drill-down. The variants in your “Out of stock” bar. |
| Stock vs Sales Velocity | Forecasts which variants in Critical/Low will OOS next. |
| OOS Spike Alert | Real-time anomaly on the OOS-band count. |
| Top Products by Revenue | Cross-reference; a top-revenue SKU in Critical band is a five-alarm fire. |
| Top SKUs | Volume drill-down; helps prioritise reorder by velocity. |
| Bottom Products | The Surplus band’s contributor base; slow-movers tying up capital. |
| Fulfillment Rate | Persistent OOS in high-velocity SKUs drags fulfilment rate; pair to see the lagging effect. |
Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin: Shopify doesn’t expose an inventory-band distribution directly; reconstruct from:- Products → Inventory: filter by Available less than, Available equal to, Available greater than. Run for each band’s threshold.
- Apps like Stocky, Inventory Planner, ShipBob Inventory: typically expose distribution and forecasting; numbers should match within sync-lag tolerance (5-15 min).
- Reports → Inventory snapshot (Shopify Plus only): closest equivalent.
| Reason | Direction | Why |
|---|---|---|
| Band thresholds | Either | We use 0 / 5 / 20 / 100 by default; your reconstruction may use different thresholds. Configurable in Nerve Centre → Inventory. |
| Active filter | Theirs may be wider | Shopify’s Inventory page can include draft and archived products by default. We filter to status = ACTIVE. |
| Multi-location aggregation | Same approach | We sum Available across active locations; Shopify Admin can show per-location split. A variant with 0 in London and 50 in Manchester appears in Healthy here, not OOS. |
| Continue-selling-when-OOS | No effect | Setting affects sales availability, not inventory band. |
| Sync lag | Either, transient | 5-15 min. |
| Card | Expected relationship | What causes legitimate divergence |
|---|---|---|
amazon.amazon_inventory_distribution | Independent | Amazon and Shopify have separate inventory pools unless multi-channel sync is enabled. |
| WMS / 3PL dashboards | Should match | 3PL inventory should equal Shopify’s “Available” for managed locations within sync tolerance. |
Known limitations / merchant FAQs
What’s a healthy distribution shape? Rough heuristics:- Healthy + Surplus: 70-80% combined. Below 60% means you’re chronically under-stocked.
- OOS + Critical: <10% combined. Above 15% means you’re losing sales daily.
- Surplus: <40% on its own. Surplus above 50% means capital is tied up in slow-movers; consider clearance pricing.
- Over-ordered launch. A new collection ordered conservatively per SKU but with too many SKUs in the range. The Surplus band fills with slow-movers.
- End-of-season carry-over. Last season’s stock not yet cleared. Push into clearance pricing.
- Forecasting model too generous. PO sizing assumed velocity that didn’t materialise. Tighten next round.
- Lead times shifted longer: supplier delays, customs, etc.
- Velocity increased: marketing wave drove demand higher than the PO assumed.
- PO sizing too small: structural under-order across the board.
- Furniture / large items: 0 / 1 / 3 / 10. Single units have meaningful operational implications.
- Fast-moving consumables: 0 / 50 / 200 / 1000. Velocity is per-day, not per-month.
- B2B with bulk POs: 0 / 100 / 500 / 5000.
Available across all active fulfillment locations into one number per variant. A variant with 0 in London and 50 in Manchester is “Healthy” on this card. Per-location distribution is on the roadmap; for now use Shopify Admin → Inventory at this location.
My subscription store, do recurring billings affect the bands?
Yes. Each subscription billing draws from inventory the same as one-off orders. Subscription-heavy brands often see more predictable band shapes (steady drains) compared to one-off-purchase stores (spikier patterns).
Action playbook based on band shape:
- OOS + Critical >10%: emergency reorder review; consider expedited shipping on top-velocity at-risk SKUs.
- Critical band rising week-over-week: lead-time shifted longer or velocity increased; widen the Healthy floor in your PO model.
- Surplus >40% and growing: clearance event needed; capital is sitting idle.
- Healthy band <50%: structural under-stocking; widen safety stock company-wide.
- OOS band drops to zero: surprising; either you have very high stock levels (capital tied up) or your indexer is missing records. Sanity check.