Search

Add multiple products via CSV

Note that this procedure is only recommended for experienced users. Any imports are carried out at your own risk. If you import a defective file, you could potentially destroy the data of your shop.

New products are usually added to your shop individually, as described in the article Add and set up products. It is also possible to add a large number of products in one go using a CSV import file.

To add products via CSV, follow these steps, which are explained in more detail below:

  1. Collect product images
  2. Export an import file
  3. Edit the import file
  4. Import products
  5. Check products

1. Collect product images

With a ZIP file, several images can be bundled into one file. These steps work differently on Windows and Mac computers. Note that the file names of the images should not contain spaces.

For Windows

  1. Collect all of the images you would like to import in one folder on your computer.
  2. Select all images.
  3. Right-click one of the images, select Send to and then Compressed (zipped) folder.
  4. Optionally, you can enter a name for the ZIP file, but the name is not important for the import.

The ZIP file has been created on your computer. You can find it in the same folder.

For Mac

  1. In the Finder, select the images you would like to import.
  2. Right-click on them and select Compress X Items (X is the number of items you selected).

The ZIP file has been created on your computer. You can find it in the same directory.

You can learn more about importing product images in the article Import of product images.

2. Export an import file

  1. In the sidebar of the administration, navigate to Settings → Export and import.
  2. On this page, you can specify various export settings and start the export process. You might need to select More options to see all available options. Take a note of all the settings you select as you will need to select them again both when editing the file and when importing it.
    Option Description
    Data export Select Products.
    Encoding Select “Standard (UTF-8)” if you use characters that are not contained in the standard character set. Otherwise, these will be exported as "?" characters. (Example: ™). In most cases, “Standard (UTF-8)” is a safe choice.
    Separator Here, you can select the character that should be used as a delimiter within the export file. The data within the file is then separated by this character. In most cases, we recommend using the semi-colon as separator. Since commas are often used within the data sets (for instance in product descriptions), using commas as a separator can cause problems when you edit the file with an external program such as LibreOffice Calc.
  3. Select Export.

The export process is launched. In certain cases this can take some time. Save the export file on your computer.

3. Edit the import file

This step is about editing the previously exported file and adding new products to it. We recommend the free program "LibreOffice Calc" for editing CSV files. Microsoft Excel can change the formatting of the files, which can damage them.

How are CSV files structured?

CSV files always have the same structure, independently from the type of data they contain. The first line contains the column names. Starting with the second line, the actual content starts. Each record (for example, each product) is shown in a new line.

If you open a CSV file using an external application such as LibreOffice Calc, the data is automatically sorted into columns. For product export files, these are, for example, the product name or the list price. The lines contain the individual data records, for example individual products.

For further information about editing export files, refer to Edit exported data.

How to edit CSV files with LibreOffice Calc?

  1. Open the exported file in Calc.
  2. Now you need to make some adjustments to the formatting of the file:
    Option Description
    Character set Select the encoding type that you chose when you exported the file previously. The encoding "Standard (UTF-8)" equals the encoding "Unicode (UTF-8)" in Calc.
    From row This value should remain "1".
    Separator options Select Separated by and the separator that you chose when exporting the file in your shop administration. For String delimiter, the quotation marks should remain selected.
  3. Select Ok.
  4. Now you can edit the file. Each line in the table corresponds to a product in your shop. Enter the corresponding data for each new product in a new line. In the column "Image for magnified view", enter the file name of an image from the ZIP file that is to be used as the main image for the corresponding product - for example productimage-1.jpg. In the "Images for gallery/slideshow" column, enter the file names of the images to be used as additional images for this product. Separate the file names with a comma, for example: productpicture-2.jpg,productpicture-3.jpg,productpicture-4.jpg
  5. When you are done, save the file.
  6. If you want to import more than 10,000 products into your shop, split the import file into multiple files. Select 10,000 lines at a time and insert them into a new Calc document. Add the header line from the first import file at the top and save each file.

4. Import products

  1. In the sidebar of the administration, navigate to Settings → Export and import.
  2. Select Import.
  3. From the Data import dropdown menu, select Products.
  4. Next to the CSV import file field, select the Select file... button. Select the import file from your computer.
  5. Select the button Select file besides Image archive (.ZIP file format) and Select the ZIP file from your computer.
  6. Under More options, choose the settings that you chose during the export of the product file.
  7. Select Import.
  8. If you want to import multiple import files, repeat the steps 3-7.

A message will appear at the top of the page, letting you know if the import was successful. If it wasn't successful, consider the information from the article Edit exported data.

If error messages for invalid attributes occur during the import, you can delete the corresponding attributes from the import file.
Currently you cannot import product bundles, personalised products or download products.
Product types can only contain attributes of the types Text and Text with value selection.

5. Check products

Select View your shop and view some product pages of imported products to make sure that the products are displayed as desired.

Was this article helpful?