How to Calculate CPG Sales Velocity: Units per Store per Week
CPG sales velocity measures how quickly a product sells relative to its distribution. Units per store per week, often shortened to UPSPW, is one practical measure: divide units sold by the number of store-weeks in the same reporting period. It helps answer a buyer's question: how productive is this item where it is available?
The sales velocity formula
Units per store per week = retail units sold ÷ store-weeks. When the store count is constant, store-weeks equals stores multiplied by weeks. Use consumer sales from the retailer, not cases shipped to a distributor. Define a unit consistently: one four-pack sold at checkout is one retail unit, not four units.
Illustrative example: An item sells 2,400 four-packs in 100 stores over four weeks. Its velocity is 2,400 ÷ (100 × 4) = 6 four-packs per store per week. At an average realized price of $7.50, that equals $45 per store per week.
Use store-weeks when distribution changes
If an item is in 50 stores for two weeks and 100 stores for the next two, the denominator is (50 × 2) + (100 × 2), or 300 store-weeks. Dividing by the ending store count times four would overstate exposure and understate velocity. A weekly store-level file makes this calculation easier to audit.
Document whether the denominator uses authorized stores, stores with inventory, or stores recording a sale. These answer different questions. Selling-store velocity excludes stores with zero sales and can look healthy while execution problems remain hidden. Pair it with authorized-store coverage and in-stock information where available.
What is a good CPG sales velocity?
There is no universal threshold. Compare the same retailer, category, package format, price tier, and time period. A single can and a multipack serve different purchase occasions. A large grocery store and a convenience store also provide different selling opportunities. Ask the buyer which productivity measure and benchmark they use.
Show both units and dollars. Higher pricing may improve dollar productivity while unit movement weakens. Separate promoted weeks from regular-price weeks, and flag new-store openings or stockouts. Use the latest four weeks for a recent signal alongside longer windows for context; overlapping windows are not independent periods of growth.
Turn the calculation into a buyer-ready action
- Rank items within comparable store groups and identify persistent gaps.
- Check inventory and shelf placement before concluding that low sales mean weak demand.
- Compare promotion and non-promotion performance using consistent denominators.
- Agree on a measurement window and the action a successful test would unlock.
If sales and velocity move in different directions, read our guide to demand versus distribution. To plan a launch using the same metric, use the retail sales forecast guide.
Can I calculate brand velocity across several SKUs?
Yes, but label the result. Brand units per store per week can rise simply because more items were added. Keep SKU-level velocity beside brand-level totals so assortment expansion does not masquerade as stronger individual-item demand.
Put this to work for your brand. CPG Consulting helps emerging brands turn retail data and commercial plans into usable sales tools. Explore our services or book a call.