Sporting Goods POS: Size and Color Matrices and Seasonal Stock

A sporting goods POS must handle two things well: a size and color matrix, so every shoe, jersey and jacket variant has its own stock count, and seasonal planning, so you buy the right depth before the season and clear what is left after it. Get these right and your best-selling size is on the shelf in October. Get them wrong and you hold last winter’s medium jackets until spring.

This guide covers those two jobs in detail, with formulas you can use this week. It then shows what Retailer OS does for each. For a wider view of what to look for, see our overview of the best sporting goods store POS.

What is a size and color matrix in a POS?

A size and color matrix is a way to store one product, such as a running shoe, as a single style with a separate stock count for each size and color combination. You manage one parent item, and the system tracks the variants beneath it.

The scale surprises people. A cleat in eight sizes and three colors is 24 variants. A store with 40 such styles has 960 variants before it counts a single jacket. Without a matrix, you either create 960 separate items by hand or you track a "men’s cleat" at one quantity and have no idea whether size 10 is gone.

What to expect from a good matrix:

• One parent style with sizes and colors as options, and one barcode per variant.
• A stock count for each variant at each location.
• A price you can set once for the style, and override for one variant when needed.
• Search that works by style name, color or size, so a cashier can find "blue, medium" without scrolling.
• Reports that roll up to the style, so you can see how the style sold, and drill down to the size.

The size curve is the real payoff. If 60 percent of your cleat sales are sizes 9 to 11, you need to know that and buy to it. A matrix is how you collect that data without a spreadsheet.

Here is the size curve in practice. Suppose you buy 48 pairs of a cleat, spread evenly across sizes 7 to 12. By midseason sizes 9, 10 and 11 are gone and sizes 7, 8 and 12 have most of their pairs left. That is 24 pairs, or about $1,400 at a $58 cost, tied up in the wrong sizes. Next year you buy to the curve: more in the middle, fewer at the ends. The matrix report tells you this. A style-level total of "24 pairs left" does not.

How should you structure SKUs and barcodes for variants?

Keep the SKU readable and the same across systems. A pattern like STYLE-COLOR-SIZE works well, for example TRL200-BLK-10. Anyone who sees it on a tag or a purchase order can tell what it is.

Use the manufacturer’s barcode where one exists. Most footwear and apparel from major brands arrive with a UPC on the tag, which saves you printing labels. For house brands, team gear and anything without a code, print your own. Whichever you choose, every variant needs one barcode, never one barcode for the whole style.

Two mistakes to avoid. Do not put the season in the SKU, because the same style comes back next year and you want its history to continue. And do not mix units, such as selling a sock as a single item in one place and a pair in another. Decide the unit once.

How do you plan seasonal inventory for a sporting goods store?

Sporting goods swing harder than most retail. Ski gear peaks in a few winter weeks, baseball and softball cluster in spring, camping and swim in summer, football and hunting in fall. Your cash is tied up in the wrong stock for part of every year. Planning is the answer.

Start with weeks of supply: units on hand divided by average weekly units sold. If you hold 48 pairs of a glove and sell 6 a week at the peak, you have 8 weeks of supply. If the season has 5 weeks left, you are over by three weeks of stock, and you should stop reordering and plan a promotion.

Then work backwards from the season:

• Pull last season’s sales by style and by week, not just by month. Weeks show you when demand actually peaked.
• Decide the buy for each style: expected season sales, plus a small safety margin, minus what you already hold.
• Order early for items with long lead times, and keep a smaller amount of open budget for in-season reorders of what is selling.
• Raise reorder points as the season approaches, and lower them again when it ends, so the system does not keep ordering a product that is done for the year.
• Set a sell-through target for the midpoint of the season. If a style is under half of its target at the midpoint, mark it down early.

A quick example. You buy 120 winter jackets at $60 cost, which is $7,200. You plan to sell 80 percent at the full price of $120 and clear the rest. The season runs slow and you end it with 40 left, which is $2,400 of cost sitting on the rack. Mark them to $79 and sell 30, and you bring in $2,370 against $1,800 of cost, so you still make a small margin. Wait until spring and sell none, and the $2,400 is tied up for six months. Marking down early almost always costs less than carrying stock.

How do you clear leftover seasonal stock?

Decide the ladder before the season ends, not after. A simple one: 25 percent off at the season’s midpoint for slow styles, 40 percent in the final weeks, and a final bundle or bin for broken size runs. A broken size run is a style where only the odd sizes remain. Those sell poorly at any price, so group them and move them.

Other ways to move seasonal stock:

• Transfer slow stock to a location that sells it, if you have more than one store.
• Bundle a slow item with a fast one, such as a glove with a bat.
• Sell online at a clearance price, if you have an online store, so the customer who is not in the shop can still buy it.
• Hold what you can carry over, such as unbranded basics, and clear only what dates itself, such as this year’s colors.

Track what you clear. A dead stock report, which lists items with stock on hand and no recent sales, is the quickest way to find what to mark down before it becomes a year-old problem.

What about team orders and rentals?

Many sporting goods stores sell to teams and leagues as well as individuals, and some rent equipment. Both change what you need. Teams want a contact, a price that differs from retail, and often payment on terms. Rentals need an item record that goes out and comes back, with a deposit. Ask any vendor to show you both before you buy.

For team customers, look for customer accounts with credit terms and price tiers, so a coach’s order rings at the team price and the balance is tracked. For rentals, check how the system records the item leaving and returning. Do not assume a retail POS handles a rental properly.

How does Retailer OS handle a sporting goods store?

Retailer OS runs the counter, the stockroom and the team in one system. For a sporting goods store, these parts apply.

• Variants and matrix inventory in size and color, with SKUs, barcodes and label printing, and stock per item per location.
• A movement ledger. Each sale, transfer, receipt and adjustment leaves a row, so you can see how a size ran out.
• Purchase orders and receiving with cost tracking, plus reorder points and par levels you can set per item.
• Inter-location transfers, including in-transit tracking, to move slow stock to a store that sells it.
• Reports for sales, top products, inventory valuation and dead stock, filtered by location, with scheduled email digests.
• Customer accounts with credit terms, contract pricing and customer price tiers, which fit team and league buyers.
• Promotions that apply at the register automatically, so a clearance price does not depend on the cashier remembering it.

There are two paid options that matter for a seasonal store. The online store is $99.99 a month, runs on the same catalog and inventory as the register, and keeps you from overselling a size you just sold in the shop. The Messaging & AI plan starts at $39.99 a month and adds demand forecasting and reorder suggestions, along with texting and email campaigns. You decide what to buy.

Pricing is $99.99 a month per store and $9.99 a month per user seat, so the smallest bill is $109.98 a month. Card payments run on your own Stripe account, with no platform fee and no cut of sales. The pricing page has the full list, and the multi-store POS page explains how a second location is added.