Inventory
Reorder and stockout signals, per SKU
Velocity-based reorder and overstock flags for every SKU, and an at-risk list of the ones that will run out before a typical resupply window — ordered by what it costs you.
The problem
Stocking out of a profitable SKU during a peak is lost margin you never see in a report. Overstock on a slow mover is cash frozen on a shelf. Both are invisible until they hurt.
How Sellrics does it
Sellrics computes sales velocity per SKU over a trailing window, divides on-hand units by it to get days of cover, and fires a reorder flag when cover drops below your lead time or an overstock flag when it runs far beyond (backend/api/inventory.py). The at-risk view (backend/api/at_risk_inventory.py) ranks the imminent stockouts by the revenue at risk, and per-SKU demand projections (backend/api/forecast_sku.py) feed reorder quantities.
What the numbers mean
Velocity is units sold per day over the trailing window. Days of cover is on-hand ÷ velocity. A reorder flag means days of cover is below your stated lead time; overstock means cover is far above it. The dollar figure on the at-risk list is the revenue you lose if that SKU goes to zero.
A worked example
Illustrative example- Scenario
- Ten SKUs on hand, from a Value Pack with 60 days of cover down to a Loss Leader with 2.
- What Sellrics surfaces
- Four SKUs are flagged reorder (days of cover 4–8, below lead time); one is flagged overstock at 45 days. The Specialty Item at 4 days of cover is the one to expedite — it has real margin and it is about to run out.
- The move
- Expedite the flagged high-margin SKUs, hold the reorder on the overstock, and let the SKU forecast set the quantity so you neither stock out nor over-buy.
Inventory Snapshot
Sample · 10 SKUsAcross all 10 SKUs: 4 reorder · 1 overstocked
Sample data — your SKUs with days of cover and reorder status.
See it with sample data
Fictional sample dataA view from the Sellrics dashboard, on fictional sample data — no store connected, nothing stored.
Inventory Snapshot
Sample data · 10 SKUs| SKU | Available | Inbound | Status |
|---|---|---|---|
FBA-SE01 | 7 | 20 | reorder |
SH07 | 14 | 30 | reorder |
SH03 | 26 | 60 | reorder |
SE23 | 32 | 40 | reorder |
SE10 | 89 | 200 | reorder |
SE15 | 55 | 40 | ok |
SE01 | 312 | 240 | ok |
SE08 | 640 | 0 | ok |
SE12 | 1,420 | 0 | overstock |
AM05 | 2,150 | 0 | overstock |