Migration data for Magento 2

Aug 6, 2020 Update
UB Data Migration Pro v3.2.4 here. Fully compatible with Magento 2.4.0.
Sept 20, 2018 Update: Check out the latest UB Data Migration Pro v3.1.6, with all-new dashboard UI. Fully compatible with Magento 2.2.6.
Oct 10, 2016 Update: A complete overhaul to UB Data Migration Pro v3.0.0 is now on air. It supports delta migration, PHP Memcached and fully ready for large-scale data migration.

Happy to announce that we have a new updated version for the free Data Migration Tool for Magento 2. We are following Magento 2 development very closely and accordingly have updated the Magento migration tool of ours.

If this is the first time you have come across this tool, then do read in detail about the features, which we have covered in our earlier blog post. Not only we have updated it to work with current version of Magento 2 but we have also focused on improvements and it is now more user-friendly than ever. This tool is under active development and we will keep working on it. Let me now brief you of the important changes in files and in tool’s configuration.

In this version we have fixed reported bugs, removed unnecessary files, added new files to the library.

Highlights of Version 0.1.19

Updates in script.js file.

Updates in gitignore file.

Fix for compatiblility with Magento2 Merchant -- beta 1.0.0

How to use :

To use this magento migration tool, follow the steps below.

Install Magento 2

Download the latest version of Magento2 from Github + Follow our Installation guide to Install Magento 2

# Configure the tool

1 -- Make a folder named “migrate_data_tool” in your web root. For example: PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool

+ Download the latest version of this tool : Magento 2 Data Migration Tool
+ Extract all files to the folder you have just created (migrate_data_tool)
+ Update write permission for folders at:

>>> PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool\assets
>>> PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool\protected\runtime

+ Update write permission for config file at:

>>> PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool\protected\config\config.php

# Step 1: Database Configure

Open your browser and type in the url to run this tool. For example: go to //localhost/migrate-data-tool/

Version: to select version of Magento
Database Server Host: identify the database server host name
Database Server UserName: identify the username of database server
Database Server Password: identify the password of database server
Table Prefix: identify the table prefix

# Step 2: Migrate Websites, Stores

# Step 3: Migrate Attributes

# Step 4: Migrate Categories

# Step 5: Migrate Products

# Step 6: Migrate Customers

# Step 7: Migrate Sales Data

# Step 8: Migrate Reviews and Ratings Data

# Step 9: Migrate Other Data

4. Complete the tasks below to finish the data migration process.

Re-save all the Attribute Sets (Product Template) migrated in the back-end of your Magento 2 website. (Open the attribute set, edit it if needed and click the save button). Open the command line window and go to the folder: PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento2_folder\dev\shell\ and type in the command line: php indexer.php reindexall then press enter key to re-index all data in your Magento 2 website.

5. Copy media files to complete migration:

+ Copy the folder at PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento1_folder\media\catalog and paste replace to PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento2_folder\pub\media\

+ Copy the folder at PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento1_folder\media\downloadable and paste replace to PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento2_folder\pub\media\

6. Now you can test the data which have been migrated into your Magento 2 website from the browser.

Download Magento 2 Migration Tool Crafts: Free Magento 2 Theme

More about Magento 2 :

Krishna

Hi,

In # Step 1: Database Configure I configured database details and clicked the “Save” button resulting in below error:

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database. The SQL statement executed was: UPDATE ‘ub_migrate_steps’ SET “id”=:yp0, “title”=:yp1, “code”=:yp2, “status”=:yp3, “migrated_data”=:yp4, “descriptions”=:yp5, “sorder”=:yp6 WHERE ‘ub_migrate_steps’.”id”=1

Please help me to resolve this.

