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.
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.
Drafts
0
Size rows folded
0
Stills matched
0
Held
0
Harbour Loafer Cognac
Wrenfield · £42.00 · 6 barcodes
345678
Harbour Loafer Black
Wrenfield · £42.00 · no still folder
345678
Ridge Chelsea Black
Calderwell · £48.00 · 5 barcodes
7891011
Ridge Chelsea Tan
Calderwell · £48.00 · no still folder
7891011
Marsh Brogue Oak
Larch & Co · £55.00 · no still folder
678910
Quay Sandal Sand
Sable Row · £29.00 · no still folder
3456
Pebble Chukka Taupe
Quayline · £46.00 · no still folder
4567
Penny Navy
Greywell · £38.00 · no still folder
3456
Dry-run plan only. Confirm writes these eight drafts to the sandbox.
Sandbox write recorded for 8 drafts. The live catalogue was not touched.
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 brand
Resolved
Style
Colour
Size
Barcode
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
Drop in the supplier sheet or the seasonal order file.
Confirm the columns for brand, name, colour, size, barcode and price.
Apply that brand's column rules and list of alternative names.
Stop rows that would duplicate a style and write them to the reject report.
Create one draft colourway per style and colour, with the size run attached.
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]