About Services Tools Blog Contact us

Supplier Sheet to Draft Colourways

Turns a supplier spreadsheet or seasonal order sheet into one draft colourway per style and colour. Brand rules and an alternative-names check reject bad rows before they duplicate a style.

  • Product Enrichment & Import
  • Footwear retail
  • Pipeline
  • Productised
  • Hybrid
  • 2026

The problem

No two brands use the same headings, and a sheet has one row per size and not one row per shoe. Wrong brand or colour names and half-finished files were fixed after they had reached the catalogue. Seasonal drops came as spreadsheets plus photo folders, and retyping each colourway lost the pictures.

What it does

Staff confirm which columns are brand, name, colour, size and barcode. The import opens one draft per colourway, with the size run and barcodes attached, and links manufacturer photos where the folder matches. Each brand's column rules and list of alternative names reject a bad row first. A trial run on test data proves the column mapping before anything goes live.

Outcomes

  • A size-level sheet becomes colourway drafts with no retyping.
  • Rows with wrong names are rejected before they duplicate a style.
  • Manufacturer photos stay with the draft when the folder matches.
  • A trial run shows what would be created and what would be rejected before anything is saved.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Confirmed column map

Confirmed
aw26-order-sheet.csv · 40 size rows · headings checked
Fields
FieldSheet columnSample
BrandBrandWrenfield
NameStyle nameHarbour Loafer
ColourColourCognac
SizeUK size4
BarcodeEAN5060999100104
PriceWholesale£42.00
Sample of 40 rows
BrandStyleColourSize
WrenfieldHarbour LoaferCognac4
WrenfieldHarbour LoaferCognac5
CalderwellRidge ChelseaBlack7
HarrowmereRidge ChelseaBlack8
Larch & CoMarsh BrogueOak6
Sable RowQuay SandalSand3
Brand rules
BrandColour columnAlias
WrenfieldColour–
CalderwellColourHarrowmere
Larch & CoCol–
Sable RowColourway–

34 further size rows use the same map. Harrowmere is a Calderwell alias and is held before it can open a second Ridge Chelsea in black.

Draft colourways

39 size rows fold into 8 drafts. 1 alias is held. 2 folders match a still. Nothing is written until Confirm.

Map confirmed by Idris Ellison

Reject report

Harrowmere is a legacy alias of Calderwell. This row would have opened a second Ridge Chelsea in black. It was stopped before a draft was created.
Held row Alias clash
Sheet brandResolvedStyleColourSizeBarcode
Harrowmere Calderwell Ridge Chelsea Black UK 8 5060999100883
Would have duplicated
Calderwell Ridge Chelsea, black, sizes 7 to 11. That draft already holds UK 8. The alias row stays on this report and is not folded in.

How it works

  1. Drop in the supplier sheet or the seasonal order file.
  2. Confirm the columns for brand, name, colour, size, barcode and price.
  3. Apply that brand's column rules and list of alternative names.
  4. Stop rows that would duplicate a style and write them to the reject report.
  5. Create one draft colourway per style and colour, with the size run attached.
  6. Attach photos whose folder matches, and preview the changes before saving them for real.

Pipeline

flowchart LR
  A[SupplierSheet] --> B[ConfirmColumns]
  B --> C[BrandRules]
  C --> D[AliasCheck]
  D --> E[Rejects]
  D --> F[DraftColourways]
  G[PhotoFolders] --> F
  F --> H[DryRunPlan]