Regards,
Krishnaprasad PB
- UberTheme
  
  Hi Disqus,
  
  Thank you for sending us your issue. The Database of this tool use the SQLLite file at path: protected/data/ub_tool.db
  That issue due to you don’t enable to write able for this database file.To solve that issue, let’s chmod 777 for the database file at protected/data/ub_tool.db( mean: Make write able permission for the database file)
  
  Anything else, Please us know.
  
  Regards,
  
  Ubertheme Team
  - Krishna
    
    Thank you. Now I am almost migrated all. But remaining is customer data. While migrating customer data I am getting below error.
    
    CDbCommand failed to execute the SQL statement: SQLSTATE[23000]:
    Integrity constraint violation: 1062 Duplicate entry ‘1’ for key
    ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_group`
    (`tax_class_id`, `customer_group_id`, `customer_group_code`) VALUES
    (:yp0, :yp1, :yp2)
    
    Please help me to solve this.
    - Antonio
      
      Hi, have you solved this issues?
      - UberTheme
        
        Hi Antonio,
        What version of this tool you are using?
        What versions of Magento 1 and Magento 2 in your working?
        Regards,
        
        UberTheme.
      - Antonio
        
        i’m used magento 1.8 to 2.0
        I have solved this issue truncate the table customer_group before to use ub migration tool.
      - Krishna
        
        no this issue is not resolved. now I am not using migrated part. Once I get new templated for magento 2.0 i will start fresh magento migration again
      - UberTheme
        
        Hi Guys,
        For technical question, it would be easier for us if you can post our forum (https://www.ubertheme.com/questions/), our team will follow up with you there.
        
        Regards,
        UberTheme.
      - Antonio
        
        You can solve this issues, truncate the table customer_group before to start customer migration.
      - Krishna
        
        Dear Antonio, Today Just now I have tried and the customer data migration was sucessfull. Thank you very much.
    - UberTheme
      
      Hi Krishna,
      What version of this tool you are using?
      What versions of Magento 1 and Magento 2 in your working?
      Regards,
      UberTheme.
      - Krishna
        
        I am using Magento 2
    - Joshua S
      
      What worked for me is add this to map under source.
      
      customer_group
      
      Then just export the SQL from that table once migration is complete and do a update IGNORE.
      
      I feel this is safer then trying to remove anything or truncate the table.
      - UberTheme
        
        Hi @disqus_KVrX9Hx7lP:disqus,
        
        Thanks for sharing the workaround.
        
        Actually, our UB Data Migration Pro has been updated with various bug fixes, so if Krishna uses our migration tool, he will not see the original issue as mentioned. Meanwhile, the workaround you proposed is more for Magento core migration tool instead.
        
        Regards,
        Ubertheme team
UberTheme

Hi all,

Just want to share a reference Magento resource:
Infographic – The ultimate comparison between Magento 1 and Magento 2 database structure
(Full size graphic): http://bit.ly/Magento-1-vs-Magento-2-database.

This comparison helps our internal development a lot. We think some of you might need to learn about the key changes in Magento 2 database structure as well, so we have formatted the data in the form of infographic. Hope you find it helpful.

Regards,
Ubertheme Team
kishanu

useful and valuable details you shared, thanks for the important blog post.
Vashishtha ServerGuy

Great tool
Custom migration tool was something many of our Magento hosting customers were looking for. Because many customers come to us for a faster loading website and dramatically awesome performance.
We will share this tool with them. Thanks a ton!
- UberTheme
  
  Thanks @VVashishtha ServerGuy for stoping by. Our free tool version is a bit outdated. We have a new UB Data Migration Pro version with a revamped codebase and enhanced feature sets here – http://bit.ly/ub-data-migration-pro.
  
  We believe our Pro version will definitely save pretty much time for your users. Many developers have been using our Pro version to complete their migration projects successfully, for instance – http://bit.ly/magento-2-data-migration-case-study or this one http://bit.ly/data-migration-casestudy
  
  Just want to add a few points in case you share our migration tool with your peers.
  
  Thanks,
  Ubertheme team
  - Vashishtha ServerGuy
    
    Yes, Please get in touch with me at [email protected]
    - UberTheme
      
      Yes, we’ve just sent you an email. Kindly check.
      Regards,
      Ubertheme team

Free Migration Tool for Magento 2 – updated

Highlights of Version 0.1.19

Updates in script.js file.

Updates in gitignore file.

Fix for compatiblility with Magento2 Merchant -- beta 1.0.0

How to use :

Install Magento 2

# Configure the tool

# Step 1: Database Configure

# Step 2: Migrate Websites, Stores

# Step 3: Migrate Attributes

# Step 4: Migrate Categories

# Step 5: Migrate Products

# Step 6: Migrate Customers

# Step 7: Migrate Sales Data

# Step 9: Migrate Other Data

4. Complete the tasks below to finish the data migration process.

5. Copy media files to complete migration:

6. Now you can test the data which have been migrated into your Magento 2 website from the browser.

More about Magento 2 :

Written By

Windig

Highlights of Version 0.1.19

Updates in script.js file.

Updates in gitignore file.

Fix for compatiblility with Magento2 Merchant -- beta 1.0.0

How to use :

Install Magento 2

# Configure the tool

# Step 1: Database Configure

# Step 2: Migrate Websites, Stores

# Step 3: Migrate Attributes

# Step 4: Migrate Categories

# Step 5: Migrate Products

# Step 6: Migrate Customers

# Step 7: Migrate Sales Data

# Step 9: Migrate Other Data

4. Complete the tasks below to finish the data migration process.

5. Copy media files to complete migration:

6. Now you can test the data which have been migrated into your Magento 2 website from the browser.

More about Magento 2 :

Written By

Windig

Further Reading

(M2) UB Data Migration Pro Extension Update – Version 3.2.7

UB Data Migration Pro 3.2.6 released with some important changes

How UB Data Migration Pro converts and migrates Configurable Products to Magento 2