About Services Tools Blog Contact us

Supplier File Enrichment

Turns a thin supplier file of codes, colours, sizes and prices into a draft shop import, filling empty required fields from the web and saving product images beside a backup of the file.

  • Product Enrichment & Import
  • Footwear retail
  • Agent skill
  • Productised
  • Local/private
  • 2026

The problem

Distributor files often carry only a code, colour, size and price. The shop still needs titles, descriptions, categories and images before a row can go live. So the import either fails its checks or publishes a blank product page.

What it does

The tool finds the empty required fields, researches the public facts that can fill them, and writes a draft import in the shop's column layout. Images are saved beside the file, and the previous file is backed up first. Barcodes and customs codes are never invented. Where a brand has a signed-in media library, downloading its photos is a separate step. The procedure is written down and is not one program, and a small script is made for each file.

Outcomes

  • A file of codes and prices becomes a draft the shop can validate.
  • Images sit with the import and nobody has to hunt for them separately.
  • The previous file can be recovered.
  • Unknown barcodes and customs codes stay blank and are never guessed.

Simplified mockup

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

northwharf-ss26.csv

15 required cells empty
Source file
Click to load the thin supplier file

Mock research only. Nothing is fetched from the web. Barcodes and customs codes are never guessed.

Research
Load the file to start
Rows as received highlighted cells are required and empty
CodeColourSizePriceTitleCategoryImage
NW-220TanUK 4£54.00emptyemptyempty
NW-220TanUK 5£54.00emptyemptyempty
NW-318NavyUK 11£42.00emptyemptyempty
NW-318NavyUK 12£42.00emptyemptyempty
NW-404OakUK 8£79.00emptyemptyempty

Draft import

en-GB · GBP
Previous file
backed up
northwharf-ss26.csv.bak-2026-10-08-0942
Draft
5
rows in shop columns
Image folder
3
beside the draft
product_images/
Alden Row tan, saved image
alden-row-tan.svg
Keppel navy, saved image
keppel-navy.svg
Brindle oak, saved image
brindle-oak.svg

Packshots from a signed-in media library are a separate step. These three are the public stills saved with the draft.

Gap report

3 not invented
CodeSizeFieldDecision
NW-220UK 5Barcodenot invented
NW-318UK 11Customs codenot invented
NW-318UK 12Barcodenot invented
Filled from public facts
  • Titles and short descriptions
  • Category paths
  • Three images in the folder
Left blank on purpose

Two barcodes and one customs code had no public match. They stay empty so the shop does not publish a guessed number.

NW-220 UK 4 and NW-404 already carried a barcode and a customs code on the source row.

How it works

  1. Read the thin file and the target column layout.
  2. Back up the previous import file.
  3. List the required fields that are empty.
  4. Fill titles, descriptions, categories and other public facts that can be sourced.
  5. Save product images into a folder next to the draft.
  6. Write a gap report for anything still unknown, including barcodes and customs codes left blank on purpose.

Pipeline

flowchart LR
  A[ThinFile] --> B[Backup]
  B --> C[GapList]
  C --> D[PublicFacts]
  D --> E[DraftImport]
  D --> F[ImageFolder]
  C --> G[GapReport]

Output