This article is also available in:
For each customer ordering at your store, their name, address and other information will be added to your customer list. If you already have a list of customers you want to use on ShopBase, you can update the information with the CSV file and upload it on the ShopBase admin page. Please refer to understanding CSV file and how to create CSV file. In this article, we will guide you how to import customer information to the store using a CSV file.

Step by Step Tutorial

Prepare the customer CSV file according to CSV sample file ShopBase provides. In which:

First Name: The first name of the customer.
Last Name: The last name of the customer.
Email: The email address of the customer.
Company: The name of the company that customer uses if applicable.
Address1: The first line of the customer's address.
Address2: The second line of the customer's address, if necessary.
City: The city the customer lives in.
Province: The province or state the customer lives in. You must also enter the Province Code if this field is completed.
Province Code: The province or state ISO code. Shopbase uses ISO alpha 2 codes
Country: The country the customer lives in.
Country Code: The country ISO code. Shopbase uses ISO alpha 2 codes
Zip: The postal or zip code for the customer's address.
Phone: The customer's phone number.
Accepts Marketing: Sets whether or not the customer agrees to subscribe to email marketing, such as a newsletter. Valid entries are yes or no.
Total Spent: The customer's total amount spent. Valid entries must not have a currency symbol included.
Total Orders: The customer's total number of orders.
Tags: A comma-separated list of tags used to tag the customer.
Note: Additional information about the customer.
Tax Exempt: Indicates if the customer is tax exempt. Fill in yes or no.

From ShopBase admin site, go to Customer. Click Import.


The Import Customers By CSV box appeears, drag and drop CSV files from your computer into the box Drop your files here or click to upload or double-click on the box Drop your files here or click to upload then select the file from your computer to upload. Tick the box Overwrite existing customers that have the same email if you want to change the customer data on the store admin page with the customer data in the CSV file provided they have the same customer email.


Click Import customers to import customers information to ShopBase admin site. Customers entering information from the CSV file will appear in the customer list in the Customers section of the ShopBase admin page.

* First Name

Related articles

Add a new customer
Edit customer information
Export existing customer information by CSV file
Was this article helpful?
Cancel
Thank you!