Create a valid import file

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.
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:

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
recipient_house_no 8 string O House number of the recipient
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)
recipient_phone 30 string C Recipient telephone number in international format
recipient_fax 30 string O Recipient fax number in international format
recipient_email 50 string O Recipient e-mail address
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 (,).
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.

The order of your columns doesn't matter.

 

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