The headings can be in any column-order as long as they are contained in first non-blank row of the uploaded file. The heading values and their expected data are:
Heading Title | Description |
---|---|
gender | If Configuration->Customer Details->Email Salutation is set to true, the value must be one of m, M, male, f, F, or female; otherwise, the value is ignored. |
first_name | The minimum length is controlled by Configuration->Minimum Values->First Name; if that value is 0, this field is optional. |
last_name | The minimum length is controlled by Configuration->Minimum Values->Last Name; if that value is 0, this field is optional. |
dob | If Customer Details->Date of Birth is set to true, the minimum length is controlled by Configuration->Minimum Values->Date of Birth and date must be in the format chosen from the "DOB Format" drop-down menu. |
Required, the minimum length is controlled by Configuration->Minimum Values->Email Address. Regardless of minimum length, the value must be a "proper" email address and must not already be used by another customer in your database. | |
company | If Configuration->Customer Details->Company is set to true, the minimum length is controlled by Configuration->Minimum Values->Company; otherwise, the value is ignored. |
street_address | The minimum length is controlled by Configuration->Minimum Values->Street Address; if that value is 0, this field is optional. |
suburb | If Configuration->Customer Details->Address Line 2 is set to false, this field is not displayed; otherwise, the field is displayed but is optional. |
state | If Configuration->Customer Details->State is set to false, this field is ignored; otherwise, either this field or the zone_id field must be specified. The minimum length of this field is controlled by Configuration->Minimum Values->State; if that value is 0, this field is optional. Either the long-form or code, e.g. Alabama/AL (United States) or British Columbia/BC (Canada), can be used. |
zone_id | If Configuration->Customer Details->State is set to false, this field is ignored; otherwise, either this field or the state field must be specified. The numeric zone_id associated with the customer's state and country. |
city | The minimum length is controlled by Configuration->Minimum Values->City; if that value is 0, this field is optional. |
postcode | The minimum length is controlled by Configuration->Minimum Values->Postcode; if that value is 0, this field is optional. If the value is specified and the associated country is one of Canada, the United Kingdom or the United States, then the value must match the Post Code format for that country. |
country | This field is required and must be one of the 2-character ISO codes for a country supported by your zen-cart. |
telephone | The minimum length is controlled by Configuration->Minimum Values->Telephone Number; if that value is 0, this field is optional. If the value is specified, its format must conform to that of a world phone number. |
fax | This field is optional. |
newsletter | Identifies whether (1) or not (otherwise) the customer is to be registered for a newsletter subscription. If the field is not supplied, the customer is not subscribed to your newsletter. |
send_welcome | Identifies whether (1) or not (0) to send a "welcome" email to the user. If the field is not supplied, no welcome email will be sent. |
If you don't know how to make a Comma-Separated Value (CSV) file, then use Microsoft Excel as normal to create a spreadsheet sheet. When you are ready to save, choose file>save as then at the bottom there will be a 'Save as type' option; choose 'CSV (comma delimited)' and then press Save. Answer yes to any warnings and there you have it... a csv!
PRO-Webs v1-05 Modification of existing contribution by: Rick Riehle