How to

How to document the merch portfolio — so procurement and brand understand it

Documenting the merch portfolio is building the file procurement presents to the steering committee, brand uses to defend its decisions, and legal consults when an audit arrives. Without that file, the program lives in the responsible person's head and dies when they leave.

See the 7 steps Templates and references

Why document the portfolio, not just run it

Most Mexican merch programs operate without systematic portfolio documentation. Each order is negotiated case by case, each supplier is evaluated in hallway conversation, each price is agreed by email and forgotten the next quarter. When the responsible person leaves, they take half the operational knowledge with them.

A well-documented portfolio solves three problems at once. The first is operational continuity: if the current responsible leaves, the next one understands the portfolio without rebuilding it from zero. The second is negotiation: with price history, MOQ and lead time, procurement knows whether a new quote is reasonable or inflated. The third is compliance: legal and compliance can audit certifications, supplier RFCs and per-lot traceability without asking for everything again.

A documented portfolio is built on five blocks. The first is the SKU catalogue: every product with description, material, dimensions, weight, colour(s), customisation options, MOQ per material, lead time by volume, unit cost by volume. The second is the supplier network: name, RFC, physical address, production capacities, active certifications, last audit date, historical defect rate. The third is the price ladder: unit-cost table by volume per SKU, with validity and annual adjustment rule.

The fourth block is order history: orders from the last 24 to 36 months with SKU, volume, supplier, actual unit price, actual vs. promised delivery date, defect rate per SKU. The fifth block is annual benchmarking: unit-cost comparison vs. market, lead-time compliance index, quality index, innovation index (new SKUs introduced vs. discontinued). The five blocks together compose the portfolio file.

Corp-Merch.MX delivers this documented portfolio to clients contracting at least 12 continuous months. The template covers 480 active SKUs and 14 audited workshops; history is kept for five years for audit and ten years for historical price reference.

Before documentation starts, three decisions must be made: what level of detail to document (summary or exhaustive), who owns the documentation (procurement, marketing or a dedicated operations area), and what update periodicity (monthly, quarterly, semi-annual or annual). Without those three decisions, the documentation stops at the first attempt and is abandoned.

The 7 steps to document the portfolio

  1. Build the master SKU catalogue — each SKU with description, material, dimensions, weight, available colour(s), customisation options (screen print, embroidery, engraving, sublimation), MOQ per material, lead time by volume, unit cost by volume (five tiers: 100, 250, 500, 1000, 2500 pieces), SKU name, internal code and customer-side SKU equivalent when applicable. Corp-Merch.MX uses a template with 18 columns per SKU.
  2. Document the supplier network — per supplier: legal name, RFC, physical address, incorporation date, legal representative, capacities (maximum monthly production per line), active certifications (GOTS, GRS, FSC, ISO 9001, SA8000) with expiry date, last Corp-Merch.MX audit date, historical defect rate, lead-time compliance index.
  3. Build the price ladder per SKU — table with five volume levels and unit cost per level; validity (typically 12 months); annual adjustment rule by inflation or exchange rate; commercial terms (deposit, balance, payment term); customer-specific exceptions. Corp-Merch.MX archives this table signed by both parties.
  4. Compile the order history of the last 24-36 months — each order with number, date, supplier, real unit price, promised delivery date, actual delivery date, reported defects, corrective actions. The database allows calculating the lead-time compliance index and the average unit cost per SKU in the period.
  5. Calculate the portfolio KPIs — four minimum indicators: lead-time compliance index (on-time deliveries vs. total), defect rate (defective pieces vs. produced), average unit cost per SKU vs. market price (benchmarking), innovation index (new SKUs introduced vs. SKUs discontinued). KPIs are reported quarterly and archived for five years.
  6. Generate the annual benchmarking — unit-cost comparison vs. market (competitor quotes or public indices), price trend analysis by category, identification of overpriced or underpriced SKUs, portfolio rationalisation recommendations. Document signed by Corp-Merch.MX and by the customer.
  7. Publish the portfolio file and update it at the agreed periodicity — the file is delivered as master archive (PDF plus spreadsheet) in a shared folder with access for procurement, marketing and legal. Update periodicity can be quarterly or semi-annual depending on program pace.

Common mistakes that cost money and institutional memory

The first mistake is documenting only what was just purchased. The portfolio has to include history, not just the current order. Without history, there is no way to know whether the current price is reasonable or whether the supplier is delivering as before.

The second mistake is treating documentation as administrative work. Documenting the portfolio is not filling a spreadsheet; it is building the program's nervous system. If it is assigned to someone without seniority or authority, the documentation ends up incomplete and out of date.

The third mistake is not versioning. Without version control and last-updated date per row, two people consulting the portfolio at different times see different things and argue about which is true. Versioning settles the argument.

The fourth mistake is forgetting the compliance dimension. The portfolio includes certifications and supplier RFCs; without that information, compliance cannot close its annual audit. The omission ends in a fine or in contract cancellation with the supplier.

The fifth mistake is not using the portfolio in negotiation. The document's existence is useless if it is not consulted when a new quote arrives. Procurement must compare every quote against the historical price ladder before accepting.

The sixth mistake is documenting everything and not documenting anything important. A portfolio with 50 irrelevant columns and missing the 5 critical ones ends up too heavy to maintain and too incomplete to use. The golden rule: what is consulted is documented; what is not consulted is dropped.

Templates, references and tools

Master SKU catalogue: sheet with 18 columns per SKU: description, material, dimensions, weight, colour(s), customisation options, MOQ per material, lead time by volume, cost per tier (100/250/500/1000/2500 pieces), internal SKU, customer SKU, notes. Corp-Merch.MX ships the ready template for 480 active SKUs.

Supplier file: record per supplier with legal name, RFC, address, representative, capacities, certifications with expiry date, last audit date, historical defect rate, compliance index. Corp-Merch.MX keeps this file as part of the annual internal audit.

Signed price ladder: table with five volume levels and unit cost; twelve-month validity; annual adjustment rule; commercial terms. Signed by Corp-Merch.MX and by the customer at the start of the master agreement.

Order history database: table with number, date, SKU, volume, supplier, real unit price, promised and actual date, defects, corrective actions. Five-year retention; Corp-Merch.MX ships the customer an annual copy in Excel and signed PDF.

Portfolio KPIs: four indicators with formula, data source, periodicity and owner: lead-time compliance index, defect rate, unit cost vs. market, innovation index. Quarterly report; five-year archive.

Annual benchmarking: document signed by Corp-Merch.MX and by the customer that compares unit cost vs. market, analyses price trend, identifies overpriced or underpriced SKUs and recommends rationalisation. Annex to the annual program close.

Suggested cadence: month 1, complete master SKU catalogue; month 2, supplier files; month 3, signed price ladder; month 4, history database loaded; month 5, KPIs calculated; month 6, first annual benchmarking; quarterly or semi-annual update depending on program pace. For programs with more than 50 active SKUs, the cycle extends to 9 months.