Supplier data onboarding

Your supplier sends a code and a colour. You need a complete product.

Upload the supplier's file as it is. Cernel joins it to your products and fills in the rest, so your team checks products instead of typing them in.

Supplier filenordhjem_AW26.csv
beskrivelsefarveEAN
STÅLFLASKE SALVIE 500MLNH-4410-50salvie5709904410506
SERV.BRÆT EG MNH-2203-MEmpty5709902203025
VÆKKEUR RETRO MINTNH-7120mint5709907120006
KUGLERAMME TRÆ 100NH-3305Empty5709903305001
60 more rows62 more rows
CernelThe same products, enrichedEnriched
ProductColourMaterialStatus
Steel water bottle, 500 mlBottlessalvieSage greenStainless steelReady
Oak serving board, mediumServing boardsNatural oakOakReady
Twin-bell alarm clockClocksmintMint greenMetalReady
Wooden abacus, 100 beadsLearning toysMulticolourBeechNeeds review
60 more products62 more products

Trusted by e‑commerce teams at

Sound familiar?

If supplier files eat your week, this is what changes.

  • Typing

    Instead of

    Copying every new supplier spreadsheet into your own fields by hand

    • Copy and paste
    • One import template per supplier

    With Cernel

    The supplier's file, as it is, turned into your products

    Cernel works out what each column holds, and the supplier's next file goes in the same way.

  • In pieces

    Instead of

    Chasing the data sheet and the image links weeks after the price list

    • Your inbox
    • A tracking sheet

    With Cernel

    Every file joins onto the product it belongs to

    Rows land on your products by SKU, GTIN, EAN or your own identifier, whenever the file arrives.

  • Gaps

    Instead of

    Sending missing fields back to product managers and waiting weeks

    • Emails
    • Brand sites in twenty tabs

    With Cernel

    Empty fields filled from your data and the maker's own pages

    An agent looks the value up on the maker's page by EAN or name, on the sites you allow.

  • Drift

    Instead of

    Marine, Navy blue, Dark navy: every supplier names the same colour its own way

    • A value list in a spreadsheet
    • Clean-up rounds

    With Cernel

    What suppliers send, converted into the values your team chose

    Cernel picks from your own option lists, so every product reads the same and filters stay clean.

How it works

From the supplier's file to a finished product, in five steps.

What happens to one supplier file in Cernel. Pick a step, or let it play.

  1. Drop in the file the supplier sent, in their layout and their language. Your suppliers change nothing.

  2. Cernel works out what each column holds, whatever the supplier calls it: the product code, the name, the colour, the EAN, the image links. The supplier's next file goes in the same way.

  3. Each row lands on the product it belongs to, by EAN, GTIN or SKU. Products you have are updated and new ones are created, and you see both counts before anything changes.

  4. Agents turn the supplier's words into your own values, find missing details on the maker's page and write titles and descriptions in your voice.

  5. You choose which values go live automatically and which get a review step; review steps check every value and only ask a person when something fails or needs a decision. Approved values go to your PIM or your shop.

Supplier fileStep 1 of 5: Upload the file

nordhjem_AW26.csvHome and gifts, in Danish, 64 rowsUploaded
varenr;beskrivelse;farve;EAN;billedeNH-4410-50;STÅLFLASKE SALVIE;salvie;5709904410506;https://…/4410.jpgNH-2203-M;SERV.BRÆT EG M;;5709902203025;https://…/2203.jpgNH-7120;VÆKKEUR RETRO MINT;mint;5709907120006;https://…/7120.jpg

Late and in pieces

The price list in week one, the data sheet in week three, the image links in week five. One product.

Supplier data rarely arrives in one go. Upload each file as it comes, in whatever layout the supplier uses: Cernel joins it to the same product by its EAN, and the product fills up as the data arrives.

  1. Week 1

    Price list

    prisliste_H2.csv

    Not here yet

  2. Week 3

    Product data sheet

    serum_30ml_data.csv

    Not here yet

  3. Week 5

    Image links

    billeder_H2.csv

    Not here yet

No image yet

Waiting for the supplier

Hydrating face serum, 30 ml

EAN 4262718009010

0 of 9 fields

Title
Waiting for the supplier
EAN
Waiting for the supplier
Price
Waiting for the supplier
Size
Waiting for the supplier
Ingredients (INCI)
Waiting for the supplier
Skin type
Waiting for the supplier
How to use
Waiting for the supplier
Shelf life
Waiting for the supplier
Images
Waiting for the supplier

After the import

Products in your structure, filled, checked and sent back.

  • Sorted on arrival

    Every new product lands in its category as it comes in, and each value keeps where it came from: the supplier's file, an agent or a person on your team.

    Product categorization
  • Filled and checked

    New products are enriched the moment they arrive: attributes, titles and descriptions, and the values an agent finds on the maker's page. You choose which values go live automatically and which get a review step; review steps check every value and only ask a person when something fails or needs a decision.

    Product data enrichment
  • Back to your systems

    Approved values go back to your PIM or your shop, typically within a minute. Any other system takes them as a file in its own columns or through the API.

    Integrations

Supplier ranges live in days, not weeks.

All customer stories
  • Tiffany Lighting Direct

    Tiffany Lighting Direct gets a new supplier range live in days, not months

    to get a new supplier range live
    Days
    products from 20+ brands
    13,000+
    extra hires needed
    0
    Read the story
    A stained-glass table lamp on a wooden table in a quiet cafe
  • Firtal Group

    Firtal Group added a thousand extra hands without adding headcount

    products enriched
    +25K
    organic traffic to product pages
    +20%
    faster time to market
    +80%
    Read the story
    In the warehouse at Firtal Group

Questions

Supplier data onboarding, answered.

  • What can our suppliers send?

    Any CSV file, in whatever layout, order, size and language the supplier uses, with their own column names. Image links in the file come in as product images, and HTML in a cell stays HTML.

  • Do our suppliers need to change anything?

    No. Your team uploads the file the supplier already sends, in the layout they already use.

  • How do files about the same product come together?

    On an identifier. Cernel uses the column that holds the SKU, GTIN, EAN, MPN or your own identifier, and each row lands on the product it belongs to, whenever the file arrives.

  • What happens when the same supplier sends the next file?

    It goes in the same way. Use the earlier upload as the template: columns are matched by name, so a column the supplier has moved keeps its place.

  • Does anything change in our catalogue before we approve it?

    No. Before an upload runs, you see how many products will be created and updated, and nothing is written until you start it. After that, you choose which enriched values go live automatically and which get a review step.

Send us one of your supplier files.

Pick the file your team dreads most. We will show it joined to your products and filled in, ready for your review.

Book a demo