Adding customs information when importing your orders via spreadsheet

Electronic customs became mandatory for some international destinations on January 1st 2019. If you have provided the required data, Click & Drop will send this information automatically whenever you pay for your labels (Personal accounts) or manifest your orders (Online Business Accounts). 
Failure to include this information may result in delays or rejections during customs clearance in the destination country. 

What countries require electronic customs?

Currently, the countries which require electronic customs are

  1. The United States of America
  2. China
  3. Brazil
  4. Portugal
  5. Russian Federation

All countries outside the EU require a CN22 or CN23 customs form. Countries within the EU do not require customs forms. In order for these to be produced by Click & Drop, check your label format settings

What information is required? 

For countries which require international customs data to be passed electronically, the required fields are:

  • Customs description
  • Customs code (HS code, harmonised system or tariff code)
  • Country of origin
  • Quantity
  • Unit price

How to include customs information in your spreadsheet

This guide will cover orders imported manually, via Dropbox, or via Click & Drop desktop.

For the basics on how to import an order via spreadsheet, please see the following guide: How to import/upload orders

If you wish to add electronic customs information via an order import, please ensure you map the following fields

Product SKU and/or Product name (The unique identifier or name of the item you are sending, ie 'Blue T shirt') 

This data is required by Click & Drop so we can store electronic customs information against your individual products/items. 

Quantity (The quantity of that item you are sending, ie '4')

Product customs code (The 6,8, or 10 digit customs (HS, harmonised system, or tariff code) code of the item you are sending, ie '22003948'
For more information, please see the following page: https://www.gov.uk/trade-tariff

Customs description (A description of the item you are sending. This description is used by customs officials to assess your items, so please ensure your description is concise and relevant, ie 'Blue cotton T-shirt')

Unit weight (The weight per single unit in kilograms, ie, 0.05)

SampleSpreadsheet.png

An example spreadsheet containing the minimum required data for two different orders to two different customers. 

For a sample spreadsheet containing the minimum required fields for an order with electronic customs, please click to download: Sample xlsx spreadsheet.

In addition to this information, there is a large variety of additional optional fields you can add to your spreadsheet, such as package size, service, and further shipping enhancements. For more information on the available fields and the data they can contain, please see the following guide: Order import field specifications