Export of data

Info

You can find further information on importing, exporting and editing exported data in the article Import and export of data – overview.

You can export different kinds of data from your shop:

  • Products: These are the products of your shop. The product types and category products assignments are not included in this export file.
  • Categories: These are the categories of your shop. The category products assignments are not included in this export file.
  • Customers: These are the customers of your shop.
  • Category product assignment: This defines which products are assigned to which categories.
  • Product types: This includes the attributes and their values. For further information, refer to Product types and attributes.
  • Bulk prices: These are the bulk prices of your shop.
  • Cross-selling: This includes a list of products and their assigned cross-selling products.

How to export the data

  1. In the sidebar of your administration, navigate to SettingsExport and import.
  2. On this page you can specify the various export settings and then start the export process. 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 Here you can select what kind of data you want to export – e.g. 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 OpenOffice Calc.
  3. Select Export.
    The export process is launched. In certain cases, this can take some time.
  4. Save the export file on your computer.

You can now edit the saved export file. For further information, refer to Edit exported data.

During the export process, the data associated with your shop is only copied and not deleted. Your shop will therefore continue to be fully functional after the export process.

Exporting selected data

It is possible to export only certain products, categories or customers instead of all of them.

  1. Within the administration area, select the page where you can find the data you would like to export - for instance, Products → View products.
  2. In the left-hand column, select all of the elements you want to export. Use the search function if necessary to find the elements you require.
  3. Select Export.
  4. On this page, you can specify the various export settings and then start the export process. Take 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
    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 a 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 OpenOffice Calc.
  5. Select Export.
    The export process is launched. In certain cases, this can take some time.
  6. Save the export file on your computer.

You can now edit the saved export file. For further information, refer to Edit exported data.

Was this article helpful?

3 out of 4 found this helpful