Rating 4.5 stars - 4 votes

How to migrate all data from one installation/version of Magento or Adobe Commerce to another one

In a course of your business growing, there may occur a need to transfer Adobe Commerce / Magento site from one to another. So, when you may need to copy your store info?

  • when upgrading from older version to newer
  • when migrating to another host/server
  • transferring data to the different domain
  • moving from production/development copy of the site to live Adobe Commerce / Magento

Whatever the reasons for Adobe Commerce / Magento migration are, moving a functioning store is not the simple task and you may face various challenges while performing it. This article covers migration for: Adobe Commerce, Open Source, Magento 2 and Magento 1 versions.

Transfer all data: Where to Begin?

The most common way of data transfer is export and import procedures. Though if you have an extensive catalog of products with store-view specific data (with multiple attributes) and multi-layered category tree, this may be a pretty cumbersome task.

Important: Database backup / restore cannot be used to transfer data as different Adobe Commerce or Magento installations contains different settings, while different versions of the shopping cart will have different database structure. This way when restoring backup on the site that it was not made from, it will crash data and tables, and you will need to start installation, website configuration and migration from a scratch.

Peculiarities of Data Migration Via Adobe Commerce / Magento Admin

First of all, you need to have some of the entities prepared in the target store beforehand, such as:

  • Magento taxes;
  • payment and shipping methods;
  • established websites and storeviews;
  • extensions.

Secondly, you have to know that in default Adobe Commerce / Magento there is the possibility to import/export customers, products and stock sources only. This means that categories, attributes, custom options and orders cannot be exported.

So how to keep this neatly-created structure when moving data? You need to recreate the mentioned entities at your target store or find other means to move information.

So with admin panel you will have to do lots of manual work that includes:

  • Re-creation of attributes and assigning them to attribute sets in your target Magento one-by-one
  • Adding all the categories (the same category tree structure) in your target Magento.
  • Moving images from one server (directories) to another
  • Re-creation of products belonging to types that are not supported by default import if you have any (bundle, downloadable) and manually assign related products, cross and up-sells
  • Finding the way to move your orders info.

In addition, if you are moving the data between different Adobe / Magento versions you should be ready for difficulties caused by differences in database structures. Some of the database fields might be named differently in other Magento version, so these columns might not be recognized by import tool. Moreover, some of the fields may even be missing in other installation.

Thus, you might be interested in more flexible import/export tool that allows you to be able to map your file columns to databases fields and avoid manual work done.

Store Manager for Magento is exactly such a solution. It will help you to move Adobe / Magento website to a new Adobe / Magento without putting your site under maintenance and avoiding data loss.

You can perform the task FREE within 14-days trial period Transfer Data FREE

The tutorial can be applied to: Adobe Commerce, Open Source, Magento 2 and Magento 1 versions.

  1. Store's Backup and Copy
  2. Export Magento Store Data
  3. Import Magento Data

Step 1 - Store's Backup and Copy

It is always important to have backup. This is your guarantee that it is possible to roll back anytime. Thus, when you are moving between the Adobe/Magento installations, it is recommended to make backup of both of them.

Now you might tell, you have source store backup and you can use it to restore it over target store or copy-paste database tables.

Important: Database restore on a target store is not a good idea because Adobe/Magento versions differ in structure and some database tables may not be restored thus causing issues.

The correct process of performing the task would be to export the necessary data from old Adobe/Magento and import this data into the new Adobe/Magento database.

So, let’s see how to do this with Store Manager.

Step 2 - Adobe Commerce / Open Source / Magento Export Data

If you were selling products via Adobe/Magento store for considerable amount of time, then most likely you have custom attributes (of different types), created attribute sets, assigned to goods. This is complex structure filled with relations between the entities and there is no way to transfer it in default Adobe/Magento.

Thankfully, Store Manager software allows you to avoid the manual work. Here is how it you can export attribute sets together with attributes.

A) Export Attribute Sets Together With Attributes

In Store Manager go to Attributes section. Launch Attribute Sets Import/Export Wizard.

Launch Attribute Sets Import/Export Wizard.
How to Migrate from one Adobe / Magento store to another one

Export attributes and sets data to CSV and select directory at your PC where it can be saved.

select directory at your PC
How to Migrate from one Adobe / Magento store to another one

To move your data between the stores it is recommended to export all the attribute sets.

export all the attribute sets
How to Migrate from one Adobe / Magento store to another one

Detailed tutorial in attribute sets export you can read here -

B) Export Products (With Categories, Images and Related Details)

With Store Manager you can skip manual re-creation of categories and images moving, as you can simply export products with all related data.

Take into account! Due to the fact that export wizard allows to export full category path, there is no need to export categories separately from products.

In case you also have empty categories without products, you can also export category tree separately from products.

Check export categories tutorial -

Open Import/Export Products Wizard from product toolbar and select ‘Export’.

Open Import/Export Products Wizard from product toolbar and select ‘Export’
How to Migrate from one Adobe / Magento store to another one

Select directory where your file should be saved and proceed next.

