Migrating a second website

Hi,
I have successfully migrated a magento 1 site into magento 2, however I now what to merge another magento 1 site into my current magento 2 site , how do I do this ? using this tool ? I copied the new database into out mysql server , pointed the tool towards this new magento 1 database and the tool thinks I have already completed the migration, how do restart the tool to merge this new database ?

9 answers

Profile photo of ubdev Staff 98150.00 $tone December 16, 2019
Public

Hi Rajeev Mongia, 
 
Glad that you’ve completed the data migration with your first Magento 1 site. 
 
If you plan to migrate the 2nd Magento 1 site, there’re a few things you should notice before proceeding:

  1. The migration process will be a little bit different compared with the first Magento 1 site migration (we will instruct in details later on)
  2. Due to our migration working rule, if you want to keep original IDs of specific data objects, your M2 instance must be a fresh instance. That means you can’t not use the Keep Original IDs setting when migrating from your 2nd Magento 1 database (you can learn more about the Keep Original IDs setting here).
  3. The delta migration feature is available for your 2nd Magento 1 database only.
  4. Our current license grants you permission to migrate from one single Magento 1 database instance only. Each extra M1 db will need additional license.

Please consider to take advantage of our current Xmas Sale with 15%OFF. The discount code is available here.
 
Regards,
Ubertheme team
 

#1
Profile photo of Rajeev Mongia 300.00 $tone December 16, 2019
Public

ok . if i purchase thetool ill be able to import a second database ? will i need download and install anything else or just follow some setup rules. at the moment the tool is regarding the new database as migrated. i totally understand the id cannot be kept the same
 

#2
Profile photo of Rajeev Mongia 300.00 $tone December 16, 2019
Public

ok . if i purchase thetool ill be able to import a second database ? will i need download and install anything else or just follow some setup rules. at the moment the tool is regarding the new database as migrated. i totally understand the id cannot be kept the same
 

#3
Profile photo of ubdev Staff 98150.00 $tone December 16, 2019
Public

Hi Rajeev, 

Yes, you can continue with the current M2 instance that you proceeded with the first Magento 1 site. However, the migration process will be a little bit different, we will let you know in details once you purchase the new license. 
 
Regards,
Ubertheme team

#4
Profile photo of ubdev Staff 98150.00 $tone December 20, 2019
Public

Hi Rajeev, 
 
Thanks for your purchase. 
Below are steps to proceed with the migration of the 2nd M1 database: 
 
Step 1: Verify all migrated data from your first M1 database ready for use

Step 2: Clean all migration log tables by running the following queries in your M2 database: 
drop table ub_migrate_map_step_2;
drop table ub_migrate_map_step_3;
drop table ub_migrate_map_step_3_attribute;
drop table ub_migrate_map_step_3_attribute_option;
drop table ub_migrate_map_step_4;
drop table ub_migrate_map_step_5;
drop table ub_migrate_map_step_5_product_download;
drop table ub_migrate_map_step_5_product_option;
drop table ub_migrate_map_step_6;
drop table ub_migrate_map_step_6_customer_address;
drop table ub_migrate_map_step_7;
drop table ub_migrate_map_step_7_invoice;
drop table ub_migrate_map_step_7_invoice_item;
drop table ub_migrate_map_step_7_order;
drop table ub_migrate_map_step_7_order_address;
drop table ub_migrate_map_step_7_order_item;
drop table ub_migrate_map_step_7_quote;
drop table ub_migrate_map_step_7_quote_address;
drop table ub_migrate_map_step_7_quote_item;
drop table ub_migrate_map_step_8;
drop table ub_migrate_map_step_8_rating;
drop table ub_migrate_map_step_8_review;
drop table ub_migrate_map_step_8_review_summary;
drop table ub_migrate_map_step_8_subscriber;
drop table ub_migrate_map_step_8_cms;
drop table ub_migrate_map_step_8_downloadable_link_purchased;
drop table ub_migrate_step;
Delete from setup_module where module = ‘Ubertheme_Ubdatamigration’;
Step 3: Install our migration tool once again following the installation steps as you did in the first time.
Step 4: Then, you could continue with steps of data migration for the second M1’s database.
 
Hope that helps. 
 
PS. Since our team is off in the weekend, please accept our apology for certain delay in response if you reach out to us during this period. 
 
Regards,
Ubertheme team
 
 
 

#6
Profile photo of Rajeev Mongia 300.00 $tone December 20, 2019
Public

Hi, when I run the step for MIgrated attributes I get the following error
 
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’12-product-details’ for key ‘EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE’. The SQL statement executed was: INSERT INTO `eav_attribute_group` (`attribute_set_id`, `sort_order`, `default_id`, `attribute_group_name`, `attribute_group_code`, `tab_group_code`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5)
When I migrate the products, I get an entry but no products are turned on, no descriptions , names etc, prices , all attributes have not been carried across

#8
Profile photo of Mall Staff 184060.00 $tone December 22, 2019
Public

Hi Rajeev,

 1062 Duplicate entry ’12-product-details’ for key ‘EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE’. The SQL

That was because your M1 database had some special cases of product attribute groups, which had the same string ‘general’ in the attribute group name in one product attribute set.

Please try with step as follows:

+ Open the PHP file at path: 
pub/ub-tool/protected/controllers/Step3Controller.php
 
and find the code line:

$attributeGroupCode2 = (preg_match("/(general)/i", $attributeGroupCode2)) ? 'product-details' : $attributeGroupCode2;

and replace it with:

//$attributeGroupCode2 = (preg_match("/(general)/i", $attributeGroupCode2)) ? 'product-details' : $attributeGroupCode2;

+ Once done, you can continue with the data migration in step #3

When I migrate the products, I get an entry but no products are turned on, no descriptions , names etc, prices , all attributes have not been carried across

You need to finish the data migration in step #3 first before you do data migration in step #5.

Regards,
Mall.
 

#9

Please login or Register to Submit Answer

Written By

Comments