How can I export/import data from/to Shopware?

You can use imports and exports to review your existing content or transfer it to interfaces or evaluation tools. We will generally describe the options you have for imports and exports.

Import

In the tab Import you have the ability to import data into your Shopware environment using CSV files.

Upload CSV file (1):
Select the native CSV file from your PC which should be used for the import. The CSV file should contain the data to be imported into your Shopware 6 environment.

Some spreadsheet programs may affect the separators or leading zeros of CSV files. Therefore you should be careful to use a tool that creates native CSV files. A free tool that creates native CSVs is Open Office Calc.

Select profile (2):
Select the profile that is used to import the CSV file. The profile determines which data from the CSV file is stored in which database tables.

Start import (3):
With this button you start the import of the CSV file using the selected profile. Now all records are validated and all error-free records are imported. All erroneous records are combined in a new CSV file, which can be downloaded afterwards.

Import activity (4):
In the Import activity you can see a history of your past imports. All imports of the last 30 days are displayed here.
Using the context menu at the end of each line, you can download the imported source CSV file again and open the profile used. For imports with erroneous records, you can also download a CSV file that contains only the erroneous data.

Export

In the Export tab you can export existing data from your Shopware environment and convert it into a CSV file.

Export (1):
In the Export section you select which data should be exported based on the profile. A list of which profile outputs which data can be found in the Profiles section.

Select profile (2):
Select the profile that is used to export your data to the CSV file. The profile determines which data from the database is written into the CSV file.

Start export (3):
With this button you start the export of the data using the selected profile.

Export activity (4):
In the export activity you can see a history of your past exports. All exports of the last 30 days are displayed here.
You can open the used profile and download the CSV file again using the context menu at the end of each line.

Source: https://docs.shopware.com/en

In case you have any other questions, please reach out to us via:

 

How can we help?