Retail Inventory Management for Boutiques: Track, Reorder, Mark Down and Control Stock

Buying the inventory was the easy part. The money is made or lost in what you do after it lands: which styles you reorder, which you leave alone, which you discount, and which you finally let go of. This guide is the retail inventory management system for stock you already own.

I'm Carina — boutique owner since 2013, Shopify Partner, and coach to 3,000+ Shopify boutique owners. Below is the lifecycle I walk owners through: receive, track, measure, reorder, afford, hold, mark down, exit — plus the weekly routine that makes each call possible.

Quick answer: what retail inventory management actually is

Retail inventory management is the system a store uses to plan, receive, track, review, reorder, mark down and eventually exit merchandise. It is a decision system, not an app.

For a small boutique it does not need to be complicated. The core job is knowing:

• What inventory you actually own, unit by unit
• How quickly each SKU is selling
• What needs to be reordered
• What should not be reordered, at any price
• What is aging and heading toward dead stock
• How much money is available for the next buy
• Whether the inventory is producing enough gross profit for the cash it ties up

You can run all of that with Shopify plus a disciplined spreadsheet or another simple tracking system. Dedicated inventory software becomes useful when SKU counts, locations, sales channels or operational complexity make manual tracking unreliable — not because every boutique is supposed to own one.

The calculations behind those questions, including weeks of supply, stock-to-sales ratio, turnover and GMROI, are set out in retail math formulas every boutique owner should know.

This page starts where the buying stops

Everything here happens after inventory is in the building: receive it, track it, measure what sold, compare styles against each other, reorder what earned it, and stop buying what didn't. The decisions that got the stock here — budget, landed cost, assortment and test quantities — belong to how to split your first wholesale order.

The inventory decision map

Every style you own sits in one of four places. Start here, then read the section that matches.

• Selling quickly → evaluate a reorder → then check whether your open-to-buy has room for it.
• Selling steadily → hold and watch → keep an eye on weeks of supply against vendor lead time.
• Slowing down → review season remaining and margin → consider a markdown.
• Stopped moving → stop waiting → run the exit options.

None of these are automatic. The same numbers read differently on a seasonal piece, a core basic, and a style you bought too deep on. The point is to put each style in a lane on purpose instead of letting the slow ones drift.

How retail inventory management works in a small boutique

The whole system is ten repeating steps. Most of them take minutes once the habit exists.

1. Plan the buy. Decide the budget, the categories and the test depth before you shop the market. The Boutique Inventory Buy Planner sizes it, and how much inventory to start a boutique covers the very first order.
2. Receive and verify. Check the shipment against the invoice before anything hits the floor.
3. Assign and track each SKU. Every unit needs an identity in your system, or it can't be measured.
4. Keep counts accurate. Cycle counts through the year, a full count periodically.
5. Review sales weekly. One sitting, every week, same day.
6. Measure sell-through, rate of sale and weeks of supply. Three numbers that turn sales into decisions.
7. Reorder proven winners — early enough that the delivery lands before you're out.
8. Control future buying with open-to-buy so reorders don't quietly outrun the cash.
9. Mark down and exit aging inventory while it still has value.
10. Review turnover and GMROI once a quarter to see whether the whole investment is working.

The rest of this guide is those ten steps in order, with the decision rules for each.

1. Receive and verify what arrives

Receiving is where most inventory errors are born, and every later number inherits them. When a shipment lands:

• Compare the shipment to the purchase order and invoice — line by line, before you put anything away.
• Count the units actually received, by style, color and size. Short shipments are common and rarely announced.
• Inspect for damage and wrong product — pulls, stains, broken hardware, substituted colorways.
• Record landed cost where freight, duties or fees are material, so margin isn't measured against the wholesale price alone. The Landed Cost Calculator does the per-unit math.
• Assign or verify SKUs and tag the units before they leave the receiving area.
• Enter it into your tracking system the same day, with the date received — that date is what makes aging measurable later.
• Flag discrepancies immediately and photograph damage. Most vendors have a short claim window, and a photo settles it faster than a description.

If one vendor produces repeat shortages or damage, that belongs in your buying notes, not just your claims folder. Vendor reliability is part of the reorder decision, and the vetted supplier list in the Little Black Book exists for exactly that reason.

