Manually adding any customers by hand can be a hassle, especially if you've got multiple customers you need to add to your site. For adding multiple customers at once, you can import a list of customers instead.
First, you are going to want to create a spreadsheet with your customers' information to import. An example of all the information required in the spreadsheet is outlined below:
There is also an attachment at the bottom of this article with a template you can save for your own use.
- id- customer ID number
- firstname- customer's first name
- lastname- customer's last name
- email- customer's email address
- group_id- must be set to "1"
- telephone- customer's telephone number
- zip- customer's zip code
- address- customer's address
- city- customer's city
- state- customer's state
- country- customer's country (Mostly you will see "United States")
- _website- must be set to "base"
**Every customer on your list must have an email address or you will not be able to upload your customer list.
Once you've created your import file, you are going to want to go to CATALOG > IMPORT/EXPORT > IMPORT
On this page, you are going to choose the "Customers" entity type. Then you can choose to append, replace, or delete existing entries with the data in the file you choose to import. Generally, you will want to choose the "Append Complex Data".
Once those have been selected, and your file has been chosen you will want to click the "Check Data" box detailed in the image above. If successful, you should see a message like the following:
If everything looks good here, you can click the blue "Import" button and that will import your newly uploaded customer list.
That's all there is to it! Your customers should now be uploaded onto your site. If you have any other questions or concerns, please submit a support ticket.