Ultimate Guide To Shopware 6 Import

Welcome to the world of Shopware import! Like every e-commerce system, Shopware 6 provides the ability to import and export information between your website and external data sources. This functionality simplifies content management chores, such as data updates or product translations. Besides, the Shopware 6 import lets you easily move products to product comparison engines and marketplaces. In this Shopware import guide, we generally describe the available options, reviewing the basic import plugin of Shopware 6 along with its profiles. You will learn how to import data to Shopware 6 and what entities are supported. Also, check our Ultimate Guide To Shopware 6 Export.

Note that we provide Shopware integration with external platforms. Contact our support for further information or try our Improved Import, Export & Mass Actions.

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

Explore Shopware 

Shopware Import Plugin

The import functionality of Shopware 6 is always at your disposal. You can find the basic import module in your administration under Settings -> Shop -> Import/Export.

Shopware 6 Import Requirements

Shopware 6 supports CSV files containing character sets in the UTF-8 format, separated with semicolons. The system interprets quotation marks as string separators. So, the basic requirements for a successful Shopware 6 import procedure include 

• UTF-8 character set
• semicolon field separator
• quotation mark string separator

Therefore, you need to set these parameters in advance in your spreadsheet editor. Also, if your data files contain umlauts, ensure the CSV is UTF-8 compliant to enable the Shopware import.

Shopware Import Run

The Import tab of the Shopware import/export module lets you transfer data to your e-commerce website. You should use CSV files only, following the basic import requirements.

The platform’s default import functionality lets you add information. You cannot use the module to remove the existing data. For instance, it is impossible to remove a sales channel assigned to a product upon product import.

Always use a period (.) in product prices, such as 3.99 instead of 3,99, because using a comma (,) leads to incorrect import. Ensure that every price associated with the database entry “price” is separated with a dot.

So, the basic import procedure in Shopware 6 is quite straightforward: 

• Upload a CSV file;
• Select an import profile;
• Launch the process. 

Hit the Choose file button to select a CSV file that contains an update. Since some spreadsheet editors may affect field separators or other CSV file parameters, you should double-check whether your update file satisfies the Shopware 6 import requirements.

You should keep in mind that the selected Shopware 6 import profile determines how to treat the imported CSV file. It specifies a database where the transferred information will be stored with all the corresponding consequences.

When a CSV file is selected, and the import profile is specified, hit the Start import button to launch the CSV transfer to Shopware 6. The system will validate all its records. It imports only error-free entries. 

As for the records associated with errors, they are combined in a new CSV file. You can download it afterward, fix the problems, and re-upload it back to the system.

According to the official Shopware 6 import guide, you can also start a dry run to check whether it is possible to import a complete CSV file or just some of its records. This feature lets you avoid a situation when you transfer only a part of the update. It helps to find errors, fix them, and import all CSV entries. 

The Import activity grid contains a history of your imports. Note that the system automatically removes activities older than 30 days.

The context menu at the end of each line lets you download the imported CSV file as well as open the profile used. If an imported CSV file contains unsupported records, you can download them as a separate CSV file. Also, the context menu lets you cancel imports during the process.

In a nutshell, the import procedure is admin-friendly and intuitive. However, you may face lots of nuances described below. Let’s look at the Profiles tab of the Import/Export section and then proceed to other important details.

Shopware 6 Import Profiles

The Profiles tab contains all the import and export profiles. You can edit them and also create new profiles here.

Use the context menu to open, delete, or duplicate profiles.

Hit the Add new profile button to create a new profile. If you have many profiles, use the search function to find the desired option.

How To Create Custom Import Profiles In Shopware 6

Below, we explain how to create custom import profiles for your Shopware 6 website. If you’ve decided to do that, ensure that you have selected the default system language. Otherwise, you won’t be able to use them. This requirement also applies to profiles in other languages. 

There are two ways to create a new import profile:

• Hit the Add new profile button;
• Use the context menu to duplicate an existing profile and apply changes to it. 

Let’s explore the first approach. Hit the Add new profile button, and Shopware 6 will display a window divided into the following two tabs:

• General;
• Field Indicator.

General

The General tab lets you name your new import profile as well as select its object type. The latter defines a certain mode for importing data and reduces the number of mapping options according to the linked database. 

Use the mapping table to match CSV fields to their respective database counterparts. Also, pay heed to the fact that it is impossible to change the object type after introducing mapping options.