2. Count what you own, and keep the count honest

System counts drift. Returns get processed wrong, a piece walks, two units ship as one, a damaged item never gets written off. Buying decisions made on drifted data are expensive, so the count needs maintaining.

• Cycle counts — count a slice of the store on a rotation, say one category a week. Nothing closes, nothing stops, and errors surface while they're still small. This is the practical default for most boutiques.
• Full physical counts — everything, at once, usually at season end or year end for the books. Slower and more disruptive, but it's the one that truly resets the system.

Either way the process is the same: count the physical units, compare against what the POS or spreadsheet says you own, and investigate anything meaningful. Small variances are normal. A pattern — one category, one vendor, one shelf — is worth chasing, because that's where shrinkage from theft, damage or mis-scanning shows up. I'm not going to quote you an average shrink rate; what matters is your own variance trend and whether it's getting worse.

Do the count before a big reorder round, not after. Reordering a style you think has two units left and actually has nine is how depth problems compound.

3. Measure what's actually selling

You can't make any of the calls below without a weekly number per style. A clean Google Sheet does this for stores under roughly $300K:

• SKU / product name
• Vendor
• Date received
• Units received
• Wholesale cost per unit
• Retail price
• Units sold (update weekly from Shopify)
• Units on hand (auto-calculated)
• Sell-through % (units sold ÷ units received)
• Rate of sale (units sold ÷ weeks in stock)

Update once a week and sort by sell-through, then sort again by rate of sale. The two lists are not identical, and the gap between them is where you bought too deep.

Sell-through, briefly

Sell-through % = units sold ÷ units received × 100, always over a stated window. It tells you what proportion of a buy has cleared — nothing more. It doesn't tell you how fast the remaining units will go, and there is no universal percentage that means "winner." The full formula, the measurement window, and the reorder framework live in sell-through rate for boutiques, and the Sell-Through & Reorder Calculator runs a single style for you. I won't repeat that math here.

4. How to decide what to reorder

A reorder case is built from several factors together, not one percentage:

• Sell-through — how much of the original buy has cleared, over a window you state.
• Rate of sale — units per week, which is what actually projects forward.
• Weeks of supply — units on hand ÷ rate of sale. This is the number that decides urgency.
• Vendor lead time — if weeks of supply is shorter than the time the vendor needs, waiting to decide is itself a decision.
• Full-price vs markdown-dependent — units that only moved after a discount prove demand at the sale price, not at your intended price. Separate those before you call it a winner.
• Seasonality — a reorder only makes sense if there's selling time on the other side of it.
• Supplier availability — the strongest reorder case is worthless if the vendor's cut off or out of the colorway.

Run a style through the Sell-Through & Reorder Calculator to see weeks of supply against your lead time before you commit.

For basics and evergreen product you restock continuously, set the timing once instead of rechecking by eye: the reorder point calculator gives you the unit level that should trigger the next order.

5. Just because it deserves a reorder doesn't mean you can afford it

These are two separate questions and owners collapse them constantly:

• Sell-through tells you what deserves the money.
• Open-to-buy tells you how much buying room actually exists.

A style can earn a reorder and still not get one this month, because the cash is committed to orders already placed or to inventory you need on the floor at month-end. Set open-to-buy monthly: open-to-buy for small boutiques explains the formula, and the open-to-buy calculator runs it. If the number comes back tight, the reorder list becomes a ranking exercise rather than a shopping list.

6. What to hold

Holding is an active choice, not the absence of one. A style is usually worth holding at full price when it's still moving at a consistent rate, when the remaining units will clear inside the selling time left, and when depth is low enough that the cash tied up isn't blocking anything better. Set a date to look again — the risk with holding is that "watch it" quietly becomes "forget it."

7. When should you consider a markdown?

There's no day count that makes a markdown correct. Weigh these instead:

• Rate of sale is slowing — compare the last two weeks to the two before them. A falling rate means your remaining units will take longer than the average suggests.
• Season remaining — if the selling window closes before the stock clears at the current rate, discounting inside the season usually beats carrying it past the season.
• Weeks of supply — deep inventory on a slowing style is a different problem than two units left.
• Margin impact — know what the discount costs per unit before you set it, not after.
• Whether it's blocking better buys — cash sitting in this style is cash not buying the one that's selling out.

