Boutique Inventory Planning When Seasonal Sales Data Is Thin

Early sales can make a small boutique's next stock order feel more certain than it is. A few purchases show what sold, but they cannot establish a dependable size curve or daily sales rate. Record transactions separately from buying assumptions, set a date to review both, and consider how much of the season will remain when any reorder arrives.

This example follows a hypothetical lightweight shirt through a 56-day selling season. The quantities, lead time and decisions illustrate a method; they are not buying recommendations for a particular shop.

Make the opening stock count usable

Give each style, colour and size its own row in a worksheet. Enter units ordered, units received in sellable condition, confirmed sales, returns, adjustments, available units and units already on order. Add the launch date and the date of each count. Mark judgements such as “navy may sell faster” as hypotheses, rather than entering them as demand.

On Day 0, the example shop receives 12 sellable shirts, with no earlier stock and no further delivery scheduled. By Day 14, it has sold five:

Navy S: two received, one sold, one available.
Navy M: three received, two sold, one available.
Navy L: three received, one sold, two available.
Oat S: one received, none sold, one available.
Oat M: two received, one sold, one available.
Oat L: one received, none sold, one available.

Those figures assume no returns, damage, transfers or corrections. Record such movements separately in a real review, then compare the worksheet with a physical count. One missing unit matters when a variant began with only two or three. A sale of the last available size also affects the next period's interpretation: zero later sales may reflect a stockout, rather than a lack of interest.

Calculate sell-through without hiding the denominator

Sell-through describes the share of a defined stock pool sold during a defined period. For this opening buy, five confirmed sales divided by 12 units received gives a little over two fifths by Day 14. Navy M sold two of three, or two thirds; oat L sold none of one. The combined figure helps assess the shirt, but the variant results are more useful when deciding what to reorder.

Write the calculation and dates beside the result. Shopify's inventory sell-through report uses units sold divided by units sold plus ending inventory for its selected period, accounting for stock received in that period. An opening-buy calculation can differ after a restock or when the opening stock predates the report period. Compare figures only after checking that their dates and stock pools match.

Days remaining is available units divided by average daily sales. Five sales over 14 days give about 0.36 sales per day; seven units divided by that rate suggest roughly 20 days of stock. Shopify's days-of-inventory-remaining report also uses ending quantity and average daily sales, and returns N/A when there are no sales on which to base a prediction.

Twenty days is a prompt for review, not an expiry date. Five purchases may have clustered around launch. Weather, display, footfall and unavailable sizes can change the next fortnight. More importantly, the overall rate does not mean every variant needs stock: navy M has one unit after two sales, while oat L has one after none. Note any days a variant was unavailable before treating its sales rate as comparable with one that remained on the rail.

Put lead time beside the season end

A reorder point asks whether available stock and incoming units are likely to cover demand until another delivery arrives. A simple working threshold is expected sales during lead time plus a chosen reserve. The reserve represents the shop's tolerance for a stockout; it is not supplied by a report. Confirm the supplier's dispatch terms, transit time, minimum quantity and likely receipt date before treating any calculation as an order.

Suppose this shop can buy individual units with a hypothetical 14-day order-to-receipt lead time. At the Day 14 review, navy M has sold two units in 14 days. Extending that observed rate through another 14 days suggests two sales before a delivery. Add a one-unit reserve and the working reorder point is three. Only one navy M is available and none is already on order, so the variant merits a decision.

That threshold does not justify a full size pack. An order placed on Day 14 would arrive around Day 28, leaving 28 days in the season. The early rate would imply four navy M sales in that remaining time, but two actual sales are too thin a basis for a firm forecast. One conditional choice is to buy two more navy M units if the supplier accepts that quantity and can deliver in time. The shop would add no other variant yet. If only a larger mixed pack is available, it could decline the reorder and note the missed opportunity for next season.

Record the amount committed, the chosen stockout risk and the next review date. A boutique with a different cash position or appetite for missed sales might choose a different reserve. The worksheet should show that choice openly, so a later review can distinguish a deliberate decision from an automatic reorder.

Review on dates that still allow action

Set review dates with the first buy. Begin each review with confirmed transactions and a stock count, then ask whether a new delivery would leave enough selling time. A workable schedule for this example is:

Day 0: record the 12 received units, the season end and the supplier's stated lead time. Set review dates; do not create an automatic reorder.
Day 14: enter five sales and seven available units, subject to a count. Consider two navy M units only if the small order and delivery date are confirmed.
Day 28: count any delivery separately. Enter sales since Day 14, returns, stockouts and the actual arrival date. Check whether demand persisted before ordering again.
Day 42: count remaining units by variant. With little season left, stop seasonal reorders and assess slow stock against the shop's margin plan.
Day 56: record final sales, reductions, returns and leftovers. Keep the actual size and colour results for the next buy.

A markdown is a response to remaining stock and selling time, not a fixed percentage triggered by a quiet week. Check whether a slow item was displayed and available throughout the period. A size that spent days out of stock did not have the same opportunity to sell as one that stayed available. Where enough time remains, another observed sales period may be more informative than an immediate reduction.

Use reports alongside the worksheet

A dashboard can speed up counting, provided its date range and inventory rules fit the question. Shopify's Products analytics bar provides an overview of sell-through, days remaining and inventory value, with routes to more detailed reports. It cannot supply this shop's season end, supplier lead time, fit notes or chosen limit on extra stock. Keep those decisions on the worksheet.

Check a report's exclusions before treating a blank row as proof of no demand. Shopify says its inventory sold daily sales quantity does not reflect returns, manual adjustments or transfer receipts. Its sell-through report includes a variant only if it sold at least once before or during the selected period; inventory reports also omit historical inventory for deleted locations. Read the report definitions and limitations when reconciling dashboard figures with a count.

A small dated record of sales, available and incoming units, lead time, and the next decision is enough to support a disciplined review. At season end, retain both the results and the assumptions behind each order. They give the next buying cycle a better starting point than a rate projected from a handful of early transactions.