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.