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.
STÅLFLASKE SALVIE 500MLNH-4410-50salvie5709904410506
SERV.BRÆT EG MNH-2203-MEmpty5709902203025
VÆKKEUR RETRO MINTNH-7120mint5709907120006
KUGLERAMME TRÆ 100NH-3305Empty5709903305001
Steel water bottle, 500 mlBottles
Oak serving board, mediumServing boardsNatural oakOakReady
Twin-bell alarm clockClocks
Wooden abacus, 100 beadsLearning toysMulticolourBeechNeeds reviewSound familiar?
If supplier files eat your week, this is what changes.
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.
Drop in the file the supplier sent, in their layout and their language. Your suppliers change nothing.
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.
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.
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.
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
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.jpgLate 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.
- Week 1
Price list
prisliste_H2.csvNot here yet
- Week 3
Product data sheet
serum_30ml_data.csvNot here yet
- Week 5
Image links
billeder_H2.csvNot here yet
Waiting for the supplier
Hydrating face serum, 30 ml
EAN 42627180090100 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 categorizationFilled 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 enrichmentBack 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
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.
Where to next.
- External data and images
Half the fields are still empty.
An agent finds the missing values and photos on the maker's own page, by EAN or name.
- Product data enrichment
The data is in. The copy is not.
Every attribute filled, and titles and descriptions written in your voice.
- Master data teams
One clean catalogue, however many suppliers.
How master data and PIM teams use Cernel next to the PIM they already run.
















