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 |
in3 |