Supplier spreadsheet mapping template
A mapping is an agreement about meaning. Record the source header, the target field and the evidence for every transformation before applying it to the full file.
How to use the template
- Keep the supplier file unchanged and work from a copy. Import this CSV as UTF-8; treat identifiers and example values as text.
- Replace the synthetic rows with your actual headers. Add the destination data type, required status and allowed values from your target specification.
- Write transformations explicitly: whitespace trimming, unit conversion or a value lookup each need a rule and authoritative evidence. “Clean it up” is not a rule.
- Set each row to DRAFT, HOLD or APPROVED. Approval belongs to your catalogue owner; the downloaded examples are not approved.
- Run the mapping on a small sample. Preserve raw values and the source-row key, and put unresolved items in an exception report.
Fields in the CSV
| Field | What to record |
|---|---|
| mapping_id / source_header / target_field | Stable mapping ID and exact column names |
| target_type / required / unit_currency_basis | Text or numeric type, target requirement, units and price meaning |
| transformation / validation_rule | Deterministic action and the check applied afterwards |
| missing_value_action / ambiguity_action | Leave blank, hold row or request supplier confirmation; never fabricate |
| evidence / owner / approval_status | Document supporting the decision, accountable reviewer and approval |
Example: a pack price that must stay on hold
Source columns say Price = 24.00 and Pack = Box. The destination expects a unit price. Do not divide by an assumed pack size. Set the mapping to HOLD until the supplier confirms pack quantity, currency and tax basis. Record that evidence, then document and approve any conversion.
Review rules, not just headings
StockCode may map to supplier_sku, but it should stay a text value. A product name is not reliable evidence for voltage, current rating or compliance. Missing required values belong in an exception list.
Rows in the template use synthetic examples only. The template does not connect to your ERP or perform any import.
Check the file before import · See an illustrative exception report
Start with a small review
CatalogCheck is a proposed service for independent UK electrical wholesalers. €299 excluding applicable taxes/month, up to five files and 10,000 rows, one target template and one review round. No ERP access or PIM migration. You approve the import.
The automated product is not live yet; first samples use existing tools with human review.
Request a free 50-row reviewDo not send a file until scope and handling terms are agreed.