Boutique inventory by size and colour, not just by style

A boutique owner checks their stock report and it says "Wrap Dress — Navy: 14 units left." That number looks fine. What it does not tell you is that all 14 are a Small, the Medium sold out two weeks ago, and every customer who has walked in asking for a Medium since then has walked out empty-handed. The style total was never wrong — it just wasn't the number that mattered.

This is the core problem with tracking apparel by style instead of by variant, and it is worth understanding properly before you decide how to fix it.

Why the style total lies to you

A style total is a sum. It adds together every size and every colour of a garment and reports one figure. Sums are good at hiding outliers, and a sold-out size is exactly that: one variant at zero, surrounded by others that are still in stock, all averaged into a number that never dips low enough to trigger a reorder.

The fix is not a smarter dashboard — it is a different unit of tracking. Each size × colour combination (and, if you carry printed and plain versions of the same colour, each of those too) needs its own line: its own stock count, its own sales history, its own reorder flag. A Navy Wrap Dress in a Medium is a different product from the same dress in a Small, as far as your stockroom and your customer are concerned, even though they share a style name, a fabric and a price. Once you track at that level, "14 left" becomes "Small: 9, Medium: 0, Large: 5" — and the gap is visible instead of buried.

This is the difference between a plain pricing sheet and a real variant matrix, and it is the first thing a Clothing Boutique Business Kit is built around: one SKU per size, colour and print, each with its own numbers, so a hole in the Medium shows up on its own instead of hiding inside the dress's total.

Sell-through: the number that tells you what to do next

Once stock is tracked per variant, one ratio does most of the useful work: sell-through rate, which is units sold divided by units sold plus units still on hand. If you received 20 units of a jacket and have sold 16, sell-through is 16 ÷ 20 = 80%. If you've sold 4 of a different style out of 20, that's 20%.

Sell-through isn't a score to hit — it's a direction-finder. A high sell-through on a given size or colour is telling you demand is there and stock is running down; a low one, weeks after the style arrived, is telling you something isn't moving and it may be time to act — mark it down, bundle it, or move it off the floor — before it ties up cash and rack space through an entire season.

The value of watching it per variant rather than per style is the same as the value of tracking stock per variant: two colourways of the same dress can have completely different sell-through, and a style-level number just averages that difference away.

Reorder points: built from your own sales, not a guess

A reorder point answers one question: at what stock level do I need to place a new order so I don't run out before the replacement arrives? It depends on two things you actually know — how fast that specific variant has been selling, and how long your supplier takes to deliver (lead time).

If a colourway sells roughly 2 units a week and your supplier's lead time is 3 weeks, you need at least 6 units on hand at any point just to cover the wait, plus some buffer for weeks that sell faster than average. That threshold is the reorder point. Below it, you flag "reorder"; at zero, "out of stock." Because it's calculated from that variant's own sales, a slow colour and a fast one get different thresholds automatically — you're not applying one blanket "reorder at 5 units" rule across a matrix where 5 units means very different things for different sizes.

Marking down without marking down into a loss

Clearance is a normal, healthy part of retail — not every unit sells at full price, and that's fine. The mistake is discounting on gut feel and finding out later that the sale price barely covered the wholesale cost, or didn't.

The arithmetic to check before you put something on the clearance rack is simple: markdown price minus wholesale cost, divided by the markdown price, gives you the margin the sale still leaves. If a garment cost you $18 wholesale and you're considering marking it down to $24, that's a margin of ($24 − $18) ÷ $24 ≈ 25% — still profitable, just thinner than full price. Drop the markdown to $20 and the margin falls to 10%. Knowing that number before the price tag changes is what separates a planned clearance from an accidental one.

Margin vs. markup — the mix-up that costs real money

These two terms get used interchangeably, and they shouldn't be. Markup is profit as a percentage of your cost. Margin is profit as a percentage of your selling price. They are not the same number.

Say a top costs you $15 wholesale and you sell it for $30. Profit is $15. As a markup, that's $15 ÷ $15 = 100%. As a margin, it's $15 ÷ $30 = 50%. A 100% markup is only a 50% margin — not 100%. Owners who plan pricing around "I want 50% margin" but accidentally apply a 50% markup instead end up pricing lower than they meant to, on every single item, all season.

Size charts: answering "what's that in EU?" without googling it

If you sell beyond one country, size labels stop being self-explanatory. A US size 6 dress is roughly a UK 10 and an EU 38; men's sizing adds another layer with chest measurements in inches mapping to EU numbering. Keeping a simple XS–XXL to US/UK/EU conversion table next to your product data means you can answer a customer's sizing question or print the right label for an export order without stopping to look it up every time.

Bringing it together

None of this requires new software philosophy — it requires tracking stock, sales and pricing at the level where the real decisions happen: the individual size and colour, not the style as a whole. A style total can look perfectly healthy while quietly costing you sales in the one size that's actually selling. Sell-through tells you what to do about slow stock before it becomes dead stock. A reorder point built from a variant's own sales protects the sizes that are moving. And getting margin, markup and markdown math right the first time means the prices on your rack say what you actually intended them to say.

If you'd rather not rebuild that logic in a blank spreadsheet, the Clothing Boutique Business Kit has the variant matrix, size chart, sell-through, reorder points and margin/markup/markdown formulas already built and linked together — open it, drop in your own styles, and the numbers that matter stop hiding inside the ones that don't.