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