Formatting a CSV File for Bulk Upload (Add Customers from Admin, Zen Cart 1.5.0 and later)

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.
email 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