00:00:13:12 - 00:00:15:17
In this
tutorial, we'll learn how to import

00:00:15:18 - 00:00:21:19
large quantities of customer data
using a dedicated import tool.

00:00:23:02 - 00:00:26:12
To start off with, we're going to navigate
to the customer management screen.

00:00:26:13 - 00:00:33:17
So if we go to customers
and customer management,

00:00:33:17 - 00:00:37:15
this will show is a list
of all of the customers currently created

00:00:37:15 - 00:00:39:14
in this particular storefront.

00:00:39:14 - 00:00:44:05
In this particular example,
we can see there's only one.

00:00:44:05 - 00:00:47:23
If we want to mass import our customers,
we can go across

00:00:47:23 - 00:00:50:01
to the CSV import tab.

00:00:51:07 - 00:00:53:21
There's a lot of information
detailed on here

00:00:53:21 - 00:00:57:27
to try and help you through this process
nice and smoothly.

00:00:58:11 - 00:01:01:10
So you can have a read through
what it expects

00:01:01:10 - 00:01:03:10
from the different bits of information.

00:01:05:00 - 00:01:08:19
One important thing to remember
is that we recommend

00:01:08:19 - 00:01:13:02
that you only import 200 per sheet.

00:01:14:12 - 00:01:16:19
So we import a CSV documents.

00:01:17:05 - 00:01:21:17
We recommend that you limit
it to 200 customers per CSV document.

00:01:21:27 - 00:01:25:03
You can import multiple CSV documents
one after the other.

00:01:25:03 - 00:01:26:27
That's no problem at all.

00:01:26:27 - 00:01:32:07
But try and limit it
to 200 for each individual sheet.

00:01:36:00 - 00:01:39:00
If you scroll
right down to the bottom of this page,

00:01:39:06 - 00:01:44:15
you have got the ability to download
a template CSV and this saves you having

00:01:44:15 - 00:01:49:21
to create all of the headings yourself
and potentially making human error.

00:01:50:00 - 00:01:53:02
Ask mistakes in just typing or copying

00:01:53:02 - 00:01:56:03
and pasting or whatever you need to do.

00:01:56:06 - 00:01:57:18
So download this

00:01:57:18 - 00:01:59:24
and you'll end up with something like

00:02:02:06 - 00:02:05:16
this document here.

00:02:06:11 - 00:02:09:10
So this gives you all the necessary
headings that you require

00:02:12:04 - 00:02:14:12
along with a sample user.

00:02:15:10 - 00:02:16:14
Just giving you

00:02:17:17 - 00:02:19:29
an idea of what expectations

00:02:20:07 - 00:02:23:07
these columns have.

00:02:29:03 - 00:02:30:06
Now we'll populate

00:02:30:06 - 00:02:32:23
our CSV template
with our own customer data.

00:02:33:28 - 00:02:36:11
We have a sample available,

00:02:36:17 - 00:02:38:27
so I'll show you now

00:02:41:26 - 00:02:44:03
that we have nine

00:02:44:28 - 00:02:47:15
sets of customer data
that we intend to import,

00:02:48:12 - 00:02:52:13
three different companies are represented
by these customer data.

00:02:52:26 - 00:02:54:20
We've got Red Company,

00:02:54:20 - 00:02:57:10
we've got Blue Company
and we've got Green Company.

00:02:57:29 - 00:03:01:24
Each of red, blue and green
have an administrator, an approver

00:03:02:01 - 00:03:04:03
and a general user.

00:03:04:03 - 00:03:07:02
And what you'll find
is that as we look across these columns,

00:03:08:06 - 00:03:10:29
those users have tried to be set up
as such

00:03:10:29 - 00:03:14:06
in the respective columns.

00:03:14:06 - 00:03:16:14
So for example, if I look in

00:03:17:11 - 00:03:20:28
departments which we set up
in a previous video, you can see that

00:03:20:28 - 00:03:24:09
they've been put in a relevant department

00:03:24:09 - 00:03:27:04
based on their company.

00:03:27:09 - 00:03:33:13
Some of them have been assigned
specific customer roles,

00:03:33:13 - 00:03:37:20
so that will give them
certain access rights.

