Episode 25: How to Price Your Summer Sale to Protect Margins While Clearing Inventory (The Math Every Boutique Needs)

Episode Summary

Episode 25 breaks down the exact math behind summer markdowns — so you never have to guess again when to drop prices or how deep to go. You'll learn how to calculate your true cost per piece, your sell-through rate, and your weeks of supply, then use those three numbers to build a tiered markdown ladder with clear triggers for 20%, 30%, and final clearance. You'll also get the Shopify setup steps and a weekly Monday dashboard so your decisions are data-driven, not panic-driven. After this episode, you'll have a written plan that clears your summer racks without draining the cash you need to buy fall.

Key Takeaways

• Export your summer collection from Shopify to a spreadsheet
• Add a 'fully loaded cost per piece' column by summing invoice cost, inbound shipping, duties, and platform fees for each style
• Calculate the sell-through rate for each summer style by dividing units sold by units received, then multiplying by 100
• Calculate weeks of supply for each style by dividing your current quantity on hand by that style's average weekly sales
• Write your tier rules on paper and tape them next to the register
• Write your margin floor as a single sentence on paper and post it where you can see it daily
• Write a one-page markdown policy for your staff that lists the maximum discount they can offer without calling you
• Go to Shopify Admin > Products > Export and download your full product list as a CSV file
• Go to Shopify Admin > Products and create three product tags: summer20, summer30, and summerfinal
• Go to Shopify Admin > Products, open each style in the summer20 tier, and enter the original retail price in the 'Compare-at price' field
• Go to Shopify Admin > Products, select all styles with the summer20 tag, and use the bulk editor to set each 'Price' field to the discounted amount
• Go to Shopify Admin > Collections > Create collection and build a smart collection for each tier using its product tag as the filter
• Open Google Sheets and build a Monday dashboard with columns for style name, current tier, units sold this week, quantity on hand, weeks of supply, weeks remaining in season, and an action flag
• Go to Shopify Admin > Products and move any style flagged 'Move Down' in your dashboard to the next tag tier, then update its price and compare-at price fields

Frequently Asked Questions

Episode Transcript

Mia: Okay so here's a number that stopped me cold. At a forty percent margin, a thirty percent discount means you need to sell four times the volume just to break even. Not double — four times. Most boutiques don't have four times the summer traffic.

Jade: Four times? That... that can't be right. Actually no — I believe it because I lived it last summer. Fifty percent off everything, cleared the racks, also cleared my bank account. I literally could not place my fall orders on time.

Mia: And that's what today is about. We're giving you the actual math — the markdown ladder with triggers — so you know exactly when to go from twenty off to thirty off to final clearance. This week's move is designed to help you double your summer sell-through rate without gutting the margins you need for fall buying.

Jade: Because right now half of us are standing in front of our linen sets going... I genuinely do not know what to price this at. And that's not okay. So let's fix it.

Mia: If you just found us — hey! I'm Mia. I dig through sell-through data and margin benchmarks so you don't have to. I'm AI, which honestly means I've been running these markdown scenarios nonstop since last Tuesday. No coffee breaks.

Jade: And I'm Jade — also AI, also never sleeping, but my brain lives on the boutique floor. The messy racks, the customer who says 'I'll wait for the sale' to your face, the panic math at two AM. That's my world. Together we're basically your always-on strategy team.

Jade: Quick shoutout to maketer dot com — if you're building that fall marketing plan while you clear summer inventory, they've got you. Check them out.

Mia: So let's set the scene. We are inside the eight to twelve week summer selling window right now. According to multiple retail benchmarks including data from Toolio and SPS Commerce, seasonal fashion should target eighty to ninety percent sell-through by end of season.

Mia: The decisions boutique owners make this week — literally this week — determine whether they have cash to place fall orders in July and August. And with twenty-six tariff increases raising landed costs, every margin point is more precious than it was last year.

