Why the sales report misleads
- Sold-out sizes stop selling. A size with no stock sells nothing, however many customers ask for it. Your fastest sizes sell out first, so they look weaker than they are.
- Returns. A size that customers often send back sells less than its gross sales say.
- Mixed product types. Dresses, jeans and knitwear each have their own size curve. Adding them together hides all three.
- Several shops. A shop, the online store and each city can favour different sizes.
Five steps to find your best sizes
-
Pick one product type and one season
Compare like with like. A size curve for dresses says little about jeans, and summer says little about winter.
-
Get units sold by size, after returns
Shopify’s sales reports break sales down by product variant. Add up each size across the styles in your group, and count the units customers kept.
-
Count the days each size was in stock
This is the step most reports skip. Shopify records every inventory change for each variant, but no standard report counts the days a size sat at zero. Rebuild them from that history, or note when each size sold out and when it came back.
-
Divide sales by days in stock
That is how fast each size sells when customers can buy it. Each size’s share of the total is your size curve. The size curve calculator does this step for you, and shows how much it changes an order.
-
Put it next to what you bought
Compare the curve with the size mix of your last order. Sizes you bought less of than the curve are the ones that sold out; sizes you bought more of are the ones you marked down.
Then do it per shop
Run the same steps for each shop and for the online store. They often differ, and one curve for all of them sends too many of a size to a place that doesn’t sell it, while another place runs out.
What to do with the answer
- Split the next order on the corrected curve, not on last season’s sales.
- Allocate each shop’s share by how fast it sells each size.
- Reorder earlier for the sizes that keep selling out: their real speed is higher than the report shows.
- Buy fewer of the sizes you keep marking down.
New to the terms? The glossary explains size curve, size mix, sell-through, weeks of cover and the rest in plain English.