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:

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

select First row in header > Click browse to select the file that is to be uploaded and

Step 3: Mapping the file

The page should look like this, though there could be some small differences:

The top section is for editing any errors:

And 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:

Step 4: Importing the file

After mapping the file headers, click Import Data t the top of the screen.

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.

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.

Mandatory Fields

Field Name	Type	Character Limit	Mandatory	Examples

Field Name	Type	Character Limit	Mandatory	Examples
Released	DateTime	8	YES	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	YES	Company Name
Sender Contact Name	Text	30		Steve McGuy
Sender Address 1	Text	30	YES	123 Fake St
Sender Address 2	Text	30		C/O That Place Co.
Sender Suburb	Text	30	YES	Melbourne
Sender State	Text	3	YES	VIC, NSW, etc.
Sender Postcode	Numeric	4	YES	3000
Sender Country Code	Text	2	YES	AU
Sender Phone	Numeric	10		0398785548
Sender Email	Text	50		stevemcguy@email.com.au
Sender Is Residential	Text	3	YES	Yes or No
Receiver Name	Text	30	YES	Customer Co
Receiver Contact Name	Text	30		John Johnson
Receiver Address line 1	Text	30	YES	456 Real St
Receiver Address line 2	Text	30		C/O That Other Place PTY LTD
Receiver Suburb	Text	30	YES	Glen Waverley
Receiver State	Text	3	YES	VIC, NSW, etc.
Receiver Postcode	Numeric	4	YES	3150
Receiver Country Code	Text	2	YES	AU
Receiver Phone	Numeric	10		0359687458
Receiver Email	Text	50		john.johnson@email.com.au
Receiver Is Residential	Text	3	YES	Yes or No
Authority to Leave	Text	3	YES	Yes or No
Delivery Instructions	Text	60		Please leave in mailbox
Special Instructions	Text	250
Items	Numeric	999	YES	101
Description	Text	250	YES	Carton, Pallet, etc.
Weight (KG) in Total (not per item)	Numeric	0.01 - 10000	YES	0.3 = 300g
Volume (m³) in Total (not per item)	Numeric	0.001 - 10000	YES	0.004

OneFlo Knowledge Base

OneFlo - Bulk Import Consignments