Select directory
How to Migrate from one Adobe / Magento store to another one

At the next step you can choose what goods to export to the spreadsheet: all products or only certain ones (if you have filtered or selected some items before you ran import). To move the whole product category, select ‘All Products’.

To move the whole product category, select ‘All Products’
How to Migrate from one Adobe / Magento store to another one

Moving forward you will see configuration step. Here you can setup settings related to structuring of information in the output file, downloadable products and images.

Configuration step
How to Migrate from one Adobe / Magento store to another one

Useful tip on images! Select the setting to export full image path to have image URLs in your file and avoid manual images transferring.

*There is no need to tick the box to export images physically to your computer, since it might take long. Full image path will be more efficient in case you want to move data between the Magento installations.

After all the settings are set, you can move to the step where you can select what columns and info you will have in your result file.

You can select only necessary fields dragging them from left to right or use buttons in the middle. For example, you can skip ID field as you will not be able to keep IDs in new store. In case you are not sure what fields to include, export them all.

Select necessary fields
How to Migrate from one Adobe / Magento store to another one


To export multi-component products (configurable, grouped, bundle, downloadable) and product relations (cross, up-sells and related goods). So tick the boxes depending on items you have to export their associations.

Pressing ‘Export’ button will start the process and after a few seconds you will see the final step, where you can select whether you want to open file (or directory it is saved to) or just close the window.

Detailed export products guide -

C) Export Customers

If you want to move customers info, you can make use of built-in Import/Export profiles of Adobe/Magento. However, after in output CSV you will see very limited number of columns with info related to clients’ accounts.

With Store Manager for Adobe/Magento you have the ability to get more detailed spreadsheet with customers details.

So after you run and select Export Customers operation, you again need to select file location to be saved.

Select Export Customers operation
How to Migrate from one Adobe / Magento store to another one

Choose whether you want to export all the customers or only certain ones. For example you might want to transfer only active clients’ accounts - let’s say, those who registered less than year ago (and applied the filter in advance).

Select Customers to Export
How to Migrate from one Adobe / Magento store to another one

Similarly to previous wizard, you need to select file delimiters symbols for proper data organization in file.

Select file delimiters symbols
How to Migrate from one Adobe / Magento store to another one

With the same logics as on previous exports, you can select fields to be exported and even change columns position in result file.

select fields to be exported
How to Migrate from one Adobe / Magento store to another one

More detailed export guidance -

D) Export Orders

Going to Sales -> Orders section of Adobe / Magento back-end you will see option to export orders. Though, what info you can get using it? To tell the truth - limited, since there are available only those fields that you can see in the grid.

With Store Manager for Magento you can export more sales-related data in CSV file format: general order data, ordered items, billing and shipping data.

Select Fields to Export
How to Migrate from one Adobe / Magento store to another one

You can select orders info to be exported to CSV. The procedure is basically the same as was described for other export actions -

E) Export Shopping Cart Price Rules

Oftentimes, online stores are running some promotions, offering clients coupons. If you want to export Shopping Cart Price Rules and import promo codes into another instance of Magento, instead of re-creating them manually, Store Manager (ver.3.9.0 and higher) allows you to do this in a snap!

Export Shopping Cart Price Rules
How to Migrate from one Adobe / Magento store to another one

With a few simple clicks, you can bring your existing coupon codes along with their conditions and settings to CSV file.

Export Adobe / Magento Cart Price Rules CSV File
How to Migrate from one Adobe / Magento store to another one

Step 3 - Adobe Commerce / Open Source / Magento 2 Import Data

Now when we have all the necessary details in files, we can proceed to importing them. Upload also will be performed in logical order:

attribute sets -> products-> сustomers -> orders.

A) Import Attribute Sets with Attributes

As an option, you can first manually create attribute sets at new Adobe / Magento stores and further import products and assign them to necessary set via Store Manager.

Hope you already know how to run Import/Export Wizards if you have completed the steps mentioned above.

The difference is that you need to select ‘Import’ option at the beginning and follow the steps described below:

  • Choose the pre-saved file from the folder at your computer.

  • Choose pre-saved file from the folder at your computer
    How to Migrate from one Adobe / Magento store to another one

  • Indicate delimiters at the next step (they should be the same that you have used during export).

  • Indicate delimiters
    How to Migrate from one Adobe / Magento store to another one

  • Preview settings to see if the file was parsed properly.

  • Preview
    How to Migrate from one Adobe / Magento store to another one

  • Import option (update existing attributes)

In case you already have the attribute set(s) with the same attributes as you import, checking this option the attribute values from file will be added to existing ones.

Import attribute sets with attributes user guide you can view following this link -

Note: In Adobe / Magento 2, the 'Swatch' attribute belongs to system attributes and needs to be added to all attribute sets. Make sure that after the migration, the 'Swatch' attribute is listed in the Attribute sets. If the "Swatch" attribute is in the "Unassigned" list, you need to add it to all the attribute sets that you use in your store.

B) Import Products with Images, Categories and Other Details

As for other points above, we have separate user guide for products import -

