About Services Tools Blog Contact us

Merging Duplicate Product Drafts

Merges two drafts of the same product colour, one from the price list and one from the photos, and moves a video-only draft onto the product it belongs to.

  • Data Merge & Cleaning
  • Footwear retail
  • Scheduled worker
  • Productised
  • Local/private
  • 2026

The problem

The same colour of a product was filed twice, once from the price sheet and once from the camera. A second rule also started a new product at every video. So a description recorded in two takes left a draft with nothing but a video.

What it does

Where two drafts share a trade barcode, the one without pictures takes in the photographed one. Two drafts that both have pictures are left apart. A draft that holds a video and no photograph is a stray. Its video moves onto the draft that owns the last photo before it, and that draft is sent back to be read again.

Outcomes

  • The price-list draft ends up with its photos.
  • A second spoken take is read with its product and no longer makes a draft of its own.
  • The default run is a preview.

Simplified mockup

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

Barcode pairs Dry run

Shared barcode 9901842000199 · sheet has no stills
D-1842 · sheet No stills
Quay last, navy suede
Millhouse Wholesale · trade £42.50
312 418 524 620 711 86
D-1907 · camera No supplier block
Quay last, navy suede
Same barcode · photographed drop
Side
Toe
Heel
Shared barcode 9902206000841 · both already have stills
D-2066 Left apart
Chalk brogue
Supplier block present, and stills too
Front
Sole
D-2071 Left apart
Chalk brogue
Reshoot · stills of its own
Side
Back

Orphan clips

A second take closed a new draft. The clip has no photograph, so it belongs on the draft that owns the still ahead of it.

D-2210 · previous still Keeper
Moss derby
Last photograph before the clip
Upper
Pair
D-2218 · clip only Orphan
Spoken second take
Video · 0:42 · no still of its own

Write gate Dry run

Apply stays off until this is confirmed. The default run only prints the plan.

Plan, not yet written
DraftsRuleResult
D-1842 + D-1907Same barcode, sheet has no stillsAbsorb
D-2066 + D-2071Same barcode, both have stillsLeave apart
D-2218 onto D-2210Clip with no photograph of its ownMove clip

How it works

  1. Find drafts that share a trade barcode.
  2. Keep the draft with the supplier details and no pictures, and merge the photographed one into it.
  3. Leave pairs that both have pictures untouched.
  4. Find drafts that hold a video and no photograph.
  5. Move the video onto the draft that owns the previous photo.
  6. Save nothing unless the run is switched to save mode.

Pipeline

flowchart LR
  A[Barcode] --> B[SheetDraft]
  A --> C[PhotoDraft]
  B --> D[Absorb]
  C --> D
  E[OrphanClip] --> F[Keeper]
  F --> G[Reanalyse]