What a size curve is
A size curve is the share of a product’s demand that falls on each size: for example S 20%, M 33%, L 33% and XL 13%. You use it to split an order. On that curve, 240 units of a sweater are S 48, M 80, L 80 and XL 32.
Why sales alone get it wrong
Sales are the demand you could serve. A size that is out of stock sells nothing, however many customers ask for it. So the sizes that sell out fastest, usually your best ones, look weaker in the sales report than they are.
Build the next order on that curve and you buy too few of them again, and they sell out again. Forecasters call this censored demand: sales stop at what was on the shelf.
The fix: sales per in-stock day
- For each size, take the units sold in the period. Use units kept, after returns, if you can.
- Count the days that size was in stock in the same period.
- Divide units by in-stock days. That is how fast the size sells when customers can buy it.
- Each size’s share of the total speed is its corrected curve.
A worked example
One sweater from an example store over 90 days. The numbers are illustrative.
| Size | Sold | Days in stock | Per day in stock | From sales | Corrected |
|---|---|---|---|---|---|
| S | 54 | 90 | 0.6 | 26% | 20% |
| M | 54 | 54 | 1.0 | 26% | 33% |
| L | 63 | 63 | 1.0 | 30% | 33% |
| XL | 36 | 90 | 0.4 | 17% | 13% |
On sales alone, M looks just like S. But M was out of stock for 36 of the 90 days. Per day in stock, it sold two-thirds more than S.
Split a 240-unit order on the sales curve and you get S 63, M 62, L 73 and XL 42. On the corrected curve it is S 48, M 80, L 80 and XL 32: 18 more of M, the size that kept selling out, and 15 fewer of S.
Where the simple fix stops
- Very few in-stock days. A size that sold out on day three gives you a speed from three days. Treat anything under two weeks with caution.
- Seasons. A speed from the peak weeks overstates the quiet ones. Compare like with like, or the same season last year.
- Several shops. Each shop, and the online store, can have its own curve. A shop that sells more L shouldn’t get the online curve.
- Returns. Count units kept, not units sent. A size that comes back often looks better in sales than it is.
- New products. No history means no curve. Start from similar products you already sold.
Getting the numbers from Shopify
Units sold by size are in Shopify’s sales reports, broken down by product variant. Days in stock are harder: Shopify records every inventory change for each variant, but no standard report counts the days a size sat at zero, so you would rebuild them from that history by hand.
Sizo does both for you, for every product, size and shop, and keeps them up to date. It connects to Shopify read-only.
Read next
- Which sizes really sell best in your store: five steps in Shopify, per product type and per shop.
- Inventory planning glossary: size curve, sell-through, weeks of cover, open-to-buy and more.