00:03:37:20 - 00:03:39:17
They've been assigned
to particular companies

00:03:41:12 - 00:03:41:29
and there's some

00:03:41:29 - 00:03:44:04
address information
being imported in there as well.

00:03:44:29 - 00:03:47:12
You don't need to fill in
every single column,

00:03:47:12 - 00:03:51:27
just the information
that you feel your customer import needs.

00:03:52:07 - 00:03:55:17
There are some bits of information
which will be mandatory.

00:03:55:28 - 00:04:08:12
So, for example, the entry of a password.

00:04:08:12 - 00:04:09:16
So I'm going to close this down.

00:04:09:16 - 00:04:14:00
It's a good idea to close the sheet down
before you try and import it.

00:04:16:03 - 00:04:19:07
Scroll
back to the top of the CSV import list

00:04:19:21 - 00:04:29:16
and then select the file
that you want to import.

00:04:34:05 - 00:04:37:23
Once you're happy, click on import

00:04:40:10 - 00:04:44:00
and this will give you very detailed
feedback

00:04:44:00 - 00:04:47:11
as to which imports have been successful
and which have not.

00:04:47:24 - 00:04:50:11
So you can see from this particular CSV

00:04:50:12 - 00:04:53:22
that we imported here
that there has been a few problems.

00:04:54:01 - 00:04:57:18
So it's saying the six user accounts
were successfully updated.

00:04:57:18 - 00:05:00:05
Three users could not be imported.

00:05:01:18 - 00:05:03:18
Now, that's
not a massive amount of information.

00:05:03:18 - 00:05:07:00
So I might want to see a little bit
more detail related to that.

00:05:07:09 - 00:05:11:21
And I can download an associated report
which will tell me exactly what fails

00:05:12:22 - 00:05:14:25
in this link here

00:05:22:20 - 00:05:25:10
and what it's saying.

00:05:25:24 - 00:05:28:04
So my administrator rows

00:05:29:21 - 00:05:31:28
so row zero, three and six.

00:05:31:28 - 00:05:38:07
So let's just open our CSV sheet again
just to get some context.

00:05:42:10 - 00:05:44:19
So this will be zero

00:05:44:27 - 00:05:49:16
three and six administrator roles
where we've actually assigned

00:05:49:16 - 00:05:52:11
the role of administrator
to these particular users.

00:05:52:29 - 00:05:57:06
We can see that it's saying
that the password format is incorrect.

00:05:57:07 - 00:05:59:13
So it's very detailed set of information

00:05:59:13 - 00:06:01:19
and it's telling us
exactly what we would need to change,

00:06:02:23 - 00:06:06:17
exactly what we need to change before
we can successfully import

00:06:06:25 - 00:06:22:10
those customers.

00:06:24:27 - 00:06:25:15
So I'm going to go

00:06:25:15 - 00:06:42:17
ahead and make those changes,

00:06:42:17 - 00:06:47:25
save those,
and then I'm going to re-import

00:06:48:00 - 00:06:56:20
that information.

00:07:00:09 - 00:07:00:27
You can see now

00:07:00:27 - 00:07:03:26
that all nine user accounts
have been successfully updated.

00:07:05:00 - 00:07:07:01
We haven't ended up with duplicates

00:07:07:01 - 00:07:10:02
of those duplicate entries
from the two imports.

00:07:10:02 - 00:07:13:03
So everything is now set up
as we expected.

00:07:13:15 - 00:07:16:17
If we look in the list of users
that we've imported,

00:07:17:08 - 00:07:19:21
we can get a feel for the information

00:07:19:21 - 00:07:23:12
that has been inserted and defined.

00:07:23:20 - 00:07:27:27
So for example, we've got our approver,
who's part of the red company

00:07:29:18 - 00:07:32:10
in the red company department

00:07:32:10 - 00:07:35:04
with approver roles.

00:07:36:00 - 00:07:38:07
I come down to my admins.

00:07:38:07 - 00:07:40:24
We can see that refined or defined
as storefront

00:07:40:24 - 00:07:44:05
administrators in the relevant department
and the relevant company.

00:07:44:05 - 00:07:45:07
For example.

00:07:45:07 - 00:07:54:22
So the import has been successful.