DHL eCommerce - Trackstar

Overview

DHL eCommerce delivers invoices as positional CSVs over SFTP. Each file contains one HDR row (invoice metadata) followed by many DTL rows — one per shipment. A single DTL row may carry values in multiple charge columns; each non-zero charge becomes a separate line item in the Trackstar API.

Shape notes

No header row. The raw CSV has no column names — the downloadable sample is headerless too, matching the real file. The 79 columns always appear in the fixed order documented in Fields below. The inline example further down adds column names purely for readability.
Line type markers. Each row starts with either HDR (invoice-level) or DTL (shipment-level). Only DTL rows become line items.
Multiple charges per shipment. A shipment can populate Charge*, ZFuel*, special-handling surcharges, and taxes simultaneously. Each populated charge becomes one line item.
Totals reconciliation. The sum of all DTL charges equals the total in column 12 (Original Amount) of the HDR row — use this to verify invoice integrity.
Asterisked column names. Most column names end in * as delivered by DHL; preserved as-is.

Sample rows

Curated subset of columns (with names added for readability). The downloadable CSV is the raw DHL eCom format — 79 columns, no header row.

Sold_To*,PUDATE*,Internal_Tracking_Num:,Material_or_VAS_Desc*,ACTWeight*,Pricing_Zone*,Charge*,ZFuel*
2684030563,2026-03-27,7290846040,DHL SmartMail Parcel Ground,3.21,5,6.22,0.45
2684030563,2026-03-26,2052047713,DHL SmartMail Parcel Expedited,3.72,6,5.82,0.39
2684030563,2026-03-08,0065880238,DHL SmartMail Parcel Expedited,4.64,3,7.71,0.40
2684030563,2026-03-03,0559073905,DHL SmartMail Parcel Expedited,4.72,2,5.96,0.30
2684030563,2026-03-25,5335895286,DHL SmartMail Parcel Expedited,1.47,5,7.54,0.44

Download

Download full sample CSV (1 HDR row + 20 DTL rows, 79 columns, no header row)

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

Row markers

Column	Description	Example
`Invoice` (index 0)	Line type. `HDR` for invoice header, `DTL` for line items	`DTL`

On HDR rows, column index 2 carries the invoice number and index 11 carries the total. On DTL rows, the remaining columns below apply.

Shipment identification

Column	Description	Example
`Sold_To*`	Account number	`2684030563`
`Inv_Posnr*`	Invoice line position	`10`
`BOL*`	Bill of Lading	`001122334455`
`BillRef` / `BillRef2`	Customer billing references	`REF-00001`
`SHIPPOINT*`	Origin facility code	`USIND1`
`PickUpFrom*`	Pickup facility	`USIND1`
`PUDATE*`	Pickup date (YYYY-MM-DD)	`2026-03-14`
`PUTIME*`	Pickup time	`09:15:00`
`Internal_Tracking_Num:`	DHL-assigned tracking number	`3343983579`
`Customer_Confirm*`	Customer’s confirmation number	`3343983579`
`Delivery_Confirm*`	Delivery confirmation number

Receiver address

Column	Description
`Name*`	Recipient name
`Address1` / `Address2`	Street address
`City*`	City
`State*`	State
`Zip*`	Postal code
`Country*`	ISO country code

Service and weight

Column	Description	Example
`Material_or_VAS_Num*`	Material or VAS code	`SMP1`
`Material_or_VAS_Desc*`	Service description	`DHL SmartMail Parcel Expedited Max`
`ACTWeight*`	Actual weight	`1.18`
`UOM_ACTWeight*`	Weight unit	`LB`
`BILLWEIGHT*`	Billed weight	`1.18`
`UOM_BillWgt*`	Billed weight unit	`LB`
`Quantity*`	Package count	`1`
`UOM_Quantity*`	Quantity unit	`EA`
`Pricing_Zone*`	DHL zone	`3`
`DIM_Weight`, `DIM_Length`, `Dim_width`, `DIM_height`, `UOM DIM_WT`, `UOM_Dims`	Dimensional weight fields

Charges — base

Column	Description
`Charge*`	Base freight charge
`ZFuel*`	Fuel surcharge
`Min_PickupChg*`	Minimum pickup charge
`CustRef` / `CustRef2`	Customer-supplied refs

Charges — special service (ZZWS)

Fields ZZWS1PRI_Dropoff* through ZZWS9PRI_NEW* carry special-service charges (dropoff, sort, stamp, machine, manifest, BPM, and reserved slots).

Charges — surcharges (ZSC)

Column	Description
`ZSC1_Content_Endorsement*`	Content endorsement fee
`ZSC2_Unassignable_Addrs*`	Unassignable address fee
`ZSC3_Special_Handling*`	Special handling fee
`ZSC4_Late_Arrival*`	Late arrival fee
`ZSC5_USPS_Qualif*`	USPS qualification fee
`ZSC6_Client_SRD*`	Client-specific rate decision fee
`ZSC7_SC_Irreg*`	Surcharge irregularity fee

Charges — returns and taxes (ZRM)

Column	Description
`ZRM1_Ret_Unassn_Chg*`	Unassignable return charge
`ZRM2_Ret_Unprocess_Chg*`	Unprocessable return charge
`ZRM3_Ret_Recall_Disc_Chg*`	Recall discount return charge
`ZRM4_Ret_Dup_Mail_Chg*`	Duplicate mail return charge
`ZRM5_Ret_Cont_Assur_Chg*`	Contract assurance return charge
`ZRM6_Move_Update_Return*`	Move update return
`ZRM7_GST_Tax` / `ZRM8_HST_Tax` / `ZRM9_PST_Tax`	Canadian taxes
`ZRM10_VAT_Tax`	VAT
`ZRM11_Duties`	Duties
`ZRM12_Tax`	Other tax
`ZRM13_Paper_Invoice_Fee*`	Paper invoice fee
`ZRM14_Screening_Fee*`	Screening fee
`ZRM15_Non_Auto-Flats`	Non-auto flats charge
`ZRM16_ORM_D`	ORM-D hazardous fee

Reserved

Column	Description
`Reserved_Future_Use_1`–`6`	Reserved for future DHL use; always empty today
`Original DelCon`	Original delivery confirmation

​Overview

​Shape notes

​Sample rows

​Download

​Fields

​Row markers

​Shipment identification

​Receiver address

​Service and weight

​Charges — base

​Charges — special service (ZZWS)

​Charges — surcharges (ZSC)

​Charges — returns and taxes (ZRM)

​Reserved

Overview

Shape notes

Sample rows

Download

Fields

Row markers

Shipment identification

Receiver address

Service and weight

Charges — base

Charges — special service (ZZWS)

Charges — surcharges (ZSC)

Charges — returns and taxes (ZRM)

Reserved