The markdown & sale calculator shows the financial side: sale price, gross profit given up per unit, and how many discounted units it takes to match one full-price sale. If the item never had enough margin to discount comfortably, that's a pricing problem — check it in the profit margin calculator.

8. How to think about inventory age

Days in stock only means something relative to your own business. Judge age against:

• Season length — 45 days is nothing on a core basic and most of the window on a holiday piece.
• Vendor lead time — if a replenishment cycle has come and gone without a reorder case forming, that's information.
• Normal selling cycle for the category — occasion dresses, denim, and impulse accessories don't clear on the same clock.
• Current rate of sale — an old style that's still moving steadily is not the same as an old style that's stopped.

Skip the universal day-30 / day-60 / day-90 schedule. It will mark down things that were always going to take longer and leave alone things that died in week two.

9. Exiting true dead stock

Dead stock isn't a day count — it's a pattern. Treat a style as finished when several of these are true at once:

• A full replenishment cycle has elapsed with no reorder case forming
• The selling season for it has largely or entirely passed
• Movement is negligible, not just slow
• It only moves when you promote it, and it stalls again after
• You would not buy it again at any price

Once it's there, stop waiting for it to magically sell. Options, in order of preference:

1. Bundle 2–3 dead pieces together at a sharp price ("Mystery Box: 3 dresses for $45")
2. Run a private "VIP loyalty sale" — email-list only, deeply discounted
3. Offer as gift-with-purchase over a spend threshold
4. Donate to a charity that matches your customer (write off the wholesale cost)
5. Wholesale-out to a clearance reseller (last resort — expect cents on the dollar)

The opportunity cost of storing dead stock is bigger than the discount. Move it, then look at the vendor: one supplier can quietly account for most of your dead stock, which is a buying decision, not a clearance one.

Selling aged stock in person is another exit route worth costing out — how much inventory you need for a boutique pop-up covers how to size what you bring to an event.

10. How to prevent overstocking and stockouts

Both problems come from the same gap: buying decisions made on feel instead of on last week's numbers. The operating system that prevents them:

• Buy shallow when demand is uncertain. A new vendor, a new category or an untested trend earns a test quantity, not depth.
• Review sales weekly so a change in direction shows up in days, not at season end.
• Use rate of sale and weeks of supply together. A percentage on its own can't tell you when you'll run out.
• Work backwards from vendor lead time. If the vendor needs three weeks and you have two weeks of supply, the reorder was due last week.
• Reorder winners before they hit zero — a stockout on a proven style is invisible in your sales data and expensive in reality.
• Stop reordering slow sellers even when the vendor offers a better price on a bigger order. Depth on a slow style is the most common overstock cause I see.
• Check open-to-buy before committing more cash, so the reorder list is ranked against a real budget.
• Mark down aging merchandise before it becomes dead stock, while a modest discount still clears it.

11. Seasonal inventory changes the clock

Seasonal merchandise runs the same decision system on a shorter fuse:

• The selling window is short, so a slow first two weeks matters much more than it would on a core basic.
• Markdown decisions come earlier — waiting for a seasonal piece to "find its customer" usually means discounting it after the season instead of inside it.
• Late reorders lose most of their value. Stock that lands with little selling time left becomes next year's problem at best.
• Plan around delivery lead time, not around when you'd like the stock. Count backwards from the date it needs to be on the floor.
• Protect the cash. Money tied up in a season that's nearly over is money unavailable for the season that's starting.

I won't give you a universal number of days — categories and regions differ too much. The rule that travels is simple: for seasonal stock, decide sooner than feels comfortable.

12. Inventory turn, and what it actually tells you

Inventory turn is how many times you sell through your average inventory in a year (cost of goods sold ÷ average inventory at cost). It's a whole-business health read, not a per-style one: a low turn means a lot of your cash is sitting still, a high turn means your cash is recycling quickly but you may be stocking out on winners.

