Skip to content
All solutionsMaster data · Item matching

How do two item masters become one, without days of manual work?

Two unaligned item masters become one checked master. Rules decide where the data is clear. You decide where it is not.

Request a demoHow it works
For
Data & analytics
What you bring
Two item masters as Excel or CSV files, such as a market data export and a retailer file
What you get
One checked item master, and the open cases with reasons for your decision
Item matching
Demo data

File AMarket data MAT 03/202648 items

  • JOGHURT KIRSCHE 150G4012340000011
  • JOGHURT VANILLE 150G4 012340 000066
  • BUTTERMILCH 500ML4.01234000004E+12

File BRetailer file (ERP)48 items

  • Joghurt Kirsche 150 g4012340000011
  • Joghurt Vanille 150 g04012340000066
  • Buttermilch 500 ml4012340000042
matched automatically
41
open cases
3
no partner
4

Open case 1 of 3The EAN sits on two items in file B.

In file A

JOGHURT MANGO 150G

4012340000479

  • Joghurt Mango 150 g4012340000479
  • Quarkcreme Mango 150 g4012340000479

What changes

  1. Match items

    TodayThe panel and the retailer name the same item differently.

    With Synthexa

    One item master

    Fixed rules match the clear cases, every match with its rule, reason and source.

  2. Settle doubtful cases

    TodayThe same EAN does not always mean the same item.

    With Synthexa

    Open cases for your decision

    Synthexa presents candidates with reasons, and you decide.

  3. Match every delivery

    TodayWith every new data delivery, matching starts from scratch, by VLOOKUP and visual checks.

    With Synthexa

    Decisions that last

    With the next delivery your decisions apply automatically, and the export shows every change.

Bottom lineOne item master you can trace, and an Excel file in its original format.

What you can rely on

  1. Every match has its reason.

    For every match Synthexa shows the rule, the reason and the source. Private labels, pack sizes and flavour variants are not mixed up.

    One match, example

    • 4012340000011EAN in file A
    • 4012340000011EAN in file B
    • Same EANreason

  2. Your own rules, in your words.

    Write additional rules as plain sentences and test them on your files before they apply.

    Your own rules, example

    • “Multipacks count as separate items.”tested
    • “Match promotional packs to the base item.”tested

  3. Your format stays.

    The result comes back as an Excel file in its original format, every change highlighted in colour.

    Result, example

    • Matched_retailer.xlsxOriginal format, changes highlighted in colour

Frequently asked questions

In short

What is an open case?

An item whose data is ambiguous, for example because its EAN sits on two items in the other file. Synthexa presents candidates with reasons, and you decide. Your decision applies automatically to the next delivery.

Worked example, fictional figures
Items in file A
48
matched automatically
−41
no partner in file B
−4
open cases for you
3

items

Which data does Synthexa need?
Two item masters as Excel or CSV files, such as a market data export and a retailer’s item file. You do not need to clean them: Synthexa recognises cover sheets, title rows, footnotes and EANs in scientific notation itself.
What do I get, and in which form?
One item master, every match with its rule, reason and source. The export comes as an Excel file in its original format, with changes highlighted in colour.
How does this differ from market analysis?
Item matching merges two item masters into one checked master. Market analysis evaluates large exports and answers your questions about the figures.
Does the AI decide on matches?
No. Fixed rules match the clear cases, and you decide all others. You write additional rules in your own words and test them on your files before they apply.
Where is my data?
The platform is hosted in Frankfurt, and AI processing takes place in Europe. Your data is not used to train AI models.

More use cases

We’ll show you Synthexa with your own data.

Briefly describe your question. We reply personally within two working days.

How we start

  1. 1IntroductionYou describe your questions and data, we show Synthexa on a fitting example.
  2. 2Pilot with your dataYour team judges the value on a clearly scoped case.
  3. 3RolloutWe set up users, single sign-on and your slide master.
For market research and consulting firmsProvide studies to your clients in Synthexa, under your brand and domain.Request a partnership