Greetings! Long time it has been. Today's post comes from a project I was handed to convert the tens of thousands of users through our website that are using social accounts into email/password logins. It has served us well over the years, but with the on-going scrutiny from the changes at Facebook, and the integration we need to do with our online shop which does not have social authentication - makes sense it is time to remove.
But what is the cleanest way? We want to make this as seamless and easy as possible for our customers and with one EDM delivery. I have come up with the following procedure:
The comments should make it fairly self-explanatory. What you may find interesting is that we are deleting the corresponding user from Wordpress. This will get re-created after they sign in with the new user ID. If you are curious on the SQL that can be used to look up and delete the user by the Auth0 user_id, you can use this query:
From there you can delete the user ID from those two tables. In case you are curious on what the "Ticket API" we are creating for each user is - we use this as part of the campaign. When the customer opens this link tailored to them, it opens the page for them to enter their new password, without the need to enter any other detail including their email.
All of the mail-merge information (including the ticket url) is produced out to a spreadsheet to download and can be used as part of the email campaign which advises that their account has been converted to an email and password combination. Nice and simple!
Hope this helps -- as always.
Jesse.
Comments
Post a Comment