Importing/exporting trade customers in bulk
You can import trade accounts in bulk onto your account using a spreadsheet upload. These trade customers will then be able to login to their accounts on your website as if they’d created an account themselves.
Additionally, you can also take an export of all of the trade accounts that currently exist on your account.
Exporting trade customers
To export your trade customers into a CSV spreadsheet select Export:from the menu. In the top right corner select
A box will then appear. Select prepare your export and allow the system to process your spreadsheet:
Once the system has finished processing the spreadsheet select download your export and the file will be downloaded to your computer’s hard drive:
Preparing the import file
By using a spreadsheet upload you can import trade accounts in bulk to your account. The spreadsheet must be in a specific format in order to process correctly.
To obtain a template of the spreadsheet select Import:from the menu. In the top right corner select
A new box will appear. Select download the import template here:
An editable CSV file of the template will then be downloaded to your computer's hard drive.
Each trade customer should be placed on a new row of the spreadsheet.
The template has the following fields to be filled in:
Date Of Birth
Address Line 1
Address Line 2
Address Line 3
In this field place the name of the country the customer is from. The name of the country must be entered according to the names specified in the system. If you don't use the approved name the country information will not import correctly. Download the list of countries here:
Enter a password for the customer’s account which they will then be able to change later.
Reward Points Balance
This field will be available to you if you are using the reward points app.
If the trade customer is to be given a global discount enter it in this field, using only numbers.
If the trade customer has a credit account enter Yes here.
Trade Pricing Band
If you are using the trade pricing bands feature enter the exact name of the band in this field. If the name does not exactly match a trade pricing band it will not work.
This field will be available to you if you are using the how you heard about us app.
Additional Data 1
In the 5 additional data fields you can enter any internal notes you want to store on the trade customer’s account.
Additional Data 2
Additional Data 3
Additional Data 4
Additional Data 5
Saving the spreadsheet
In order to successfully upload, the spreadsheet needs to be saved as a CSV file. If you are using an Apple computer save the file as a ‘Windows Comma Separated (.csv)’ file. The upload will not process if the spreadsheet is in any other format.
Importing the file
To upload your file and import the trade accounts go back to your ‘Trade Accounts’ page and select Import to see this box again:
Select Choose file and find the spreadsheet in your computer’s hard drive.
Once you have attached the file select import.
Allow the system to process the file. If you are uploading a large file it might take some time to process, but don't navigate away from the page. Once the file has uploaded you will see an 'Import completed' success message.