Field Indicator

The Field Indicator tab lets you specify a separator and an enclosure character. In Shopware 6, they are used to indicate the separate field within a CSV file:

Separators split single fields. A semicolon is the default option.

Enclosure characters group multiple fields. They appear at the beginning and end of a text. Note that separator characters are ignored within enclosure characters. A double quotation mark is the default option.

If your Shopware version contains import settings, you can also define how the system should handle the import file values. You can enable the creation of new records in the store as well as overwrite existing information.

Upload CSV File

Shopware also lets you create a new import profile based on existing CSV. It can be a file exported from another store. Upload it to provide your new import profile with the corresponding fields this CSV includes. Next, assign them to the corresponding database entries. That’s it!

How To Create Mapping For Shopware 6 Import

In a nutshell, creating a mapping scheme for an import profile in Shopware 6 is reduced two just two repetitive actions: you specify values from a CSV file and set a corresponding database value in front of it. That’s it. However, you need to keep several nuances in mind.

Add New Mapping

Hit the Add new mapping (1) button to add a line (2) to the mapping section of your import profile, where you can match a CSV entry with a database record. Note that you should use the name of the corresponding column from the CSV file that will be used with this profile as a CSV name.

Specify Required Fields

Use the Require (3) toggle to specify whether the respective field is a required field. If the toggle is active, the corresponding filled in your import file must be populated. Otherwise, you will get an import error. 

Add Default Values

Shiopware 6 also lets you specify default values (4)  that are provided automatically upon import if the corresponding field is empty.

Specify Field Position

This column lets you define which position (5) the corresponding field may appear in a CSV file.

Remove Entities

Use the context menu (6) on the right and its Delete option to remove unnecessary fields from your mapping scheme.

Shopware 6 Import Object Types

The following chapter explores all object types supported in Shopware 6 import by default. You will discover all database entries of each individual object type described. 

Product

You can save only a complete profile that contains the following mandatory fields: id, stock, name, taxId, productNumber.

Customer 

You can save only a complete profile that contains the following mandatory fields: id, firstName, lastName, customerNumber, email, defaultBillingAddressId, defaultShippingAddressId.

Categories

You can save only a complete profile that contains the following mandatory fields: id, name, type.

Orders

You can save only a complete profile that contains the following mandatory fields: id, salesChannelId, orderDateTime, stateId.

Media

The standard Shopware 6 import procedure lets you save only a complete profile that contains the following mandatory field: id.

Newsletter Recipients

You can save only a complete profile that contains the following mandatory fields:  id, email, status, hash, salesChannelId.

Properties

You can save only a complete profile that contains the following mandatory fields:  id, group.Id, and name.

Variant Configuration

You can save only a complete profile that contains the following mandatory fields: id, productid, and option.id.

Cross-Selling

You can save only a complete profile that contains the following mandatory fields: id, productid, and optionid.

Promotions

You can save only a complete profile that contains the following mandatory fields: id, productid, and optionid.

Advanced Prices

You can save only a complete profile that contains the following mandatory fields: id, productId, ruleId, and quantityStart.

Promotion Codes

No restrictions are listed in the official documentation.

How To Import Products To Shopware 6

Now, let’s see how to import products to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file. Let’s see other important nuances in this Shopware 6 import guide. 

Don’t start your Shopware 6 product import by choosing a CSV file. Select a corresponding import profile instead – Default product. The Import product variants checkbox displays. Do not activate it. We describe how to import product variants below. 

Now, choose a CSV file that matches the selected profile. You should ensure that your CSV file contains all products and required information, as we’ve already mentioned. Correct column names are mandatory. 

When everything is configured properly, click Start import.

Example CSV Fle

You can view and download an example of a default product profile here: Shopware Import/Export CSVs. 

The corresponding table consists of the following columns. You have to edit them accordingly:

After Shopware Import

If the Shopware 6 import process is successful, the system displays a message with the corresponding information. It means that your imported products are already available under Catalog -> Products.

In the case of a failed import process, Shopware 6 displays a message under the Start Import button, informing you of the numbers of both successfully imported and failed records.

As mentioned above, Shopware 6 import is associated with the ability to download the unimported entries in a separate CSV file. The latter consists of the failed records and an extra column titled  _error. Here, you can see the import of the corresponding record failed. 

Correct errors straight in the downloaded CSV file and then re-import it back.

Automated Product Import

