Skip to main content

Ingest and reconcile

Build one product truth without replacing your systems

Fuse reconciles ERP, PIM, supplier and team data, applies the priorities you set, and produces a traceable record every system can read.

The situation today

What goes wrong today

Each system holds a fragment. The ERP has the SKU, the price and the stock. The PIM has attributes and descriptions. Media sits in a DAM or a shared folder. The supplier owns the technical specification. Marketing writes the commercial content. The marketplace imposes its own fields on top. Nobody holds the whole record, so everyone rebuilds a private version of it in a spreadsheet, and the company argues about which one is right.

The mechanism

How it runs in Fuse

You decide which source field feeds each field of the golden record, and how merge treats a steward edit against a newer source value. On re-import, merge runs before validation: locked fields and steward decisions survive, and contradictions are flagged instead of overwritten. Every field carries its origin, the transformation applied to it and its validation status. Changes are kept in history. Validated fields are then distributed to the systems that need them.

Before Four systems, four dialects

  • Supplier A

    Excel, weekly

    gtin
    05400123456789 agrees
    reference
    SKU-458 restated
    price
    €129 agrees
    colour
    rouge restated
  • Supplier B

    CSV over API

    gtin
    05400123456789 agrees
    reference
    458-R restated
    price
    134 EUR disagrees
    colour
    Red agrees
  • ERP extract

    Nightly job

    gtin
    05400123456789 agrees
    reference
    PROD-458 restated
    price
    129.00 agrees
    colour
    R restated
  • PIM extract

    Manual entry

    gtin
    05400123456789 agrees
    reference
    SKU458 restated
    price
    not set absent
    colour
    rouge restated

After One record, every field accountable

CHAIR-458

Ergonomic office chair

  • CHAIR-458 reference sourced from Fuse master validated
  • 05400123456789 gtin sourced from Supplier A validated
  • 129 EUR price sourced from ERP extract validated
  • Red colour sourced from Colour reference validated
  • EN · FR · NL locales sourced from Translation step validated

Ready to publish

ERP wins on price. Supplier B is 5 EUR behind and held for review.

Illustrative payloads. Field names match the default Fuse model.

Fuse holds references to media, not media. It can flag a missing or unmapped image or document URL; it does not store or version binary files, and it does not replace a DAM.

What changes

What you get

  1. A complete view of what exists

    Everything known about a product in one place, including which system knew it.

  2. Fewer re-entries

    The value is taken from the system that owns it, rather than retyped in the one that needs it.

  3. Data at its source

    Fresh, validated and attributed, because the pipeline reads the owner rather than a copy.

  4. Ownership becomes obvious

    When you can see which application produced a value, the argument about who fixes it is short.

  5. One product truth

    Sales, the shop and the channels all read the same record, in the same version.

Indicators to track

How to measure it

Products with a golden record

percentage of the catalogue in scope

Conflicts between sources

field-level conflicts per import

Time to identify where a value came from

minutes on record detail

Usually the fastest improvement to notice, and the easiest to demonstrate internally.

Corrections propagated automatically

fields updated downstream per run

Next

Pick one range and we will build its golden record

Bring an ERP extract, a PIM export and a supplier file for the same products. We reconcile them on your priorities and show you where every value came from.

Thirty minutes on your data, not a slide deck.