How to just migrate customers without Website/Stor

Hello Uber,
we bought your extension data migration pro to migrate customer data only from Magento 1.9 to 2.1. I asked the support 2 times if it is possible to only migrate customer data.
We rebuild a shop in M2 and have totally new product structure and configuration (Example: M1.9: Simple-Products Bundle-Products, M2: Configurable Products with virtual Products). We also use new product attributes, etc. The only thing we want to migrate is:
-- customer data and newsletter subscriptions
-- orders (if possible, SKU didn’t change)
-- Rules & Cupons
Now we installed and run the extension and the situation is, that i have to migrate at least the Website and Stores. After the migration all customers are related to the migrated website instead of the existing and the migrated Website is the standard Website.

Please give me advice for a few questions:
-- Can I migrate customer data only and attach all customers to my existing and configured Website (via cli?) ?
-- Can I migrate recent orders without migrating products? We didn’t change the SKU
-- Can i migrate Baskte-Rules & -Cupons? We have only Basket-Rules and Rules are Based on SKU which didn’t change
If the above is not possible:
-- Can you tell me, how i can fix the customer-relation the the wrong Website in the database directly
-- Is it safe to rename the migrated Website/Store?
-- Is it sage to delete the migraded Website/Store?
-- Are there any side-effects i should consider?

thanks
Jürgen 

36 answers

Profile photo of Mall Staff 184060.00 $tone November 11, 2016
Public

Hi [email protected],

— Can I migrate customer data only and attach all customers to my existing and configured Website (via cli?) ?
— Can I migrate recent orders without migrating products? We didn’t change the SKU
— Can i migrate Baskte-Rules & -Cupons? We have only Basket-Rules and Rules are Based on SKU which didn’t change

No, If you wish to migrate the Customers, Orders, Sales data  you have to migrate related data in the steps: #2, #3, #4, #5 to take care the constraint of data

— Can you tell me, how i can fix the customer-relation the the wrong Website in the database directly

Yes, after migrated all successfully, you can manual update directly this info in your database.

— Is it safe to rename the migrated Website/Store?

Yes, you can edit this after migrated successfully your data.

Is it sage to delete the migraded Website/Store?

You can only delete this after you moved needed related data to other websites and stores.
Please have a look and contact me if you need further assistance!
Regards,
Mall.
 
 
 

#1
Profile photo of cdme 30.00 $tone November 15, 2016
Public

Hello Mall,
now i migrated Website/Store and Customer Data. But Login fails and the reset password-function sais magento is not able to send the mail to reset the password.
This is what i did:

  • configure step 1, 2 and 6 (Database settings, Website/Stores, Customers)
  • php bin/ubdatamigration run --step=2
  • php bin/ubdatamigration run --step=6 --limit=1000
  • php bin/magento cache:clean
  • php -f bin/magento indexer:reindex
  • php bin/magento cache:flush

Next i set my already configured Website to standard again and manually manipulated group_id, website_id and created_in in ‘customer_entity’

  • UPDATE customer_entity SET group_id = ‘1’ WHERE group_id = ‘4’; (migrated “general” to origin “general”)
  • UPDATE customer_entity SET website_id = ‘1’ WHERE website_id = ‘2’; (migrated website to origin website)
  • UPDATE customer_entity SET store_id = ‘1’ WHERE store_id = ‘2’; (migrated website to origin website)
  • UPDATE customer_entity SET created_in = ‘XYZ’ WHERE 1; (Name of origin Website)

And again: 

  • php bin/magento cache:clean
  • php -f bin/magento indexer:reindex
  • php bin/magento cache:flush

A User registered after the migration can login without problems, but a migrated User can’t login (An unspecified error occurred. Please contact us for assistance.)
If you need, we can provide you with additional information or login data to the test-server, please let me know.
 
Regards,
Jürgen

#2
Profile photo of Mall Staff 184060.00 $tone November 15, 2016
Public

Hi cdme,