If you have to deal with regular data updates, the basic Import/Export module of Shopware 6 may not be enough for satisfying your business needs. If it is necessary to periodically import products to your e-commerce website, a third-party tool can help you automate these processes. It means that you only need to configure the process once, and it will run in the background following the specified schedule.

You need the Improved Import, Export & Mass Actions extension to automatically create a schedule of updates and import products to Shopware 6. Besides, the module lets you map all the external data to the corresponding values from your Shopware database so that you can link any external source to your e-commerce website. Contact our support for further information and follow this link:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

How To Import Newsletter Recipients To Shopware 6

Now, let’s see how to import newsletter recipients to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file.

Don’t start your Shopware 6 newsletter recipient import by choosing a CSV file. Select a corresponding import profile instead – default newsletter recipient. 

Now, choose a CSV file that matches the selected profile. You should ensure that your CSV file contains all products and required information, as we’ve already mentioned. Correct column names are mandatory. 

When everything is configured properly, click Start import.

Example CSV File

You can view and download an example of a default newsletter recipient profile here: Shopware Import/Export CSVs. 

The corresponding table consists of the following columns. You have to edit them accordingly:

After Shopware Import

If the Shopware 6 import process is successful, the system displays a message with the corresponding information. It means that your imported newsletter recipients are already available under Marketing -> Newsletter recipient.

In the case of a failed import process, Shopware 6 displays a message under the Start Import button, informing you of the numbers of both successfully imported and failed records.

As mentioned above, Shopware 6 import is associated with the ability to download the unimported entries in a separate CSV file. The latter consists of the failed records and an extra column titled  _error. Here, you can see the import of the corresponding record failed. 

Correct errors straight in the downloaded CSV file and then re-import it back.

Automated Newsletter Subscriber Import

If you have to deal with regular data updates, the basic Import/Export module of Shopware 6 may not be enough for satisfying your business needs. If it is necessary to import newsletter subscribers to your e-commerce website periodically, there is a tool that can help you automate these processes. It means that you only need to configure the process once, and it will run in the background following the specified schedule.

You need the Improved Import, Export & Mass Actions extension to automatically create a schedule of updates and import newsletter subscribers to Shopware 6. Besides, the module lets you map all the external data to the corresponding values from your Shopware database so that you can link any external source to your e-commerce website. Contact our support for further information and follow this link:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

How To Import Properties To Shopware 6

Now, let’s see how to import properties to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file.

Don’t start your Shopware 6 properties import by choosing a CSV file. Select a corresponding import profile instead – default properties. 

Now, choose a CSV file that matches the selected profile. You should ensure that your CSV file contains all products and required information, as we’ve already mentioned. Correct column names are mandatory. 

When everything is configured properly, click Start import.

Example CSV File

You can view and download an example of a default property profile here: Shopware Import/Export CSVs. 

The corresponding table consists of the following columns. You have to edit them accordingly:

After Shopware Import

If the Shopware 6 import process is successful, the system displays a message with the corresponding information. It means that your imported properties are already available under Catalog -> Properties.

In the case of a failed import process, Shopware 6 displays a message under the Start Import button, informing you of the numbers of both successfully imported and failed records.

As mentioned above, Shopware 6 import is associated with the ability to download the unimported entries in a separate CSV file. The latter consists of the failed records and an extra column titled  _error. Here, you can see the import of the corresponding record failed. 

Correct errors straight in the downloaded CSV file and then re-import it back.

Automated Property Import

If you have to deal with regular data updates, the basic Import/Export module of Shopware 6 may not be enough to satisfy your business needs. If it is necessary to import properties to your e-commerce website periodically, there is a tool that can help you automate these processes. It means that you only need to configure the process once, and it will run in the background following the specified schedule.

You need the Improved Import, Export & Mass Actions extension to automatically create a schedule of updates and import properties to Shopware 6. Besides, the module lets you map all the external data to the corresponding values from your Shopware database so that you can link any external source to your e-commerce website. Contact our support for further information and follow this link:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

How To Import Categories To Shopware 6

Now, let’s see how to import categories to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file.

Don’t start your Shopware 6 category import by choosing a CSV file. Select a corresponding import profile instead – default categories. 

Now, choose a CSV file that matches the selected profile. You should ensure that your CSV file contains all products and required information, as we’ve already mentioned. Correct column names are mandatory. 

When everything is configured properly, click Start import.

Example CSV File

