Overview
If your eCommerce platform is not on the list of supported platforms you can extract your orders from a CSV file and import it into DHL Express Commerce.
Learn how to map your CSV file, so your orders can be imported into DHL Express Commerce.
You can use our default CSV file, or customise your own CSV file.
1. CSV file requirements
- You must add one piece of data per column.
- You must add one item per line (if there are two items in one order, add two lines with the same order number).
- Each order number must be unique.
In Settings > CSV File you have the following import options:
-
Use the preformatted template
Download the DHL CSV template containing default field mappings.
-
Use the WIX CSV template
If you are using Wix you can extract your orders from WIX and import them in DHL Express Commerce using CSV.
To map your spreadsheet data to our column headers, you need to select rows from the 'Available Column' section and drag and drop them into the 'CSV File Columns' section. You can't delete the required columns in the right-hand side section however, you can reorder them to based on your business needs.
-
Map your own customised CSV
You can use your own CSV and map the column in DHL Express Commerce. The mapping interface has two columns. The column on the left represents all available fields available, and the column on the right represents your CSV file.
TIP! You'll need to drag and drop the labels, so the label on top will be the first column of your CSV file. The second label will be the second column of your CSV file. Make sure that you save your changes.
2. Importing a CSV file
- In the Orders screen, click Import, then select Upload CSV File.
- Select a CSV file from your computer, then click Import CSV.
- Click Close, when the import is complete.
3. Automatic CSV File Import
Importing CSV orders is possible via FTP. See this article for more information.
4. CSV Field Definitions and Specifications
Name |
Details |
Requirement |
Max Field Length |
|
OrderNumber |
A unique reference for the shipment. Usually Order Number, but could be invoice number, pick slip number, etc. |
Mandatory |
50 |
|
Date |
The date the order was created. |
Mandatory |
10 |
|
Name |
The customer's name. Usually first name and last name. |
Mandatory |
100 |
|
Building |
The building name/number, flat number, store number - any addressing information that is not strictly part of the street address. |
Optional |
100 |
|
Street |
The recipient's street name and number (eg 23 Underwood Street). |
Mandatory |
100 |
|
Suburb |
The recipient's suburb (eg Highbrook). |
Mandatory |
100 |
|
City |
The recipient's city/town (eg Auckland). |
Mandatory |
100 |
|
Postcode |
The recipient's postcode number (eg 2013). |
Mandatory |
10 |
|
State |
The recipient's state (eg California). If sending to a region that does not use states, leave this blank. |
Optional |
100 |
|
Country |
The recipient's country name or country code (eg New Zealand or NZ) |
Mandatory |
100 |
|
|
The recipient's email address. Can be used to send the customer delivery notifications. |
Optional |
100 |
|
Telephone |
The recipient's phone number. Can be used to send the customer delivery notifications (if a mobile number is specified). |
Optional |
100 |
|
ItemName |
The name of the product to be shipped (eg "Banana").Note: if there are multiple products, specify them in another row. |
Optional |
100 |
|
ItemPrice |
The value of the product to be shipped (in your default currency). |
Optional |
10 |
|
Instructions |
Delivery instructions for the shipment (eg "Deliver to back door"). |
Optional |
200 |
|
Weight |
Individual weight of each product to be shipped in KGs. |
Optional |
4 |
|
ShippingMethod |
Shipping Method is typically which delivery option your customer has selected on your website. |
Optional |
100 |
|
Reference |
An optional secondary reference to this shipment (eg "Cost Center"). |
Optional |
50 |
|
SKU |
Product SKU for the product to be shipped. |
Optional |
50 |
|
Qty |
Quantity of the product in the shipment. |
Optional |
50 |
|
Company |
The Company Name of the recipient (eg "Acme Inc."). |
Optional |
100 |
|
SignatureRequired |
Set flag Y/N to apply the extra service of signature required for shipment |
Optional |
1 |
|
ATL |
Set flag Y/N to apply the extra service Authority To Leave |
Optional |
1 |
|
CountryCode |
Country code of the recipient's address (eg "NZ"). |
Optional |
2 |
|
PackageHeight |
Height of the parcel(s) |
Optional |
4 |
|
PackageWidth |
Width of the parcel(s) |
Optional |
4 |
|
PackageLength |
Length of the parcel(s) |
Optional |
4 |
|
Carrier |
Set the Courier you wish to ship the item with. |
Optional |
100 |
|
CarrierProductCode |
Set the Service Code to use for this delivery. This allows you to assign the delivery service for this order. |
Optional |
3 |
|
CarrierProductUnitType |
The Unit Type of the shipment (Available options are Carton, Pallet, Skid, Satchel, Jiffy, Bag). |
Optional |
50 |
|
Declared Value Currency |
Put an alphabetic currency code value in this field if you want your customs declaration to be displayed in a different currency, for example if your shop sells items in USD. |
Optional |
3 |
|
Code |
HS Tariff Code for this item. |
Optional |
50 |
|
Colour |
Product colour. |
Optional |
50 |
|
Size |
Product Size. |
Optional |
50 |
|
Contents |
Description of item you are sending (this will be displayed on the shipping label) |
Optional |
50 |
|
Dangerous Goods |
Set flag to Y/N this will apply the dangerous goods configured in your profile to the shipment |
Optional |
1 |
|
Country of Manufacturer |
Country of where the item was manufactured input as country name |
Optional |
50 |
|
DDP |
Set flag to Y/N this will apply the extra service of Delivery Duty Paid for shipments |
Optional |
1 |
|
Receiver EORI |
Input receiver's EORI tax registration number |
Optional |
50 |
|
Receiver VAT |
Input receivers VAT tax registration number |
Optional |
50 |
|
ShippingFreightValue |
Allows you to provide the shipment freight charge for customs purposes |
Optional |
50 |