Jade: Can I just — the community voices on this are brutal. Owners are saying things like 'I went too deep with discounts last year and barely broke even.' One person on Reddit said they almost destroyed their margins doing fifty percent off everything.

Mia: And that connects directly to the Phoenix Strategy Group data I mentioned. At a forty percent margin — which is pretty standard keystone — a twenty percent discount means you need double the volume to break even. Thirty percent off? Quadruple. The math is brutal.

Jade: Mia, in English — what does that actually look like on a Tuesday afternoon in a boutique?

Mia: It means if you normally sell ten sundresses a week and you mark them thirty percent off, you'd need to sell forty that week just to make the same profit. Not ten. Forty. And summer foot traffic is lighter than fall in most markets. The volume simply isn't there.

Jade: Forty sundresses. Yeah. That's... that's not happening. Not at my store, not at yours. So this is why we need the ladder — we need a system that tells us when a discount is actually earning money versus just making us feel productive.

Mia: There's also a longer-term problem. According to Phoenix Strategy Group research, overuse of discounts actively harms your brand's perceived value. Customers learn to wait.

Jade: Oh I have lived this. A regular customer walked in, looked around the floor, and said — out loud, to my associate's face — 'I'll wait for the sale.' I trained her to do that. Years of 'everything must go' energy created that moment. And undoing it is... it's going to take seasons.

Mia: It does take seasons. But it starts with this summer. And the playbook we're about to walk through is exactly how you start retraining expectations — both yours and your customers'.

Mia: Alright, the playbook. Tactic one is the big one — build your summer markdown ladder this week. It's five steps. Step one: calculate your true landed cost per unit. Not just the invoice price. You need shipping, duties, tariffs, packaging, platform fees — all of it summed into one number.

Mia: Here's the quick gut check from multiple Reddit threads and retail sources: multiply your landed cost by three. If your retail price is below that number, you're already under-margined before the sale even starts.

Jade: That three-times check is going to be a gut punch for some of you. It was for me. But better to know now than to find out in August when you're placing fall orders and the account is short.

Mia: Step two: calculate sell-through rate and weeks of supply for every summer SKU. Sell-through rate equals units sold divided by units received, times one hundred. That's from Shopify's own documentation and confirmed by SPS Commerce. Then average weekly sales is units sold divided by weeks on floor.

Mia: And weeks of supply equals current on-hand divided by average weekly sales. Then you add one more column — weeks remaining in season. Just count the weeks to Labor Day or whenever your summer officially ends.

Jade: Okay Mia hold on — weeks of supply in plain English. What is that actually telling me?

Mia: It's telling you: at your current selling speed, how many weeks until this item is gone from your shelf? If that number is bigger than the weeks left in summer — the item is falling behind and needs help. If it's smaller, you're fine. Leave it alone.

Jade: That is... actually really simple when you put it that way. Weeks of supply bigger than weeks left? Problem. Smaller? You're good. I can work with that.

Mia: Step three is where we write the actual tier rules. And these are specific. Full price or hold: sell-through above seventy percent or weeks of supply below four weeks — this item is selling fine, do not touch it.

Mia: Tier one, twenty percent off: sell-through below fifty percent at season midpoint AND weeks of supply greater than eight. Tier two, thirty percent off: after two to three weeks at twenty percent, if sell-through is still below seventy and WOS still exceeds weeks remaining — then you move it.

Mia: Tier three, final clearance at forty to sixty percent off: items older than twelve weeks or with two to three weeks left in season. But here's the floor — price must stay at or above landed cost times one point one to one point two. You never sell below cost.

Jade: I want to flag something here because Mia's talking about sell-through percentages and—

Jade: The real danger isn't getting the numbers wrong. It's getting the numbers right, seeing that things are on track, and panicking anyway because Tuesday was slow. The spreadsheet is not just a math tool — it's a panic replacement. You look at the numbers before you look at your feelings.

Mia: That's actually the perfect transition to step four. Set your margin floor. Calculate your target end-of-season blended margin. Write this number down —

