Leaders Insights
Leaders Insights

Stay at the top of your field, a little every day.

DomainsMarketingDataFinanceAI
ResourcesLearnTestToolsBlogGlossary
© 2026 Leaders Insights — All rights reserved.
Tracks/Data in fashion/Data landscape, quality and metrics/Governance for seasonal, size-curve, and channel data
4/5+150 XP

Data landscape, quality and metrics

5Mapping the apparel data landscape: from PLM to POS+1506Taming the style-color-size hierarchy and product master+1507Data quality metrics for merchandising and catalog+1508Governance for seasonal, size-curve, and channel data+1509Analytics benchmarks: the fashion KPI dictionary+150

Governance for seasonal, size-curve, and channel data

# Governance for seasonal, size-curve, and channel data

A denim brand runs its Monday sales meeting. Wholesale reports "Spring '26 sold through at 62 percent." E-commerce says the same style is "still 40 percent in stock." Retail insists the season already ended. All three are right, and all three are looking at different definitions of the same product, the same season, and the same inventory. Nobody can act.

This is the daily reality of ungoverned fashion data. The numbers are not wrong. They are unreconciled. This lesson shows you how to fix that with ownership, definitions, and refresh cadences for the three most volatile datasets in apparel: season codes, size curves, and channel-level inventory.

Why fashion data breaks reconciliation

Most data-quality problems in apparel are not calculation errors. They are definition conflicts. Three structural features make fashion especially fragile:

  • Seasons overlap. Spring '26 ships to wholesale in January, hits retail floors in February, and lingers on e-com through July as markdown. There is no single "season end."
  • Size is a distribution, not a number. A style does not sell "500 units." It sells a curve across XS to XL, and that curve differs by channel and region.
  • Inventory lives in many systems. Wholesale sits in an ERP (Enterprise Resource Planning, the system that runs orders and finance). Retail sits in a POS (Point of Sale). E-com sits in a separate commerce platform. Each counts stock its own way.

Governance is the discipline of making these agree. Not by forcing one truth, but by defining terms, assigning owners, and setting when data refreshes.

Season codes: the master key

A season code is the identifier that groups products by their selling period (for example, SS26 for Spring/Summer 2026). It is the single most abused field in fashion data because everyone assumes it means the same thing. It does not.

Define the season lifecycle explicitly

Governance requires you to name each phase and attach a date rule:

| Phase | Definition | Owner |

|---|---|---|

| Design season | When the collection was designed | Product / Merchandising |

| Ship season | When goods are delivered to a channel | Supply Chain |

| Selling season | When the product is on the floor / live | Channel teams |

| Markdown phase | When full-price selling ends | Merchandising |

The failure mode: a planner filters "SS26 sell-through" using ship season, while finance reports using selling season. The gap is weeks, and the numbers never tie.

Rule to adopt: one field per phase, never a single "season" column doing four jobs. Store design_season, ship_season, and selling_season separately.

Ownership and cadence

Assign a data owner (accountable for the definition) and a data stewarddata stewardA business-side owner responsible for the quality, consistency and appropriate use of data in their domain.View full definition → (maintains the values day to day). Season codes change rarely, so a quarterly review cadence is enough. Lock the code list. New codes require sign-off from the merchandising owner, not ad hoc creation by an analyst.

Size curves: governing a distribution

A size curve is the percentage of units expected or sold across a size range. If a shirt sells XS 10 percent, S 25 percent, M 30 percent, L 25 percent, XL 10 percent, that is its curve.

Size curves drive buying, allocation, and markdown. When they are wrong, you over-buy sizes nobody wants and stock out of the ones they do. This is where broken-size loss (units stranded because the size that sells is gone) originates.

The governance problem

Size curves are computed, not entered, so the risk is methodology drift. Two analysts calculate the "M" share differently: one uses units sold, one uses units received. Same product, different curve.

Define one canonical formula and publish it:

sql
-- Canonical size-curve share, by style and channel
-- Definition: net units sold (sold minus returns) / total net units sold
SELECT
  style_id,
  channel,
  size,
  SUM(units_sold - units_returned) AS net_units,
  ROUND(
    SUM(units_sold - units_returned) * 100.0
    / SUM(SUM(units_sold - units_returned)) OVER (PARTITION BY style_id, channel),
  1) AS size_share_pct
FROM fact_sales
WHERE selling_season = 'SS26'
GROUP BY style_id, channel, size;

Note PARTITION BY style_id, channel. Curves must be computed per channel. E-com skews larger (returns and try-before-you-buy behavior differ), and retail skews to walk-in demand. A single blended curve hides both.

Worked calculation

Say a dress sold these net units in retail: XS 40, S 120, M 150, L 90, XL 20. Total is 420.

  • M share = 150 / 420 = 35.7 percent
  • S share = 120 / 420 = 28.6 percent

