CSV field reference

This page documents every column in the Transdirect CSV import template. For multi-item orders (multiple rows sharing the same Order ID), the order-level fields are read from the first row — subsequent rows only need the Order ID and the item fields (weight, dimensions, quantity, packaging).

Template layout

The template contains exactly 23 columns, in this order:

Order ID, Goods Description, Carrier, Pickup Date, Address Type, Receiver Name,
Email Address, Phone Number, Business Name, Street Address, Suburb/Town,
Postcode, State, Country, Weight, Length, Width, Height, Quantity, Packaging,
Alcohol/Glass/Liquids, Frequent Rate, Signature Required

A template-format file must contain all 23 columns in this order — a file with missing, extra, or reordered columns is rejected. If you prefer to keep your own spreadsheet layout, the importer in the members area can also map your columns to Transdirect fields when you upload, so you are not locked to the template.

Rows that fail validation are skipped and returned to you in a downloadable errors file with a message per row; the remaining rows still import.

Order fields

Order ID

A unique identifier for the order. All items belonging to the same consignment must share the same Order ID.

Required: Yes
Multi-item: Must appear on every row

Goods description

An accurate description of the goods being shipped. This is used by couriers for customs and handling purposes.

Required: No, but strongly recommended
Multi-item: Only read from the first row per Order ID

Carrier

The preferred courier for this order. Enter the courier name as it appears in Transdirect (e.g. “Allied”, “TNT Road Express”, “Couriers Please”, “Aramex”).

Required: No
Multi-item: Only read from the first row per Order ID
Behaviour: If the specified courier is available for the route, it is automatically selected.

Pickup date

The requested pickup date in DD/MM/YYYY format (YYYY-MM-DD is also accepted).

Required: No — you can set the pickup date when booking
Multi-item: Only read from the first row per Order ID

Receiver fields

Address type

The type of delivery address.

Required: No
Multi-item: Only read from the first row per Order ID
Valid values: Business, Commercial, Residential, Private
Default: If left blank, the address is treated as business when a Business Name is provided, otherwise residential.

Receiver name

The full name of the person receiving the delivery.

Required: Yes
Multi-item: Only read from the first row per Order ID

Email address

The receiver’s email address. Used to send tracking notifications.

Required: No, but recommended
Multi-item: Only read from the first row per Order ID

Phone number

The receiver’s phone number. Used as a secondary contact for delivery.

Required: No, but recommended
Multi-item: Only read from the first row per Order ID

Business name

The business name at the delivery address. The driver uses it to locate a commercial address and hand the freight to a representative of the business.

Required: No (but always provide it for business/commercial deliveries)
Multi-item: Only read from the first row per Order ID

Street address

The street address for delivery. Do not include the suburb, postcode, or state — these are separate fields.

Required: Yes
Multi-item: Only read from the first row per Order ID

Suburb

The delivery suburb. Must match the postcode.

Required: Yes
Multi-item: Only read from the first row per Order ID

Postcode

The delivery postcode. Must match the suburb.

Required: Yes
Multi-item: Only read from the first row per Order ID

State

The state or territory for the delivery address.

Required: Yes
Multi-item: Only read from the first row per Order ID
Valid values: Two or three letter abbreviations, or full name. All of the following are accepted: NSW, N.S.W, New South Wales

Country

The destination country.

Required: No (defaults to Australia)
Multi-item: Only read from the first row per Order ID
Valid values: ISO 3166-1 alpha-2 code (e.g. AU, NZ) or full country name (e.g. Australia, New Zealand)

Item fields

These fields describe the individual items in the order. For multi-item orders, each row must include its own item details.

Weight

The weight of the item in kilograms. Decimals are accepted.

Required: Yes — must be greater than 0
Multi-item: Required on every row

Length

The length of the item in centimetres.

Required: No, but always provide it — a blank or invalid value falls back to 1 cm, which will misquote the shipment
Multi-item: Applies per row

Width

The width of the item in centimetres.

Required: No, but always provide it — a blank or invalid value falls back to 1 cm
Multi-item: Applies per row

Height

The height of the item in centimetres.

Required: No, but always provide it — a blank or invalid value falls back to 1 cm
Multi-item: Applies per row

Quantity

The number of identical items with these dimensions.

Required: No (defaults to 1)
Multi-item: Applies per row

Packaging

The packaging type for the item.

Required: No (defaults to Carton)
Multi-item: Applies per row
Valid values: Carton, Skid, Pallet, Tube, Crate, Satchel, Bag, Envelope, Other

Alcohol / Glass / Liquids

Whether the item contains alcohol, glass, or liquids. This affects courier eligibility and handling requirements — items flagged here are treated as a Wine/Beer/Liquor carton.

Required: No (defaults to No)
Multi-item: Applies per row
Valid values: Yes, Y, 1 (anything else is treated as No)

Booking option fields

Frequent Rate

Set to Yes (or 1) to quote and book the order at your Multipickup Frequent User rate instead of the everyday rate.

Required: No (defaults to No)
Multi-item: Only read from the first row per Order ID

Signature Required

Set to Yes (or 1) to add a SIGNATURE REQUIRED delivery instruction to the booking.

Required: No (defaults to No)
Multi-item: Only read from the first row per Order ID