You can view and download an example of a default category profile here: Shopware Import/Export CSVs. 

The corresponding table consists of the following columns. You have to edit them accordingly:

After Shopware Import

If the Shopware 6 import process is successful, the system displays a message with the corresponding information. It means that your imported categories are already available under Catalog -> Categories.

In the case of a failed import process, Shopware 6 displays a message under the Start Import button, informing you of the numbers of both successfully imported and failed records.

As mentioned above, Shopware 6 import is associated with the ability to download the unimported entries in a separate CSV file. The latter consists of the failed records and an extra column titled  _error. Here, you can see the import of the corresponding record failed. 

Correct errors straight in the downloaded CSV file and then re-import it back.

Automated Category Import

If you have to deal with regular data updates, the basic Import/Export module of Shopware 6 may not be enough for satisfying your business needs. If it is necessary to import categories to your e-commerce website periodically, there is a tool that can help you automate these processes. It means that you only need to configure the process once, and it will run in the background following the specified schedule.

You need the Improved Import, Export & Mass Actions extension to automatically create a schedule of updates and import categories to Shopware 6. Besides, the module lets you map all the external data to the corresponding values from your Shopware database so that you can link any external source to your e-commerce website. Since the plugin is not the main topic of this Shopware 6 import guide, contact our support for further information and follow this link:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

How To Import Media To Shopware 6

Now, let’s see how to import media to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file.

Don’t start your Shopware 6 media import by choosing a CSV file. Select a corresponding import profile instead – default media. 

Now, choose a CSV file that matches the selected profile. You should ensure that your CSV file contains all products and required information, as we’ve already mentioned. Correct column names are mandatory. 

When everything is configured properly, click Start import.

Example CSV File

You can view and download an example of a default media profile here: Shopware Import/Export CSVs. 

The corresponding table consists of the following columns. You have to edit them accordingly:

After Shopware Import

If the Shopware 6 import process is successful, the system displays a message with the corresponding information. It means that your imported media items are already available under Content -> Media.

In the case of a failed import process, Shopware 6 displays a message under the Start Import button, informing you of the numbers of both successfully imported and failed records.

As mentioned above, Shopware 6 import is associated with the ability to download the unimported entries in a separate CSV file. The latter consists of the failed records and an extra column titled  _error. Here, you can see the import of the corresponding record failed. 

Correct errors straight in the downloaded CSV file and then re-import it back.

Automated Media Import

If you have to deal with regular data updates, the basic Import/Export module of Shopware 6 may not be enough for satisfying your business needs. If it is necessary to import media files to your e-commerce website periodically, there is a tool that can help you automate these processes. It means that you only need to configure the process once, and it will run in the background on following the specified schedule.

You need the Improved Import, Export & Mass Actions extension to automatically create a schedule of updates and import media files to Shopware 6. Besides, the module lets you map all the external data to the corresponding values from your Shopware database so that you can link any external source to your e-commerce website. Contact our support for further information and follow this link:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

How To Import Advanced Prices To Shopware 6

Now, let’s see how to import advanced prices to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file.

Don’t start your Shopware 6 advanced price import by choosing a CSV file. Select a corresponding import profile instead – default advanced prices. 

Now, choose a CSV file that matches the selected profile. You should ensure that your CSV file contains all products and required information, as we’ve already mentioned. Correct column names are mandatory. 

When everything is configured properly, click Start import.

Example CSV File

You can view and download an example of a default advanced price profile here: Shopware Import/Export CSVs. 

The corresponding table consists of the following columns. You have to edit them accordingly:

After Shopware Import

If the Shopware 6 import process is successful, the system displays a message with the corresponding information. It means that your imported advanced product prices are already available under Catalog -> Products.

In the case of a failed import process, Shopware 6 displays a message under the Start Import button, informing you of the numbers of both successfully imported and failed records.

As mentioned above, Shopware 6 import is associated with the ability to download the unimported entries in a separate CSV file. The latter consists of the failed records and an extra column titled  _error. Here, you can see the import of the corresponding record failed. 

Correct errors straight in the downloaded CSV file and then re-import it back.

Automated Advanced Price Import

If you have to deal with regular data updates, the basic Import/Export module of Shopware 6 may not be enough for satisfying your business needs. If it is necessary to import advanced prices to your e-commerce website periodically, there is a tool that can help you automate these processes. It means that you only need to configure the process once, and it will run in the background following the specified schedule.

