Skip to main content
Open Catalog > Products, click Import and export and choose under Import what you are importing: Products…, Prices… or Images (ZIP)…. You need the Import Products permission to see these. Every import works in three steps: 1 · Choose file, 2 · Check what changes and 3 · Import. “Nothing is saved until step 3”: the check shows what the file would change, and you decide.

​
Import products

Products are imported from an Excel file (.xlsx or .xls). Click Download the template for the columns. “A row whose SKU (or else GTIN) matches an existing product updates it — a GTIN match also gives the product the row’s SKU; any other row creates a product. When updating, a blank cell keeps the current value.” A weight or dimensions given without a unit are read in grams and millimetres. Prices are not part of this file: import them separately. The check counts what Will be created and Will be updated, rows Repeated in the file (only the first is used) and rows that fail, with the reason for each. When an ERP connection manages SKUs, a row cannot change the SKU of a product linked to it; see Who manages SKUs.

​
Import prices

A price import sets the prices of one price level, by SKU, from an Excel file (.xlsx or .xls). Prices of this view… under Export gives you a file in the same format, with every level, net and gross, that you can change and import again.
1

Choose the file

Choose the Price level, whether Amounts in the file are net or gross, and the file. Under Options:
  • Update existing prices: “On: a price that differs from the file is replaced. Off: only products with no price at this level get one.”
  • Skip rows whose price moves more than … % and list them for review: a backstop against a wrong column or a misplaced decimal point.
2

Check what changes

Click Next: check what changes. The check sorts the rows into Will change, Unchanged, Needs a look (moves over the percentage you set), Cannot import (SKU not found, bad amount) and Set elsewhere (“another system sets these prices”). Show rows filters the table.
3

Import

Click Import ‹n› changes. Only the rows that change are written; the result counts Changed, Unchanged, Skipped, Failed and Set elsewhere. Download the report (.xlsx) gives every row with its result and the reason; fix the skipped rows in it and import it again.

​
Rows another system sets

A row whose level another system manages is not imported. Its status is Skipped: set by another system, for example “‹level› is managed by another system, so this row was skipped.” The result lists them under Prices set by another system: “The import left these rows as they are: another system sets their prices. They are not errors, and importing the file again will not change them.” See Who sets a level’s prices.

​
Prices a rule may set again

When an imported price is one a repricer rule covers, the result lists it under Prices a rule may set again, per rule, with the rule’s next run: “Written as you asked. These rules may set them again at their next run.” Keep these prices… keeps those products out of the rule; see Keep my price.

​
What an imported price is

An imported price is recorded as set by you, with “Excel import”, in the product’s Selling price history. On a bundle whose price followed its components, the imported price becomes a fixed price. “Pricing Intelligence and the repricer receive the new prices at the next hourly sync.” Sync these products now sends them at once.

​
The permission to import prices

Importing prices needs Update or Import Products, both under Product. The import dialog needs Import Products to open. An API key or integration that imports prices through POST /api/catalog/product-price/import-prices (or …/import-prices-with-progress) needs one of the two as well; the Product permission alone is not enough.

​
Import images

Images come in a ZIP file. “Upload a ZIP whose top-level subfolders are named by product GTIN/EAN or SKU. Each folder’s images are attached to the matching product, ordered alphabetically (the first becomes the primary image).”
  • Match folders by: Auto (GTIN, then SKU), GTIN / EAN or SKU.
  • Replace existing images: on, a matched product’s current images are removed before the imported ones are added; off, they are added after them, up to 20 images per product.
The check shows the folders that match a product, those that match none (“no product with that GTIN or SKU, skipped”) and how many images it will attach. “The import runs on the server: you can close this window and it carries on.” Click Import ‹n› images to start it.

Products

Edit products and their prices one by one.

Price levels

Create price levels and choose who sets them.