One-time Excel / CSV import
Next to the dozens of platform integrations, StoreLinkr lets you import your own product catalog once from an Excel or CSV file. You upload the file, map your columns to StoreLinkr fields, preview the result, and the products are created in your PIM in the background.
This is ideal for a first bulk load of products, or for adding a batch of products that isn't available through a live integration.
Starting an import
- Navigate to Catalog > Products.
- Choose the one-time import option and open the Excel / CSV import panel.
- Select your file (
.xls,.xlsx, or.csv, up to 10 MB) and click Continue. - Map your columns: StoreLinkr tries to auto-detect common column names. Check each field and adjust the mapping where needed.
- Click Preview to check the first five rows, then Execute import.
The import runs in the background. You can follow its progress under Settings > Tasks.
StoreLinkr remembers the mapping you used last time. If you import a file with the same column headers again, your previous mapping is applied automatically and you only have to check it.
Download an example file
Not sure how to structure your file? Download the example CSV and use it as a starting point:
The example contains the recommended column names and a few sample rows. Replace the sample data with your own products and keep the header row.
Required and optional fields
Only one field is required:
- EAN — the barcode / GTIN of the product. Rows without an EAN are skipped.
Every other field is optional, including the product name. If you leave the name empty, the product is still imported and shown as (no name) in the portal until you fill it in. All fields can be enriched later in the PIM editor.
Supported columns
StoreLinkr auto-detects the following columns based on their header (case-insensitive). Headers are matched on whole words, so EAN code and Verkoopprijs incl. btw are recognised too. You can always adjust the mapping manually.
| Field | Auto-detected headers | Required |
|---|---|---|
| EAN | ean, gtin, barcode, ean13, ean8, isbn, isbn13, isbn10 | Yes |
| Name | name, title, product name, naam, titel | No |
| Brand | brand, manufacturer, merk, fabrikant, author, auteur, publisher, uitgever | No |
| SKU | sku, article number, artikelnr, artikelnummer, reference, productcode | No |
| Model | model, type | No |
| Description | description, long description, omschrijving, beschrijving | No |
| Sales price | price, sales price, prijs, verkoopprijs, vraagprijs, retail price | No |
| Purchase price | purchase price, inkoopprijs, cost, kostprijs | No |
| Stock | stock, quantity, qty, voorraad, aantal | No |
| Condition | condition, conditie, staat, quality, kwaliteit, grade | No |
| Condition description | condition description, staat omschrijving, opmerking, remark, comment | No |
| Location / internal reference | location, locatie, stock location, voorraadlocatie, internal reference, interne referentie, shelf | No |
| Category | category, categorie, main category, hoofdcategorie, genre | No |
| Image URL | image, img, afbeelding, foto, photo, picture, url, image url | No |
In the mapping step you can also map width, height, length and weight columns.
Prices
Write prices as a plain number (12,50 and 12.50 both work). Currency symbols, spaces and thousand separators are handled automatically, so € 12,50 and 1.234,50 import correctly as well.
The preview warns you when a mapped price ends up as 0,00. That almost always means the wrong column is mapped — check the mapping before running the import.
Condition and condition description
Map your condition column to Condition. StoreLinkr recognises the wording in several languages and translates it to the right grade for each sales channel:
| Value in your file | Stored as |
|---|---|
new, nieuw | New |
as new, zo goed als nieuw, like new | As new |
refurbished, gereviseerd | Refurbished |
good, goed | Good |
used, gebruikt, tweedehands | Used |
reasonable, redelijk, acceptable | Reasonable |
moderate, matig, fair | Moderate |
damaged, beschadigd, poor | Damaged |
Anything StoreLinkr doesn't recognise falls back to New, so check the preview if you use your own wording.
Use Condition description for a free-text note about the physical state of the individual item ("cover slightly worn, pages clean"). This field is never overwritten by AI enrichment and is sent to Books in Belgium as the offer comment.
Location / internal reference
If you store your items by shelf or bin, map that column to Location / internal reference. It is exported to Books in Belgium as the stock location, so you no longer need to abuse the SKU field for it.
Images and attributes
- Images: map one or more image columns. Each column should contain a public image URL. Use Add image column to map extra images.
- Attributes: any column that isn't mapped to a standard field can be imported as a product attribute (for example
Color,MaterialorWear marks). Use Add attribute column to add them manually.
Overwriting existing products
By default, products that already exist (matched on EAN) are left untouched. Enable Overwrite existing EAN in the mapping step if you want the import to update products that are already in your catalog.
After importing, open the Data Quality dashboard to spot products that still need a name, images, description or price before you export them to your sales channels.