---
title: Data Migration and Import/Export Strategies | Shopware Community Hub
description: >-
  Primer on migrating data from other platforms into Shopware, and leveraging
  different approaches to important and exporting data
canonical_url: >-
  https://hub.shopware.com/learn/unit/solutions-architect-data-migration-and-import-export-strategies
---

# Data Migration and Import/Export Strategies

<LearningObjectives>

- Understand the tools available for **importing and exporting data** in Shopware.
- Learn best practices for **data migration** to ensure data consistency and minimize errors.
- Recognize **common limitations** with Shopware’s import/export features and how to address them.

</LearningObjectives>

# Introduction to Import/Export in Shopware

Shopware provides built-in tools for importing and exporting data, enabling merchants to manage large datasets efficiently. From product catalogs to customer lists, import/export functionality is crucial for day-to-day operations as well as initial data migrations from other systems. However, there are a few limitations and potential issues that users should be aware of to ensure smooth data handling.

## Overview of Options

- **Shopware Migration Assistant**: Starting-off point for building out migrations from other platforms to Shopware. Meant to be used as a one-off migration, this tool provides a framework for migrating.
- **Shopware Import/Export**: Provides basic import and export functions for core entities like products, categories, and orders. It supports CSV-based imports and exports.
- **Third-Party Solutions**: In the Shopware app store, many more third-party solutions are available. These include: Improved Import, Export & Mass Actions by Firebear, Universal Importer and Exporter by Antony Systemhaus, Import-& Export of Variants by Proxation, and [many more](https://store.shopware.com/en/search?search=import).

## Shopware Migration Assistant

The **Shopware Migration Assistant** is designed for moving from other eCommerce platforms (such as Shopware 5, Magento, or WooCommerce) to Shopware. It simplifies the migration process by allowing users to transfer data like products, customers, and orders while preserving essential details and relationships.

### Key Features

- **Supported Platforms**: Migration Assistant supports migrations from **Shopware 5**, **Magento 1 & 2**, and **WooCommerce**, these existing migrations can be used as templates for other platforms.
- **Data Types Supported**: The assistant can migrate core data such as **products**, **customers**, **orders**, **categories**, **media**, **CMS pages**, and **configuration settings**.
- **Mapping and Configuration**: During migration, users can map source data fields to Shopware fields, allowing customization of data alignment based on Shopware’s schema.

**Limitations and Considerations**:

- **Partial Data Migration**: Some custom data fields or non-standard configurations may not migrate fully and might require manual intervention.
- **Customization Needs**: Complex or highly customized migrations may require custom plugins or additional manual data handling.

### Migration Process

1. **Install the Migration Assistant**: Available as a plugin, the Migration Assistant can be installed and configured in the Shopware Admin.
2. **Connect Source System**: Connect to the source platform using credentials or API keys, depending on the platform.
3. **Select Data to Migrate**: Choose which data sets to migrate, like products, orders, or customer information.
4. **Map Fields**: Map data fields from the source system to Shopware fields. This step helps ensure data aligns properly with Shopware’s structure.
5. **Run Migration**: Once everything is set up, start the migration process. The assistant provides updates on migration progress and logs any errors for troubleshooting.
6. **Review and Validate Data**: After migration, review the data within Shopware to ensure it transferred correctly and make adjustments if needed.

Read more: [Migration Assistant](https://developer.shopware.com/docs/products/extensions/migration-assistant/).

## Import/Export Module in Shopware

The **Import/Export** module in Shopware is a versatile tool that enables users to import or export data sets in formats like CSV. It’s ideal for regular data updates, such as updating product catalogs, customer lists, or inventory levels.

<img src="../../assets/images/import-export.png" width="550"/>

### Key Features

- **Data Types Supported**: Supports core entities, including _products_, _categories_, _customers_, _orders_, _media_, and _product variants_.
- **CSV Format**: Imports and exports use CSV files, making it easy to manage large data sets and prepare them with standard spreadsheet applications.

**Limitations and Considerations**:

- **Limited Complexity**: While the Import/Export handles basic entities, more complex data and transformations are not supported.
- **Field Mapping**: Import/export doesn’t support advanced field mapping by default, which can limit compatibility with some external systems. For complex needs, consider using 3rd party solutions.
- **Large File Constraints**: Large data files may need to be divided into smaller chunks to avoid timeouts and performance issues.

### Import Process

1. **Access the Import/Export Module**: Go to Settings > Import/Export in the Shopware Admin to access the module.
2. **Prepare the CSV File**: Ensure the data is structured to match Shopware’s required CSV format. Templates are available in the Import/Export module for each data type.
3. **Select Entity Type**: Choose the entity type you want to import, like products or categories, and upload the CSV file.
4. **Validate Data**: Shopware will validate the data during import to ensure there are no errors. Any issues will be highlighted in the import log.
5. **Review and Publish Data**: After import, review the data in Shopware to ensure it’s displaying correctly.

### Export Process

1. **Choose Data Type for Export**: In the Import/Export module, select the entity you want to export, such as products or orders.
2. **Define Filters** (Optional): Use filters to export only specific data sets (e.g., exporting only active products or orders from the last month).
3. **Download CSV**: Run the export and download the CSV file for external use, reporting, or backup.

Read more: [Import/Export](https://docs.shopware.com/en/shopware-en/settings/importexport).

## Known Limitations

While Shopware’s Import/Export Assistant is functional, it has limitations, especially for businesses with complex data or high-volume needs. Here are some common issues and how they can be managed:

### 1. Limited Field Mapping and Customization

- **Issue**: Shopware’s built-in import/export functionality has basic field mapping capabilities. This can make it challenging to map custom fields or attributes from external systems, especially when migrating complex data.
- **Solution**: For more advanced field mapping, consider using third-party plugins. This plugin allows you to configure complex mappings and handle custom fields more effectively.

### 2. File Size Constraints

- **Issue**: Shopware’s import/export tool may encounter issues with very large files, especially when handling thousands of product entries. This can lead to timeouts or incomplete imports.
- **Solution**: If you encounter file size limitations, try breaking down large files into smaller chunks and importing them sequentially.

### 3. Error Handling and Lack of Detailed Error Messages

- **Issue**: One limitation with the default import/export function is that error messages can sometimes be vague, making it difficult to identify and fix specific issues in data files.
- **Solution**: When importing data, ensure data consistency (e.g., correct field types, no missing fields) before starting. If errors occur, try testing with smaller datasets and review any Shopware documentation for field-specific requirements.

### 4. Limited Support for Complex Relationships

- **Issue**: Complex relationships, such as multi-dimensional product variants or advanced product configurations, can be difficult to manage with the built-in import/export tool, as it’s optimized for simpler, one-to-one data structures.
- **Solution**: For complex data relationships, using 3rd party solutions such as the Firebear Importer or custom-built import/export scripts may provide greater flexibility and control over relational data handling.

### 5. Data Inconsistencies During Migration

- **Issue**: Data inconsistencies can arise when migrating from older platforms, especially if those platforms use different schemas or naming conventions for attributes.
- **Solution**: Before importing, clean, and standardize data in a staging environment to align with Shopware’s schema. This can reduce the risk of inconsistencies in production. Test imports first to ensure data integrity.

### 6. Lack of Scheduling and Automation

- **Issue**: Shopware’s default import/export tool lacks native scheduling capabilities, making it less suitable for automated, recurring data imports and exports.
- **Solution**: Consider using third-party plugins, which offer scheduling options. Scheduling can be essential for businesses needing regular data synchronization with external systems.

### 7. API Rate Limits and Performance Impact

- **Issue**: Large imports can strain server resources, leading to performance impacts on the storefront, especially if conducted during peak usage hours. Additionally, API rate limits may restrict large data transfers.
- **Solution**: Schedule imports during low-traffic periods, and scale with server hardware adding a dedicated database server, and an extra webserver dedicated to imports and cronjobs.

## Best Practices for Data Import/Export

To ensure successful imports and exports in Shopware, keep the following best practices in mind:

- **Test in Staging First**: Always test data imports on a staging environment to identify potential issues and avoid production data disruptions.
- **Use Validated, Clean Data**: Standardize field formats and ensure no missing data or inconsistencies in source files.
- **Map Fields Carefully**: Align source fields with Shopware’s fields to avoid mismatches and ensure the imported data displays correctly.
- **Divide Large Files**: For large datasets, import in smaller batches if the default tool struggles with file size.
- **Regular Backups**: Create regular backups of your Shopware instance, especially before importing new data, to allow easy recovery if issues arise.