Overview
DPD delivers invoice data via the DPD Insights portal. Each file is one invoice’s worth of shipments, with one row per shipment (parcel). Columns use English names; DPD also accepts a set of Dutch-language column aliases for the key identifier and charge fields (see Dutch column aliases below).
Shape notes
- Semicolon-delimited, not comma. DPD uses
; as the column separator. Standard comma-CSV readers will misread DPD files.
- One row per shipment. Each row is one parcel. A row may populate several charge columns (base price, fuel, toll, etc.); each non-zero charge becomes one line item in the Trackstar API.
- Tracking number is the parcel number. DPD’s
Parcel number column maps to tracking_number. Shipment number is a separate DPD reference, not the tracking number.
- Quoted reference values. DPD occasionally wraps a reference value in quotes to protect an embedded semicolon (e.g.,
"RF_103326;").
- Dates are
YYYYMMDD or DD.MM.YYYY. Both are accepted — no separators in the former (e.g., 20260331), dots in the latter (e.g., 31.03.2026).
Sample rows
Curated subset of columns for readability. The downloadable CSV has all 43 columns.
Invoice number;Invoice date;Customer number;Parcel number;Service;Base price;Energy surcharge;Total amount
26840305;20260331;63196946;79184603396001;Express;8.62;0.35;9.80
05566517;20260331;66888433;77960076935433;Shop Delivery;7.75;0.63;10.02
60987472;20260331;76964474;74069815441672;Shop Return;5.37;0.84;11.07
23132839;20260331;33439835;41425546063107;Classic;13.24;0.52;25.57
29556504;20260331;52571506;59507496384122;Classic;4.90;0.63;13.88
Download
Download full sample CSV (1 header row + 25 data rows, 43 columns, semicolon-delimited)
All sample data is synthetic. Tracking numbers, account numbers, addresses, and reference fields are fabricated and do not correspond to any real shipments or customers.
Fields
Sender and receiver
| Column | Description |
|---|
Sender name / Sender name 2 | Sender identity (DPD relay + merchant name) |
Receiver name / Receiver name 2 | Recipient name lines |
Sender address / Sender ZIP / Sender city / Sender country | Sender address |
Identifiers
| Column | Description | Example |
|---|
Type | Shipment type (P = parcel) | P |
Quantity order | Items in the order | 1 |
Customer number | Customer account — maps to account_id | 63196946 |
Customer name | Customer display name | Acme Logistics NL B.V. |
Invoice number | Invoice ID — maps to invoice_id | 26840305 |
Invoice date | YYYYMMDD — maps to transaction_date | 20260331 |
Parcel number | DPD parcel tracking number — maps to tracking_number | 79184603396001 |
Shipment number | Separate DPD shipment reference | 368264 |
Destination and service
| Column | Description |
|---|
Destination zone | NL, EU, INT |
Commercial destination country | ISO country code |
Service | Service name (Classic, Shop Delivery, Shop Return, Express) |
Shipment date | YYYYMMDD |
Charges
Each populated charge column becomes one Trackstar line item. The charge_description is set to the column name.
| Column | Description |
|---|
Base price | Base freight charge |
Energy surcharge | Energy / fuel surcharge |
Toll surcharge | Road toll surcharge |
Peak surcharge | Peak-period surcharge |
System return surcharge | System return fee |
Oversized/Overweight surcharge | Oversize / overweight fee |
Customs surcharge | Customs handling fee |
Total other surcharges | Miscellaneous surcharges |
Total amount | Row total (sum of all populated charges; informational, not a separate line item) |
VAT percentage | VAT rate applied |
Descriptions, measurement, references
| Column | Description |
|---|
System return date / System return description | Context for a system return surcharge |
Oversized/Overweight description | Context for an oversize / overweight surcharge |
Date of measurement / Depot of measurement | When / where the parcel was measured |
Weight | Parcel weight (grams) |
Length / Width / Height / Girth | Dimensions (cm) |
Customer parcel reference 1 | Customer’s parcel reference (typically order number) |
Customer shipment reference 1 | Customer’s shipment reference |
Other surcharges codes | Comma-separated codes for any itemized other surcharges |
Dutch column aliases
For Dutch-language files, DPD recognizes the following column aliases for the key fields. Where a row uses the Dutch name, it maps to the same Trackstar field as its English counterpart.
| Trackstar field | English column | Dutch alias |
|---|
invoice_id | Invoice number | Factuur |
transaction_date | Invoice date | Factuurdatum |
account_id | Customer number | Relatienummer |
tracking_number | Parcel number | Pakketnummer |
Tarief (base freight), Toeslag (surcharge), Totaal (total), and COD Toeslag (cash-on-delivery). As with the English charge columns, each populated charge becomes one line item with the column name as its charge_description.
