Size Run & Broken-Size Floor Check (Clothing) – Free Excel Template for Retail Stores
The customer found the perfect shirt… but not in her size. A daily floor check for fashion stores: count units per size (XS–XXL) for each displayed style. The sheet flags 'broken' size runs (missing...
The customer found the perfect shirt… but not in her size. A daily floor check for fashion stores: count units per size (XS–XXL) for each displayed style. The sheet flags ‘broken’ size runs (missing S, M or L), counts missing sizes and tells staff what to refill from the stockroom – a quick win for conversion.
Table Of Content

Why it matters
Visual merchandising is how a store sells when nobody is talking to the customer. Windows, lighting, mannequins, shelf space and complete size runs decide whether a visitor walks in, picks up a product and buys it. Measuring VM turns ‘it looks nice’ into decisions you can repeat in every branch.
What’s inside the template
You fill in: Check Date, Branch, Style Code, Description, Colour, Category, Displayed on, XS, S, M, L, XL, XXL, Available in Stockroom, Action.
Calculated automatically:
- Units on Floor
- Sizes Missing
- Size Run – Broken = core size S, M or L is missing on the floor
How to use it, step by step
- Check the key displays (mannequins, wall bays, front tables) every morning and after the evening peak.
- Type 0 for a size that is on the rack but sold out – empty means not counted.
- Refill every ‘BROKEN’ line from the stockroom immediately; if not available, move the style to a smaller display.
- Rename size headers for shoes (36–45) or kids (2Y–12Y) if needed.
The dashboard: numbers to watch
- Styles checked
- Broken size runs
- Complete size runs
- Units on floor
Summary tables: Size-run status, Broken runs by category.
Example from the template
| Check Date | Branch | Units on Floor | Sizes Missing | Size Run |
|---|---|---|---|---|
| 2026-11-12 | Baghdad Mall | 7 | 2 | BROKEN – refill |
| 2026-11-12 | Baghdad Mall | 14 | 1 | Partial |
| 2026-11-12 | Baghdad Mall | 11 | – | Complete |
Download the template free
Free, no registration. Two versions: English and Arabic (right-to-left). Works in Excel, Google Sheets and WPS.
Browse all 60 templates in the ProSite Library
Need help running your store?
ProSite fits out, opens and runs retail stores in Baghdad and Erbil – store fit-out, visual merchandising, operations teams, IT setup and manager training. Call or WhatsApp us on +964 780 930 9998.




[…] Date Tracker (Supermarkets, Perfume & Cosmetics) – Free Excel Template for Retail Stores Size Run & Broken-Size Floor Check (Clothing) – Free Excel Template for Retail Stores Home/Retail Guides/Space Productivity – Sales per m² & per […]