You need the Improved Import, Export & Mass Actions extension to automatically create a schedule of updates and import advanced prices to Shopware y. Besides, the module lets you map all the external data to the corresponding values from your Shopware database so that you can link any external source to your e-commerce website. Contact our support for further information and follow this link:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio

How To Import Product Variants To Shopware 6

Now, let’s see how to import product variants to Shopware 6. As usual, the system lets you start the import procedure under Settings -> Shop -> Import/Export -> Import tab. Below, you will find not only the import process associated with your Shopware administration but also a corresponding CSV file.

The following 4 steps are necessary to import variants to Shopware 6:

1) Import Products

Since product variants consist of multiple products, you need to import the products for which you want to import new variants before going any further. However, you may need to transfer variants for already existing products. In this case, it is possible to skip this step.

You can see a default product profile here: Shopware Import/Export CSV. Download the CSV file and leave its id and parent_id columns empty. Proceed to the Import/Export module and launch the transfer.

2) Import Properties

Now, you have to import the properties to create product variants. It is possible to skip this step if the properties you want to use are already available in your administration.

You can see a default property profile here: Shopware Import/Export CSV.  Download the CSV file and leave its id column empty. It is generated during the Shopware 6 import. 

Enter the UUID of the property group in the group_id column – the ID displays in the browser’s address line when you call up the property group in your administration.

Also, it is possible to use the default property profile of the basic Import/Export module to get the properties you need. Once you have filled in the CSV file, re-import it in the Import/Export module.

3) Import Variant Configuration

We are almost ready since products and properties are already imported. Now, you should link them as variant configurations to create the variants later. 

You can see a default variant configuration profile here: Shopware Import/Export CSV. Download the CSV file and specify option_ids there. Consider it an automatically created UUID of the properties. You will get it by exporting the properties from the last step once again.

Now, you need to enter product_ids – the UUIDs of the main products for which you will create variants. The corresponding information is displayed in your browser’s address bar when you call up the products in the administration.

Like in the previous step, Shopware 6 lets you get them by exporting the properties via the default variant configuration settings profile.

You need to leave its id column blank and re-import the file using the standard Import/Export module and the default variant configuration settings profile.

4) Import Variants

The final step of importing product variants to Shopware 6 has two implementations. You can either transfer the corresponding data to your e-commerce website or generate the missing information within the administration.

Let’s see how to import variants to Shopware 6. The previous three steps helped you prepare for the final procedure:

• Go to the default Import/Export module of Shopware 6;
• Open the default product profile;
• Activate the import product variants feature;
• Fill in the mandatory fields in your import CSV file: 
  • parent_id – the ID of the main product;
  • product_number – the desired product number of the variant;
  • active – 0 or 1;
  • stock – the variant stock availability;
  • optionIds – the IDs of the properties that can be separated with “|”.

As you can see, the system notifies you about possible issues.

With the first three steps of this chapter, you’ve already prepared the variants. You just need to generate them instead of importing them:

• Go to your Shopware 6 administration;
• Proceed to products; 
• Open the product for which you have imported the variants;
• Open the generate variants tab and click Start variant generator.
  
  
• Select property values to generate variants.

That’s it! Now, you know how to import product variants to Shopware 6.

Final Words

Although the default Shopware import offers a bunch of powerful solutions, there is always a way to improve. We’ve already mentioned above that the default Shopware 6 Import/Export plugin is not enough to satisfy all the existing e-commerce demands. Therefore, let’s return to our Improved Import, Export & Mass Actions extension and focus on its core highlights and features.

The purpose of this Shopware import plugin is to help you bulk edit and update products, prices, and stock information with only a couple of CSV columns. Also, the module supports Google Sheets, so you can implement your product information management (PIM) on top of the popular platform. And unlike Shopoware 6, our plugin supports multiple file formats on import. You get full product import and export with custom properties (attributes) in a single file. Other features include:

• Update schedules – a tool that automates import and export processes;
• Advanced mapping – product properties mapping and presets;
• Intuitive interface – import and export profiles;
• Support for different files and sources – CSV and other file types, Google Sheets, Google Drive.

Note that we provide frequent updates and new functionalities for Improved Import, Export & Mass Actions. Therefore, contact our support for further information on the app and its current feature set that enhances the Shopware 6 import. Also, follow this link you will find the latest version of the extension there:

Get Improved Import, Export & Mass Actions for Shopware by Firebear Studio