Now next season you buy 1,000 units. The governed curve tells you to buy about 357 M and 286 S. If someone had used a stale or blended curve of "20 percent per size," you would have bought 200 M and stocked out in week two.

Cadence

Size curves refresh weekly during the selling season because early sales reshape the expected curve. Freeze the curve at end of season to serve as the baseline for next year's buy. Owner: planning/allocation lead.

Channel inventory: the reconciliation core

This is where the Monday meeting fell apart. Channel-level inventory means on-hand units by location and by channel: wholesale, owned retail, and e-com.

Name the definitions that conflict

The word "available" means different things:

  • On-hand: physically in the building.
  • Available to sell (ATS): on-hand minus reserved (allocated to orders, in carts, held for wholesale).
  • In transit: shipped but not received.

E-com typically reports ATS. Wholesale often reports on-hand. Retail may report both under one label. That single-word ambiguity is the root cause of most cross-channel disputes.

Governance rule: every inventory number must carry its definition and its snapshot time. "1,200 units" is meaningless. "1,200 ATS, e-com, as of 06:00 UTC" is auditable.

Refresh cadence by channel

Cadence must match how fast each channel moves:

  • E-com: near real time or every few minutes. Oversell risk is immediate.
  • Owned retail: intraday, often hourly POS sync.
  • Wholesale: daily or per shipment event.

Document the cadence in a data contract: a written agreement between the team that produces data and the teams that consume it, specifying schemaschemaA schema is the formal blueprint that defines how data is structured, named, typed, and related within a database, file, or message.View full definition →, definitions, freshness, and who to call when it breaks. For a practical primer, see dbt's guide to data contracts.

Metrics that prove your data is governed

Governance is only real if you measure it. Track these data-quality metrics, not financial ones:

  • Reconciliation gap: absolute difference between channel inventory sum and the master (ERP) total. Target: under 1 percent (a common internal benchmark; treat as an estimate, not a standard).
  • Freshness SLA hit rate: percent of refreshes that landed on time. If e-com promised 5-minute freshness, how often did it deliver?
  • Definition coverage: percent of key fields (season codes, size, ATS) with a published, owned definition. Aim for 100 percent on these three.
  • Orphan rate: percent of SKUs (Stock Keeping Units, the unique product-size-color identifier) missing a valid season code or size. High orphan rates guarantee broken reports.

A simple reconciliation check

Master ERP says 10,000 units of style SS26-DRESS. Channels report: wholesale 6,000, retail 2,500, e-com 1,400. Sum is 9,900.

Reconciliation gap = (10,000, 9,900) / 10,000 = 1.0 percent.

At the 1 percent threshold, this is a flag, not a crisis, but you investigate the missing 100 units (likely in transit, uncounted). Governance means the gap is visible and assigned, not discovered in a meeting.

Knowledge check

1. In the opening scenario, wholesale reports 62% sell-through, e-commerce reports 40% still in stock, and retail says the season already ended. What is the fundamental problem being illustrated?

2. Why does the lesson describe governance as NOT 'forcing one truth'?

3. Why does the lesson argue that a style's sales should be treated as a distribution rather than a single number?

MULTIPLE CHOICE

4. Select ALL correct answers about why fashion data is especially fragile for reconciliation.

Select all the correct answers.

MULTIPLE CHOICE

5. Select ALL correct answers describing what governance for volatile fashion datasets requires.

Select all the correct answers.

Putting it together: the governance sheet

For each of the three datasets, one page answers four questions:

1. What is it? One-sentence definition, no ambiguity.

2. Who owns it? Named owner and steward.

3. How often does it refresh? Explicit cadence with an SLA.

4. How do we know it is right? The quality metric and its threshold.

Season codes: owned by merchandising, quarterly review, measured by orphan rate. Size curves: owned by planning, weekly refresh in season, measured by methodology consistency. Channel inventory: owned per channel with a data contract, refresh matched to velocity, measured by reconciliation gap.

When all three are governed, the Monday meeting changes. Wholesale, retail, and e-com are quoting the same season definition, the same size logic, and inventory numbers that carry their definition and timestamp. The debate moves from "whose number is right" to "what do we do about it."

Key Takeaways

  • Split the season field. Store design, ship, and selling season separately. One column doing four jobs is the top cause of unreconciled sell-through.
  • Publish one size-curve formula and compute it per channel. E-com and retail curves differ; a blended curve mis-buys sizes and creates broken-size loss.
  • Never quote inventory without its definition and timestamp. "ATS, e-com, 06:00 UTC" is governable; "1,200 units" is not.
  • Match refresh cadence to velocity. E-com near real time, retail intraday, wholesale daily. Write it into a data contract with an owner.
  • Measure governance with data-quality metrics, reconciliation gap, freshness SLA, definition coverage, and orphan rate, so quality is visible before the meeting, not during it.

Previous

Data quality metrics for merchandising and catalog

Next

Analytics benchmarks: the fashion KPI dictionary