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 support@b2bwave.com and attach your Excel file. We would be happy to review this and get back to you.