DPD - Trackstar

Overview

DPD delivers invoice data via the DPD Insights portal. Each invoice comes with a PDF and a spreadsheet of its shipments: a semicolon-delimited CSV for recent invoices, or an XLSX file for older ones. The spreadsheet has one row per shipment (parcel). Columns use English names; some DPD files use other names for the key identifier and charge columns (see Alternate column names below).

Files you’ll receive

Trackstar downloads every document DPD attaches to an invoice and serves it unchanged through the Files endpoint, under the file name DPD gives it.

File	`file_type`	When it appears	Line items
Invoice PDF	`pdf`	Every invoice	None
Invoice CSV (semicolon-delimited)	`csv`	Recent invoices	One per non-zero charge
Invoice XLSX	`xlsx`	Older invoices, in place of the CSV	One per non-zero charge

Grouped per invoice. Each file’s id contains a folder named {invoice number}_{YYYYMMDD} (the invoice date), so the PDF and spreadsheet for one invoice share a folder. file_name is DPD’s own file name. Files collected before mid-October 2026 are not grouped this way.
Invoice number and date can be blank. XLSX files, and older CSVs with a dash in the file name, leave the Invoice number and Invoice date columns empty. Trackstar fills invoice_id and transaction_date from the invoice the file belongs to instead.
The same invoice can arrive twice. Each daily sync starts on the date the previous one ended, so invoices dated on that shared day are downloaded by both and appear as two sets of files. Line items are not duplicated: both copies produce the same line-item ids. If you process the raw files yourself, de-duplicate by invoice number.
Failed exports. DPD occasionally produces a CSV whose only content is the line ODS data retrieve failed. These files produce no line items.
XLSX files are binary spreadsheets, not semicolon text. Trackstar reads their rows by the same column names as the CSV.

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.
Quotes can hide a real separator. DPD sometimes wraps a value in double quotes with the following ; inside them, for example "RF_103326;". That ; is a real column separator, not part of the value. A standard CSV reader treats it as text and returns a row one field short (42 instead of 43), with every later column shifted left. Trackstar removes all double quotes before splitting, which restores the full row. Do the same if you parse DPD files yourself. In this example, Customer parcel reference 1 is ORD-104381 and Customer shipment reference 1 is empty:
...;Girth;Customer parcel reference 1;Customer shipment reference 1;Total amount;VAT percentage;Other surcharges codes ...;76;"ORD-104381;";9.80;21;
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`. Blank in XLSX and dash-named files	`26840305`
`Invoice date`	`YYYYMMDD`; maps to `transaction_date`. Blank in XLSX and dash-named files	`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

Alternate column names

Some DPD files use other names for the key fields. Where a row uses one of these names, it maps to the same Trackstar field as its English counterpart.

Trackstar field	English column	Alternate name
`invoice_id`	`Invoice number`	`Factuur`
`transaction_date`	`Invoice date`	`Factuurdatum`
`account_id`	`Customer number`	`Relatienummer`
`tracking_number`	`Parcel number`	`Pakketnummer`

These files can also carry charge columns that the English file doesn’t have. Each populated one becomes a line item with the column name as its charge_description, the same as the English charge columns.

Column	Meaning
`Tarief`	Base freight (tariff)
`Toeslag`	Surcharge
`Fuel surcharge`	Fuel surcharge
`mautpreis`	Road toll
`verzoll_gebuehr`	Customs fee
`COD Toeslag`	Cash-on-delivery surcharge
`Totaal`	Total

Unlike Total amount in the English file, Totaal is treated as a charge column, so a non-zero Totaal becomes its own line item alongside the other charges on the row.

Mapping to invoice line items

Trackstar field	Source
`id`	Base64 of `{Invoice number}-{Parcel number}-{Shipment number}-{Invoice date}-{charge column}`, leaving out blank parts. The same charge gets the same `id` even when its invoice is downloaded twice
`tracking_number`	`Parcel number` (or `Pakketnummer`)
`invoice_id`	`Invoice number` (or `Factuur`), falling back to the invoice the file belongs to
`account_id`	`Customer number` (or `Relatienummer`)
`transaction_date`	`Invoice date` (or `Factuurdatum`), falling back to the invoice’s date. `Shipment date` stays in `raw`
`charge_description`	The charge column’s name, e.g. `Energy surcharge`
`gross_cost` / `net_cost`	Both set to the charge column’s amount. DPD files carry no separate discount
`raw`	The full row, with double quotes removed and surrounding whitespace trimmed

​Overview

​Files you’ll receive

​Shape notes

​Sample rows

​Download

​Fields

​Sender and receiver

​Identifiers

​Destination and service

​Charges

​Descriptions, measurement, references

​Alternate column names

​Mapping to invoice line items

Overview

Files you’ll receive

Shape notes

Sample rows

Download

Fields

Sender and receiver

Identifiers

Destination and service

Charges

Descriptions, measurement, references

Alternate column names

Mapping to invoice line items