About Services Tools Blog Contact us

Brand Range Tracker

Checks a buying spreadsheet to show whether each line is in the till, has arrived, has a real photograph and is live on OpenCart.

  • Reporting Dashboards
  • Footwear retail
  • Dashboard feature
  • Bespoke
  • Hybrid
  • 2026

The problem

Buying tracks a season in a spreadsheet and cannot see which lines have arrived, been photographed and gone live. To find out, someone opens the till, the studio files and OpenCart for every row. A line with a placeholder image looks finished when it is not.

What it does

Staff drop in a tracker and the heading row is found automatically. It then picks a product identifier column in order: trade barcode, barcode, supplier code, name. Each line gets a tick for being in the till, stock on hand, a real photograph and OpenCart status, and placeholder import images do not count as a photograph.

Outcomes

  • A season tracker shows four tick columns instead of a chase.
  • Placeholder images do not count as a photograph.
  • The same file can be scored again without a new export.
  • Buyers see which lines are received but not yet live.

Simplified mockup

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

Brand range tracker

1. Drop the season file
Click to load the autumn tracker
2. Or re-score a saved name
File peek

Autumn 2026 buy, draft Prepared by the studio Style, Trade barcode, Supplier code, Image Oak harbour boot, 5058123400118, , studio_oak.jpg Grey pebble trainer, 5058123400149, , import_placeholder.jpg Ivory linen court, , ML.4421, studio_ivory.jpg

3. Progress
Load a tracker to start

How a line is matched

OrderColumnRule
1Trade barcodeExact match. Used for nine of the ten autumn lines.
2BarcodeExact match when the trade barcode cell is empty.
3Supplier codeDots are removed. ML.4421 becomes ML4421.
4NameLast resort, after the shorter dotted form of the name.
Photograph

A studio file ticks the column. A file named import_placeholder.jpg does not, even when the shop row is already live.

Heading row

Title lines above the headings are skipped. The autumn file’s headings sit on line 3, under the season note.

How it works

  1. Drop in a spreadsheet.
  2. Find the heading row and the best identifier column.
  3. Match barcodes exactly, and try supplier codes and names with shorter forms.
  4. Tick till presence, stock, a real photograph and OpenCart status.
  5. Ignore placeholder images from the import when checking for a photograph.
  6. Check the same file again later by choosing it from a list.

Pipeline

flowchart LR
  File["Tracker file"] --> Head["Find headings"]
  Head --> Match["Match identifiers"]
  Match --> Till["Till and stock"]
  Match --> Photo["Real photograph"]
  Match --> Shop["Live on OpenCart"]
  Till --> Table["Tick table"]