Store Level > Data > Imports > AddressBook Import

The AddressBook Import streamlines the process of importing shipping and billing addresses using a single spreadsheet into the system. 

Store Level > Data > Imports

1. Select AddressBook Import from the drop down list. Click on the 'Download Import Template' button.

2. Open the downloaded template and complete fields listed below.

There are notes associated to some fields to assist in filling out the template. These notes are listed below as well as within the template itself.

Note** Make sure when you finish to delete the 2nd and 3rd rows which is just an example user. 

Field	Notes
Import Mode	0 = Upload/Update 4 = Deletes record
AddressBookTypeID	*Required 1 = Shipping 2 = Billing
AddressBookName	*Required
AddressBookFName	*Required
AddressBookLName	*Required
AddressBookCompany
AddressBookAddress1	*Required
AddressBookAddress2
AddressBookCity/Province	*Required
AddressBookStateId	*Required
AddressBookPostalCode	*Required
AddressBookCountryId	*Required United States - Needs to entered as US. If entered as USA it could cause issues with the import.
AddressBookPhoneNum
User Identifier
DisplayOrder

3. Drag file to upload or Browse Files to choose the file and then click Import.

4. Then click Validate and Complete to upload.

When the file is uploaded, it could take several minutes to several hours for the import to be completed. The number of addresses being imported will affect how long the import takes to complete. Once the imported file has been processed, you will receive an email notifying you that it is either successful or there were issues. The email will note how many records processed successfully and the reason if any failed. 

If any records fail to import, you will want to move those records to a new template and upload that new template to complete the import.

Updated April 07, 2025 13:12