Episode 22: Memorial Day Weekend Sales Strategy: Unofficial Summer Kickoff Playbook for Boutiques

Episode Summary

In this episode, you'll build a four-hour pre-market audit that pulls sell-through rate by category, your top-ten revenue looks, your five worst dead-on-arrival styles, and real vendor lead times from Shopify or Square. You'll learn how to turn that data into five printed sheets you carry onto the trade-show floor as a shield against vendor pressure and trade-show FOMO. By the end, you'll know exactly which categories to grow, which to skip, and how much of your budget to protect versus test. This episode is for any boutique owner heading to summer market and tired of coming home with pieces that end up on the clearance rack.

Key Takeaways

• Open Shopify Analytics and export your Sales by Product report for the last 90 days as a spreadsheet file.
• Add a Category column to your spreadsheet and group every style by its fashion category such as dresses, tops, denim, or accessories.
• Build a pivot table in Google Sheets with Category as the row and total quantity sold as the value.
• Export your current product list from Shopify under Products and note the on-hand quantity for each style.
• Calculate sell-through rate for each category by dividing quantity sold by starting stock, then color-code each row green for 60 percent or above, yellow for 40 to 59 percent, and red for below 30 percent.
• Sort your sales export by total revenue from highest to lowest and highlight the top ten styles on the list.
• Write down the vendor, price, silhouette, fabric, and color for each of the top ten styles on a separate printed sheet.
• Sort the same sales export by quantity sold from lowest to highest, filter for styles that have been available in your store for at least 30 days, and flag the five worst performers as dead-on-arrival styles.
• Write one sentence next to each dead-on-arrival style explaining why it failed, such as wrong price point, wrong fabric for your climate, or poor timing with a trend.
• Write your one-page market rules sheet listing what you will buy, what you will not buy, your total open-to-buy budget, and your budget split of 60 to 70 percent on proven winners, 20 percent on identified gaps, and 10 to 20 percent on test styles from new vendors.
• Go to Shopify Admin → Analytics → Reports and use the cumulative metrics toggle to set your date range to last summer, June through August, so you can see when revenue peaked by fashion category.
• Go to Shopify Admin → Orders → Export and download all orders including the date created and the date fulfilled fields.
• Add a lead time column in Google Sheets by subtracting the created date from the fulfilled date for each order so you get the number of days each order took.
• Build a pivot table in Google Sheets with vendor name as the row and average lead time in days as the value, then sort from fastest to slowest.
• Label each vendor on your pivot table as gold for under 14 days, standard for 14 to 28 days, or pre-season only for over 28 days, then print the completed table.
• Go to Shopify Admin → Analytics → Overview and screenshot your current conversion rate, average order value, returning customer rate, and revenue per session.
• Go to Shopify Admin → Apps → Flow and create a new automation that sends you an email when any of your top-ten styles drops below your chosen reorder quantity.
• Go to Shopify Admin → Apps → Flow and create a second automation that tags any style as needs-review when it has been active for 30 days and has sold fewer than three pieces.
• Add a tag to every style you order at market, labeling it either audit-buy for data-backed orders or fomo-buy for impulse orders made at the show.
• Schedule a 60-day sell-through review in your calendar for two months after market closes and add a reminder to compare the sell-through rate of your audit-buy styles against your fomo-buy styles.

Frequently Asked Questions

Episode Transcript

Mia: Okay so I found a stat that genuinely made me set my coffee down. McKinsey data shows companies that buy using actual data are nineteen times more likely to be profitable than ones going on gut instinct. Nineteen times.

Jade: Nineteen?! And meanwhile every boutique owner I know walks into summer market with like... a vibe and a credit card.

Mia: A vibe and a credit card! That's literally the anti-playbook. And that's why today we're building the actual playbook — a four-hour pre-market audit that replaces trade-show FOMO with receipts. Real receipts from your own register.

Jade: And this week's move is designed to help you double your sell-through rate on summer inventory — the metric that decides whether your July is profit or clearance rack panic. Let's get into it.

Mia: If you just found us — hey, welcome. I'm Mia. I dig through Shopify exports and wholesale calendars so you don't have to. I'm AI, which honestly means I've already read every boutique forum thread posted this month before you finish your morning latte.

Jade: And I'm Jade — also AI, also never sleeping. But my thing is the floor. The vendor negotiation, the customer who wants it in a six but you only bought eights... that chaos is where I live. Together we cover the numbers and the noise.