We want to draw your attention to the most important options you need to set up transferring products data:

  • Select the file with product info you have previously exported.

  • Select the file
    How to Migrate from one Adobe / Magento store to another one

    There is the possibility to import spreadsheet saved locally at your PC or remote file using http or ftp link with access details to it.

    This might also be useful for your further inventory updates when suppliers provide you with URL to file at their site.

  • Import settings step is very important as it contains configurations for categories, images, downloadable products and file columns with multiple values.

  • Import settings step
    How to Migrate from one Adobe / Magento store to another one


    Here you need to indicate what symbols are used in your file to separate information within columns.

    The first options is for categories delimiters in case you have category path indicated in your file, the second - for images in media gallery and third one for fields containing multiple values (like related items, cross, upsells etc).

    Note, symbol for images and for multiple values columns should not coincide.

    Categories Settings:

    Use ID as category path is used in case your categories are already created in target Adobe / Magento.

    If you are importing from other Adobe / Magento installation this option should be unchecked, as your IDs will not match. In this case it is advisable to use category path.

    Keep current categories associations option is used in case the same goods as you import are already in database and via import you want to assign them to new categories indicated in the file.

    Downloadable products:

    If you are uploading downloadable products, check the box and specify directory where they are saved.

    Settings for Moving Images:

    Normalize name setting is always set by default as it helps to avoid issues in case your image title contains specific symbols.

    ‘Import images’ checkbox should be ticked in case you want to upload images.

    In our case, since we have in file full image URL exported, there is no need to choose ‘Local directory with images’.

    ‘Generate new image name’ option has been introduced due to the fact that new Adobe / Magento versions require unique image names.

    Note: The ‘Generate new image name’ option significantly slows down the upload procedure. If your image names are unique, you can skip it.

  • CSV columns mapping is very useful in case your database structures differ and you can link file columns to Adobe / Magento fields.

Assign .csv Columns to Database Fields
How to Migrate from one Adobe / Magento store to another one

Hint: You need to select field with unique identifier. In most cases this is SKU (or may be other field). ID cannot be used as we are importing new items for this database and product ids are auto-incremented.

C) Import Customers into Target Magento

As was already mentioned above, with Store Manager you have exported more info on clients’ accounts than is possible from Magento backend.

Now you can import the CSV to migrate users to new Magento.

Again, the process is very similar to previous ones -

At the assigning step you can also link csv columns to database fields and upload necessary info.

Assign .csv Columns to Database Fields
How to Migrate from one Adobe / Magento store to another one

Important: As for customers passwords, Adobe / Magento automatically converts plain text pass customer enters into a hash when it is saved. The ways of encoding are not the same in different installations, so unfortunately you will not be able to keep them in target Adobe / Magento. You can ask the customers to go through password recovery procedure.

D) Orders Import into Adobe Commerce / Open Source / Magento 2

Switching to other Magento store, one of the most difficult tasks is to import orders.

Starting from version 2.28.1 Store Manager is capable of performing this procedure like with all the entities mentioned above -

Note:If the original CSV file has been exported from one version of Adobe / Magento and now you are importing orders into Adobe Commerce / Open Source / Magento 2 store, you may experience compatibility issues (for example, with the order item_product_options or weee_tax_applied fields). We recommend contacting our support team following and our specialists will assist you with the import process.


If you are using Adobe Commerce / Magento Enterprise edition of Store Manager you can import orders together with customers accounts, so you can skip the previous step, unless you want also to import registered clients’ accounts without purchases.

Standard edition of Store Manager does not include import of orders.

Link .csv Columns to Database Fields
How to Migrate from one Adobe / Magento store to another one

D) Move Coupons Importing Adobe / Magento Cart Rules

The detailed instructions on how to migrate extensive list of Adobe / Magento coupon codes using Store Manager for Adobe / Magento (ver.3.9.0 and higher) are listed in the related article -

Assign .csv Columns to Database Fields

Last Stage

You are almost done. Now you need to test your website and see if the data are displayed correctly. Also make test product, customer and order and see if existing data were imported correctly.

Try copying Adobe / Magento 2 content from one store to another with Store Manager for Adobe / Magento for free Try FREE

That's it. Have a happy transfer!

Related Articles:

manage Adobe / magento multiple stores article

Manage Adobe / Magento Multi Stores Conveniently

Find out how to manage multiple stores from one place. Get guides on proper configuration of a store connection. Read More...

add different images to different magento store views tutorial

Add Different Images to Different Adobe / Magento Store Views

Find out how to add to export file group of fields with related information (ordered items, shipping details, billing details). Read More...

magento bulk product updates with multi editors tutorial

Adobe / Magento Tier Price Multi Editor for Massive Edits

Instructions on how to set up Magento tier prices for products in mass (in simple and advanced mode) and copy/paste them. Read More...

how to set multi lingual category tree in Adobe / magento 2 article

Set Multi-Lingual Category Tree in Adobe / Magento 2

Find out how to translae category data from the back-end or via Store Manager using the import tool. Read More...

Be the first to comment.
Live Chat