Ignore borrowed "healthy retail" targets. Turn varies enormously by category, price point, and business model — a $19 accessories mix and a $180 occasion-dress mix should not turn at the same speed. What's useful is your own trend: compare this quarter to the same quarter last year, and watch whether turn is improving as you get better at the reorder and markdown calls above.

13. The rest of the numbers worth watching

• Days on hand — average days a unit sits before selling. Useful directionally, per category.
• Gross margin % — (retail − landed cost) ÷ retail, per style. This sets how much markdown room you actually have.
• Stockout rate — how often your top sellers are unavailable. Every stockout is a sale the rate-of-sale data will never show you.
• Sell-through by vendor — the fastest way to see who deserves more of the budget next season.
• Open-to-buy — set monthly, before market, not after.

14. The three store-level numbers behind all of this

Everything above works at the style level. Once a quarter it's worth zooming out and asking how the whole inventory investment is performing, and that takes three numbers that build on each other.

• Cost of goods sold — beginning inventory + purchases + freight-in − returns − ending inventory. Not what you spent on stock; what actually left the shelves. The Boutique COGS Calculator builds it line by line.
• Inventory turnover — COGS ÷ average inventory at cost. How many times you sold through your average stock investment, and how many days the average item sits. The Inventory Turnover Calculator handles both.
• GMROI — gross margin dollars ÷ average inventory at cost. How many margin dollars each $1 tied up in stock returned. The GMROI Calculator runs it, and it's the one to use when you're deciding which categories deserve more budget.

The reason to run all three rather than just the last one: turnover and margin can each look fine on their own while the combination quietly underperforms. A category turning six times a year at a thin margin can return less than one turning twice at a rich one. Run GMROI per category — tops, dresses, denim, jewelry, gifts — and the ranking is usually not the one you'd have guessed.

15. The retail inventory numbers, in one table

Every metric below exists to support a decision. If a number doesn't change what you do next, stop tracking it.

Metric	What it tells you	Formula / meaning	Decision it helps you make	Tool or guide
Sell-through	How much of a buy has cleared	Units sold ÷ units received × 100, over a stated window	Whether a style is even a reorder candidate	Sell-Through Calculator
Rate of sale	How fast it's selling right now	Units sold ÷ weeks in stock	Projecting forward instead of looking back	Sell-Through Calculator
Weeks of supply	How long the remaining units last	Units on hand ÷ rate of sale	Reorder timing against vendor lead time	Sell-Through Calculator
Inventory turnover	How often your stock investment recycles	COGS ÷ average inventory at cost. No universal target — track your own trend	Whether too much cash is sitting still	Inventory Turnover Calculator
GMROI	Margin dollars per $1 tied up in stock	Gross margin $ ÷ average inventory at cost. Benchmarks vary by category — compare your own categories	Which categories deserve more budget	GMROI Calculator
Gross margin	What's left after the product cost	(Retail − landed cost) ÷ retail	How much markdown room a style has	Profit Margin Calculator · Landed Cost Calculator
Stockout rate	How often winners are unavailable	Share of your top sellers out of stock when checked. No standard target	Whether reorders are happening too late	Weekly review (below)
Inventory age	How long a style has been in stock	Days since date received, judged against season and category	Markdown and exit timing	Markdown Calculator
Open-to-buy	Cash actually available to spend	Planned end inventory + planned sales − current inventory − stock already on order	Whether a deserved reorder can be funded now	Open-to-Buy Calculator

Where I've written that there's no universal target, I mean it — published "good" numbers for turnover, sell-through or GMROI come from businesses with different price points, categories and cost structures than yours. Your own trend, quarter over quarter, is the benchmark worth having.

16. A worked example: two styles through the system

Illustrative numbers, not benchmarks. The point is the decision path.

Style A — a midi dress. Received 24 units six weeks ago at a landed cost of $22, retailing at $58. It has sold 18 units, all at full price.

• Sell-through: 18 ÷ 24 × 100 = 75% in six weeks.
• Rate of sale: 18 ÷ 6 = 3 units per week.
• Units on hand: 24 − 18 = 6.
• Weeks of supply: 6 ÷ 3 = 2 weeks.
• Gross margin: ($58 − $22) ÷ $58 = 62%, or $36 per unit.

