CSV Batch Upload Tool Guide

The CSV Batch Uploader is a great tool to save you time if you have lots of orders, want to streamline your booking process and are happy to get comfortable with spreadsheets. If that sounds like you, then read on!

With the tool, you upload and book up to 100 orders at the same time using a spreadsheet of delivery information. You can then download one file of labels, and get back to your day. 

View the tool on your dashboard. 

Below is all the information you need to master the CSV Batch Upload Tool:

  1. What is the CSV Batch Upload Tool?

  2. Blank CSV template file

  3. Input addresses correctly

  4. Where to upload your file

What is the Batch Order Uploader?

The uploader takes a CSV file of orders, books these orders with Sendle all at once, and then gives you one file of labels to download and print.

CSV stands for Comma Separated Values which is a format where data is separated by commas. Creating a CSV is simple using common applications your computer already has, such as Excel or Numbers. In most cases, it’s simply a case of saving your spreadsheet in one of these applications as a .csv file.

Looking for a head start? Then download our CSV template to get started.

Input addresses correctly

When it comes to mastering deliveries, the most important thing to know is this: it’s all in the address.

If you put in good addresses, you get out good deliveries. If you put in bad addresses, you get out bad deliveries.

With this in mind, there are 3 things to get right.

  1. Addresses

  2. Volume and/or weight of each parcel

  3. Delivery instructions

1. Addresses

There are many ways to write addresses, but there’s only 1 way that works for couriers.

Sendle’s booking system cannot verify if the address you enter is real (only that the suburb/postcode is serviceable).

This means that you must master a few important address components:

  1. Input the street name and number in the first field: sender_address_line1 and receiver_address_line1

  2. Input any descriptive information, like level, in the second field: sender_address_line2 and receiver_address_line2

  3. Input the business name in the company field: sender_company and receiver_company

  4. Use a matching suburb and postcode

The three examples below to explain addresses use the format:

Company

Address line 1
Address line 2
Suburb
Postcode
State
Country

Yes No Why?
10/60 Hopewell Street
Surry Hills
2010
NSW
Australia
10/60 Hopewell Street
Sydney 
2010
NSW
Australia
The suburb and postcode must be a matching set. Sydney’s postcode is 2000, Surry Hills’ postcode is 2010.

The Planting Shop

15 Lovers Lane
Brunswick
3056
VIC
Australia 

The Planting Shop
15 Lovers Lane
Brunswick
3056 
VIC
Australia

Use the company field for business names.

The first line is for the street name and number only. 

The Apple Shed

11B/10 Victoria Street
Level 2, Northfield Shopping Centre
Ryde
2112
NSW
Australia

The Apple Shed

Level 2, Northfield Shopping Centre
11B/10 Victoria Street
Ryde
2112
NSW
Australia

The first line is for the street name and number only.

The second line is for extra descriptive information.


2. Volume and Weight

The combination of each parcel’s weight and volume is used to determine the price of each delivery.

The volume or size of your parcel is calculated like this:

Parcel_measurements.png

  1. Measure the length, width, and height of each parcel in metres. E.g. 1.1m (height), 0.2m (length), 0.2m (width)

  2. Multiply these dimensions - height (m) x width (m) x depth (m) e.g. 0.2m x 0.2m x 1.1m = 0.044

  3. The result is the cubic volume of your parcel e.g. 0.044

For international orders, you do not need to provide a volume measurement, but your parcels must fit within the size guidelines for international sending.

The weight of your parcel is calculated in kilograms.

  1. Input the weight of your parcel without the measurement e.g. 0.25 or 5 (not 5kgs, or kilograms)

See here for more details on parcel sizes and weights.

3. Delivery Instructions

Delivery instructions are used to help the delivery driver leave the parcel in the most convenient location, or get a signature on the first attempt.

If you are unsure if the receiver of your parcel will be home on the day of delivery, it is best to leave clear and concise delivery instructions.

