Customer Name

Select the column that identifies the customer's name, and it will appear on the Web Portal and in the driver's application.

Customer Id

Select the column that uniquely identifies the customer. It should be a unique number. An example of this might be CNPJ or CRN

Latitude

Select the column that identifies the customer's location's latitude value

Longitude

Select the column that identifies the customer's location's longitude value

Route Id

Select the column that uniquely identifies the route. This typically is a number or a combination of letters and numbers. Some users use the truck license plate

Driver Id

Select the column that uniquely identifies the driver. This could be a name, but typically is a number or a name with a number. This field will be used to assign drivers to a route if the "Assign Drivers" option is selected. An example of this might be CPF, Número de Identificação Fiscal or RUT

Address

Select the column that identifies the address of the customer's location. This will be shown on the driver's device and Web Portal for informational purposes only

Start Time Offset (hr)

If there are multiple loads per route, select the column that designates the expected start time of the route

Product Name(s)

Select the column that identifies the product names and/or SKU identification number. This will be shown on the driver's device and Web Portal for informational purposes only

Product Quantity

Select the column that identifies the product quantities associated with the product name(s) column. This will be shown on the driver's device and Web Portal for informational purposes only

Time Window Start

Select the column that identifies the start of the delivery time window for each customer

Time Window End

Select the column that identifies the end of the delivery time window for each customer

Service Time (min)

Select the column that identifies the estimated amount of time the driver will be at the customer location delivering/picking-up products

Customer Phone

Select the column that identifies the customer's contact phone number

Contact Name

Select the column that identifies the name of the contact at the customer's location

Customer Email

Select the column that identifies the customer's contact e-mail address

Start Location Id

Select the column that identifies the start location of the route. If not specified, the Distribution Center (DC) warehouse will be used.

End Location Id

Select the column that identifies the end location of the route. If not specified, the Distribution Center (DC) warehouse will be used.

Start Location Name

Select the column that identifies the start location's name of the route. If not specified, the Distribution Center (DC) warehouse will be used.

End Location Name

Select the column that identifies the end location's name of the route. If not specified, the Distribution Center (DC) warehouse will be used.

Start Location Latitude

Select the column that identifies the latitude of the start location of the route. If not specified, the Distribution Center (DC) warehouse will be used.

End Location Latitude

Select the column that identifies the latitude of the end location of the route. If not specified, the Distribution Center (DC) warehouse will be used.

Start Location Longitude

Select the column that identifies the longitude of the start location of the route. If not specified, the Distribution Center (DC) warehouse will be used.

End Location Longitude

Select the column that identifies the longitude of the end location of the route. If not specified, the Distribution Center (DC) warehouse will be used.