The reorder call: the vendor's lead time is three weeks and there are two weeks of supply left, so a reorder placed today still arrives after a short stockout — and placing it next week makes that gap worse. There's season left, the units sold at full price, and the margin is healthy, so this one is a reorder, sized against what open-to-buy allows rather than against enthusiasm.

The GMROI read on this style: gross margin earned so far is 18 × $36 = $648. Inventory at cost started at 24 × $22 = $528 and is now 6 × $22 = $132, averaging $330. GMROI = $648 ÷ $330 ≈ $1.96 of margin per $1 invested over the period. Strong enough that this vendor and category deserve a bigger share of next month's budget.

Style B — a printed tote, bought at the same time. Received 30 units at $9 landed, retailing at $28. It has sold 6.

• Sell-through: 6 ÷ 30 × 100 = 20% in six weeks.
• Rate of sale: 1 unit per week, and the last two weeks were slower than the first two.
• Weeks of supply: 24 ÷ 1 = 24 weeks.
• Cash tied up: 24 × $9 = $216, sitting still.

The markdown call: 24 weeks of supply on a slowing style outlasts any sensible selling window, and the $216 is precisely the cash Style A's reorder needs. Margin is 68%, so there's room to discount and still make money. Mark it, clear it inside the next few weeks, and don't reorder it — that combination of a slow start and a falling rate is a buying lesson, not a promotion problem.

Run your own numbers through the Sell-Through & Reorder Calculator and the markdown calculator rather than copying these.

17. The review cadence

Weekly: update units sold, re-sort by rate of sale, and move anything that changed lanes on the decision map. Monthly: set open-to-buy. Quarterly: cycle counts rolled up into a real reconciliation, plus turnover and GMROI on the whole business.

Storage still matters to the decisions: label shelves by category then SKU range, keep the top 20 sellers accessible, photograph new arrivals the day they land, and process returns back into inventory within 48 hours — untracked stock can't be measured, and unmeasured stock becomes dead stock by default.

18. Spreadsheet, Shopify or inventory software: what does a small boutique need?

There are three broad stages, and most boutiques spend longer in the first than they expect.

Very small or simple boutique

Shopify's built-in tracking plus the disciplined spreadsheet above is genuinely enough under roughly 200 SKUs on a single channel. The limiting factor is habit, not software. If the sheet gets updated weekly, it will outperform an app nobody opens.

Growing boutique

More SKUs, higher order volume, several sales channels or recurring inventory discrepancies are the signals that stronger inventory features start paying for themselves. Purpose-built options in the Shopify ecosystem include Stocky, Sortly, Trunk and, once forecasting errors are costing real money, tools like Inventory Planner or Katana. Check current pricing and features directly with each — they change.

Physical retail or omnichannel boutique

Once you sell both online and in person, the hard part is keeping one stock record instead of two. A connected point-of-sale system becomes increasingly valuable here, because the in-person sale and the online sale need to draw down the same units.

If you're still setting the store up, the Shopify Store Setup Checklist covers products, inventory settings, policies and checkout in the right order — inventory tracking is much easier to keep clean when it's configured properly from the start.

Your next step

If the merchandise has not been ordered yet, start upstream with how boutiques buy wholesale, since most stock problems begin at the order. Otherwise: pick your slowest ten styles this week and put each one in a lane: reorder, hold, mark down, exit. Then run the reorder candidates through the Sell-Through & Reorder Calculator and check the budget in the open-to-buy calculator.

Then, once a quarter, zoom out: run the COGS Calculator and carry the result straight into the turnover calculator and the GMROI calculator to see how the whole inventory investment is performing.

If footwear is part of the assortment, track it separately from apparel: preset packs and size-level sell-through can hide slow inventory inside an otherwise successful style. Use this shoe case-pack and size-run planning guide before setting the first shoe reorder point.

Sizing a buy that hasn't been placed yet is a different job — the Boutique Inventory Buy Planner handles the before, and how much inventory to start a boutique covers the very first order.

If you want me to look at how your inventory is currently set up, the Boutique Store Audit covers it. And if you'd rather work these decisions through with feedback each month instead of alone, that's what ECom Academy is for.

Inventory is boring. Review it weekly and it stops eating your cash.

— Carina