Importing Customer Address Lists

For customers that have multiple addresses, these can be imported into your B2B Wave account and added to your existing customer profiles. Customers will then have the ability to select from a drop-down list of their available addresses at the Order Checkout page, when placing an order from your store.

Note: If you haven’t imported customers into your B2B Wave account yet, you will need to complete this step first (adding only the main address for each customer account). Follow this guide here for instructions on importing customers.

Step 1: Go to Tools > Import Addresses > select Export existing addresses:

Step 2: Download and Open the exported Excel spreadsheet. It should look similar to this:

Step 3: Insert a line under the original customer entry for each additional address you want to add for that customer. 

In the screenshots below, columns, where the information is the same as the original customer entry, will be written in green. Columns, where the information is different, will be written in red. Any column to be left blank (that isn’t blank for the original customer entry) will be highlighted in gray.

Step 4: Now you can go ahead and import the updated Excel file into B2B Wave within the Import Addresses section. Once the import has been completed you can test that it worked correctly by logging in as one of your customers > place a test order > see if the list of addresses appears on the Confirm Order page for that customer, like so:

Field Descriptions for Address Books

Name Type Description Required
address string - no
address2 string (i.e. Suite 2, Floor 5, Apt. 7000) no
city string - no
province string Two-letter ISO code for Province or State (i.e. ON, TX) no
country string Two-letter ISO code for Country (eg GB, US, CH) no
postal_code string Supports zip code and postcode values as well no
phone string - no
address_type string Include order as the value for any new address being added to an existing customer. yes
reference_code String Used by external systems for setting their own ID no
customer_id integer ID of customer (same ID for all addresses added for a customer) yes
created_at datetime Create Time auto calculated
updated_at datetime Update Time auto calculated
last_used_at datetime Last Used Time (when was this address last used for an order) auto calculated

If you run into any issues with the import or are unsure if you've formatted your Excel file correctly, please send an email to and attach your Excel file. We would be happy to review this and get back to you.

Still need help? Contact Us Contact Us