COVID-19 update: Sendle continues to deliver! Find out what we are doing to ensure your shipments are delivered reliably and safely.

How to book multiple orders at once - CSV batch upload

The CSV Batch Uploader is a great time-saving tool if you’d like to streamline processes (and if you’re not afraid of spreadsheets).

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

You’ll be able to access the tool via your Sendle dashboard once it has been enabled for you and you have sent your first package. If you would like to use batch upload, please reach out to our support team and they will enable this for you.

Below you’ll find all the information you’ll need to master the CSV Batch Upload Tool.

OK, what is the CSV Batch Order Uploader?

The uploader takes your CSV file (with all your orders), books these orders with Sendle all at once, and then gives you a file with all your labels to download and print. The Batch Order tool can create up to 100 orders per CSV upload. 

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. 

Where to upload my file?

To upload your correctly formatted CSV, click 'Batch Order' at the top right from your dashboard homepage. 

We’ve included a sample file on the ‘Batch Order’ page that you’ll be able to download and use to upload your orders with. 

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

Input addresses correctly

When it comes to mastering shipping, the most important thing to know is this: it’s all in the address. We use the mantra of: if you put in good addresses, you get good deliveries… but if you put in bad addresses, you end up with bad deliveries.

With this in mind, there are three things you need to get right:

  • Addresses
  • Volume and/or weight of each parcel
  • Delivery instructions 

So, let’s make sure you’re nailing it from the start: 

1. Addresses

There are many ways to write an address, but there’s only one way that works for our delivery partners. 

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:

  • Input the street name and number in the first field: sender_address_line1 and receiver_address_line1
  • Input any descriptive information, like floor and apartment number, in the second field: sender_address_line2 and receiver_address_line2
  • Input the business name in the company field: sender_company and receiver_company
  • Use a matching city and zip code.

The example below shows you the right way to input the address:

Company

Address line 1

Address line 2

City

State

Zip code

Country

 

Wonka Candy Company

123 Fake Road 

Suite #1001

Beverly Hills 

California 

90210

US

2. Volume and Weight

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

  • Volume is calculated as a cube (like a box). We represent this volume in cubic inches, so it's super easy to figure out. Find your volume in cubic inches by just multiplying your box length by width by height in inches. Voila! Volume!
  • The weight of your parcel is calculated in pounds. Input the weight of your parcel without the measurement e.g. 0.25 or 5 (not 5lbs, or pounds). This article about sizes and weight limits might be useful too.

3. Delivery Instructions

Delivery instructions are used to help the driver leave the package in the most convenient location.

You have 100 characters maximum for delivery instructions. So, use them wisely!

We have a whole article to help you create clear instructions.

CSV Glossary

Column

What to include in the field

Example

sender_name

Full name of the sender

Willy Wonka

sender_company

recommended

Business name

Wonka Candy Company

sender_address_line1

Building number & street name

P.O. Boxes 

123 Fake Road

sender_address_line2

optional

Building name, floor, apartment number, additional descriptive information

Suite #1001

sender_suburb

City name

This must match the zip code/postcode entered

Beverly Hills 

sender_state_name

Full state name or official abbreviation

CA or California

sender_postcode

Five-digit zip code

This must match the city entered 

90210

sender_country

United States is the only option

United States or US

sender_contact_number

Used to contact the sender if there are any issues with the pickup or delivery

1234567899

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

 

receiver_suburb

City name

This must match the Zip code entered

Seattle 

receiver_state_name

Full state name or official abbreviation

WA

receiver_postcode 

Five digit Zip code

This must match the city entered 

98122

receiver_country

United States is the only option

US or United States

receiver_contact_number

recommended

Used to contact the receiver if there are any issues with the delivery or address information.

1234567899

delivery_instructions

Maximum of 100 characters

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


Leave in the letterbox

The big red building, blue door

pickup_date

optional

Format: dd/mm/yyyy

You’ll be able to select the pick up date when confirming the orders

04/05/2018

weight_value

Pounds are the only option

0.5 

volume_value

Size of the parcel, calculated in cubic inches

0.001

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

weight_unit

Only option is pounds

lb

volume_unit

Only option is cubic inches

ft3

Get instant support

If something goes wrong with your delivery or you need to make a change to your order, use the Sendle Toolbox on the parcel tracking page.

Access Support Tools
You will need your six-character Sendle reference number.

Can't find what you're looking for?

Contact us