Free tool
How fast is each SKU selling per store?
Daasity's July 2024 guide describes velocity as how fast a product sells in stores, often units per store per week, and retailers read it to see whether it's in demand.2 Put in units sold, stores and weeks for each SKU or retailer, and see its velocity over every store carrying it and over the stores that sold it, ranked. Paste straight from a spreadsheet. Nothing is sent anywhere.
Fictional example for a snack brand's 4 SKUs. Paste your own rows over it, type into it, or .
| SKU or retailer | Units sold | Sales $ optional | Stores carrying it | Stores that sold it optional | Weeks | Remove |
|---|---|---|---|---|---|---|
Up to 12 rows, so a share link carries them all. Columns in this order paste in one go, with or without a header row.
Units per store per week, ranked
Part 1
Read velocity the way a buyer does
Do this first
- Export units and sales by SKU for the same weeks from your retailer portal or distributor report.
- Count the stores carrying each SKU in those weeks, and the stores that sold at least one if the report shows it.
- Paste the rows in, or type them.
- Put in your buyer's target and copy the ranking for the review.
- More units isn't faster. Daasity's example has 10,000 units across 50 stores in Los Angeles and 7,200 across 30 in San Diego, both over 4 weeks.2 That's 50.0 units per store per week against 60.0, so San Diego sells faster on fewer units.
- Rank by all stores. SPS Commerce calls the measure over every store that should be selling "an unbiased and complete look", and the one over selling stores the view of stores that are selling.1
- Read the gap. In the example, Chili lime sold in 24 of its 40 stores. Over those 24 it moves 5.0 a week, over all 40 only 3.0. When the selling-store figure is high and the all-store figure low, SPS Commerce's reading is that the item "is not selling where it should be".1 Check shelf placement and replenishment in the other 16 before cutting price.
Part 2
What the calculator leaves out
| Left out | Why it matters |
|---|---|
| ACV-weighted measures | This counts every store the same, so a syndicated data provider's figure for the same SKU may differ |
| Promoted and base velocity | A week on promotion lifts the average. Run promoted weeks as their own row to see the base |
| Stores added mid-period | A store that started carrying the SKU in week 6 of 8 counts as 8 weeks here. Use the weeks it was on shelf, or a shorter period |
| A buyer's target | Your buyer's target is the one that counts, so the field is yours to fill from them |
- Wholesale on Faire: the how to increase Faire sales guide covers reorders, for wholesale accounts with no retailer portal to read sell-through from.
- Margin per order by channel is the channel margin calculator.
Want velocity next to every other channel, monthly?
This reads one period you type in. Our monthly report reads the standard exports you already get, for every channel you sell through, and ranks what moved and why. You send the exports, with no logins or store access. Your first month is free, and it ends on its own.
Sources, read October 12, 2026
- SPS Commerce, Walmart Sales Analytics - Inside the Insights, Jacqueline Nance, updated July 2, 2020. Units per store per week (USW) and dollars per store per week ($SW): sales divided by the stores valid for replenishment, then by the weeks measured. "With zeroes" divides by valid stores, "without zeroes" by selling stores.
- Daasity, Sales Velocity in CPG: What It Is & Why It Matters, Brittany Currie, July 15, 2024. Velocity "often expressed as units sold per store per week", units divided by stores times the time period, and the Los Angeles and San Diego example.