Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents |
---|
Template
Download:
View file | ||
---|---|---|
|
Use Case
Tip |
---|
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.Table of Contents | ||||
---|---|---|---|---|
|
Warning |
---|
Stop!Are you uploading more than 200 consignments? Uploading a large file can put a lot of strain on the system and can take quite some time to load. It is not recommended to load more than 200 cons at a time. It is best practice to break large numbers of cons into 200 cons or less |
Template
Download:
View file | ||
---|---|---|
|
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
Image RemovedImage AddedStep 2: Selecting the file
Note |
---|
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 |
select First row in header > Click browse to select the file that is to be uploaded and select First row in header.
Image RemovedInstructions
Select: Settings > "Import Consignments"Select the file that is to be uploaded and select First row in header.
Step 3: Mapping the file
The page should look like this, though there could be some small differences:
Image AddedThe top section is for editing any errors:
Image AddedAnd the bottom section is for mapping the headings. 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
:
Image ModifiedStep 4: Importing the file
After mapping the file headers, click Import Data t the top of the screen.
Image AddedThis 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.
Image Removed
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.
Image AddedMandatory Fields
Field Name | Type | Character Limit | Mandatory | Examples | ||||
---|---|---|---|---|---|---|---|---|
Released | DateTime | 8 |
|
| 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 |
|
| Company Name | |||||||
Sender Contact Name | Text | 30 | Steve McGuy | |||||
Sender Address 1 | Text | 30 |
|
| 123 Fake St | |||||||
Sender Address 2 | Text | 30 | C/O That Place Co. | |||||
Sender Suburb | Text | 30 |
|
| Melbourne | |||||||
Sender State | Text | 3 |
|
| VIC, NSW, etc. | |||||||
Sender Postcode | Numeric | 4 |
|
| 3000 | |||||||
Sender Country Code | Text | 2 |
|
| AU | |||||||
Sender Phone | Numeric | 10 | 0398785548 | |||||
Sender Email | Text | 50 | stevemcguy@email.com.au | |||||
Sender Is Residential | Text | 3 |
|
| Yes or No | |||||||
Receiver Name | Text | 30 |
|
| Customer Co | |||||||
Receiver Contact Name | Text | 30 | John Johnson | |||||
Receiver Address line 1 | Text | 30 |
|
| 456 Real St | |||||||
Receiver Address line 2 | Text | 30 | C/O That Other Place PTY LTD | |||||
Receiver Suburb | Text | 30 |
|
| Glen Waverley | |||||||
Receiver State | Text | 3 |
|
| VIC, NSW, etc. | |||||||
Receiver Postcode | Numeric | 4 |
|
| 3150 | |||||||
Receiver Country Code | Text | 2 |
|
| AU | |||||||
Receiver Phone | Numeric | 10 | 0359687458 | |||||
Receiver Email | Text | 50 | john.johnson@email.com.au | |||||
Receiver Is Residential | Text | 3 |
|
| Yes or No | |||||||
Authority to Leave | Text | 3 |
|
| Yes or No | ||
Delivery Instructions | Text |
60 | Please leave in mailbox | |||||||
Special Instructions | Text | 250 | ||||||
Items | Numeric | 999 |
|
| 101 | |||||||
Description | Text | 250 |
|
| Carton, Pallet, etc. | |||||||
Weight (KG) in Total (not per item) | Numeric | 0.01 - 10000 |
|
| 0.3 = 300g | |||||||
Volume (m3) in Total (not per item) | Numeric | 0.001 - 10000 |
|
| 0.004 |