DPD - Trackstar

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`

Charge columns may also appear under alternate names — 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.

​Overview

​Shape notes

​Sample rows

​Download

​Fields

​Sender and receiver

​Identifiers

​Destination and service

​Charges

​Descriptions, measurement, references

​Dutch column aliases

Overview

Shape notes

Sample rows

Download

Fields

Sender and receiver

Identifiers

Destination and service

Charges

Descriptions, measurement, references

Dutch column aliases