Import Overview

In the following section, we’ll guide you through the process of importing data into Shopware 6 using the Improved Import, Export & Mass Actions app.

NOTE:

1. In the current version, system properties available for Shopware products by default cannot be excluded from the import mapping.
2. To disable a product during import, the ‘Active’ product property should be left empty.

Also, check our Shopware 6 Master Table for more detailed examples of importable tables.

Step 1: Select the File

Your very first step with Improved Import, Export & Mass Actions consists of the following activities:

1. Name your profile;

2. Select an entity you want to import (e.g., products or customers);

3. Create a schedule of updates. Turn on the toggle(1), choose your time zone(2) (you can type in the city instead of scrolling), specify your starting frequency(3) (every hour, day, week, or month), and configure additional parameters(4) (such as the exact time if you choose daily update or day and time if you decide to update once per week).

   

4. Configure email notifications;

   1. Enable the notification toggle.

   2. Choose your notification type: succeed, failed, or succeed and failed jobs.

   3. Specify an email address to send notifications to.

   4. Select the encryption.

   5. Specify the host for your email address.

   6. Type the port.

   7. Specify a sender’s username (an email address).

   8. Provide the corresponding password.

   9. You can attach job logs to the notification emails. However, they may be huge in size.

      

5. Select the file you want to import. The app currently supports CSV, XML, and XLSX file formats. Additionally, you can specify the delimiters used in the CSV file manually, or click the “Auto detect delimiter” checkbox and let the extension do the job.

6. Choose an import source — see File Sources for details on FTP, URL, Google Drive, and Google Sheets.

7. Configure advanced settings that include:

   1. URL rewrite behavior;
   2. media replacement behavior;
   3. advanced price replacement behavior;
   4. stock increment strategy;
   5. data transformation.

Advanced Settings

URL Rewrite Behavior

URL rewrite behavior:

• Display Warnings: When selected, the app alerts you if there are duplicate URLs in the imported file. If an imported product shares a URL with an existing product on your website, the app generates a new URL based on the product name.
• Increment Duplicate: With this option, the app imports products with duplicate URLs but modifies their URLs to follow the format “existing_url-n+1,” where “n” represents the duplicate number (starting at “0” for the first duplicate, resulting in “existing_url-1” after import).
• Force Overwrite: This option assigns the existing URLs to the imported products if duplicates are found in the import file. As a result, the imported products retain the existing URLs, while the original products are left without URLs.

Replace Media

Replace media:

If this option is enabled, it deletes the existing product media and replaces it with the images from the imported file.

Replace Advanced Prices

Replace Advanced Prices:

Enable this option to overwrite the existing advanced prices of products on your website with those specified in your CSV file.

To combine the existing price tiers with the imported ones, keep the Replace Advanced Prices feature disabled.

Stock Increment Strategy

Stock increment strategy:

• If Disabled: The product quantity is updated to match the quantity specified in the import file. For example, if your store’s current quantity is 100 and the import file specifies 50, the store quantity will be updated to 50 after the import.
• If Enabled: The product quantity is increased by the amount specified in the import file. For instance, if the current quantity is 100 and the import file specifies 50, the store quantity will be updated to 150 after the import.

When this feature is enabled, a Reload Product Before Update toggle appears:

• If Disabled: The quantity is updated immediately, following the selected stock increment strategy, without reloading the product data.
• If Enabled: The product data is reloaded first, and then the quantity is updated according to the selected stock increment strategy.

Data Transformation is described separately.