Customer Import Spec Changes

Effective Thursday January 5th there will be a small update to the customer import format specification.  Currently the customer import does NOT match the customer export format exactly.  We will be updating the customer import to match exactly with the customer export format.

This change is being done to facilitate easier changes when changing via an exported customer file.

Note that all information up through the billing and shipping information columns is exactly the same as before.  The differences begin after the shipping email column.  Please see the table below to compare the old vs new customer import specification.  I have highlighted the first difference in red to make it more apparent where the differences start.

New Old
User ID User ID
Password Password
Billing last name Billing last name
billing first name billing first name
billing company billing company
billing address1 billing address1
billing address 2 billing address 2
billing city billing city
billing state billing state
billing zip billing zip
billing country billing country
billing phone billing phone
billing fax billing fax
billing email billing email
shipping Last Name shipping Last Name
shipping first name shipping first name
shipping company shipping company
shipping address1 shipping address1
shipping address 2 shipping address 2
shipping city shipping city
shipping state shipping state
shipping zip shipping zip
shipping country shipping country
shipping phone shipping phone
shipping fax shipping fax
shipping email shipping email
promotional emails send newsletter
tax exempt tax exempt
shipping same protected page access
protected page access reward total
budget original reward left
budget left budget total
reward total budget left
reward left