Importing Contacts from a File

In Tradebox, you have the option to import contact records into Tradebox from a file. This is useful if you have customers who are tax exempt or otherwise need a specific tax code for reasons other than their location (EU and ROW customers are handled automatically through settings elsewhere. Please see here for further information.)

To do this, go to the Contacts section in Tradebox and select Actions > Import, then set the Source to File.

When you click OK, this will open up a box for you to navigate to your file and select whether or not it has headers. 

Your file should be laid out with the following columns. There is a sample file attached to this article which you can use as a template. The fields in red are mandatory.

Field	Type	Example
Name	Text	Stephen Bales
Company Name	Text	Tradebox Ltd
Billing Address 1	Text	Office 18A – 20A
Billing Address 2	Text	Union Quay
Billing Address 3	Text	North Shields
Billing Address 4	Text	Tyne and Wear
Billing Postcode	Text	NE30 1HJ
Billing Country Code	Text	GB
Email Address	Text	sales@tradebox.uk.com
Telephone 1	Text	0191 257 4707
Telephone 2	Text	0191 257 4707
Website	Text	www.tradebox.co.uk
Tax Code	Number	2
Override Tax Code	Boolean	FALSE
VAT Reg No	Text	123456789

 

All columns must be present in the file, however, only Name, Email Address and Tax Code are required to be filled in. To determine the tax code number, go to Configuration in the top right of the program and then select Tax Rates. 

The number you should use is displayed in the left hand column, under No. For example, if you want the customer to be zero rated, you would enter 1 against tax code, or if you wanted them to be non-vatable, you would enter the number 4.