The free Import/Export Tool from Shopware is helpful when it comes to changing or creating a large amount of data. Pickware also provides several profiles for the Import/Export Tool, for example for stock changes or supplier creation. To make the most of the tool, there are a few things to keep in mind – especially when opening, editing and saving the CSV files. Below, we'll show you step by step for Microsoft Excel and LibreOffice Calc what you need to consider so that the CSV file is displayed correctly in your spreadsheet program and can also be imported correctly back into Shopware.
General notes
Regardless of the program used, the following points must be considered when editing the CSV file for the Shopware Import/Export Tool:
Export the relevant profile as a CSV file from Shopware and use it as a template.
Open the file as a CSV file in a spreadsheet program.
Important: the encoding must be UTF-8 and the separator must be a semicolon.
The separator for decimal numbers in the file can be configured in the Shopware Import/Export Tool.
Finally, the file must be exported or saved again as a semicolon-separated CSV file in UTF-8 format.
CSV import/export with Excel (from Excel 2010)
First, perform a CSV export with the desired profile in your Shopware shop.
Open a new document in Excel.
Import the CSV file by navigating to the Data tab and clicking Get Data → From Text.
Select Delimited and choose Unicode (UTF-8) as the file origin, then click Next at the bottom.
Select the semicolon as the delimiter.
When editing the file, make sure to use the same decimal separator that you configured in the Import/Export Tool. In Excel, you can set the decimal separator via the advanced options.
The exported file can now be used as a template and filtered and edited accordingly.
Save the edited file as a CSV file in UTF-8 format
Finally, import the CSV file into your shop.
CSV import/export with LibreOffice Calc
Open LibreOffice.
Select the CSV file via Open File.
Similar to Excel, a dialog will open where you need to make the settings as described above.
Confirm the settings with OK.
The exported file can be used as a template and filtered and edited accordingly. Make sure to use the same decimal separator as in Shopware.
Save the file as a CSV file in UTF-8 format. To do this, select Save As and check the box for Edit filter settings. Then click Use CSV Format and select UTF-8 format again in the dialog that appears.
What to do if my spreadsheet program doesn't support UTF-8 encoding?
If your spreadsheet program doesn't support valid UTF-8 encoding, you can ensure UTF-8 encoding as follows: Open the edited CSV file in a text editor and save it there as a UTF-8-encoded CSV file. This detour via the text editor allows the file to be saved correctly in UTF-8 formatting.
Note: For the import into Shopware, the CSV file must be UTF-8 encoded. To be safe, test the import beforehand in a test environment or staging system. Before performing the import on the live system, it's advisable to create a database backup first.