Create a valid import file for shipments

To be able to import you need an import file with all the details of your shipments.

DPD Shipper can import CSV, TXT or XLSX files, but CSV or TXT are strongly recommended.
The fields must be separated by a semicolon (;) or a pipe (|) and a header line is strongly recommended. The order of the columns doesn't matter.

The following fields can be used when creating the import file for shipments.

  • Mandatory means the field must always contain a value. Criteria means it's only mandatory in certain cases, Optional means it's never mandatory.
  • The system can also be assigned fixed values for certain fields if you can't inlude them in your CSV, TXT of XLSX file. These fixed values will then be used for each shipment.
  • Header is strongly recommended
  • The order of the columns doesn't matter.
Field Length Type Field Type* Description
*Field types: M = Mandatory, C = Criteria, O = Optional  
id_address_sender 6 number O To identify sender address assignment of import shipment orders. If not set in the file, default sender address is used. Identifier allocated from DPD Shipper admin in configuration file.
delisid 10 string O To identify correct configuration for shipment orders assignment
recipient type 1 string O Type of recipient (B for B2B, C for B2C), default:C
recipient_name 35 string M Recipient name
recipient_name2 35 string O An eventual second name of the receiver (specific department for example)
recipient_street 35 string M Recipient street. May also contain the house number.
recipient_house_no 8 string C House number of the recipient. Only mandatory if not included in recipient_street
recipient_street2 35 string O Extra address info (such as building number)
recipient_zip 9 string M Recipient ZIP code
recipient_city 35 string M Recipient city
recipient_state 2 string O State within the recipient country (applicable for USA and Canada), e.g. CA for California
recipient_country 3 number M Recipient country (ISO 3166)
recipient_language 2 string O Language of notifications for recipient (EN, NL, FR, DE). Be careful: it has to be an actual language code and not a country code. BE of GB are not valid languages. NL, FR or EN are.
recipient_phone 30 string C Recipient telephone number in international format. Example: 
+32#4771234567. Mandatory for Express shipments. Also mandatory for B2C if no email is given.
recipient_fax 30 string O Recipient fax number in international format
recipient_email 50 string C Recipient e-mail address. Mandatory for B2C if no phone is given.
recipient_note 70 string O Recipient note (extra instructions for the recipient)
recipient_reference 35 string O Recipient reference number
recipient_information 150 string O Information/instruction for delivery to courier device (POD) to displayed
product 10 String M Internal product ID (B2B, B2C, PSD,...)
services 255 string O Internal IDs of all Services (COD, SWAP, SMS, 6, TYRE, IDC...)
nops 255 string O Not used. You can ignore this.
parcel_count 3 number O How many parcels in your shipment, default:1
parcel_SWP_count 2 number C Number of parcels for return (if different than parcels number heading of recipient) default: same as parcel count, of 1
parcel_volume 9 number C Parcel volume (length/width/height) in cm without separators; In case of different volume per parcel, separate vaIues by comma (,). Only mandatory for shipments outside the EU.
parcel_weight 8 number M Parcel weight in decagrams rounded in 10 without decimal delimiter (e.g. 300 equa Is 3 kg); In case of different weight per parcel, separate values by comma (,)
parcel_note 100 string O Not used. You can ignore this.
parcel_note_back 100 string O Not used. You can ignore this.
parcel_reference1 35 string O Parcel reference number 1
parcel_reference2 35 string O Parcel reference number 2
parcel_reference3 35 string O Parcel reference number 1
parcel_reference4 35 string O Parcel reference number 2
id_check_name 35 string C Not used. You can ignore this.
id_check_number 35 string C Not used. You can ignore this.
pickup_id 6 number O Delivery to PICKUP point, global reference number of place.
pickup date 6 or 8 string O Date in two supported formats yymmdd or yyyymmdd

 

You can download our example files here.

Attention! If you open the files in a spreadsheet application such as MS Excel, numerical values that start with 0 (e.g. telephone number) are usually converted so that the 0 falls off. You can prevent this by importing the values as text instead of numbers.

 

Submitted by Dirk-Jan Dirix on Fri, 03/08/2019 - 10:22