On the main Logistia screen, Deliveries, click on Import Orders button from the right-side. Select the local Logistia account from the dropdown, if you have other e-commerce platforms integrated.
Make sure you have selected the delivery date for when you want to create the routes. Then click on Import XLS file button to browse for the file on your PC.
Logistia will prompt you to match the columns from your file with the corresponding data type available. The only required data type is either Street with Number or Lat, Long coordinates to add your stops.
Please make sure you map them correctly for every column you wish to display in Logistia. If you have data that is not required, leave it unselected and Logistia will ignore it.
Click on the Import button to finish the import and see a preview of your data. All you need to do is confirm the delivery date for your stops. Next, you’ll be directed to the Optimize Route process.
Next time you import a file, Logistia will remember the mapping as long as the format does not change.
|Parameter Name||Description||How to use & Examples|
|Order No||An external identifier associated with your stop. Leave it blank and Logistia will assign an order number for the stop.||* ABC-123|
|Client Name||Name of the recipient associated with the stop||John Doe|
|Client Telephone||Phone number associated with the stop||+17657644322|
|Client Email||Email address of the recipient associated with the firstname.lastname@example.org|
|Street with number||The main address of the map||7 Commons Ln|
|City||The city in which the stop is located||New York|
|County||The state/county where the stop is located||New York|
|Postal Code||The Zip or Postal code of the stop||12601|
|Other address info||Any other useful information about the stop||Second door on the left|
Beware of the dog
|Delivery Price||The cost of the delivery associated with the stop||10|
|Product Name||The name of the product associated with the stop||Healthy protein meal plan for 1 day|
|Product Price||The price for 1 piece of the product name(s) associated with the stop||29.9|
|Product Quantity||How many pieces of the product name(s) are associated with the stop||2|
|Payment method||The payment method associated with this stop||Card|
Cash on delivery
|Payment status||The payment status associated with this stop||Paid|
|Comments||Any relevant comments associated with this stop||Leave it with the neighbour|
|Tags||A relevant tag to identify the stop with more accuracy||Special delivery|
|Delivery interval||The delivery time interval associated with this stop||10:00 – 13:00|
10AM – 7PM
|Order drop-off time (min)||How many minutes the driver will spend at the stop||5|
|Priority||In case of a partial solution, this flag will prioritize this stop instead of other stops||true|
|No contact delivery||A flag to signal the delivery should happen without interacting with the recipient of this stop||true |
|Reference Number||A field to cross-reference this stop with your own systems (e.g. ERP)||ABC-12345|
|Lat, Long Geo Point||The Latitude and Longitude coordinated associated with this stop||46.123, 26.123|
|Lat||The Latitude coordinate of this stop||46.123|
|Long||The Longitude of this stop||26.123|
|Custom fields name||If you have defined any custom fields in Logistia Settings, you can use it to map it from your Excel file|