Jade: Today's episode is brought to you by maketer dot com — go check them out before you head to market this summer.

Mia: Alright, pulse check. Three things are happening right now that directly affect your market prep and I need you to know about all of them before you pack your rolling bag.

Jade: Hit me.

Mia: Number one. Shopify killed its Compare to Benchmarks feature. It's already gone as of May nineteenth. That toggle that let you see how your conversion rate stacked up against similar stores — poof. Vanished.

Jade: Wait — so owners who were relying on that to know if they were doing okay just... lost their measuring stick?

Mia: Exactly. And here's the thing — those benchmarks were never that useful because quote-unquote similar stores were never actually that similar. But it means your own historical data is now literally the only yardstick you have. Which is why today's audit matters even more.

Jade: Okay so the fix is build your own baseline. Which we're covering today.

Mia: Number two. Vendor lead times are quietly getting longer and nobody's announcing it. I pulled community reports from Reddit and Shopify forums — one owner said their quote fast vendor jumped from two weeks to six weeks without warning.

Jade: That's the one that gets me because I've heard owners say — and this is almost word for word — it was mid-July before my summer dresses arrived and by then customers had mentally moved to fall.

Mia: Right. And that's money sitting in bags in your back room while your customers are shopping elsewhere. So hour three of our audit today is specifically about calculating real vendor lead times from your own order history — not from what the vendor promises you at the booth.

Jade: And number three — Mia, in English please because I know you're about to get technical — what's happening with Shopify Flow?

Mia: Fair. In English — Shopify Flow can now talk to your sales data. That means you can set up an automatic alert that says hey, your bestseller is running low, reorder now. Or hey, this new style has been sitting for thirty days and nobody's buying it.

Mia: Previously you needed a paid app for that.

Jade: So your store basically tattles on slow inventory. I love that. Okay — that's a post-market power move though, right? Set it up when new inventory lands?

Mia: Exactly. We'll touch it again later. But the big three takeaway right now — benchmarks are gone so build your own, vendor lead times are lying to you so verify them, and Flow just got way more useful for catching problems early.

Jade: Alright this is the part I've been waiting for. The four-hour pre-market audit. Mia has this broken into four hours, one task per hour, and by the end you have five printed sheets that go in your bag to market. Your cheat set.

Mia: And I want to be clear — no third-party apps required. Shopify or Square, Google Sheets which is free, and a printer. That's it. First time takes four hours. By your third season you'll do it in under two.

Jade: Hour one. Sell-through rate by category. And before anyone panics — Mia, can you just explain what sell-through rate actually means?

Mia: It's just the percentage of what you bought that actually sold. If you bought a hundred units of dresses and sold seventy, your sell-through is seventy percent. That's it. The higher the number, the better your buying instinct was for that category.

Jade: And Shopify doesn't just hand you that number which is honestly so frustrating—

Mia: It doesn't. Community forums are full of owners asking how to find it. You have to export your sales by product report, export your inventory, and combine them in a spreadsheet. It's not hard but it's not obvious.

Jade: Okay so there are specific steps for pulling this in Shopify and in Square and Mia mapped this out beautifully — go grab it on the companion page at the site because she walks you click by click through where to go and what to export.

Mia: But here's the part I want you to remember even if you don't visit the page. Once you have your sell-through rate by category, color-code it. Sixty percent or above is green — buy more at market. Forty to fifty-nine is yellow — maintain, don't grow. Below thirty percent is red —

Mia: shrink or skip that category entirely.

Jade: That red category thing — that's the one that saves you money at market. Because you will walk past a gorgeous booth with exactly that category and your gut will say buy it. And your sheet says no.

Mia: And there's a new Shopify feature that helps here. They added a cumulative metrics toggle. You can set it to last summer — June through August — and see exactly when revenue ramped and peaked by category.

Mia: So if dresses peaked in week two of June, your dress vendor needs a lead time that lands product before June first.

Jade: That's actually brilliant because it connects your what-sold data to your when-it-sold data. Okay, hour two.

Mia: Hour two is your top-ten revenue items and your five worst DOA styles. DOA meaning dead on arrival — the styles that just... sat there. You sort your sales export by total revenue descending. Your top ten are right there.

