CSV field reference

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

Template layout

The template contains 24 columns, in this order. The first 23 are the standard columns, and the last, Delivery Instructions, is optional:

Order ID, Goods Description, Courier, 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, Delivery Instructions

When you import, you match your columns to Transdirect fields on the Map Columns step, so your file does not have to follow the template’s order or headings. A file in the template layout is matched automatically. Older exports that use the heading “Carrier” instead of “Courier” are also accepted. CSV, XLSX and XLS files are accepted.

Eight fields must be matched to a column before you can continue: Order ID, Receiver Name, Street Address, Suburb / Town, Postcode, State, Country and Weight. The Country column can be blank, but it must be in the file.

An import is limited to 1,000 rows (not orders: a multi-item order uses one row per item) and a 10 MB file per upload.

A row missing a required value is shown with an error message before you import, and the import button stays disabled until every error is fixed. Only a failure Transdirect can detect at import time, such as a reused Order ID, skips just that order while the rest of the file still imports.

Text fields have maximum lengths: Order ID, receiver name, phone, business name and street address 255 characters, Courier 100, Email Address 65, Postcode 25, State 25, Country 65, and Delivery Instructions 20. A row with a longer value is refused.

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

Note

An Order ID can only be imported once. If an order with the same ID already exists in your account, the row is rejected with “Order ID already used”, unless you tick Update existing orders on the Configure step. Orders that are already booked, shipped or cancelled are never updated.

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

Courier

The courier you would like to use for this order, for example Aramex or Couriers Please. It is saved with the order as a preference: you still compare quotes and choose the courier when you book. The older column heading “Carrier” is also accepted.

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

Tip

Leave this field blank to compare all available couriers and choose one when you book.

Pickup date

The requested pickup date in DD/MM/YYYY format (YYYY-MM-DD is also accepted). Dates are always read day first, so 08/11/2026 is 8 November.

• Required: No. You can set the pickup date on the Configure step or when booking.
• Behaviour: A blank, unreadable or past date becomes the next business day, and a Saturday or Sunday moves to the Monday.
• 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, in any case
• Default: Residential. A blank cell is imported as residential even when a Business Name is filled in, so set Business for every business delivery.

Note

Business and Commercial are treated identically. Residential and Private are treated identically.

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. An Australian mobile that lost its leading zero in a spreadsheet, such as 412345678, is read as 0412345678.

• 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. A spreadsheet that drops the leading zero is fixed for you: 800 is read as 0800.

• 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: The abbreviation or the full name, in any case, for example NSW or New South Wales. Anything else is flagged as a warning in the preview.

Country

The destination country.

• Required: The column must be matched, but a blank cell is read as Australia
• Multi-item: Only read from the first row per Order ID
• Valid values: AU, AUS or Australia for Australian addresses

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, and 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 does not block the import, but the order is saved without that measurement and cannot be quoted until you add length, width and height on the Orders page.
• Multi-item: Applies per row

Width

The width of the item in centimetres.

• Required: No, but always provide it. A blank or invalid value does not block the import, but the order is saved without that measurement and cannot be quoted until you add length, width and height on the Orders page.
• Multi-item: Applies per row

Height

The height of the item in centimetres.

• Required: No, but always provide it. A blank or invalid value does not block the import, but the order is saved without that measurement and cannot be quoted until you add length, width and height on the Orders page.
• 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, in any case. Any other value is imported as Carton, so check the preview.

Alcohol / Glass / Liquids

Whether the item contains alcohol, glass, or liquids. This affects courier eligibility and handling: 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 or true, in any case (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

Note

Frequent rates are switched on for new Transdirect accounts by default. See Multipickup and frequent rates.

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

Delivery Instructions

A short note for the driver, such as Deliver before 3pm. It is printed on the label, so it has the same 20-character limit as the Delivery Instructions box on the booking form. A longer value is not cut short: the row is rejected with an error so you can shorten it.

These headings are also accepted for this column: Delivery Instruction, Special Instructions, Special Instruction, Instructions, Delivery Notes and Delivery Note.

• Required: No
• Max length: 20 characters
• Multi-item: Only read from the first row per Order ID

Other fields you can map

When you upload your own layout, you can also map columns to Sale Price, Buyer Name and Buyer Email. These are not in the template. Sale Price is also used as the booking’s declared value, which sets transit warranty cover.

Next steps

• See example CSV rows
• Back to CSV import overview