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 |