Skip to main content

Import data from a file

With Data Import you add or change many records at once from a CSV file: products, prices, customers, categories, stock, attribute values and media. Use it for a price change of hundreds of products or for a new range.

Data Import wizard Step 1 showing the data type dropdown with Products, Prices, Bulk prices, Bulk cost prices, Price sheets and Companies

Before you begin​

You need Backoffice access and the Configuration role with Owner access.

Know what an import does​

  • It adds and changes. A row that matches an existing record changes that record. A row that matches nothing makes a new record. A product is matched on its Propeller number, the number from your own system, its SKU or its supplier code, whichever your file holds.
  • It cannot be undone. There is no button to take an import back. Try a file with three rows before you import three thousand.
  • It tells you what failed. After the import you see how many rows were imported and which rows had an error.

Choose the type of import​

TypeWhat a row holds
Products, CategoriesA product or a category with its texts and codes
Companies, Contacts, CustomersA company, a contact or a private customer
PricesThe prices and the tax code of a product
Bulk pricesA price of a product from a certain quantity
Bulk cost pricesA cost price of a product from a certain quantity
Price sheetsA price sheet itself: its code, name and priority
Price sheet discountsA discount on a price sheet
InventoriesThe stock of a product
Attribute products, clusters, categories, companies, contacts, customersThe value of one of your own fields for one record
Attribute descriptionsThe definition of a field itself. See Attributes
Media images, documents, videosAn image, a document or a video of a product

Prepare the file​

  1. Go to Admin > Data Import and choose the type under Step 1.
  2. Click Download an example .csv file and open it. The first row holds the column names. The second row says per column what to fill in and whether it is required.
  3. Fill in your rows under it and delete the two rows of explanation, as the file itself asks.
  4. Save the file as CSV.

Some types have two example files. Pick the one that fits the number in your file.

ExampleUse it when your file identifies a record by
The first, for example Products via product idThe number Propeller gave it, in a column such as PRODUCT_ID
The second, for example Products via source idThe number from your own system, for example your ERP. It goes in SOURCE_ID, with the name of that system in SOURCE_NAME

Keep the columns separated by commas and write decimals with a point, as in the example. Dates are written as 2026-10-31T09:55:00.000Z.

Run the import​

  1. Under Step 2, click Upload or drag the file onto the page. Only .csv files are accepted.
  2. Under Step 3, check that every column of your file is matched to the right field. Columns whose name matches a field are matched for you.
  3. Click Import at the top right.

Step 2 showing Prices selected with example CSV download links and an Upload button

Step 3 showing the header mapping table with CSV columns mapped to data type dropdowns

Step 4 shows the result: the number of rows that were imported and the number of rows with an error.

Step 4 after an import in which all three rows were rejected: 0 successful rows, 3 errors and the error message with the affected rows

Each error has a message and the numbers of the rows it applies to. Correct those rows in your file and import them again.