Migrate Lightspeed Customers to Shopify

Migrate Lightspeed Customers to Shopify

October 9, 2019 0 By Bernardo Ryan


And this is the second video in this
series, where I show you how to migrate from Lightspeed to Shopify. And now we
will take on customers in Lightspeed. I go to the customers and I see there are lots
of customers in my Lightspeed, of course, in this case I have only myself as an
example. I click on export, which is in Lightspeed exporting all the customers
to the file, then I download the file here and I go to my files. And I see this
file “Customers Export” and then all I need to do is add Lightspeed to the name
of the file so that it’s, it contains the Lightspeed and customers words so that
Excelify can recognize what you want, this file,
what is this file, basically. And now I just drag it to the Excelify app here,
allow it to analyze it and see it says format is Lightspeed, by that you know
that has indeed recognized it as a Lightspeed file. And then you see that it
sees one customer, and again, you can either press import and import those
customers straight away to the Shopify or you can do the, here dry run, if you
check this box of the dry run and press import. Then it will just convert the
file to the Excelify format and it will not import just yet, so then you can
download this import results file and it’s just simulated import, basically,
it’s not real yet, but but it gives you, it gives you all this data from
Lightspeed in the Excelify format, so you have all your email and you have two
rows, because there are two addresses. And you can verify this information, like the
names, the phones choose whatever additional fields you want to fill in,
here comes the address comes. You can check that they are correct,
you can even add here. If you add in this column “true” value here, then it will
send account activation email at the time when you are importing those
customers, and by that way that’s, that’s one of the methods how you can reinvite
your customers from Lightspeed to your Shopify store, that’s if you want them to
receive it right away, but of course you can delay this invite
and invite them later in bulk, also, using Excelify, so that when you have your
store, everything prepared and ready and only then you send out your invites. Of
course, you can also mark true here to send a welcome email. Also, if you have
your passwords, that I hope you don’t, but if you want, you can just, like, generate
passwords for your customers and then send them out to the customers. Then all
the rest of the fields, which Shopify doesn’t have a place for, we are putting
them in metafields for the customer. So whatever you might need additional
information, like, the birthdate or gender, or whatever was there. It’s, but
it’s not lost, its put in metafield, so when you export again using Excelify
and include the metafields in export you can see those values, and you can use
them however you want. All right. And then after you have improved your data, you
can, like, close and save the file and do the real import. And now I’ll be
importing, again, the import results so that we have the modified data imported.
Then I press import and… Whoops! It’s expected, but I wanted to show you, that
it failed with this customer and, again, I can download the import results file so
that you could just see the process of dealing with those errors. So in my
results file I have here the import comment
column which says what was wrong with this customer. And it says failed phone
is invalid and, indeed, I have put some dummy phone which is, which is not valid.
And if I put the correct phone here, remember you are in Excel, so you need to
make sure, like, that you just don’t screw up your phone numbers with all the
country prefixes and so on, and let’s paste it here as well, the same phone now.
Again, I save it, close it, do another import, press import, wait a
second and now we see that it’s new one, one customer created. Then I go to
customers in the shop for admin and I see that, indeed, it created my account
with all the address and phone and also some additional fields in the notes as
well as metafields, which you can’t see here, but if you export customers with
metafields, then you will be able to see them. Alright and so that’s that’s how
you migrate your customers and it might happen that, for example, you have, like,
100,000 customers coming here from Lightspeed and thousands of them fail.
And then the same way – you just download the import results file and then you, you
just from this file, you just delete. You can do, for example… For example, here will
be some “OK” rows and usually it’s, it’s the most easiest and convenient way. You
just apply the filter, and you filter to show all “OK” rows and you just delete
the all “OK” rows so that you are left only with the failed rows. And then you
work on the failed rows to fix them and import only those, because
the okay rows are already imported and there’s nothing to do with them anymore.
So, yeah, that’s how you import your customers from Lightspeed. Cheers!!! you