Not all customers have been migrated

Hi
In M1 we have 28000 customers.
After import in M2 there is only 15000 migrated.
(All customer groups ticked in UB migration interface).
Any ideas what this might be?
Thanks
 

11 answers

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

Hi there,

the data to be migrated shows 28k so I would expect those to have come over?
 Any idea?

If you have assigned all needed customers to the M1 website which you have checked to migrate in step #2 setting of our migration tool (this step is very important, please verify the value of the ‘website_id’ field in the ‘customer’ table in your M1 database after your change), and if you did complete all steps as suggested in my reply #5, all your customers will be migrated to M2.

Anyway, could you reset and proceed with data migration in all steps of our migration tool from the ground up once again? I know this takes you extra time, yet it helps to ensure data integrity. 
 
Regards,
Mall.
 

#
Profile photo of Mall Staff 184060.00 $tone November 6, 2019
Public

Hi there,

In M1 we have 28000 customers.
After import in M2 there is only 15000 migrated.
(All customer groups ticked in UB migration interface).

That issue is strange. Please provide me information of your instance:

  • Admin credentials of your M2 site
  • SSH credentials of  your M2 sit
  • Let me know the path to M2 folder
  • phpMyadmin credentials of your M1 and M2 databases (if you have phpMyadmin control panel)

I will help to check further and get back to you then.
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access. 

Regards,
Mall.

#1
Profile photo of wood.sofs 540.00 $tone November 6, 2019
Public

Thank you, I have found the issue though:
I only migrated 1 store view (website).
The missing customers are assigned to the other websites on the M1. Is there a way to pull these over when only migrating 1 website?
I guess the only way is to assign the customers to the migrated website? (and then run the delta?)
Thanks
 
 

#2
Profile photo of Mall Staff 184060.00 $tone November 7, 2019
Public

Hi there,

The missing customers are assigned to the other websites on the M1. Is there a way to pull these over when only migrating 1 website?
I guess the only way is to assign the customers to the migrated website? (and then run the delta?)

Yes, if you want to migrate one website from M1 only, you can do that workaround (In M1 site, assign all the customers you want to the M1 website which you have checked to migrate in the setting of step #2. And then, do delta migration in step #6). 

Regards,
Mall.

#3
Profile photo of wood.sofs 540.00 $tone November 7, 2019
Public

Hi
So this did not work.
I assigned all customers in the M1 site to the site that I am migrating (Total 28882 records found in M1).
The UB tool states:

 
But there is only 15142 customers listed in M2 (after a delta migration of step 6):

 
Any ideas what has gone wrong?
(reindexed and cache cleared).
Thanks
 
 

#4
Profile photo of Mall Staff 184060.00 $tone November 7, 2019
Public

Hi there,

Any ideas what has gone wrong?

Lets try with steps as following:
+ Run following SQL in your M2 database:

UPDATE `ub_migrate_map_step_6` SET `created_time` = '2000-01-01 00:00:00', `offset` = 0 WHERE `entity_name` = 'customer_entity';

+ Once done, run delta migration in step #6 with update mode:
php -f bin/ubdatamigration run --step=6 --mode=update
+ And then, reindex the data and clean M2 cache.
Regards,
Mall.

#5
Profile photo of Mall Staff 184060.00 $tone November 8, 2019
Public

Hi there,

I have done that (twice) and there has been no change in the data on the M2 site.

That is strange. Did you assign all needed customers to the website you mentioned successfully in M1?

I guess the only way is to assign the customers to the migrated website? (and then run the delta?)

Did you run the SQL as suggested in my reply #5 before proceeding with the delta migration in step #6 with the ‘update’ mode?

Regards,
Mall.

#7
Profile photo of ubdev Staff 98590.00 $tone November 14, 2019
Public

Hi there, 
Glad that to hear that. Please move forward with the process at your end. If you have any additional question, please get back to us here. 
Regards,
Ubertheme team

#10

Please login or Register to Submit Answer

Written By

Comments