About Services Tools Blog Contact us

Filling Barcodes, Weights and Carton Sizes

Fills blank barcodes, supplier codes, shipping weights and carton sizes on draft products, reading weight and carton from the box photograph first.

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

The problem

Draft products leave the photography stage without a barcode, a supplier code or a carton size, and those gaps block publishing and shipping. Carriers and the till also need a weight, and most new colourways arrive without one. Typing these from the box label could not keep up with a season.

What it does

The fill step works through draft products that are missing codes or shipping details. Barcodes and supplier codes are completed from supplier data already gathered. A blank weight and carton size are read from the box photograph by a local Gemma model through Ollama. If the photo cannot be read, they fall back to the most common values for that product type. Till weights that already exist are left alone.

Outcomes

  • A missing barcode or carton size no longer blocks publishing or shipping.
  • Weights come from the box photo before a product-type default is used.
  • Till weights entered by hand are not overwritten.
  • Products that still cannot be filled stay visible.

Simplified mockup

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

Staged colourways with gaps

Eight colourways still have empty cells
  1. Fill barcodes and supplier codes
  2. Read two box photographs
  3. Apply four type defaults
  4. Leave the till weight that is already set
  5. Flag the row with no source
ColourwayBarcodeSupplier codeWeight and cartonSource
Calderwell Ridge chestnut · boot – – –
–
till blank
Waiting
Calderwell Ridge navy · boot – – –
–
till blank
Waiting
Fenrow Harbour grey · trainer – – –
–
till blank
Waiting
Fenrow Harbour black · trainer – – –
–
till blank
Waiting
Quayline Moor tan · loafer – – –
–
till blank
Waiting
Larch Court black · court – – –
–
till blank
Waiting
Sable Row sand · sandal – – –
–
till 820 g
Till set
Greywell Dale oak · type unset – – –
–
till blank
Waiting

Box photograph

Canned read
Ridge chestnut label
Carton label showing 1180 grams and a 33 by 12 by 21 centimetre carton
What the read returned

Used for both Ridge colourways. Navy shares the carton. The photograph is a stand-in for this preview.

Weight1,180 g
Width33 cm
Height12 cm
Length21 cm

If this read had failed, a boot would have taken the type default instead.

Usual weight and carton by type

The most common values already on the shop. Used only when the box photograph cannot be read.

Product typeUsual weightUsual cartonStylesUsed on this pass
Boot1,180 g33 × 12 × 21 cm42Photo used instead
Trainer860 g31 × 12 × 20 cm37Harbour grey, Harbour black
Loafer740 g30 × 11 × 19 cm18Moor tan
Court680 g29 × 11 × 18 cm11Court black
Sandal520 g28 × 10 × 18 cm9Skipped, till weight kept
Unset––1Dale oak stays gapped

How it works

  1. Select draft products with a blank barcode, supplier code, weight or carton, or pick one product.
  2. Fill the codes from the supplier data already gathered.
  3. Read weight and carton size from the box photograph with the local model, where a photo exists.
  4. Where the photo cannot be read, use the most common weight and carton for that product type.
  5. Write the till weight only when it is still blank.
  6. Flag the product when neither source can fill it.

Pipeline

flowchart LR
  A[Gaps] --> B[Identifiers]
  A --> C[Box photograph]
  C --> D[Type default]
  B --> E[Staged record]
  D --> E
  E --> F[Till weight if blank]

Output