All work
Retail & FMCG · Professional experience
Multi-Stage Product Master-Data Reconciliation
Reconciling product identifiers, pack sizes and costs across supplier, DC and retail records.
Operational· pending verificationEmployer-owned — experience summary only
Publication draft: status, contribution and technical details require contributor approval. The architecture and implementation notes below are illustrative, not verified accounts of a client deployment.
Context & challenge
The same product carried different barcodes, descriptions, case packs and costs depending on which system you asked.
Objectives
- Single matched view of each product
- Clear exception list with owners
Solution approach
- Staged matching: exact barcode, normalised barcode, supplier code, description similarity
- Case-pack and unit-cost normalisation
- Exception classification for manual review
Architecture
- Supplier file
- DC records
- Retail ERP
- Normalise
- Match
- Validate
- Exceptions
Simplified and anonymised. No private infrastructure details are published.
Important technical decisions
- Never auto-merge on description alone
Operational considerations
- Volume of exceptions vs. reviewer capacity
Results
Results pending verification. We only publish outcomes that have been confirmed.
Lessons learned
- Match confidence must be visible to the reviewer.
Visual demonstration
An interactive, synthetic demonstration related to this work is available in the laboratory.
Open demonstration