You love the smoked sea salt from a small local producer. So do about three customers. Meanwhile your best-selling olive oil sold out twice last month because there was no room on the shelf to stock deeper.
Specialty food retail analytics answers one question: which products earn their shelf space? Track five metrics for each product (sales velocity, profit per square foot, inventory turnover, GMROI and basket affinity), group products into A, B and C tiers, then review monthly. Cut or shrink what underperforms, give winners more space, and use the freed cash to test new items.
Key takeaways
- Every product on a specialty food shelf competes for limited space and cash, so each one should prove it earns its spot.
- Gross margin return on inventory investment (GMROI) shows how much gross profit a product returns for every dollar tied up in its stock, which margin percentage alone can't show.
- A high-margin product that sells slowly can return less than a lower-margin product that turns quickly.
- An ABC framework (core, seasonal or rotating, and experimental) gives you a clear rule for what to stock deeply and what to test.
- A short monthly review routine turns sales data into decisions: run reports, cut, promote, then test new products.
Why does assortment matter so much in a specialty food store?
Specialty food stores usually carry many products in a small space. Every slow seller ties up cash, takes shelf space from a faster product and, if it's perishable, risks becoming a write-off.
Here is a worked example with hypothetical numbers. Product A has a 45% gross margin and turns 3 times a year. Product B has a 30% margin and turns 12 times a year. Using GMROI (explained below), Product A returns about $2.45 in gross profit per dollar of inventory a year, while Product B returns about $5.14. The lower-margin product earns more than twice as much on the money you have tied up. Without data, that difference stays invisible.
You don't need a data team to find these patterns. You need a few clear metrics, a routine and the willingness to cut products that aren't pulling their weight.
What are the five metrics that matter for assortment decisions?
| Metric | How to calculate it | What it tells you |
|---|---|---|
| Sales velocity | Units sold ÷ weeks in stock | How fast a product moves |
| Profit per square foot | Gross profit ÷ shelf or cooler space used | Whether a product earns its space |
| Inventory turnover | Cost of goods sold ÷ average inventory at cost | How often you sell through the stock |
| GMROI | Gross margin dollars ÷ average inventory at cost | Gross profit per dollar invested in stock |
| Basket affinity | Share of baskets with product A that also contain product B | What sells together |
Sales velocity (units per week)
Sales velocity is units sold divided by the number of weeks the product was in stock. As an example, a hot sauce selling 12 units a week is a very different inventory decision from one selling 2, even if the margins match. Fast movers return cash quickly; slow movers trap it.
Track velocity by product, category and season. A sparkling water might sell several times more in July than in January, and knowing that pattern stops you from overordering in winter or running out in summer.
Profit per square foot
Profit per square foot divides a product's gross profit by the space it occupies. As an example, a spice display earning $800 a month in gross profit in 2 square feet beats a jam earning $150 in the same space. Use this metric for planogram decisions: eye-level spots, end caps and prime cooler space.
Inventory turnover
Inventory turnover is cost of goods sold divided by average inventory value at cost. Higher is usually better, but compare each product with its own category. An aged cheese will naturally turn slower than fresh mozzarella. Investigate products that turn much slower than their category.
Gross margin return on inventory investment (GMROI)
GMROI is gross margin dollars divided by average inventory at cost, the standard formula given in Fathom's KPI glossary. A GMROI of 3.0 means each dollar of inventory returned $3 in gross profit over the period. Below 1.0, the product earns less gross profit in a year than the money you have tied up in it.
Run GMROI by product, not only by category or for the whole store. Category totals hide individual products that are dragging the group down. Set a target that fits your store and categories, then flag anything that falls well short of it.
Basket affinity (what sells together)
Basket analysis looks at which products appear in the same transactions. A customer buying imported Italian pasta may also pick up San Marzano tomatoes, Pecorino Romano and olive oil. Knowing these pairings helps with cross-merchandising, bundles and choosing new products.
As an example, if 40% of shoppers who buy product A also buy product B, placing them near each other can lift basket size. If two products almost never appear together, they likely serve different shopping missions.
How does the ABC assortment framework work?
Once you have the data, sort your assortment into three tiers.
A-items: core products, always in stock. These are your top performers by GMROI, the products that define your store and bring people back. For a cheese shop, that might be Parmigiano-Reggiano, a triple-cream brie and a house cheddar. Give them prime placement, deep stock and promotional support.
B-items: seasonal or rotating products. These perform well in certain windows or add variety: a pumpkin item in October, a rose petal jam for Valentine's Day, a limited run from a local producer. They earn space during their season but shouldn't hold permanent shelf space when sales fall off.
C-items: experimental or niche products. Every specialty store needs some discoveries; they signal curation. Cap them at a set share of your assortment, for example 10-15% of SKUs, and give each one a clear target. If a C-item misses its velocity or GMROI target within a set window, such as 90 days, cut it.
How do you run a monthly assortment review?
A simple four-week rhythm turns reports into action.
- Week 1: Run the reports. Pull velocity, turnover, GMROI and profit per square foot for last month. Flag products below their category benchmark for two months in a row.
- Week 2: Make the cuts. Look at your weakest performers by GMROI. For each one, choose an action: move it to a less prominent spot, order less, mark it down to clear, or discontinue it. Tell staff so they can answer customer questions.
- Week 3: Promote the winners. Give top performers more visibility: eye-level placement, social media features, or bundles with slower items.
- Week 4: Test new products. Use the space and cash freed by cuts to trial a few new SKUs, and put a review date on the calendar before you place the first order.
What should you watch out for when cutting products?
Data is a guide, not the whole answer. Before you cut, check three things:
- Basket role. A slow product may bring in a customer who buys a lot of other things. Check basket affinity before you drop it.
- Seasonality. A product that looks weak in March may be a December best seller. Compare against the same month last year where you can.
- Stockouts. A product that ran out half the month will look slow. Check its in-stock record before judging velocity.
For more on reading your numbers, see our guides to retail analytics for beginners and pricing artisan and specialty food products.
How does ShelfPerks help with specialty food analytics?
ShelfPerks describes itself as a Store Operating System that puts point of sale, inventory, purchasing and reporting in one setup, so your sales data and stock data live in the same place. For assortment decisions, the relevant features include:
- Real-time analytics, with an advanced dashboard and real-time reports from the Standard plan up.
- Real-time inventory management with unlimited products, updated with every sale.
- Expiration reports and alerts on Plus and Premium, so slow perishables get attention before they become write-offs.
- AI-based and suggested purchase orders on Plus and Premium, so reordering follows what actually sells.
The Standard plan is $29.95 per month billed annually or $34.99 billed monthly, with no revenue limit. You can start a 14-day free trial of Premium features with no credit card required and run your first assortment review. See the pricing page for details.
Frequently asked questions
What is GMROI and how do you calculate it?
GMROI (gross margin return on inventory investment) is gross margin dollars divided by average inventory at cost. It shows how much gross profit each dollar of inventory returns; below 1.0, a product earns less gross profit in a year than the money tied up in it.
How do you decide which products to cut in a specialty food store?
Review each product's sales velocity, turnover, GMROI and profit per square foot every month, and look at its weakest performers. Before cutting, check whether the product drives other purchases, is seasonal, or simply ran out of stock.
What is ABC analysis for a retail assortment?
ABC analysis sorts products into tiers: A-items are core top performers kept in stock, B-items are seasonal or rotating, and C-items are experiments with clear targets. It tells you where to invest shelf space and cash.
Is a high-margin product always more profitable?
No. A product with a 45% margin that turns 3 times a year returns about $2.45 in gross profit per dollar of inventory, while a 30% margin product turning 12 times returns about $5.14. Turnover matters as much as margin.
