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.