Use caseBook a walkthrough.
Catch store out-of-stocks and phantom stock
Inventory by store from the retailers that share it, checked for items with none on hand and for stock that has stopped selling, with the follow-up drafted.
Store inventoryOat Drink 1L · retailers that share it
Checking storesOn hand and sales, by storeBy store
Harborview Markets · 310 on hand
Harborview Markets · 5224 on hand · sales stopped
Fieldstone Foods · 1814 on hand
Fieldstone Foods · 2211 on hand
Follow-ups draftedHarborview Markets · 31 and 52
One store at zero disappears in the chain total
Sales by chain can look steady while single stores have none of your item on hand, or show stock that has stopped selling.Sales by chain · last 4 weeks
Harborview Markets · all storesOat Drink 1L selling as usual
SellingHarborview Markets · Oat Drink 1L by store
Store 310 on hand
Out of stockStore 5224 on hand · sales stopped
Phantom stockThe chain total looks fine. Two of its stores are not selling the item.
Lost in the chain total
A chain's weekly sales can hold steady while a few of its stores have none of your item on hand.The count says it is there
A count that shows units on hand never reads as an out-of-stock, even when the item has stopped selling.Checked store by store
Finding the stores at zero means pulling inventory for every store and every item, retailer by retailer, by hand.How it runs on Corvera
Three steps, set up with the Corvera team.STEP 1
Connect store inventory
Inventory and sales by store, from each retailer that shares them.Sources for store inventoryConnecting
Harborview MarketsPortal · inventory and sales by store
Fieldstone FoodsEmailed report · inventory and sales by store
Market St GrocerySales only · not checked
STEP 2
Check on hand against sales
Each item a store carries is checked for none on hand, and for stock on hand that has stopped selling.On hand against salesOat Drink 1L
CheckingHarborview Markets · 31
0 on hand
Harborview Markets · 52
24 on hand · sales stopped
Fieldstone Foods · 18
14 on hand · selling
STEP 3
Get the flags
Out-of-stocks and phantom stock by store, each with a dollar value and the follow-up drafted.3 stores, ranked by what is at stake
Harborview Markets · 52$2.3K
Oat Drink 1L · phantom stockChocolate Oat 1L · phantom stockHarborview Markets · 31$1.9K
Oat Drink 1L · out of stockFieldstone Foods · 22$0.8K
Barista Oat 1L · out of stockFollow-ups drafted for all three stores
What Corvera flags at the store
Each flag names the store, the item, and what it is worth.01
Every item a store carries with none on hand, at each retailer that shares store inventory.Out-of-stocks by store
On hand · every item, every storeBy store
Oat DrinkBaristaChocolate
Harborview · 31012-
Harborview · 5224158
Fieldstone · 181496
Fieldstone · 221107
None on hand
Not carried: a distribution gap
02
Units on hand with no sales for an extended period, especially when the item was selling and the sales suddenly stopped.Phantom stock
Harborview Markets · 52 · Oat Drink 1L
Units sold
EarlierNow
On hand24 units, unchanged
03
Every out-of-stock and phantom stock flag carries a dollar value, like every other flag in the daily action list.What each flag is worth
Each flag, with its valueValued
Harborview · 31 · Oat Drink 1LOut of stock
$1.9KHarborview · 52 · Oat Drink 1LPhantom stock
$1.4KHarborview · 52 · Chocolate Oat 1LPhantom stock
$0.9KFieldstone · 22 · Barista Oat 1LOut of stock
$0.8K04
The stores to work come ranked by what is at stake, with the largest first.Ranked by what is at stake
Stores to work todayRanked
1
Harborview Markets · 52Phantom stock on 2 items
$2.3K2
Harborview Markets · 31Out of stock on Oat Drink 1L
$1.9K3
Fieldstone Foods · 22Out of stock on Barista Oat 1L
$0.8K05
The email to the buyer, the distributor rep, or the broker comes written from the same data, for your rep to check and send.The follow-up, drafted
Follow-up · Harborview Markets · 52
To: Category buyer, Harborview MarketsStore 52: two items on hand but not selling
Oat Drink 1L · 24 on hand, sales stoppedChocolate Oat 1L · 8 on hand, sales stoppedCould someone at the store check both items?
Drafted for Jack to check
EditSend
06
Out-of-stocks and phantom stock sit in the same daily action list as distribution gaps, unsold accounts, and DC reorders.In the daily action list
Today's actionsRanked by value
DC reorderRidgeline · South DC · Oat Drink 1L
$8.4KDistribution gapHarborview Markets · 31 · Chocolate Oat 1L
$3.1KOut of stockHarborview Markets · 31 · Oat Drink 1L
$1.9KPhantom stockHarborview Markets · 52 · Oat Drink 1L
$1.4K