but a migrated User can’t login (An unspecified error occurred. Please contact us for assistance.)

It seems you have not set the website with customers data migrated is website default.

  • UPDATE customer_entity SET group_id = ‘1’ WHERE group_id = ‘4’; (migrated “general” to origin “general”)
  • UPDATE customer_entity SET website_id = ‘1’ WHERE website_id = ‘2’; (migrated website to origin website)
  • UPDATE customer_entity SET created_in = ‘XYZ’ WHERE 1; (Name of origin Website)

After migrated successfully, you shouldn’t do that, you could set the website migrated with website_id=2 as a website default of your site. And then everything will working fine.
Please have a look again!
Regards,
Mall.

#3
Profile photo of cdme 30.00 $tone November 15, 2016
Public

After migrated successfully, you shouldn’t do that, you could set the website migrated with website_id=2 as a website default of your site. And then everything will working fine.
Please have a look again!

Please have a look to your first answer. What i am doing is exactly what i asked an got the answer that it will work. I also asked the support if the extension will work for my issues before i paid 400 bugs for it! Please have a look at my e-mail-correspondence with Niki from Ubertheme startet October 7th.
We need to keep our website_id (1) because anything is configured and mapped and based on it. So we don’t understand why we should use the migrated website_id (2).
We have to rollout so please solve the issues i paid for.
 
Thanks
Jürgen

#4
Profile photo of Mall Staff 184060.00 $tone November 16, 2016
Public

Hi cdme,
Please provide me the admin and ssh credentials of your Magento 2. I will check further current working and help you out.
Regards,
Mall.

#5
Profile photo of Mall Staff 184060.00 $tone November 16, 2016
Public

Hi cdme,
Below is content of my public key, i’m on Ubuntu OS:

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDMloNWDNg6ITfRZ2KaMwCW20xS6EZrk73TzW7VCXPi7TltOgFekoGTm5kGlc2G7YVjIf+Hb1mLThgmoYreTgs8irKJiCPCFVR2pkJFFw1/IOFd0v4/MuHmpa3J+66UxKP75gkqLk+h+HL5BzCYlEsej0OoNs+roF7Elz8WbtBwCVBW5M/w+BIyWNZkHKHuxZPj+X2pIVwaRIfgxlSZkeBjehXl/tMu3I4wVvIt8Fgz/MQ+hPjljTdMnBJJQIXtK2sDnqCfry9woMkZGSG4JubotWY5ZTNjWyeD3yhDT+v2gHjYmbDNtNBxMEr+Q4jtntcM1AqWabuGnSru2u01aG+F qvv@qvv-hp

Regards,
Mall.

#7
Profile photo of Mall Staff 184060.00 $tone November 17, 2016
Public

