Customers migrated but passwords do not work

Answered

Public

groupimaging asked October 27, 2017

I have migrated customers over to the new store but when I try to have a customer login their password is not accepted. Is their a way to migrate the passwords as well?

UB Data Migration Pro

18 answers

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 27, 2017

Public

Hi there,

I have migrated customers over to the new store but when I try to have a customer login their password is not accepted.

Could you please check again? Please make sure you have correct customer login credentials, and such credentials work fine in M1 db.
Other completed migration projects using our migration tool so far do not run across such login issue. If the issue still persists, do let me know, I will check further.
Regards,
Mall.

Vote Up

Vote Down

groupimaging ⋅90.00 $tone October 27, 2017

Public

I checked three customer logins and none worked. They do work on the M1 store.

Vote Up

Vote Down

ubdev ⋅ Staff ⋅98150.00 $tone October 27, 2017

Public

Hi there,
We wonder if you logged in from Google Chrome browser? We’ve just tested and run across the similar situation in the Chrome browser. However, we logged in a test account successfully at our end, after trying to clean cache and old cookies data in your Google Chrome browser.
If that’s the case, please try to clean cache and old cookies data. Otherwise, please provide us following credentials so that we could debug further:

Credentials of one customer that has the log-in issue
URL of your M1 site
Admin and SSH credentials of your Magento 2 site
Let us know the path of your Magento 2 web root folder

Regards,
Ubertheme team

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 27, 2017

Public

Hi there,
Kindly re-check your Magento2 instance. I got this when try access your site: https://prnt.sc/h2t9rb
Also, let’s try at your end with CLI commands:
chmod -R 777 var
chmod -R 777 pub
Once done, let’s tell me know how about the login issue.
Regards,
Mall.

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 27, 2017

Public

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 28, 2017

Public

Hi there,

I chmod those directories and got a 500 error. I reverted back to 755

Ok.

Try accessing the admin again. I had the same error from home but now it is working after I did https for admin url in M2 config.
https://dev.groupimaging.com/store/bend/

But i still can’t access from my end. Do you have whitelist IPs settings?
Regards,
Mall.

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 29, 2017

Public

Hi there,

I have migrated customers over to the new store but when I try to have a customer login their password is not accepted.

I have checked in your working and see the root issue of that because you haven’t select ‘MERGE DEFAULT WEBSITES’ option in the step #2 of our tool: https://prnt.sc/h3djdm
All your migrated customers belong to the migrated web site with code ‘base_migrated’
And you have not setting the migrated website (base_migrated) as Default website at this time:
https://prnt.sc/h3djpi
Please note that, to login with migrated customers you have to set the migrated web site as default website.
Kindly have a look again.
Regards,
Mall.

#10

Vote Up

Vote Down

groupimaging ⋅90.00 $tone October 29, 2017

Public

OK thanks for figuring that out. I have rolled back my database and was going to try again with the correct settings. It is now hanging on step two with no progress in 15 min. Do I need to clear out any files to start the migration again?

#11

Vote Up

Vote Down

groupimaging ⋅90.00 $tone October 29, 2017

Public

found the CLI for resetting migration.
php bin/ubdatamigration reset
migration is running now.

#12

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 29, 2017

Public

Hi there,
Yes, i see you are migrating in the step #5. Let’s continue at your end. And tell me know if you need further assistance.
Regards,
Mall.

#13

Vote Up

Vote Down

groupimaging ⋅90.00 $tone October 30, 2017

Public

OK it is working now! Thank you for the help! This is such a great tool, you have saved me hours and hours of work!
I did have some products that migrated over that I don’t need anymore and I have tried to delete them but I get this error:

SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(`devgroup_magento214dev`.`q`.`items_count` - 1)', query was: UPDATE `quote` AS `q`
 INNER JOIN `quote_item` AS `qi` ON q.entity_id = qi.quote_id AND qi.parent_item_id IS NULL AND qi.product_id = 331
SET `q`.`items_qty` = `q`.`items_qty` - `qi`.`qty`, `q`.`items_count` = `q`.`items_count` - 1

Any idea on what could be wrong?  On my first migration attempt when the customer passwords did not work I was able to delete products, but now I can't.

Thanks,
Mike

#14

Vote Up

Vote Down

groupimaging ⋅90.00 $tone October 30, 2017

Public

OK I found a solution. Ran this sql on the “quote” table on the database

UPDATE `quote` SET `items_count` = '1' where `items_count`='0';

#15

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 31, 2017

Public

Hi there,
Great, let’s continue and contact me if you need further assistance.
Regards,
Mall.

#16

Vote Up

Vote Down

pawan guleria_911 ⋅20.00 $tone November 6, 2017

Public

Hi All

I want Buy this extension , I want to migrate my 14,000 Customers and the 15,000 orders ,
This tool can be migrate my data or not ?

And after Migration my customers password will works or Not ?

#17

Vote Up

Vote Down

ubdev ⋅ Staff ⋅98150.00 $tone November 7, 2017

Public

Hi Pawan Guleria,
The volume of data you mentioned is within scope of our UB Data Migration Pro.
You can take a look at recent data migration case studies 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
-- And this case study as well -- Freelaunch.nl used UB Data Migration Pro to migrate 230,000 products to Magento 2