Batch upload - book multiple orders at once

On this page

What is batch upload? / How to create and upload a batch of ordersAddressesVolume and weight / Numbers / Adding extra cover / Leaving columns blank / Pickup, drop off, and delivery speedsBatch order limits  

What is a batch upload, and how does it work?

Tired of creating your orders one-by-one? With batch uploads you can create dozens or even hundreds of orders at once, in a fraction of the time.

When you have a list of parcels that you’d like to book with Sendle, you can can put all the parcel info into a single spreadsheet and upload it to Sendle to create dozens or hundreds of parcels at once.

Getting started can feel daunting, but batch uploading is easy once you understand it. The trickiest part is filling out the spreadsheet for the first time, and this page will walk you through the it step by step. 

How to create and upload batch of orders

Step 1. Download the template and reference sheet

The batch uploader needs specific information for each order, so we’ve created a template you'll use to create your spreadsheet of orders. We’ve also created a reference sheet for you. The template is empty, but the reference sheet has an explanation and an example in each column.

Download the template for batch uploading

Download the reference sheet for batch uploading

Step 2. Fill out the template

You can use any spreadsheet software you like – we recommend Google Sheets, but Excel and Numbers are also good.

Enter each order in its own row, following the column headers. Use the reference sheet as a guide. (You can also check the Tips for filling out your batch upload template section below)

It’s a good idea to only create two or three orders with your first batch upload – that way it'll be easy to fix any errors or mistakes, and your next batch will be smooth sailing.

Step 3. Save your filled template as a CSV file

You can only upload CSV files, so you’ll need to save or export your spreadsheet as a CSV file. The exact steps will depend on the spreadsheet software you’re using, but here’s how it works.

  1. Open your spreadsheet and click File 
  2. Choose either Save as, Export, or Download.
    Which one you see will depend on the program you’re using
  3. Choose .CSV as the file format
  4. Give your file a unique name and save it somewhere you’ll be able to find it easily

Step 4. Upload the file and check your orders

  1. From your Sendle dashboard, click Batch order
  2. On the batch upload page, click Select your CSV file 
  3. Choose your file and click Upload
  4. Read through your order list to make sure the details are correct, and open any orders you aren’t sure about to double check.

If you have any orders with errors they'll be highlighted red in the order list, and orders with warnings will be yellow. To fix them, just click into each order and scroll through it – you’ll be able to see where the problem is.

Step 5. Choose pickup or drop off, and select a delivery speed

If you're booking your orders for a standard pickup you can simply enter the date in your file. Make sure your pickup address is verified or it will default to drop off. 

If you'd like to change any orders from pickup to drop-off or use a different delivery speed, you can set these options now.

  1. Use the checkboxes to select the relevant orders
  2. Click Delivery option and choose an option
  3. If you've chosen a pickup option, set your pickup date
  4. Click Update

Step 6. Confirm your orders and print your labels

When you’re ready to confirm your orders, click Create orders.

Your labels will be available in a single file so you can print them all at once, but the process of printing is the same: choose Cropped or A4 labels, click Download labels, then print them off.  

Tips for filling out your batch upload template 

The best way to fill out your template for the first time is to use the reference sheet as a guide. It has an explanation of each column, plus two examples.

If you'd rather just use this page, here are the main things to know.

Addresses

The columns in the CSV template match the fields you see when you book a parcel through the regular order form.

Remember to only enter the street number and street name in receiver_address_line1 – any additional information (such as level, unit or apartment number, or building name) goes in receiver_address_line2.

Volume and weight

Enter the weight, length, width, and height, and when you upload your CSV file we'll calculate your parcel’s volume and choose the right parcel size for you.

Numbers 

You can enter as many or as few decimal points as you like, just make sure you're using the correct measurement (e.g. inches or lbs).

If you enter a number that begins with a zero, your spreadsheet software might delete that first zero – which is a problem for things like mobile numbers and reference numbers. To fix the problem, just add an apostrophe at the start of the number, like this:

‘040 4123 123

Leaving columns blank 

The following columns are optional, which means you can leave these blank with no problems.

  • pickup_date
    If you leave this column blank, your orders will be booked for drop off)
  • receiver_company
  • receiver_address_line2
  • customer_reference

Batch order limits

Your 'batch order limit' is the maximum number of orders you can include in a single CSV file. It’s based on your billing threshold, and it increases as your sending volume increases.

When you create orders (manually or using a batch upload) the cumulative cost of your orders is displayed on the Billing page in the Sendle app under Pending charges, and your current billing threshold is shown under Next payment.

When your pending charges reach your billing threshold, Sendle activates a payment. As soon as that payment goes through your billing threshold increases, and your batch order limit increases to match. 

This process repeats as your sending volume grows, until you reach the maximum billing threshold and batch order limit for your plan type.

You can see your upload limit on the Batch upload page:

Screen_Shot_2021-07-08_at_13.29.50.png

Batch order limit too low? No worries, just split your orders across multiple CSV files. There’s no limit to the amount of CSV files you can upload in a day

And, good news – if you upload multiple CSVs it’s likely that you’ll hit your billing threshold, which will raise your batch order limit for next time.

Batch order limits by plan type

When you first start sending parcels with Sendle, your billing threshold will be set to an initial amount, depending on your Sendle plan type. As your sending volume increases your limit will also increase, until it reaches the maximum amount.

Standard
The starting billing threshold is $5, then $20 and increasing up to a maximum of $500
The starting batch order limit is 3 orders per CSV, then 5 orders and increasing up to a maximum of 100 orders

Premium
The starting billing threshold is $5 then $30 and increasing up to a maximum of $1,000
The starting batch order limit is 5 orders per CSV, then 10 orders and increasing up to a maximum of 200 orders

Pro
The starting threshold is $5 then $100 and increasing up to a maximum of $4,000
The starting batch order limit is 15 orders per CSV, then 25 orders and increasing up to a maximum of 300 orders

 

Get instant support with the Sendle Toolbox

If something goes wrong with your delivery or you need to make a change to your order, use the tools in the Manage Parcel section on the parcel tracking page.

Access Support Tools
You will need your Sendle reference number
to acess your parcel's tracking page.

Can't find what you're looking for?

Contact us