Hi cdme,
I have checked in back-end of your site at: http://schlafgutclone.stage.12bis3.de/shop/
And with all information you have said. I see you want to merge related Customers of the website in Magento 1 -- Schlafgut to website in Magento 2 -- Schlafgut NEU.
To get that, you have to do exactly steps as below:
1 -- Reset all steps which you have done with our tool (step #2, #6)
(maybe you have to clean the Magento cache after this action done: php -f bin/magento cache:clean)
2 -- Re-setting for all steps as you did with our tool in first time. (skip steps you don’t want to migrate)
3 -- In Migrating Data tab, click to ‘Run’ button to run migrate in step #2 (Don’t click ‘Run migrate data all steps’ button)
4 -- After you have done with step #2, let’s run below sql in the database of your Magento2:

UPDATE ub_migrate_map_step_2 SET m2_id = 1 WHERE m1_id = 1; // only for your case ;)

5- After you have done with above sql, come back to back-end of our tool in your site and you can continue click to ‘Run’ button in the step #6 to migrate Customers data.
6 -- After you have done with Customers data migration, let’s open your terminal and go to your Magento 2 folder and run bellow commands:
php -f bin/magento cache:clean
php -f bin/magento indexer:reindex
php -f bin/magento cache:clean
Let’s do it to get the customers data as you want.
And tell me know how it goes.
Regards,
Mall.
 
 
 
 
 
 

#10
Profile photo of Mall Staff 184060.00 $tone November 17, 2016
Public

Hi Jürgen,
Please share with me a backup file of your Magento 1 database. I will proceed migration in my local to detect the root of issue that you mentioned.
Also, kindly let me know 1 customer account for testing (username & password)
I will keep you updated once done.
Regards,
Mall.

#12
Profile photo of Mall Staff 184060.00 $tone November 21, 2016
Public

Hi cdme,

Please use the stage we build for you and testet the migration:
http://schlafgutclone.stage.12bis3.de/shop/

I have re-checked and see this issue when login with Customer credentials you shared:
http://i.prntscr.com/fc4a5c55c28a494994c95f3945e52180.png
So what is the web root folder path of that site in terminal?
Do you use any third-part ext can effect to login function in that site?
Pls, tell me more detail, i will check further to detect the root of issue.
Regards,
Mall.
 

#27
Profile photo of Mall Staff 184060.00 $tone January 8, 2017
Public

Hi Rob Staff,
What is the question you have posted? 
Let’s tell me know exactly the context of your issue. I will check further and help you out.
Regards,
Mall.

#30
Profile photo of Rob Staff 100.00 $tone January 8, 2017
Public

Hi Mall,
I have the same scenario as CDME above. I am just firing up an instance of my site to test with the answer you gave in #10 above. However, I also need to migrate all SALES data to store_id=1 and website_id=1. Should I execute this SQL again before step 7?

UPDATE ub_migrate_map_step_2 SET m2_id = 1 WHERE m1_id = 1; 
#31
Profile photo of Rob Staff 100.00 $tone January 8, 2017
Public

Hi Mall,
Here is what I am trying to do. I have built new store on M2, added categories/products (as needed to use new attribute set and change structure, so could not simply migrate categories/product). Now I need to migrate customers and all sales data. The UB tool will not allow me to import sales data unless i import product/category data. My first attempt I migrated all data, then deleted the imported products/categories. The problem with the first attempt was same as CDME, all customers were assigned to migrated store_id=’2′, all sales data was migrated to store_id=’2′, and a duplicate customer group ‘general’ id=”4″. I need to import to store_id=”1″. The M1 db and M2 db have identical stores and customer groups however the migrate make new id’s for imported data. How can I map these? 
Second attempt I tried the method as you mentioned to CDME and receive entigrity constraint violation for duplicate categories (which I do not need to migrate anyway). 
 
Can you please advise how to import: customers and sales data ONLY from M1 website_id 1 store_id 1 to M2 website_id 1 store_id 1. (steps 6 & 7). All products/categories/settings are on website_id 1 store_id 1 in the M2 site from scratch not migrated.

#32
Profile photo of Rob Staff 100.00 $tone January 9, 2017
Public

Oh dear,
I just realised it would be much simpler change the existing product/categories to migrated store after I have migrate all data and deleted migrated products. Thanks anyway

#33
Profile photo of Rob Staff 100.00 $tone January 12, 2017
Public

Hi Mall,
So I migrated all data and moved existing products to migrated store_id. I ran ALL steps including update increment ID’s, but now the order and invoice ID’s are stuck on 00000000 and the follow error when I try to place order. How do I fix this issue?
I was hoping this expensive module would simplify the migration but didn’t work out for me

An error occurred on the server. Please try to place the order again.
#35
Profile photo of Mall Staff 184060.00 $tone January 12, 2017
Public

Hi Rob Staff,

An error occurred on the server. Please try to place the order again.

To solve that, simply for each your Store Views migrated. Let’s click to open it and then re-save it in back-end of your Magento2 site.
And clean the Magento2 cache.
Regards,
Mall.

#36

Please login or Register to Submit Answer

Written By

Comments