How it works
CSV import and export have their own home in the platform. In the sidebar, open CSV under Tools. The page has two tabs:- CSV Import: bring product data into Cernel from a file. Cernel reads your file, suggests how each column maps to your attributes and product identifiers, and shows you a preview of what will be created or updated before anything happens.
- CSV Export Templates: reusable column layouts for exporting product data. You define a template once, then run exports from the Catalog whenever you need a file.
- From catalog: you manage products in one system and send a CSV to Cernel. Cernel enriches it and you get updates back in the same format. The file keeps the same column layout each time, so you map it once.
- From vendor: different suppliers send you files in different shapes. Cernel maps each vendor’s columns to your attributes and brings them together into one catalog.
Why you would use this
Import from any spreadsheet
Reuse your export layouts
Importing products from a CSV
Prefer to watch first? These short walkthroughs cover each import type, then the written steps follow below.- Catalogue import
- Vendor import
Open CSV and start an import

Choose where your file is coming from
- From catalog: you manage products in one place and round-trip a CSV through Cernel.
- From vendor: you receive differently-shaped files from multiple suppliers and want them combined into one catalog.

Upload your file and name the import
.csv file onto the upload area (or click to browse). Cernel fills the Name field with the file’s name as soon as you select it, so you can go straight to Import CSV File to analyze it. Type your own name first if you want something more recognizable, and you can always rename the import later.
Map your columns to Cernel attributes
- Map each column to an existing attribute or a product identifier (such as SKU or GTIN), or create a new one inline.
- Columns Cernel couldn’t place are listed as skipped: add the ones you want with Add to imported columns.
- Where Cernel recommends a new attribute, accept it with one click.
Choose how the import updates your catalog
- Full Sync: existing products are updated and new rows are created.
- Update Only: only existing products are updated; rows without a matching identifier are skipped, so nothing new is created.
Review the impact, then run
Follow the import on its status page

A finished CSV import's status page, with its progress steps, What's next tips, and the See imported products button
Tracking imports in the CSV Import list
The CSV Import tab has a Status column for every import: Starting, Importing, Imported, or Needs attention (some rows weren’t added). It updates by itself while an import runs. Click an import to open its status page. To change how its columns map, open the status page or choose Edit column mapping from the row’s menu.Exporting your catalog as a CSV
Exporting works in two parts: you create a reusable export template that defines the columns and layout, then you run an export from the Catalog using that template. You can also pick columns ad hoc at export time without a template.Create an export template
Add a template
Configure the columns
- Export Name: a descriptive name for the template.
- Quick setup (optional): upload a sample CSV and Cernel auto-maps columns whose names match your attributes or identifiers, so you don’t have to build the layout by hand.
- Column mapping: choose which attributes and product identifiers to include, rename the output column headers, and drag to reorder. Click New Export Mapping and pick Attribute, Identifier, or Empty column.
- Empty columns: an empty column has a header and no attribute behind it, so its cells stay empty in every export. Use it to match the exact layout another system expects without creating an attribute just to hold a blank column. Each header must be unique within the template.
- Shared columns: two or more attributes can fill the same output column. The column lists every attribute that writes to it, and a warning reminds you that when several of them have a value, the newest value wins.

Save the template
Run an export from the Catalog
Pick your scope in the products table
Open the export modal and choose a template

Set the file options and download
- File name: defaults to the current category; the
.csvsuffix is added automatically. - Export language: pick one enabled language. The primary language is marked (Primary).
- Delimiter and Include header row: control the file format.
Advanced configuration
Building export columns without a template
Building export columns without a template
- Attributes: all attribute values, split into category and product attributes. Search to filter, drag to reorder, and edit the output header per column.
- Identifiers: SKU, GTIN, MPN, and any custom identifier types.
- Product fields are the built-in properties: Title, Product ID, Parent ID, and Parent Identifier.
- Product variants: set Min and Max variant levels to expand matched products into their variants. Leaving Max empty includes all descendants.
- Integrations: per-integration properties (for example Shopify metafields), shown when at least one integration is connected.
Re-importing an updated file
Re-importing an updated file
Reusing an import or export template
Reusing an import or export template
- Use an existing import as a template with the row’s Use as template for new import action. Cernel starts a new import and matches your uploaded file’s columns to the original by name: columns that match keep their original mapping, and columns with no match start unmapped in Skipped columns, ready for you to map. The new file no longer has to carry the exact same columns in the same order, so you can reuse a proven setup even when a vendor sends a slightly different file. Nothing is saved until you run the import. (Imports created before April 1, 2026 can’t be used as a template; start a new import instead.)
- Duplicate an export template to create a new template with the same columns, mappings, and settings. The copy opens ready to edit, with the name pre-filled as ” copy”.
Finding products that came from a CSV import
Finding products that came from a CSV import
Frequently asked questions
What file format is supported for import?
What file format is supported for import?
.csv files, up to 200 MB per file. The delimiter (comma, semicolon, tab, or pipe) is detected automatically; if it can’t be detected, you pick it during upload. If your file is larger than 200 MB, split it into multiple smaller files and import them into the same integration.My first column won't map, or Cernel says it can't read the file
My first column won't map, or Cernel says it can't read the file
Do I need to connect a store or PIM, or can I just use CSV?
Do I need to connect a store or PIM, or can I just use CSV?
Should I choose 'From catalog' or 'From vendor'?
Should I choose 'From catalog' or 'From vendor'?
Why can't I run my import?
Why can't I run my import?
Why weren't all my products imported?
Why weren't all my products imported?
What happens to columns Cernel doesn't recognize?
What happens to columns Cernel doesn't recognize?
My CSV has HTML in a column, like a formatted description. Will it render?
My CSV has HTML in a column, like a formatted description. Will it render?
<p> and <ul> tags), stores that value as HTML. The product detail page and any connected storefront then render the formatting instead of showing the raw tags. Cells without markup are stored as plain text as before, so you don’t need to flag which columns contain HTML.How do I import product images?
How do I import product images?
http:// or https://).If you have image files but no URLs yet, host them somewhere that gives a stable, direct link first (your Shopify store or another connected commerce platform, or a public storage bucket or CDN), then put those links in the column. A Google Drive “share” link won’t work, because it opens a viewer page rather than pointing straight at the image file.How do I give a product more than one image?
How do I give a product more than one image?
| or ; points at an address that does not exist. The image then fails to load, and image enrichment for that product reports an error instead of producing a picture. If one product’s images fail while others succeed, check whether that product’s image cell holds more than one URL, and split them into separate columns.How do I reuse the same export every time?
How do I reuse the same export every time?
How do I export product variants alongside their parents?
How do I export product variants alongside their parents?
0 and leaving Max empty includes the matched products plus every descendant; setting Min to 1 exports only the variants.Can I import product variants from a CSV?
Can I import product variants from a CSV?
Why are some export column names highlighted?
Why are some export column names highlighted?
Why do empty Single Select and Multi Select values export as blank cells?
Why do empty Single Select and Multi Select values export as blank cells?
None, which downstream systems could mistake for real content. If an older export shows None in Single Select or Multi Select columns, run the export again to get truly empty cells.