Import & Export Customers

Import from Excel template


Open the Customers Page by clicking the Customers icon in your left hand panel.

Screen Shot 2019-11-28 at 2.49.22 AM

 

Click "Import" along the top toolbar

 

And the Import Customers window will appear. 

Screen Shot 2019-12-13 at 4.10.38 PM

Click "Customer Template" to download the Excel template. Open and edit the template file and fill in the information for your customers.

  • 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. Choose the file from your computer and click Import File.

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 Products

From the Customers Page, click the Export button in the toolbar and an .XLS file should be downloaded to your computer.

Screen Shot 2019-12-11 at 12.24.39 PM

 

Next click the export button and you should be able to download the data