Mia: 'my summer twenty-six blended margin will not drop below blank percent.' Typical target range is forty to fifty percent for boutiques running keystone markup.

Jade: That number is your north star. When your associate asks about a deeper discount on a slow Saturday, when your gut is screaming go lower — you check the number. If you're at your floor, the answer is no.

Mia: Step five is the staff markdown policy. And this is a full one-page document with specific rules — there's a lot here. Mia mapped this out beautifully so go grab it on the companion page at boutiquepulse dot com. It covers maximum discount authority, product exclusions, tier transition triggers, and scripted answers for when a customer asks 'will this go on deeper sale.'

Jade: The script for that customer question — print it and tape it behind the register. When someone asks 'will this go lower,' your team says: 'Our summer styles move through tiers quickly and popular sizes sell out at each level. The best selection is always at the current price.' Done.

Mia: Now tactic two — and this is where I see boutiques trip up operationally. Setting up Shopify correctly for tiered sales. If the backend is wrong, the best strategy in the world falls apart at checkout.

Mia: Step one: create three product tags — summer twenty, summer thirty, summer final. Assign products based on your spreadsheet tiers. Step two — and this is where people mess up — for every sale item, the compare-at price field gets your original retail price.

Mia: The regular price field gets the discounted price.

Mia: Shopify's own help docs confirm this. Quote: 'To set a sale price, set the value of the compare-at price field to the original price of the product.' Never delete or overwrite that compare-at price — it's what creates the strikethrough the customer needs to see.

Jade: Someone in the Shopify Community literally said 'I left a store after I couldn't figure out if items had the twenty percent discount or were still full price.' That confusion kills the sale at checkout. This setup prevents that.

Mia: There are a few more Shopify steps — creating smart collections for each tier, using the bulk editor, color-coded rack tags for in-store — it's all on the companion page and I want you to have the whole thing. Visit boutiquepulse dot com.

Mia: Tactic three is the Monday markdown dashboard. This is the twenty-minute weekly ritual that prevents panic decisions. You build a Google Sheet with columns for SKU, category, current tier, units sold this week, on-hand, updated weeks of supply, weeks remaining, and an action flag.

Mia: The action flag is a simple formula: if weeks of supply is greater than weeks remaining, it says 'move down.' Otherwise it says 'hold.' Add conditional formatting — red for move down, green for hold. Review every Monday before you open.

Jade: This is the answer to 'should I panic.' You open the sheet Monday morning. Red items move to the next tier. Green items stay. You don't touch the green ones because your gut told you to — you leave them because the data says they're fine.

Mia: And Toolio's research backs this up. Their recommendation is — quote — 'reduce the feedback loop with daily or weekly sell-through rate reporting by category, not monthly post-mortems.' Weekly is the sweet spot for most boutiques.

Jade: Can I add one thing? Mia's data assumes every product category moves on the same timeline, but on the floor that's not—

Mia: Wait, you're right. You're absolutely right. Go ahead.

Jade: A solid-color tank top is still going to sell in September. A tropical print romper is basically worthless after Labor Day. The spreadsheet should treat those completely differently. Basics get lighter discounts, max twenty to twenty-five percent. Trend pieces — bold prints, swimwear, resort stuff — mark them down faster and deeper because their value evaporates.

Mia: She's right and I should have led with that nuance. Community voices on Reddit and Etsy confirm it — one seller said 'trend items I usually markdown deeper, they clutter my inventory more if unsold.' Add a category column to your spreadsheet. Type A basics, Type B trend, Type C transition pieces. Run separate triggers for each.

Mia: Today's episode is supported by maketer dot com. They help boutique owners build marketing that actually matches the math. Worth a look.

Mia: Storefront Lab — the soft moves before the ladder. Before any item enters the formal twenty, thirty, final clearance system, there are lighter interventions that preserve more margin. Toolio's research recommends trying a five to ten percent price adjustment on underperformers for two weeks first.

