Import & Export Customers

If you would like to import or export customers in bulk, you can do so using .XLS files.  

Import from Excel template

Open the Customers Page by clicking the 'Customers' icon on your left-hand menu.

distribute_createcustomer_1

 

Click 'Import' along the top toolbar

distribute_importcustomer_1

 

And the Customer Import panel will appear.  You can click 'Start' to upload or link to a Customer Import file.

distribute_importcustomer_2-1

Customer Import Template

If you need a template to help import your customers, click 'Download a sample file' to download the Excel template. Open and edit the template file and fill in the information for your customers.

distribute_importcustomer_3

The red and green labels at the top of the spreadsheet will explain the various fields.

 

Once you've completed the spreadsheet, you will need to upload it to Brandboom. Click 'Start' to upload the file from your computer or link from another location.

Multiple Shipping Addresses

Importing Additional Shipping Addresses through Excel 

If your customer has multiple shipping addresses, pay attention to the "Type" column on the Customer Template.

  • Enter "B" under Type to indicate a billing address.
  • Enter "S" under Type to indicate a shipping address. You can use Customer Code 2 to identify different shipping addresses for one customer.
  • If the Type Column is left blank, customer information in that row will be imported as a Billing & Shipping address.

 

Export Customers

IF you need to export your Customers, click the 'Export' button in the toolbar.

distribute_importcustomer_4

 

Next, click the 'Export' button and you should receive an email with a download link for your export template.

distribute_importcustomer_5

 

NOTE: Password-protected files cannot be imported.