Mia: For each one you write down the vendor, the price, the silhouette, the fabric, the color.

Jade: And the reason you write down all those attributes and not just the product name is—

Mia: Because at market you're not looking for the exact same product. You're looking for the same DNA. If your number one seller was a linen midi dress at sixty-eight dollars in sage green, you want anything matching that profile from any vendor.

Mia: The attributes are the pattern, the product is just one expression of it.

Jade: I love that. The DNA not the name. And then Mia you have this Pareto thing—

Mia: The Pareto check. Add a running percentage column — cumulative revenue divided by total revenue. Find where you hit eighty percent. Everything above that line is your Pareto core.

Mia: According to McKinsey's research, this kind of data-driven focus makes businesses twenty-three times more likely to acquire new customers. Your primary job at market is to protect and expand that core.

Jade: Okay and now the DOA list — this is the one that hurts but it's so necessary. Sort ascending, filter for items active at least thirty days. One owner on Reddit said once I saw my fail items listed it was so obvious I had been buying the same bad trends over and over.

Mia: And this is the crucial step most people skip. For each DOA style, write one sentence about why it failed. Wrong price point? Wrong fabric for your climate? Trend timing off?

Mia: Because at market, when a vendor shows you something with those same attributes, you now have language to say no instead of just a feeling.

Jade: That's your blacklist with receipts. Okay — hour three, vendor lead times. This is where I actually want to push back on you a little bit Mia.

Mia: Oh? Go ahead.

Jade: You have this formula — lead time equals fulfilled date minus created date from your Shopify orders. And in a perfect world that works. But on the floor, a lot of boutique owners are placing wholesale orders outside Shopify — through vendor portals, at the show on paper order forms, through a rep on the phone. Those orders don't have a clean Shopify trail.

Mia: That's... actually a really good point. So what's the workaround?

Jade: Pull up your email. Search the vendor name. Find the last ten PO confirmations and match them against when you actually received the shipment. Even rough averages beat vendor promises. A vendor saying oh we ship in two weeks — that is marketing, not a delivery guarantee.

Mia: I stand corrected. Use whatever trail you have — Shopify order data if it's there, email confirmations if it's not. The point is the same. Tier your vendors. Under fourteen days is gold — those are your in-season replenishment partners. Fourteen to twenty-eight is standard. Over twenty-eight days?

Mia: That vendor is pre-season only.

Jade: And if you're ordering summer goods at late May market from a vendor in that over-twenty-eight tier, that product is arriving in late July. Your customer has mentally moved on. You're stocking fall moods on summer hangers.

Mia: Hour four — the part that ties everything together. You build your one-page market rules sheet and your budget allocation. This is the physical thing you carry in your hand at every booth. It has two columns. I will buy — and I won't buy.

Jade: And the budget split — tell them about the budget split because this is where the discipline lives.

Mia: Sixty to seventy percent of your open-to-buy goes to proven winners. Depth buys in your top-ten categories, more colors, size-gap fills. Twenty percent goes to identified gaps your data revealed. And ten to twenty percent — that's your test budget. New vendors, new trends, but capped.

Mia: With a sixty-day sell-through review already on your calendar before you leave.

Jade: That test budget piece is so smart because it means you're not saying never try anything new. You're saying try new things with guardrails and a deadline. Big difference.

Mia: And according to Clarity US — they study decision-making frameworks — the exact recommendation is test and validate decisions before full execution. That's literally what this test budget does. You reduce risk and refine strategy before making major investments.

Jade: So at the end of hour four you have five printed sheets. Your category scorecard, your top-ten list, your DOA blacklist, your vendor lead-time tiers, and your one-page rules sheet. There's a full step-by-step on the companion page — it's worth going through properly because Mia has the exact export paths for both Shopify and Square.

Mia: And photograph all five sheets before you leave. Trade-show chaos loses paper. Ask me how I know... actually don't, I'll just say I've read enough forum horror stories.

Mia: Quick shout to maketer dot com for supporting the show. If you're prepping for market, they're worth a visit.

Jade: Storefront Lab time. These are techniques owners are actually using right now — not theory, not something worth trying someday. This is happening in stores this week.

Mia: First one — the AUDIT versus FOMO tag system. This is an idea worth testing after your next market trip. When your summer inventory arrives, tag every single SKU in Shopify with one of two tags. Buy-method-audit for anything your data backed.

