Migration process - Magento
What can be migrated?
Currently, you can migrate the following data:
- Shop features
- Category structure
- Reviews
- Manufacturer
- Customer data
- Address data
- Customer numbers
- Orders
- Products
- Product numbers
- Product master data
- One-dimensional variants
- Multidimensional variants
- Properties
- Article pictures
- Stock
The following data requires manual assignment during migration:
- Order status
- Payment methods
- Tax rates
This may make it necessary to create the corresponding data in Shopware in advance.
With Magento 2 this concerns additional data, as these are no longer available in the database and therefore cannot be taken into account during migration. This includes country, currency, and language assignments that are assigned in the sales channels.
Notes on some differences between Magento and Shopware
Magento-Attribute
All attributes are migrated except "manufacturer" and "cost".
Since Magento does not have a separate entity "manufacturer", the data will be taken from the attribute "manufacturer" if it is filled.
Magento 1-attributes are migrated to properties when:
- These were created by the user (no system attribute)
- whose setting "Use filter navigation on search results pages" is set to "Filterable (with results)" or the setting "Use to create configurable product" is set to "Yes
- Attributes are adopted as variant properties for variants if
- These were created by the user (no system attribute)
- The setting "Use to create configurable product" is set to "Yes"
Magento 2-attributes are migrated to properties when:
- These were created by the user (no system attribute)
- Their setting "Use filter navigation on search result pages" is set to "Filterbar (with results)" or the setting "Catalogue input type for shop owners" is set to "DropDown
- Attributes are taken as variant properties for the variants if
- These were created by the user (no system attribute)
- The setting "Catalogue input type for shop owners" on "DropDown" ist
Magento 1 and 2-attributes are migrated as custom fields if:
- These were created by the user (no system attribute)
Products
The following product types are migrated:
- Simple product
- Configurable product
- Configurable products in Magento are migrated to the "product container
- The Simple-Products attached to the configurable product are migrated as variants
- Downloadable product
Store-to-Sales channel Migration
Stores are migrated to sales channels, which are then assigned languages via shop views. If no shop view is available, the default language from Magento is used.
Media migration
The product/category media can be retrieved from the Magento database and can be migrated normally. However, since the CMS data is not listed in the database, migration is not possible at this point.
CrossSelling
Magento knows cross-selling, up-selling and related products. These are migrated as a single cross-selling group to Shopware 6.
OrdersOrders are migrated based on the delivery:
- If a delivery exists in Magento, it will be migrated with the status "Delivered" (or what was selected in the pre-mapping)
- If there is no delivery in Magento, an order is created with the status "Open" (or what was selected in the pre-mapping)
Prepare migration
Access to the Magento installation
For a successful migration it is necessary that the migration extension in the Shopware 6 installation has access to the Magento installation and the database. Only then can all media be migrated completely from the Magento shop directory.
extension installation
Once you have successfully installed Shopware 6 on your server, you can begin migrating your Magento Shop. For this you need the extension SwagMigrationAssistant for Shopware 6, which you can get from the Community Store.
After you have purchased the extension in the store for free, you can install it in the Shopware Administration under Settings > extensions.
If the extension is not yet displayed here, check whether you are logged in to Shopware 6 Admin with the same Shopware account as in the Shopware Community Store.
Set up shipping and payment methods
In the course of the migration it will be necessary to manually assign the shipping costs and payment methods from Magento to the Shopware 6 shipping and payment methods, as these cannot be migrated automatically.
We therefore recommend that you create these in the Shopware Admin before the migration. You can find out in detail how to do this here:
Shipping
Payment methods
Establish connection
To migrate your data from Magento to your Shopware 6 shop, you must first connect your Shopware 6 installation to the database of your Magento shop. You start this in Shopware 6 Administration under the menu item Settings > extensions > Migration assistant.
Once this connection to your Magento database has been established, you can migrate data from your Magento shop at any time.
Your Magento Shop will not be changed until your Shopware 6 Shop goes live and will run until then. You can also migrate subsequent changes to your Magento data at any time.
You start the migration process by clicking the Start button.
In the first step you will be shown which profiles are available for the migration. Profiles for Shopware 5 are already pre-installed. To migrate your Magento Shop, you can install the profile for Magento 1.9 here.
After installing the profile, simply click Continue.
In the step Migration - Create connection you now enter the following important information:
Connection Name: Here you first enter a unique name for the connection. This is especially necessary if you want to establish a connection to several shops.
Profile: Describes the type of source system. To migrate your Magento installation, select magento19 here.
Gateway: Describes the type of connection between the two systems. For the migration from a Magento shop you can use Local here.
Edit connection
The next step is to specify the Magento database you want to migrate from. This database is generally read only. No changes will be made there.
Host: Enter the Host URL of your database here. If the database is installed on the same server, you can also enter localhost here.
Port: Enter the default port of your database here. Usually this is 3306 by default.
Username: Enter a database user with administration rights here.
Password: Enter here the password for the database user specified above.
Database name: Here you enter the database name of the database which contains the data of your Magento installation.
Migrate media via download: Activate this option if the media path of the source system is not locally accessible through the migration wizard. You then have the option to specify an external source system url from which the product images should be downloaded.
Shop installation folder: This field is available if you have not checked the option migrate media by download. Enter the absolute path to the directory where Magento was installed. This is necessary because some media are only stored locally in the Magento directory and not in the database.
Source system url: This field is available if you have enabled the option Migrate media via download. Enter the URL to the source system from which the product images are to be downloaded and then migrated.
Database table prefix: In Magento you had the possibility to set a global prefix before the database tables. If you did, enter this prefix here.
When you have finished, click on Connect to establish a connection to the specified database.
It is important to enter the exact and complete path to the Magento installation in the area Shop installation folder and Source system Url, otherwise problems may occur during the migration of the product images.
Modify Meta Data
As part of the migration, some metadata will be truncated as the database dyp will change from mediumtext to varchar(255). These values will therefore be truncated after 255 characters.
The following values are affected:
| table | column |
| s_article | description |
| s_categories | metadescription metakeywords |
Check migration data
After you have entered all the necessary details of your connection, you will be redirected to the migration overview. Here you have an overview of the current connection, can choose which data will be migrated and track your previous migrations.
Overview
After you have successfully established the connection, you will automatically be taken to the migration overview. Here you can see which system profile was used, when the last connection check was performed and when the last migration was performed with this connection.
You can make changes to the current connection via the Edit connection button. Via the context menu next to the connection you can create a new connection to another shop, delete the access data of the current connection or change the overview to another already created connection.
Data selection
In the data selection you decide which data you want to migrate from your connection to the Shopware 6 Shop. To do this, simply tick the box for the data you want to migrate. By clicking on the question mark symbol you can see exactly how much data will be migrated.
History
In the history you have the possibility to view all previous migrations and migration attempts. The context menu on the right shows you all information about the migrations.
Perform the migration
During the migration process, it is important that the tab in which the migration was started remains open until the migration is completed, otherwise migration may be interrupted.
After you have clicked on Start Migration, the migration is performed in four steps. Review, Read, Write and Media Download.
Nach dem Du auf Migration starten geklickt hast, wird die Migration in vier Schritten durchgeführt. Prüfen, Lesen, Schreiben und dem Medien Download.
Checking
The migration now performs a check. The system checks whether the data from the old shop can be assigned to the new shop.
Manual assignment:
Some data such as payment methods, shipping methods or tax rates are not transferred automatically. These should first be created in Shopware 6 Administration. In this step you can then manually assign them to the respective Shopware counterpart.
As soon as you have manually assigned all not automatically assigned data, you can continue the migration by clicking the Continue button.
Performed assignments:
In the assignments you can check whether the automatically assigned data have been correctly assigned. Here you can also change your allocations later or change the automatic allocations later.
Reading
In this step, all data to be migrated is read from the Magento database. In addition, if you have specified a correct path to a Magento shop installation, the local data of the shop will also be read. All read data is given a checksum, which is used during later migrations to check whether the data has been migrated before. All unchanged data is therefore not migrated again.
If it happens that data is not migrated although it has changed, the checksums can be reset. You can find out more about this in the section Perform migration again.
Writing
The read data is now written in Shopware 6. In this step, customer groups, categories, languages, currencies and sales channels are automatically created in Shopware 6 if they do not already exist.
Media download
In this step, all media files from the Magento installation are downloaded and loaded into the Shopware 6 Media Manager.
Ready
As soon as the migration is completed, you can return to the overview page of the current connection via the button Go to overview.
Repeat migration
If data in your Magento Shop still changes after your migration, you can repeat the migration process at any time. Simply select the data you want to migrate again under Data selection and then click on Start migration again in the upper left corner.
All changed values will be transferred again.
Perform migration again
If data in your Magento Shop changes after your migration, you can repeat the migration process at any time. Just select the data you want to migrate under Data Selection and then click on Start Migration in the upper left corner again.
All changed values will then be transferred again.
You can repeat the migration as often as you like. At the first migration all migrated data will get a checksum. Based on this checksum, the migration wizard recognizes whether data needs to be migrated or not. This prevents data from being migrated twice and possibly overwritten.
If you want to perform a complete migration again so that all data in the target system is overwritten, you can reset the checksums. You can do this in the migration overview in the shop system area using the drop-down menu.
