New customers are created each time an order with a new customer e-mail address is imported. You can repurpose our CSV order import to upload your customer billing and shipping details.
Before You Start
Make sure you have a CSV store
Required Fields
Required fields and what to fill in |
|
Input |
|
| status | shipped |
|
| total_price | 0 |
|
| created_at | 2020-01-01 00:01:00 UTC |
|
| payment_type | cash |
|
| shipped_at | 2020-01-01 00:01:00 UTC |
|
| sku | customer-import |
|
| qty | 1 |
|
| number | P-135642 (any number will work, this will be the order number) |
|
Your Customers' Details | Header | Description | Example |
| shipping_address_first_name | The first name of the customer |
|
| shipping_address_last_name | The last name of the customer |
|
| shipping_address_address1 | The first line of the shipping address | 10 Wind St |
| shipping_address_city | The city of the shipping address |
|
| shipping_address_country | The country of the shipping address | UK |
| shipping_address_state | The state or county of the shipping address | West Glamorgan |
| shipping_address_zip | The zip or postal code of the shipping address |
|
Note: If an order number is not present, the customer will not be imported.
How to Import Your Customers via CSV
Download a blank order CSV import file here
Fill in the required fields as detailed above
Head to your orders page and click on the UPLOAD ORDERS button
Select the CSV order channel you wish to use and select your file
Click on IMPORT ORDERS to upload and you will receive an e-mail once the import has been completed
You can then make those customers into Wholesale Customers by heading to Settings > Customers and editing their customer type