Import CSV File

 

Import CSV File

If you need to send out multiple shipments, our spreadsheet/csv upload tool will allow you to quickly and easily organise your manual shipments in an easy to use format. You can either use our template or use your own.

 

Instructions below:

 

1. Login to your Transdirect Account and select Orders

image2

 

 

2. You can download and use the template file to import bulk orders

 

Click the Question mark icon to read instructions on how to download and import CSV file.

 

Select the link “template.csv” as displayed below for the format.

 

image4

 

Fields Details on CSV:

 

Order ID:

A unique order ID for your customer allows us to identify all the items that you are shipping as each item with different measurements and/or weights is required to be on a separate line.

To book multiple items with different sizes or weights on the one consignment, you will need to have each item on a separate line with the same Order ID on each line.

  • This field is optional.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 255

Goods Description:

It is important that we have an accurate description of the items you are sending to ensure it is processed and handled appropriately. Please enter a description of the items that allows our team to identify the items.
This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is: 65,536

Carrier:

Please enter the preferred carrier for your booking from the following list. If this carrier is able to offer the service level, the carrier will be selected automatically to save you time in the booking process. If the carrier is not able to service this request, a list of all available options will be presented to you before the booking is submitted.
If a multi-pickup service is offered by this carrier and enough orders are submitted in this upload, this will automatically submit this as a multi-pickup request.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is optional.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • The available options for this field are 255

 

Pickup Date:

The pickup date is the day that your freight will be ready for collection; the required format is DD/MM/YYYY and is only available to enter from the following business day.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.

 

Address Type:

Our carriers will need to know if the address for delivery is zoned as a business or a residential address to assist them in planning the delivery. Restrictions apply for certain vehicle types in residential areas and delays can occur if an address is not accurately declared.

If the delivery is to a business, the driver will be looking for a commercial building with a business name and a representative of the business who can sign for the items.

Valid entries for this are: ‘Business’, ‘Commercial’, ‘Residential’, ’Private’

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Maximum character length is 11

 

Receiver Name:

The name of the person who will be receiving this delivery, this person will be contacted if we need to clarify any information that may be required to complete the delivery.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

This field is mandatory.

  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 255

 

Email Address:

We will contact the receiver and provide information on how to track the booking once the order has been confirmed with the carrier. We may also contact the receiver via email if we need to confirm any additional information on the booking.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: Valid Email
  • Maximum character length is 255

 

Phone Number:

We require 2 contact points for the receiver if we need to confirm any additional information to assist in completing the delivery.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 255

 

Business Name:  

If the delivery address is to a commercial premises, the driver will need to know the name on the building to locate this correctly and to ensure the freight is handed over to a representative of this business.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • If the Receiver Address Type is Commercial, this field is mandatory.
  • If the Receiver Address Type is Residential, this field is not required and will be ignored.
  • Maximum character length is 255

 

Street Address:

This is the address of the receiver, not including the town/suburb and postcode, that we will be used to complete delivery. Please include any information such as Building Name, Unit Number, Street Number etc to assist us in locating the delivery address.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 255

 

Suburb/Town:

The suburb/town name in conjunction with the post code will determine the list of available carriers that can service your booking and the cost to transport the items. For us provide an accurate quote and ETA for delivery we require accurate addresses information.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 255

 

Postcode:

The post code is required and will need to match the Suburb/Town name entered. If this information does not match, you will need to update this once the data has uploaded before a quote can be provided.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 25

 

State:

The state the delivery address is located in, either the 2-3 letter abbreviation or the full state name is acceptable. Eg.  ‘NSW’,’N.S.W’ and ‘New South Wales’ would be acceptable inputs.

This information is only required on 1 line per Order ID. If you are entering multiple lines of data, you are only required to enter this on 1 line that contains the same Order ID.

  • This field is mandatory.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 25

 

Country:

The country the delivery is to occur in. This field is optional and if not included, this will default to Australia. You can enter either the 2 letter abbreviation code for that country or enter the name in full. Eg. ‘AU’ and ‘Australia’ are both valid values.

  • This field is optional.
  • Allowed Characters: A-Z, 0-9, Special Characters*
  • Maximum character length is 65

 

Weight:

The item weight in kilograms, rounded up to the nearest whole kilogram.

  • This field is mandatory.
  • Allowed Characters: Valid Number
  • Maximum character length is: Total 10 digits and 2 decimal places.

 

Length:

The items length in centimetres, rounded up to the nearest whole centimetre.

  • This field is mandatory.
  • Allowed Characters: Valid Number
  • Maximum character length is: Total 10 digits and 2 decimal places.

 

Width:

The items width in centimetres, rounded up to the nearest whole centimetre.

  • This field is mandatory.
  • Allowed Characters: Valid Number
  • Maximum character length is: Total 10 digits and 2 decimal places.

 

Height:

The items height in centimetres, rounded up to the nearest whole centimetre.

  • This field is mandatory.
  • Allowed Characters: Valid Number
  • Maximum character length is: Total 10 digits and 2 decimal places.

 

Quantity:

The number of items in this order matching the dimensions provided in the previous fields for this entry. If there are more items in this order however the dimensions do not match those that have been entered on this line, enter them on a separate line however ensure the order number field contains the same value.

  • This field is mandatory.
  • Maximum character length is 11

 

Packaging:

Description of how this item is packaged, is this in a carton, a box, packed on a pallet or inside of a wooden crate?

Valid inputs are:  Carton, Skid, Pallet, Tube, Crate, Satchel, Bag, Envelope, Other

  • This field is mandatory.
  • Maximum character length is 8

 

Alcohol/Glass/Liquids:

If this item contains alcohol, glass or liquids, the carrier will need to know to ensure it is handled appropriately by their staff. By entering ‘Yes’ or ‘No’ in this field, the shipping label will include a clear instruction advising the contents will need to be packed for transit appropriate to their contents.

This field is optional, by leaving this field blank or not including it in your spreadsheet, this will automatically default to No. You can also enter ‘y’ or ‘n’ into this field.

  • This field is optional.
  • Allowed Characters: Yes, No, Y, N
  • Maximum character length is 3

 

3. Select the IMPORT CSV button and select the CSV file from your PC that contains your order details

 

4. Click on the IMPORT button to upload all orders from CSV file

 

5. After the .csv file has been imported successfully, a list of orders will be displayed

  • You can select one of the orders that synced from your store
  • Click “BOOK NOW” dropdown and select “Book” to continue booking

 

  • Fill all details on the Quickbook screen in order to complete the booking.

 

Outline of sample spreadsheet examples:

 

Row 2, Order ID PO1000:

Order contains 1 carton to a business address.

 

Row 3, Order ID PO2005:

Order contains 1 carton to a residential address

Business name has been left blank as this is not required

 

Row 4, Order ID 11:

This has been provided to demonstrate a similar example to rows 2&3 however the ‘Address Type’ field contains a variant of Commercial, rather than Business which is still expected to produce the same outcome in our system.

 

Row 5, Order ID 10:

Order contains 1 ‘other’ type of packaging to a commercial address.

We’ve got you covered. Send with Transdirect and start saving today!Get a Quote