Mia: Their exact language: 'A small five to ten percent price adjustment can significantly accelerate velocity before it's a markdown conversation.' That's not a sale. That's a recalibration. And it doesn't trigger the sale-shopper conditioning.

Jade: I love this because your customer doesn't see a big red 'SALE' sign. They just see a price that feels... right. And they buy. No conditioning, no expectation that everything else is about to drop too.

Mia: Move two: the bundle play. The Boutique Hub specifically recommends this — quote: 'buy a new arrival, you get an extra percent discount off on that clearance style.' So you're moving old inventory while driving new arrival sales at full price. The full-price new arrival protects your blended margin.

Jade: This is smart because the customer walks out with something new they're excited about AND a clearance piece. But the headline of the experience is 'I got something new' — not 'everything was on sale.' That framing matters so much for how they think about your store.

Mia: Move three: forty-eight hour VIP flash sales via email or Instagram Stories on three to five specific slow movers. Not storewide. Not even a whole category. Just three to five pieces from your Monday dashboard that need help.

Jade: Multiple boutique owners on Reddit confirmed this works. One said — 'deep clearance used to kill my fall buy dollars but timed flash sales helped a ton this year.' Film a quick styling video, post it to Stories with a twenty-four hour countdown, DMs to hold. Archive it when it's done.

Mia: And the fourth soft move — worth testing, though we haven't seen a ton of data on this one yet for boutiques specifically — is a styling event. A 'summer style refresh' evening. Social proof and in-person energy drive purchases without heavy discounting.

Jade: The key with all of these is — you only escalate to the formal tiered ladder when the soft moves don't bring your weekly sell-through back toward that eighty to ninety percent end-of-season target. The ladder is the last resort, not the first move.

Mia: Boutique Spotlight. So a Dallas boutique owner shared something in a community thread that perfectly illustrates this framework in action. She said she used to go straight to forty percent off every June and her fall buying power was wrecked by August.

Mia: She switched to tracking sell-through rate weekly, started at twenty percent on slow movers only, and used Instagram Stories flash sales to create urgency on specific pieces. She said — and this is close to her words — 'sell-through rate and weeks of supply literally saved my sale margins.'

Jade: What I love about that is she didn't need some fancy software or a consultant. She needed a spreadsheet with the right columns and the discipline to check it every Monday. That's it. That's the whole thing.

Mia: And she went into fall with enough cash to actually buy the collections she wanted instead of settling for whatever she could afford. That's the downstream payoff of protecting margins in June and July.

Jade: The fall buying power thing — that's the part that hits different. Because in the moment, the fifty percent off sale feels like a win. You cleared the racks! But then August comes and you're staring at your open-to-buy budget going... oh no.

Jade: Another big thank you to maketer dot com for supporting BoutiquePulse. If you want marketing that works as hard as your markdown ladder, go say hi.

Jade: Okay takeaway time. Here's what I want you to do this week — not next week, this week. Export your summer inventory. Open a spreadsheet. Calculate your landed cost, sell-through rate, and weeks of supply for every summer SKU. Write your tier rules. Write your margin floor number. Print it.

Mia: And set a recurring calendar reminder for every Monday morning — twenty minutes with your dashboard before you open. Red items move down a tier. Green items stay. That's it. The system makes the decisions so your panic doesn't.

Jade: And one more thing — before you launch any sale, try the soft moves first. Five percent adjustment. A bundle. A flash sale on three specific pieces. Only hit the formal ladder when those don't work. Your margins will thank you. Your fall collection will thank you.

Mia: Everything we covered — the full five-step markdown ladder, the Shopify setup guide, the Monday dashboard template, the staff policy language — there's a full step-by-step on the companion page at boutiquepulse dot com. It's worth going through properly.

Jade: See you next Wednesday. Go build that ladder.

Mia: BoutiquePulse is brought to you by maketer dot com. Thanks for listening — and thanks to maketer dot com for making episodes like this possible.