Magento 2: Data Migration Tool

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 an absolutely revamped dashboard UI. Fully compatible with Magento 2.2.6. It supports delta migration, Command-line Interface, PHP Memcached and fully ready for large-scale data migration.
May 17, 2016 Update:
We decided to upgrade our free migration tool to a premium version — UB Data Migration Pro to provide a better, stable and more feature-rich solution for Magento 2 migration. Check out this 9-minute video to learn more about how this new migration tool can help with Magento 2 migration.

Magento 2 migration from Magento 1.x would soon be requirred as the current Magento 2 beta version eventually leads to a stable version. We have developed a free tool to help you take care of the migration and we have covered the whole process with easy to follow steps with screenshots and codes. The tool will be updated and improved as we get more feedback. Moving to the latest version will obviously be beneficial for most Magento users. The data migration may be troublesome for new users, but no worries I am sure this blog post would be of help for you and you can also follow our earlier blog post series on Magento 2 structure and benefits. Here is what we’ve learnt about Magento 2 beta’s new structure so far.

Key changes in the database structures.

Magento 2 Migration Data Tool

Changes in tables.

+ Name change for some tables

Magento 2 Migration Data Tool

+ Change of Attributes

Magento 2 Migration Data Tool

Our plan for the Magento 2 Migration tool

This upcoming Magento 2 migration tool will help to transfer your database from older versions to the latest Magento 2 in some simple steps. Our aim is to make it the most handy as possible.

Here are what the tool will help to migrate.

Magento 2 Migration Data Tool

In this post, we are standing at process 1 To use this migration tool, follow the steps below.

# Pre-condition: Install Magento 2

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

# Step 1: 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

Magento 2 Migration Data Tool

+ Download the latest version of this tool at Magento 2 Data Migration
+ Extract all source code from downloaded file to the folder you have just created (migrate_data_tool)
+ Make writeable 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

+ Make writeable permission for config file at:

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

# Step 2: Run this tool

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

Magento 2 Migration Data Tool

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

# Step 3: Follow step by step to migrate data

Follow step by step to migrate needed Data from Magento 1 website to Magento2 website.

Magento 2 Migration Data Tool

# Step 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.

Magento 2 Migration Data Tool

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\

# Step 5: 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 :

Written By

Biz & Operations Ubertheme.com & Joomlart.com

