Adding customs information when importing your orders via spreadsheet

Since January 2021, there have been several changes to the information you may need to provide with any international orders. This guide covers all the changes you may need to make in Click & Drop to ensure your international orders reach their destinations without delay.

Whilst electronic advanced data is now mandatory and is captured by Click & Drop, there is a still a requirement to attach a physical CN22/23 document to the outside of your item. These are produced when you generate your label.

Please note, some destinations and services require a CN23 document regardless of shipment value, in such cases, Click & Drop will produce the appropriate CN23 for your shipment.


This guide covers how to provide electronic customs information when importing orders by spreadsheet. 


What information is required? 

The minimum required fields for all international destinations are:

  • Customs description
  • Extended customs description
  • Customs code (HS code, harmonised system or tariff code)*
  • Country of origin
  • Quantity
  • Unit price (ex-tax)

However, requirements vary between customs regions and customs schemes.

How to include customs information in your spreadsheet

This guide will cover orders imported manually or using 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. 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: Between 6 and 13 alphanumeric customs (HS, harmonised system, or tariff code) code of the item you are sending, i.e. '22003948'. With our HS code look up facility, if you have provided a customs description Click & Drop will automatically look up an appropriate HS code for you. 

Customs description: A brief description of the item you are sending. This description is used by customs officials to assess your items. Please ensure the description is concise and relevant, i.e. 'Blue cotton T-shirt'. This description will also be used to look up an appropriate HS code for the item. 

Extended customs description: A full description of the item you are sending. This description is used by customs officials to assess your items in greater detail. Please ensure the description is accurate and complete, i.e. Extra large navy blue short sleeve v-neck T-shirt, 90% cotton 10% polyester, materials from India, manufactured in Thailand.

Unit weight: The weight per single unit in kilograms, i.e. 0.05

Unit Price: The exclusive of tax value of a single unit.

Note: International shipments use exclusive of tax values, however we appreciate users may want Click & Drop to display inclusive of tax order totals. To support both these needs, Click & Drop has a series of order and order line value fields that can be used in combination as you choose. 

Sub-total(ex-tax): The order's total value excluding order-tax and shipping costs you charged your customer. This will be used to declare the total value of a shipment for customs.

Total: The total value of an order including tax but excluding retail shipping costs. 

Order tax: The total value of tax paid by the user on the order


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

Providing accurate Customs Codes

Using tools from our partner, Hurricane Modular Commerce, we can help you find the correct customs code for your products.
Provide a customs description in your sheet and upon import we'll apply the best description and customs code for you to use. You can disable automatic HS code look up in your customs settings.

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

What if my customer's order contains more than one different product?

If your order contains more than one type of product, you will need to include multiple rows in your spreadsheet per order.

Each line will contain the same name and address data, but the fields for product data will be different.

In order for Click & Drop to recognise that different lines in your spreadsheet belong to the same order, you will need to ensure that each line contains the same order reference number

In our example below, two lines in the spreadsheet contain the same name and address data, but the product data is different. As we have mapped the order reference number field, and both lines have the same order reference value, Click & Drop will add both lines of product data to the same order.



Our created order now contains product details for all three of the T-shirts that John Smith has ordered.