Report tags for route optimisation

The following tags can be used in reports to show route optimisation information, such as the estimated delivery time in SMS notifications.

There are different tags depending on whether manual or automatic route optimisation is being used. Tags containing Estimated are used for manual route optimisation and tags containing AutomaticEstimated are used for automatic route optimisation.

If the estimated time of arrival is rounded via the home delivery settings, the tags containing Roundedmust be used. However, the rounded time is not displayed anywhere in the Opter interface.

Manual route optimisation

Use these tags if routes are optimised manually in dispatch.

Tag	Returns
EstimatedPickupTime	Estimated pickup time and date. The Estimated pickup time column in dispatch for the first shipment on the order. Displayed in the format “YYYY-MM-DD hh:mm:ss”.
EstimatedDeliveryTime	Estimated delivery date and time. The Estimated delivery time column in dispatch for the last shipment on the order.
RoundedEstimatedPickupTimeString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated pickup time and date. Displayed in the format “Today hh:mm” or “YYYY-MM-DD hh:mm”.
RoundedEstimatedDeliveryTimeString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated delivery date and time.
RoundedEstimatedPickupTimeOrTimeWindowString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated pickup time and date. If no route optimisation has been performed, the time window for pickup from order reception is displayed, which consists of the fields Time/Date / Time/Date under Sender. Displayed in the format “Today hh:mm - hh:mm” or “YYYY-MM-DD hh:mm - hh:mm”.
RoundedEstimatedDeliveryTimeOrTimeWindowString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated delivery date and time. If no route optimisation has been performed, the time window for delivery from order reception is displayed, which consists of the fields Time/Date / Time/Date under Receiver. Displayed in the format “Today hh:mm - hh:mm” or “YYYY-MM-DD hh:mm - hh:mm”.
Shipments.SHI_EstimatedPickupTime	Lists the pickup date and pickup time for all the shipments on the order. The Estimated pickup time column in dispatch. Displayed in the format “YYYY-MM-DD hh:mm:ss”.
Shipments.SHI_EstimatedDeliveryTime	Lists the delivery date and delivery time for all the shipments on the order. The Estimated delivery time column in dispatch. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Automatic route optimisation

Use these tags if you automatic route optimisation (real-time optimisation) is used.

Tag	Returns
AutomaticEstimatedPickupTime	Estimated pickup time and date. The Estimated pickup time (automatically adjusted) column in dispatch for the first shipment on the order. Displayed in the format “YYYY-MM-DD hh:mm”.
AutomaticEstimatedDeliveryTime	Estimated delivery date and time. The Estimated delivery time (automatically adjusted) column in dispatch for the last shipment on the order.
RoundedAutomaticEstimatedPickupTimeString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated pickup time and date. Displayed in the format “Today hh:mm” or “YYYY-MM-DD hh:mm”.
RoundedAutomaticEstimatedDeliveryTimeString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated delivery date and time.
RoundedAutomaticEstimatedPickupTimeOrTimeWindowString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated pickup time and date. If no route optimisation has been performed, the time window for pickup from order reception is returned, which consists of the fields Time/Date / Time/Date under Sender. Displayed in the format “Today hh:mm - hh:mm” or “YYYY-MM-DD hh:mm - hh:mm”.
RoundedAutomaticEstimatedDeliveryTimeOrTimeWindowString	Used if there is a setting for rounding the arrival time in the home delivery settings. Estimated delivery date and time. If no route optimisation has been performed, the time window for delivery from order reception is returned, which consists of the fields Time/Date / Time/Date under Receiver. Displayed in the format “Today hh:mm - hh:mm” or “YYYY-MM-DD hh:mm - hh:mm”.
Shipments.SHI_AutomaticEstimatedPickupTime	Lists the pickup date and pickup time for all the shipments on the order. The Estimated pickup time (automatically adjusted) column in dispatch. Displayed in the format “YYYY-MM-DD hh:mm:ss”.
Shipments.SHI_AutomaticEstimatedDeliveryTime	Lists the delivery date and delivery time for all the shipments on the order. The Estimated delivery time (automatically adjusted) column in dispatch. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example

The following paragraph returns the estimated pickup time of the first shipment on the order, and a list of delivery times for all the shipments on the order.

HTML

<p>Estimated pickup time: @Model.EstimatedPickupTime</p>
<p>
<b>Deliveries</b><br/>
@foreach(var item in Model.Shipments.ActiveItems)
{
   <text>- @item.SHI_EstimatedDeliveryTime</text><br/>
}
</p>

Text

Estimated pickup time: <item name="EstimatedPickupTime"/>

Deliveries: <query command="Shipments">
- <item name="SHI_EstimatedDeliveryTime"/>
</query>

Results

Estimated pickup time: 03.09.2024 10:22:45

Deliveries:

– 03.09.2024 10:52:05

– 03.09.2024 11:16:25

Reference Materials

Home delivery

Introduction to notifications

Creating reports for notifications

Notifications with links to Track & Trace

Choosing the report for notifications to receivers