Setup default import order mapping on an account
The default order mapping can be setup on an account from the account details without the need of additional coding from the Dispatch Science development team. The .CSV template is attached to this article, see bottom of article.
Open Accounts and in list of Accounts, click on an Account Name to open its details.
In Account Details under Order Options, click on Create Standard Mapping link
You will receive a message, click on OK to create the standard mapping or on Cancel to abort.
Once the mapping has been associated to the account, you will see the confirmation message at the top and the mapping associated to the account.
Enter Orders in Import File
Download the import file. It is very important to keep the column header name as is, they should not be renamed.
The following columns should always be filled in:
Dropoff Contact Name, Address Line 1, City, Province and Postal Code.
Pickup Contact Name, Address Line 1, City, Province and Postal Code.
The first 3 columns will be used to import values in the Reference fields:
Reference Number 1, Reference Number 2, Reference Number 3
Those fields represent the 3 reference fields that are setup for in the Profile for the account. Do not rename those columns even if they are named differently in the profile. They will map to the first, second and third reference field.
The service level should be entered as the ID. You can find this information under Pricing, Service Levels. Open a service level schedule to see the list of Service level IDs.
Ready At and Delivery window
There are 2 different ways to send the Pickup and Delivery time:
Using Ready At and Service Level:
Delete columns Del Date, Del no earlier than, Del no later than (columns D, E, F).
Enter a Ready At date-time and a service level. These will be used to automatically calculate the order drop off window.
Using the a Delivery window
Enter the date of delivery in the Del Date column.
Enter a time in the Del no earlier than to indicate when the delivery can start
Enter a time in the Del no later than to indicate when the delivery should be completed. The time should be equal to or later than the Del no earlier than.
Enter a Ready At that is NOT EARLIER THAN the Del date and Del no earlier than time
Enter a service level.
Note: The service level will be used to calculate pricing. The delivery window will be used as entered.
Vehicle Type Id
Vehicle Type Id refers to the ID on the vehicle. You can find this information under Pricing in the Vehicles:
Pickup and Delivery Latitude and Longitude
These 4 fields can be left blank or even removed from the import file if they are not used.
If these are blank or not present in the file, the geolocation of the pickup and delivery address will be done by Dispatch Science.
If you enter a latitude and longitude, the address will be used to display and the latitude and longitude will be used as the geolocation.
Number Of Pieces and Weight vs Parcels
Depending on which file you are using, Standard Order or the Standard Order with Items, different fields will be available.
Standard Import File without items
Number Of Pieces
Enter here the number of pieces in the order. A parcel, using the lowest ranked parcel type from the parcel type schedule associated with the account, will be used to create the order.
If you enter 0 piece, no parcel will be created on the order.
If weight is omitted, it will default to 0. If a weight is entered, it will be split in between each of the parcel as entered in Number of pieces.
Standard Import File with Items
This file will be used if you want to enter the items or parcels for each order.
On the first row of an order, fill in the information for the order and the first parcel.
On the subsequent rows of the order, only fill in the information for the parcels.
See Filled in Standard with items to be used as an example.csv file at the bottom of this article.
Item_Parcel Type Id
This will be the ID on the parcel type schedule associated to the account.
If this is left blank, the item will not be added to the order.
This will be added in the description field on the parcel
This is the weight of the item. If a minimum weight was entered in the parcel type, the weight will be displayed in the order but the minimum weight will be used for the calculation of the weight extra fee.
Item_Length, Item_Width, Item_Height
These field will contain the length, width and height in the unit of measure associated with the parcel type as entered in Item_Parcel Type Id if the parcel type was set as customizable. If entries are added in those columns and the parcel type is not set to be customizable, the order will not be created and an error will be added in the log file.
This will contain the barcode for the item. If there are no barcodes entered, the barcode will be left blank.
If some of the barcodes are entered and others are left blank, the ones that are blank will be blank.
If no barcodes are entered for any of the items in the order and there is a custom barcode template setup on the account, the barcodes will be created upon import.
Import User Name
If the import is for one Account, this field can be left blank.
If you are importing orders for multiple accounts, the field should contain the email address associated to the Account User for the order.
The following column should be removed when sending the standard import file to your account users
If the Driver Number is added to this column, the order will be dispatched to the driver.
Note: If your driver numbers are not unique, this will create an error and the order will not be dispatched.
The Driver pay can be added in this column and this will set the predefined commission for the order.
If a price is indicated in this column, the delivery price will be overwritten on the order.
For convenience, you have different files that can be given to your accounts and the other marked as internal that you can use yourself with the above 3 fields.
Please note there is also a file named Filled in Standard with Items to be used as an example.csv which does not contain the above 3 fields but give an example on how to fill in the file when there are items.
Import orders for an account
Click on Orders and then click on Import then click on Import File.
Click on Choose File and navigate to location of your file, select the file and click Open. File name will show in the field.
Select the Import Type
By Account: When By Account is selected, you will be able to select the account and the user of the account.
For Multiple Accounts: When selecting For Multiple Accounts, you will need to add in the file the Import User Name which should be the email of the account user for each order. Select the correct mapping from the drop-down field.
Click on Import to start the importing process.
You will be returned to the list of Import with the status as Requested:
You can refresh the page using the browser refresh or the refresh at the bottom right of the list to see the updated status or you can leave this page and you will receive an email when the import is done.
Note that an email will also be sent to the support email associated with Dispatch Science and the users.
In the import list, on the right hand side of each row, you have a download menu. When clicking on the download menu, you can either open the Log File or download the original import file.