Comments
  • Ashutosh Pandey

    I downloaded the the database migration tool but could not find “runtime” file in the “protected” folder. Please have a look.

  • Jacco

    I seem to encounter the same problem. Even chmod -R 777 does not change this error

    • Can you show me more detail about the issue as you said? (any screenshot?)

  • Sampathi Ramakrishna

    Hi,
    again i got the error at step 3..like below image …please give the solution for this.its urgent for me

    Thanks,
    RamSampathi

  • Mikesh

    When I migrate the articles I get a Gaitway Timeout Error. The script runs about 10 minutes. We have 3000+ articles in our magento 1.x Shop.

  • zarana Patel

    Hello,

    I reached till “Step 9: Migrate Other Data”, What I need to do next to complete migration process?

    Please help me as soon as possible.

    Thanks.

  • sachin

    Hello I am getting below error:

    CDbConnection failed to open the DB connection: could not find driver

    • Hi sachin,
      This tool use the Sqlite, let’s enable the php Sqlite in your web server to solve the issue.
      Best,
      UberTheme.

  • David Sbardella

    On step 1 I get:

    Error 500

    include(Mage1WebsitePeer.php): failed to open stream: No such file or directory

    • Hi David Sbardella,

      Let’s share me more information about your working. What version of this tool you are using?

      Where is the source code of this tool you are downloaded?

      That issue because the source code of this tool in your working missing the php Class ”Mage1WebsitePeer.php’

      Let’s update the latest code of this tool at https://github.com/ubertheme/magento2_data_migration

      Best,
      UberTheme

  • Huỳnh Ngọc Hòa

    When i migrate to step 9 …error ” Undefined variable: migrated_tax_ids”
    http://pasteboard.co/ociU5XC.png
    Can you help me? pls.

    Thanks 🙂

  • Uruselfei

    Can’t even start tool, getting Internal Server Error 500. it says (in error log) –

    /path_to_web/tool/.htaccess: Invalid command ‘IndexIgnore’, perhaps misspelled or defined by a module not included in the server configuration
    PHP Fatal error: require(): Failed opening required ‘/path_to_web/app/bootstrap.php’

    Tool itself placed to /path_to_web/tool/. seems that there’s some problem with paths. all modules are installed correclty

    tool version: 0.1.24

    • Hi Uruselfei,
      Seem issues come from the configuration in your web server.
      You should follow exactly the steps in guide to use this tool at https://github.com/ubertheme/module-ubdatamigration

      Best,
      UberTheme

      • Uruselfei

        Thanks! this helped. I was following some other installation instructions where it was needed to download package from GitHub and start in manually as external script.

        now i can see this module inside Magento20 admin, but now i’m having CDbException:

        CDbConnection failed to open the DB connection: could not find driver
        /path_to_magento/pub/ub-tool/yii/db/CDbConnection.php(399)

        anything else should be installed?

        • Uruselfei:
          This tool use the Sqlite, let’s enable the php Sqlite in your web server to solve the issue.
          Best,
          UberTheme.

          • Uruselfei

            thanks, this really helped! but now – next trouble 🙂
            CDbException while migrating discount rules.

            The table “{{salesrule_website}}” for active record class “Mage1SalesruleWebsite” cannot be found in the database.

            /path_to_web/pub/ub-tool/yii/db/ar/CActiveRecord.php(2385)

            can’t check which step it was (probably 5 or 6), because all i get when trying to connect to my Magento2.0 is

            Exception printing is disabled by default for security reasons.
            Error log record number: 942534845069

          • Hi Uruselfei,
            Does your Magento 1 website working fine now?
            That issue because your Magento1’s database is missing the table ‘salesrule_website’.
            What version of Magento 1 in your working?

          • Uruselfei

            yes, my current (1.6.1.0) Magento is working OK. in attached picture you can see my setup. Actually, only 2 WebSites are in real production: Interval (www.interval.ee – 2 languages) and Nature4You (www.nature4you.eu – 1 language). Others are “placeholders” for future projects.

            ‘salesrule_website’ table is really missing. can it help if i create this table manually? if yes, can you help me with structure and possible data, please?

          • Hi,
            Can you upgrade your Magento 1 to 1.7.x or later?

          • Uruselfei

            unfortunately – not. i was trying several limes with different tools/techniques/manually/etc, but… that’s why your tool was my “last hope” to be up to date.

          • So, let’s try run this SQL in Magento1 database, and restart with this tool.

            CREATE TABLE IF NOT EXISTS `salesrule_website` (

            `rule_id` int(10) unsigned NOT NULL COMMENT ‘Rule Id’,

            `website_id` smallint(5) unsigned NOT NULL COMMENT ‘Website Id’,

            PRIMARY KEY (`rule_id`,`website_id`),

            KEY `IDX_SALESRULE_WEBSITE_RULE_ID` (`rule_id`),

            KEY `IDX_SALESRULE_WEBSITE_WEBSITE_ID` (`website_id`)

            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Sales Rules To Websites Relations’;

            and tell me know how it goes.

          • Uruselfei

            can i “roll back” last step some how? don’t know which number it was 🙂
            or i should re-install Magento2 and run tool from the beginning? why I am asking – my current Magento2 (both frontend and backend) is completely “dead” with error

            a:4:{i:0;s:40:”More than one default website is defined”;i:1;s:3118:”#0 /path_to_magento20/vendor/magento/module-store/Model/StoreManager.php(239): MagentoStoreModelWebsiteRepository->getDefault()

          • Hi Uruslfei,
            You can use this URL to reset all migrate steps:
            http://YOUR_MAGENTO2/pub/ub-tool/index.php/migrate/resetAll

            and you can restart with this tool.

            Do it and tell men know how it goes.

            Regards,
            UberTheme

          • Uruselfei

            hi!

            so, after creating table, tool reset and restart i have got new error (at least not Error 500 :))

            and this happened during sales data transfer step

          • Hi Uruselfei:
            That because the database of your Magento 1 has some bad data with field named ‘store_name’ in sales_order table and it isn’t accepted in new rules of Magento 2.
            In this case, you have to find and manual update this data in database of your Magento 1.
            and then, you can restart this step with this tool.

            Also, please note that:
            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.

          • Ed9arBorges

            I correct this problem in table store_website there can only be one is_default set to 1

          • @ed9arborges:disqus:
            Thank for your working around with this tool.
            Can you show me more detail about your working?

          • Yes, let’s re-install the Magento 2 and re-try with this tool one more.
            Also, can you share me the dump of your Magento 1 database?
            Regards,
            UberTheme.

  • Bhargav

    I m getting below error. Please reply.

    • Hi
      Let’s create a folder with named ‘runtime’ at path ‘protected/runtime’
      and make write permission for this folder and tell me know how it goes.
      Regards,
      UberTheme

  • Vijay

    Hi,
    I have latest downloaded Data Migration tool zip from github( https://github.com/ubertheme/magento2_data_migration/releases/tag/v0.1.24 ) and then extract all source “migrate-data-tool” folder in wamp root directory (wamp/www/migrate-data-tool) after then I have run this in browser(http://127.0.0.1/migrate-data-tool/) but getting error “Application runtime path
    “D:wampwwwmigrate-data-toolprotectedruntime” is not valid. Please
    make sure it is a directory writable by the Web server process.”.Please see attachment

    I am using WampServer2.5 and I have applied full permission of “migrate-data-tool” folder.
    Also I have not seen below file or folder in this tool
    1) migrate-data-toolasset
    2) migrate-data-toolprotectedruntime
    Please see attachment

    Can please help me?
    Thanks

  • Vijay

    Hi,
    When I migrate “Step 3: Migrate Attributes” getting error
    Can you please help me?

    Thanks

    • Hi Vijay,
      Does your Magento 2 database is a fresh installation before you use this tool?
      Regards,

      UberTheme.

  • vlspro

    Hello,

    I have used the migration tool.

    But i get diverends errors. See the list below.
    Is there anybody who can help my white these errors.

    CDbException

    The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.

    /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/db/ar/CActiveRecord.php(2385)

    2373
    2374 /**
    2375 * Constructor.
    2376 * @param CActiveRecord $model the model instance
    2377 * @throws CDbException if specified table for active record class cannot be found in the database
    2378 */
    2379 public function __construct($model)
    2380 {
    2381 $this->_modelClassName=get_class($model);
    2382
    2383 $tableName=$model->tableName();
    2384 if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null)
    2385 throw new CDbException(Yii::t(‘yii’,’The table “{table}” for active record class “{class}” cannot be found in the database.’,
    2386 array(‘{class}’=>$this->_modelClassName,'{table}’=>$tableName)));
    2387
    2388 if(($modelPk=$model->primaryKey())!==null || $table->primaryKey===null)
    2389 {
    2390 $table->primaryKey=$modelPk;
    2391 if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey]))
    2392 $table->columns[$table->primaryKey]->isPrimaryKey=true;
    2393 elseif(is_array($table->primaryKey))
    2394 {
    2395 foreach($table->primaryKey as $name)
    2396 {
    2397 if(isset($table->columns[$name]))

    Stack Trace#0+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->__construct(Mage1Website)

    #1+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/db/ar/CActiveRecord.php(661): CActiveRecord->getMetaData()

    #2+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/db/ar/CActiveRecord.php(1355): CActiveRecord->getTableSchema()

    #3+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/db/ar/CActiveRecord.php(1475): CActiveRecord->query(CDbCriteria, true)

    #4– /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/protected/controllers/MigrateController.php(237): CActiveRecord->findAll(“code ‘admin'”)

    232 //variables to log
    233 $migrated_website_ids = $migrated_store_group_ids = $migrated_store_ids = array();
    234
    235 //Get list front-end websites from magento1
    236 $condition = “code ‘admin'”;
    237 $websites = Mage1Website::model()->findAll($condition);
    238
    239 if (Yii::app()->request->isPostRequest && $step->status == MigrateSteps::STATUS_NOT_DONE){
    240
    241 //uncheck foreign key
    242 Yii::app()->mage2->createCommand(“SET FOREIGN_KEY_CHECKS=0”)->execute();
    #5+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/web/actions/CInlineAction.php(49): MigrateController->actionStep2()

    #6+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/web/CController.php(308): CInlineAction->runWithParams(array())

    #7+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/web/CController.php(286): CController->runAction(CInlineAction)

    #8+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array())

    #9+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/web/CWebApplication.php(282): CController->run(“step2”)

    #10+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/web/CWebApplication.php(141): CWebApplication->runController(“migrate/step2”)

    #11+ /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/yii/base/CApplication.php(184): CWebApplication->processRequest()

    #12– /home/jmligh1q/public_html/migrate-data-tool/magento2_data_migration-0.1.25/index.php(13): CApplication->run()

    08
    09 //remove the following line when in production mode
    10 defined(‘YII_DEBUG’) or define(‘YII_DEBUG’, true);
    11
    12 require_once($yii);
    13 Yii::createWebApplication($config)->run();

    2016-01-19 20:19:38 Apache/2.4.16 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Yii Framework/1.1.16

  • milan patel

    Step 5 product migration taken time 1 day whole continues loading but not completed.total 2500 products. plz reply ASAP.

  • milan patel

    The table “{{tax_class}}” for active record class “Mage1TaxClass” cannot be found in the database. in step 6 customer migrate..

    • Hi milan patel,
      Thank you working around with this tool.
      Let’s share me, what versions of the Magento 1 and Magento 2 in your working?
      What version of this tool you are using?
      Does your Magento 1 database working fine?
      Regards,
      Mall.

  • Attila Naghi

    Hi !! I got this notice message “Before migrate the Sales Invoices, you have to migrate the Sales Orders first.” I already migrate first the sales order first, but it still showing me this message. Please see the img . What should I do ?

    • Glad that you have worked around our migration tool.
      Let’s fress ‘Reset’ button and click ‘Select all’ -> click ‘Start’ button again.

      Please note that:
      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,
      Mall.

  • nht48823

    just migrated the data, all seem to go well, however data was not migrated. my new db there is nothing there. I have this tool installed in my root. the magento 2 is also install in my root my first attempt all went well. now i have a new installation under my root./magento2/magento2/ when i did the migration it says all completed but there is no data migrated to my new installation/DB. does this tool need to be under the root./magento2/magento2/ or i can use the root installation i already have?

    • Hi nht48823,
      Glad that you have worked around our migration tool.
      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,
      Mall.

  • Jm Cabugnason

    Hello good day, the next button after completing step 7 didn’t show up. Any one can help me with this issue?
    Thank you.

  • Prathap Kumar

    When I run the tool (localhost/migrate-data-tool/ )
    I am getting following error.
    CDbConnection failed to open the DB connection: could not find driver

    How can i fix it? Please help me

    • Ittigorn Tradussadee

      :: Found this down the threads here, posted by UberTheme

      I was having the same problem and this solution worked for me.

      “This tool use the Sqlite, let’s enable the php Sqlite in your web server to solve the issue.
      Best,”

      If you’re using Ubuntu like me then you can search for PHP packages and install the right one for your current version of PHP.
      Mine is sudo apt-get install php7.0-sqlite3

      • Hi @ittigorntradussadee:disqus and @disqus_MKxULVnwGy:disqus,

        Glad the workaround helps.

        Anyway, as mentioned in our afore-mentioned comment, we no longer maintain the old migration tool on Github, and replace it with newer versions: UB Data Migration Pro and UB Data Migration Lite (free). You will find new feature enhancements in these releases.

        Please take this into consideration in case you have new migration project next time.

        PS. Check out this 9 minutes video to get a closer look into how our new migration tool works – https://youtu.be/Jvr8d3OeB8M

        Sincerely,
        Ubertheme Team

        • Ittigorn Tradussadee

          Thank you Ubertheme team for clarifying that.

          I forgot to mention that I was using UB migration tool (lite) that I have downloaded today and ran into this problem on my Ubuntu 16.04 so went searching around for an answer. This thread came up along with other things.

          I don’t know if it’s weird or not that I still get this problem although I didn’t use the version published in github but the solution posted here before actually worked.

          Anyway, thanks 🙂

  • Hi All,

    After a long time we optimise the code base and enhance new features, today our team is excited to announce our newly launched UB Data Migration Pro.

    If you have any Magento 2 migration project in place, UB Data Migration Pro will be a good starting point and save you tons of work. Have a closer look into this module via: https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro

    PS. For any question or concern about this migration tool, feel free to head over to our Help desk – http://www.ubertheme.com/questions, our team are happy to help you out.

    Sincerely,

    Ubertheme team

  • Hi al,

    Our team has just created a new infographic – The ultimate comparison between Magento 1 and Magento 2 database structure – http://bit.ly/Magento-1-vs-Magento-2-database.

    Hope that this comparison can help anyone new to Magento 2 become familiar with the key changes in Magento 2.

    Regards,
    Ubertheme Team

  • Abhishek Modi

    Hi,
    Import was successful, I can see all the products and categories in admin panel. But I can not see any product on website frontend on any of the category pages.

    • Hi @disqus_2SPM5OJTIN:disqus
      We wonder whether you did use our old migration tool instance on Github? If that is the case, it’s hard to confirm on the root of issue, as this version was not maintained for long.
      As you might notice we have replaced such old script with a newer version – UB Data Migration Pro: https://www.ubertheme.com/magento-news/magento-2-data-migration-pro-release/
      Thanks,
      Ubertheme team

      • Abhishek Modi

        Thanks a lot reply. Yes I might be using the older version, can you please let us know what all are the major changes in the new version?

        • Hi @disqus_2SPM5OJTIN:disqus
          The features are still based on our old script frame, however we keep ongoing incremental development, in particular bug-fixes and optimization. This is crucial as we had chance to fix issues from specific use cases, as well as test compatibility with Magento CE.
          For now, UB Data Migration Pro is fully compatible with the Magento CE2.1.0.
          Regards,
          Ubertheme team

  • Thanks very util 🙂

  • Hi friends,

    Have you heard of our recent big update to UB Data Migration Pro (V3) – http://bit.ly/ub-data-migration-v3?

    The V3 is a complete overhaul, compared to its previous releases. We restructured the workflow, simplified the setting steps into pre-migration group; It’s ready for large-scale data migration; it enables delta migration, supports PHP Memcached and much more.

    Hope you like the new V3.

    PS. We’re working on a new tutorial video for this V3 release, expect to have it ready next few days.

    Regards,
    Ubertheme team

  • Girija

    After data migration my Magento 2 site frontend and admin is not showing.its always loading.

    • Hi @disqus_AhDaX32x84:disqus,

      We wonder which migration tool version you’re using. If you use our old script distributed on Github, we’re afraid such version is no longer maintained, and has been replaced with a newer tool – UB Data Migration Pro http://bit.ly/ub-data-migration-v3

      Regards,
      Ubertheme team

      • Girija

        Sounds good. but am Sorry. I have used older version , Its was working fine. but, after i have migrated database, my category and products not showed in frontend, but thank you. Also can u give any ideas for theme migration.

        • Hi @disqus_AhDaX32x84:disqus,

          Our old script was initially developed based on the early Magento release, so it missed a lot of bug fixes and improvements, compared to our UB Data Migration Pro version (especially our latest V3 version).
          Hope for your understanding.

          PS. Theme and extension integration is a separated task that should be handled at your end. Our migration tool focuses on the data migration only.

          Regards,
          Ubertheme team

  • dedar singh

    Hi i have around 20000+ customers how i can migrate them in chunks.Because while migrating users it takes lots of time.i was uploading from last 4 days not uploaded yet.. 🙁

    Please Help

    • Hi @dedarsingh:disqus,

      It seems you’re using our old script. We’ve a newer Pro version – https://www.ubertheme.com/magento2/ub-data-migration-pro-v3/ which supports delta migration, command-line interface, php memcache … The Pro V3 codebase is fully revamped and enhanced for large data migration.

      We used this Pro V3 ourself to help Winetasting.com migrate nearly 400,000 customer entities successfully. You can check out this case study to see for yourself – https://www.ubertheme.com/magento2/case-study-winetasting-migrate-customer-entities-to-magento-2/

      Regards,
      Ubertheme team

      • dedar singh

        Does it not possible in free version to migrate large data..

        • The free version used old codebase which is not ready for large data.

          Further, if not to mention new advanced features like delta migration, command-line interface and so on, the old free script was not updated with various incremental bug fixes and optimizations in our Pro version.

          Sincerely,
          Ubertheme team

        • Hi @dedarsingh:disqus,

          Sorry we missed your message somehow.
          Not only the limit in data volume, the old script was not optimized and resolved with many bug fixes we applied to our Pro version.

          Regards,
          Ubertheme team

  • Rulfo Flanagan

    The table “{{tax_class}}” for active record class “Mage1TaxClass” cannot be found in the database.

    I get this error in step 6 of migration process from Magento 1.7.2 to 2.0.11

    pubub-toolyiidbarCActiveRecord.php(2385)
    2385 throw new CDbException(Yii::t(‘yii’,’The table “{table}” for active record class “{class}” cannot be found in the database.’,

    pubub-toolprotectedcontrollersMigrateController.php(1821): CActiveRecord->findByPk(“3”)
    1821 $tax_class1 = Mage1TaxClass::model()->findByPk($customer_group2->tax_class_id);

    Could anyone help, please?

    Thanks in advance

    • Hi @Rulfo Flanagan,

      It seems you’re using our old migration tool instance on Github. This version was not maintained for long and was replaced with a newer version – UB Data Migration Pro: https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro/

      The current version Pro v.3 is a complete overhaul with revamped code base, plus completely new features like delta migration, command-line interface etc.,

      For additional technical question about our migration tool, kindly submit a ticket via our helpdesk https://www.ubertheme.com/questions, we will follow up further.

      Thanks,
      Ubertheme team

  • Chaw Tz Maung

    Hi Friends, Can you give me a favor? Data migration is successfully done UberTheme however, data can’t be load in admin panel and customer login function also doesn’t work. Please give me a hand. Thanks in advance.

    • Hi @Chaw Tz Maung,

      It seems you did use our old script on Github? If that’s the case, it’s pity that we no longer maintain such version. Please consider to move forward with our Pro version to take advantage of various updates (with bug fixes) and brand new features like Delta migration etc.

      Thanks for your understanding.

      Regards,
      Ubertheme team

      • Chaw Tz Maung

        Thanks for your kindly response. I’d like ask one more question. I’m thinking to buy Pro version. In case extension doesn’t work, is there insurance for refund and if it is, will get back fully or half. Thanks.
        Looking forward to hearing from you.

        • Hi @Chaw Tz Maung,

          We do have 7 Days Money Back Guarantee. If there appears issues from our migration tool that prevents you from completing data migration, we will proceed full refund to you.

          Actually, in recent projects that users used our tool, some issues arise, mostly from the server side or the database issue itself (non-standard Magento 1 database etc.,). However, our team help resolve all such issues successfully.

          PS. Please note our migration tool is available for Magento CE only.

          Sincerely,
          Ubertheme team

          • Chaw Tz Maung

            Thanks for your quick response. We’ll inform you once order is confirmed.

          • Hi Chaw Tz Maung,

            You’re welcome. For any technical question you might have, please submit a ticket via our helpdesk at https://www.ubertheme.com/question, we will help you out.

            Regards,
            Ubertheme team

          • Chaw Tz Maung

            Let me ask you one more question. Is this Pro version is eligible for multiple domains? And do you have any discount? Thank.

          • Hi Chaw Tz Maung,

            Our Pro version grants you license to use on one Magento instance only. You will need additional purchase for each new extra Magento instance. We have discount for multiple purchases though.

            Please reach us via info (at) ubertheme.com if need further clarification on the license or multiple purchase discount.

            Regards,
            Ubertheme team

        • Hi Chaw,

          You can take a look at our recent successful migration projects to learn more about our Pro version:

          – We did use the Pro version ourself to help Winetasting.com – Migrate 382,047 customer entities to Magento 2 – https://www.ubertheme.com/magento2/case-study-winetasting-migrate-customer-entities-to-magento-2/

          – And this case study as well – Freelaunch.nl used UB Data Migration Pro to migrate 230,000 products to Magento 2 – https://www.ubertheme.com/magento2/data-migration-230000-products/

          Hope that helps.

          Regards,
          Ubertheme team

  • Juliano Vargas

    HI UberTheme.

    First Thank’s for the great free source tool provided by UBTheme.
    Second I have sightly issue in the last step follow the error.
    Property “Mage2Catalogrule.sub_is_enable” is not defined.
    magento2_data_migration-0.1.25/yii/db/ar/CActiveRecord.php(145)

    I not sure where to start or what to do next would you please guide me to the right direction thank you.

    • Hi @Juliano Vargas,

      Thanks for spending time working with our migration tool.

      It’s pity that we no longer maintain the old script on our Github and replaced with a newer version – UB Data Migration Pro.

      We know you might concern why we refer you to our Pro version instead of the free one. Actually, it took us huge resources to update our Pro version to this stage, with brand new feature like Delta Migration, Command-line Interface etc., So moving forward with the Pro version will save you pretty much time.

      If you want to learn more about our Pro version, this Tutorial video will help: https://youtu.be/R4UBLe2kf-I (including delta migration steps)

      Further, you can take a look at recent data migration case studies:
      – We did use the Pro version ourself to help Winetasting.com – Migrate 382,047 customer entities to Magento 2: https://www.ubertheme.com/magento2/case-study-winetasting-migrate-customer-entities-to-magento-2/
      – And this case study as well – Freelaunch.nl used UB Data Migration Pro to migrate 230,000 products to Magento 2: https://www.ubertheme.com/magento2/data-migration-230000-products

      Regards,
      Ubertheme team

    • Joffy Jose

      Reset and Refresh. I got Solution.

  • Bibhuti

    I have used this. I got everything except customers. I have around 6000 customers.

    Please suggest how can I get customer from Magento 1 to Magento 2.

  • Hi,

    I ended up with this error:

    CDbException

    The table “{{tax_class}}” for active record class “Mage1TaxClass” cannot be found in the database.

    What can be turn around for this one?

  • Caroline Cruz

    Thanks for the post……it was very helpful. Keep updating the more blogs.

  • David O’Connor

    Is this tool compatible with the latest version of Magento? (currently v2.2.5)

  • Miniraj Shrivastava
  • Stage Softweb
    • Hi @Stage Softweb,

      The error notice you mentioned refers to the duplicated issue of sales order. It seems your Magento 2 instance has sample data, however you did select the Keep Original IDs in Step 7 of our migration tool.

      If that’s the case, you can select one of the options below:
      – Clean all sample data
      – Or Reset, then uncheck the Keep Original Id in step 7.

      Anyway, we highly recommend you consider using our latest UB Data Migration Pro extension – https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro. It is fully compatible with the latest Magento 2.2.7 and Magento 2.3.0, plus many enhancements and bug fixes. It will save you pretty much time.

      Regards,
      Ubertheme team

    • Hi @Stage Softweb,

      The error notice you mentioned refers to the duplicated data of the sales order. It seems your M2 instance has sample data in place, however you selected Keep Original IDs setting in Step 7 of our migration tool.

      Under this circumstance, you can either:
      – Remove your sample data and migrate again
      – Reset Step 7 and uncheck the Keep Original IDs setting in Step 7.

      Anyway, we highly recommend you consider using our latest UB Data Migration Pro ver 3.1.7 which is compatible with Magento 2.2.7 and Magento 2.3.0. It comes with bug fixes and enhancements.

      Hope that helps.
      Regards,
      Ubertheme team