Mia: Buy-method-FOMO for anything you grabbed on impulse or vendor pressure.

Jade: Oh that is brutally honest and I am here for it.

Mia: At sixty days, filter your sales report by tag and compare sell-through rates between the two groups. After two or three seasons you'll have irrefutable personal proof — your own data telling you which buying mode makes money.

Mia: The Farmers Market Coalition actually recommends this kind of tagging methodology for vendor performance tracking.

Jade: I guarantee the FOMO buys underperform. I just... I feel it in my bones. But that's the whole point right? Stop feeling it in your bones and start seeing it in your spreadsheet.

Mia: Second technique — the revenue-per-rack goal. Before market, calculate your total monthly revenue target divided by the number of racks or fixtures in your store. That gives you a per-rack benchmark.

Mia: Every new order at market should fill a rack that can realistically hit that number based on the category's sell-through rate.

Jade: So if a vendor's line can't earn its rack space based on your data, it doesn't get a hanger. Period. That is such a clean way to think about it because it makes the decision physical. You're not just deciding whether to buy — you're deciding what else gets evicted from that four-foot section.

Mia: And the third one — the AI assist for anyone who wants to speed this whole audit up. We put four free prompts on the companion page. You paste your exported data into ChatGPT or Claude or Gemini — free tier works —

Mia: and it analyzes your categories, identifies DOA patterns, builds a vendor decision matrix, and even generates your one-page rules sheet.

Jade: Wait — Mia, in plain terms — they literally paste their spreadsheet data into the chat box and it tells them what to buy and what to skip?

Mia: That's exactly what it does. The prompts are pre-written so you just fill in the blanks. It's not replacing your judgment — it's giving you a second opinion based on patterns you might miss because you're deep in the data. Think of it as a free analyst sitting next to you during the audit.

Jade: I want every listener to grab those prompts. Seriously. The companion page has all four and they're copy-paste ready.

Mia: Okay boutique spotlight. This one comes from a real community voice on the Shopify forums. A boutique owner — she didn't share her store name but she described a summer market trip where she went in with just gut instinct.

Mia: Ordered heavy in a trendy category because everyone at the show was raving about it.

Mia: Her exact words — last season I totally overordered some trendy stuff because everyone at the show was raving about it. It barely sold. Half of it ended up on clearance. She described it as heartbreaking watching fall inventory arrive so late it became markdown merchandise.

Jade: And that's not a failure of taste or judgment really — that's a failure of process. She didn't have a sheet. She didn't have a sell-through score telling her that category was already red in her store. The show floor energy filled the gap where data should have been.

Mia: But here's the flip side. Same forums, different owner. She said we don't plan trips without pulling category sell-through rates first anymore — it's a game-changer. She now walks the floor knowing exactly what categories to lean into and which to walk past no matter how pretty the booth is.

Jade: That's the before and after. Same owner, same taste, same vendors — different process. And the process is what we just spent the whole episode handing you.

Mia: Another owner on Reddit said something that stuck with me — using my POS sales data I could confidently walk into that vendor's booth and pass. That confidence is what the audit gives you. It's not just numbers. It's armor.

Jade: Big thanks to maketer dot com — they help boutiques like yours grow smarter. Go say hi at maketer dot com.

Jade: Alright — takeaway time. If you do one thing after this episode... actually no, if you do five things, here they are. Block four hours before you leave for market. Pull sell-through by category. Identify your top ten and your DOA five. Calculate real vendor lead times. Print your rules sheet. That's it.

Mia: And the quick-win you can do right now — like before the next episode drops — go into Shopify Analytics, screenshot your conversion rate, your AOV, your returning customer rate. Save it in a Google Sheet tab called My Baselines May twenty-twenty-six. Fifteen minutes. That replaces the benchmark feature Shopify just took away.

Jade: And after market — tag everything. Audit or FOMO. Be honest with yourself. Sixty days later your data will do the arguing for you. You'll never need convincing again.

Mia: One more thing — the companion page has the full step-by-step export instructions for both Shopify and Square, all four AI prompts ready to paste, and a printable template for your five-sheet cheat set. We want you to have the whole thing.

Jade: Go to market with data this time. Not a vibe and a credit card. We'll see you next week.

Mia: Thanks again to maketer dot com for making this episode possible. Visit maketer dot com and tell them BoutiquePulse sent you.