Importing and exporting your customers - Revision history

Admin: /* The customers.csv file explained */

2025-12-09T02:36:49Z

The customers.csv file explained

2025-12-09T02:36:04Z

Customer Export/Import File Format

2023-03-05T23:08:35Z

The customers.csv file explained

2023-03-05T23:07:50Z

The customers.csv file explained

2023-03-05T23:06:33Z

The customers.csv file explained

2023-03-05T23:03:37Z

The customers.csv file explained

2023-03-05T22:58:48Z

The customers.csv file explained

2017-05-08T01:59:56Z

Importing Customers

2017-05-08T00:53:38Z

Customer Export/Import File Format

2015-10-07T23:36:59Z

The customers.csv file explained

@@ Line 146: / Line 146: @@
 | Credit
 | The total value of any store credit for this customer. Number to two decimal places.
 |}

@@ Line 79: / Line 79: @@
 Wholesale
 Credit
 </pre>
 The fields are explained below.

@@ Line 90: / Line 90: @@
 |-
 | Title (Optional)
-| The salutation for the customer. Valid values are Mr, Mrs, Miss, Ms, Mx, Dr, Prof, Sr, or Reverend.
+| The salutation for the customer. Valid values are Mr, Mrs, Miss, Ms, Mx, Dr, Prof, Sr, or Reverend.  This field can also be left blank.
 |-
 | First Name

@@ Line 126: / Line 126: @@
 |-
 | Accepts Marketing
-| True or False.
+| TRUE or FALSE.
 |-
 | Total Spent (Optional)

@@ Line 89: / Line 89: @@
 ! '''WHAT IS IT?'''
 |-
-| Title
+| Title (Optional)
-| The salutation for the customer. Usually Mr, Mrs or Ms.
+| The salutation for the customer. Valid values are Mr, Mrs, Miss, Ms, Mx, Dr, Prof, Sr, or Reverend.
 |-
 | First Name

@@ Line 117: / Line 117: @@
 |-
 | Country
-| The country in which the customer is located.
+| The country in which the customer is located. This field does not use abbreviations, so the full name of the country will need to be specified.  e.g. Australia, or United States, or United Kingdom.
 |-
 | Postcode (Optional)

← Older revision		Revision as of 01:59, 8 May 2017
Line 46:		Line 46:

	This will submit your import for processing. You will be taken to an import status page, where you can wait for the import to complete, or continue working elsewhere until you are notified by email that the import has finished.		This will submit your import for processing. You will be taken to an import status page, where you can wait for the import to complete, or continue working elsewhere until you are notified by email that the import has finished.
		+
		+	'''Note:''' The ''Credit'' field will always be ignored for existing customers. This field is only available when creating new customers.

	==== Customer Export/Import File Format ====		==== Customer Export/Import File Format ====