Notes:

  1. Authority to leave: Allows the driver to leave the parcel on the property without a signature.

  2. 500g A4 satchels must have blank delivery instructions (these are Authority to leave automatically). If you provide delivery instructions for A4 satchels, they will be upgraded to a shoebox size.

  3. You have 100 characters maximum for delivery instructions.

Where to upload my file?

To upload your correctly formatted CSV, tap 'send a parcel' on your dashboard. At the top-right, toggle the button from 'single' to 'batch'. Or, hit 'Batch Upload' at the top right from your dashboard homepage.

CSV Glossary

Column What to include in the field Example
sender_name Full name of the sender Amy Parcél
sender_email Your account email address amy.p@plantingshop.com
sender_company
recommended
Business name The Planting Shop
sender_address_line1

Building number & street name

No P.O. Boxes or parcel lockers

3/56 Freeman Lane

sender_address_line2
optional

Building name, level, additional descriptive information Level 2, Northfield Shopping Centre
sender_suburb

Suburb name

This must match the postcode entered (it cannot be the capital city or region name)

Surry Hills
sender_state_name Full Australian state name or official abbreviation NSW or New South Wales
sender_postcode

Four digit Australian postcode

This must match the suburb entered (it cannot be the capital city postcode)

2010
sender_country Australia is the only option Australia or AU
sender_contact_number Used to contact the sender if there are any issues with the pickup or delivery 0400123456
pickup_instructions
recommended

Information to help the pickup driver find your location and parcel

Maximum of 100 characters
Sendle cannot phone on approach or book a specific pickup time

If not home, parcel left in blue letterbox
receiver_name Full name of the receiver Anna Smith
receiver_email
recommended
The receiver’s email address, used for tracking notifications anna@a-smith.com
receiver_company
recommended
Business name  
receiver_address_line1

Building number & street name

No P.O. Boxes or parcel lockers

10 Apple Road
receiver_address_line2
optional
Building name, level, unit, additional descriptive information Level 2, Northfield Shopping Centre 
receiver_suburb

Suburb name

This must match the postcode entered (it cannot be the capital city or region name)

Brunswick 
receiver_state_name Full state name or official abbreviation Victoria or VIC
receiver_postcode 

 

Four-digit Australian postcode
This must match the suburb entered (it cannot be the capital city postcode)

3056
receiver_country The receivers full country name or ISO abbreviation. The selected format (full/abbreviated) must be consistent with the sender_country. Australia or AU
receiver_contact_number
recommended
Used to contact the receiver if there are any issues with the delivery or address information. +61 400123456
delivery_instructions

Maximum of 100 characters

Used to help the delivery driver find the delivery location or leave parcels in the best place.

Our delivery agents cannot phone on approach or book a specific delivery time.

For domestic orders:

500g satchels: leave this field blank. Satchels are delivered as Authority to leave.

2kg - 25kg: enter ‘authority to leave’ to give the delivery driver permission to leave the parcel without getting a signature.

Authority to leave
Leave in the letterbox

The big red building, blue door

pickup_date
optional

Format: dd/mm/yyyy

If left blank, the next available business day will be selected

04/05/2018
kilogram_weight

Weight of the parcel in kilogram

The combination of kilogram_weight and cubic_metre_volume are used to choose the parcel size

0.5 
cubic_metre_volume
domestic only

Size of the parcel, calculated in metres cubed:

height (m) x width (m) x depth (m) e.g. 0.2m x 0.2m x 1.1m = 0.044 (this means the parcel is 44 litres)

Both the kilogram_weight and cubic_metre_volume are used to determine the price of each delivery

0.044 
description This description will show up in your dashboard and in tracking emails for the receiver Planting Shop wooden planter
customer_reference This reference will show up on the label
Use to include packing instructions such as an order ID, product SKU or number of items
#REFstripe10

customs_description
international only

A description of the parcel contents for international customs Wooden pot plant
contents_value
international only
The value of the parcel contents used for international customs 45.95
country_of_origin
international only
The country where the parcel contents were manufactured, used for international customs Australia or AU

 

 

Can't find what you're looking for?

Contact us