Template
Download:
Use Case
Bulk importing consignments is best used for:
Promotional Activities
Sending the same freight item details (one carton or satchel) to multiple different receivers using the same Carrier Service.
Example
I want to send a promo box to all my Bunnings partners. I know that I have 50 Bunnings receivers and I have all the receiver details in a list.
OR
I have a new product demo that I want to have it sent to all my branches so they can have their customers test the new product.
Limitations
Bulk importing consignments cannot be used for:
Dangerous Goods consignments
Dangerous Goods need to be officially declared, in OneFlo, due to DG compliance regulations
Dangerous Goods need item level information, which Bulk Uploads does not currently collect
Consolidation
Bulk imported consignments will not consolidate.
Bulk importing consignments is not recommended for:
Small number of consignments
Bulk uploading consignments could take longer than manually filling out the form in OneFlo. It is recommended for customers that frequently have more than 20 consignments created a day.
Returns
Bulk uploading consignments will be treated as an outbound consignment by the system. This could cause issues with the cost of the consignment.
Multiple items per consignment
A consignment will be created for each line in the csv file. If there are multiple items in a line, this will cause the consignment to divide the weight and volume by the number of items.
Step 1: Accessing the Import Consignments page
In OneFlo, click on the settings cog ⚙ in the top right hand corner of the page > Click Import Consignments
Step 2: Selecting the file
Please note: The file will need to be in a .csv format. Please use the attached template as it will make the next step easier
Click browse to select the file that is to be uploaded and select First row in header.
Instructions
Select: Settings > "Import Consignments"
Select the file that is to be uploaded and select First row in header.
Underneath this section is where the headings are matched to the list. If there are any --Select File Column-- In the second column, click on the drop down boxes and match them to the first column appropriately.
Click Import Data.
This will take you to a new screen where, if there are any errors, they can be corrected here. Refresh the page after a while to see if any errors appear, or if they have processed. If there are a large number of consignments, this may take some time to process.
Clicking the green triangle will show what the errors are, if there are any.
The table on the first page shows the requirements for importing consignments for troubleshooting any errors that may appear on this page.
This screen is where most of the errors can be fixed. For example, Receiver Location is invalid is because either the postcode or suburb is incorrect.
Requirements
Field Name | Type | Limit | Mandatory | Examples |
|---|---|---|---|---|
Released | DateTime | 8 | Y | DD/MM/YYYY |
Service | Text | 20 | TP02 | |
Reference | Text | 20 | 123ABC | |
3rd Party Account | Text | 10 | DEF456 | |
Cost Centre | Text | 10 | ||
Sender Name | Text | 30 | Y | Company Name |
Sender Contact Name | Text | 30 | Steve McGuy | |
Sender Address 1 | Text | 30 | Y | 123 Fake St |
Sender Address 2 | Text | 30 | C/O That Place Co. | |
Sender Suburb | Text | 30 | Y | Melbourne |
Sender State | Text | 3 | Y | VIC, NSW, etc. |
Sender Postcode | Numeric | 4 | Y | 3000 |
Sender Country Code | Text | 2 | Y | AU |
Sender Phone | Numeric | 10 | 0398785548 | |
Sender Email | Text | 50 | ||
Sender Is Residential | Text | 3 | Y | Yes or No |
Receiver Name | Text | 30 | Y | Customer Co |
Receiver Contact Name | Text | 30 | John Johnson | |
Receiver Address line 1 | Text | 30 | Y | 456 Real St |
Receiver Address line 2 | Text | 30 | C/O That Other Place PTY LTD | |
Receiver Suburb | Text | 30 | Y | Glen Waverley |
Receiver State | Text | 3 | Y | VIC, NSW, etc. |
Receiver Postcode | Numeric | 4 | Y | 3150 |
Receiver Country Code | Text | 2 | Y | AU |
Receiver Phone | Numeric | 10 | 0359687458 | |
Receiver Email | Text | 50 | ||
Receiver Is Residential | Text | 3 | Y | Yes or No |
Authority to Leave | Text | 3 | Y | Yes or No |
Delivery Instructions | Text | 250 | Please leave in mailbox | |
Special Instructions | Text | 250 | ||
Items | Numeric | 999 | Y | 101 |
Description | Text | 250 | Y | Carton, Pallet, etc. |
Weight (KG) in Total (not per item) | Numeric | 0.01 - 10000 | Y | 0.3 = 300g |
Volume (m3) in Total (not per item) | Numeric | 0.001 - 10000 | Y | 0.004 |