Last updated: 2025-06-09

Report tags for route optimisation and Home delivery

In this Price item

The following tags can be used in reports to show route optimisation information, such as the estimated delivery time in SMS notifications. The ETA has different tags depending on whether it comes from the manual or continuous optimisation:

  • Estimated: Times from manual route optimisations, i.e. when you have clicked on Calculate route sequence in the route optimisation window.

  • AutomaticEstimated: Times from the continuous route optimisation. The times are updated continuously, but the notification is not sent out every time the ETA is updated. For more information, see Automatic route optimisation.

    For example, if you have notification subscriptions that are sent out when an order gets the status Picked up and the ETA is updated at a later stage, because something else on the order is updated, no new notification is sent out (because the status is not updated to Picked up). Include a link to Track & Trace in the notification and the recipient can follow all ETA updates there. For more information, see Notifications with links to Track & Trace.

  • Rounded: If you round off the ETA in , you must use the tags starting with Rounded in the table below. The rounded time is not shown anywhere in the Opter interface, but is only visible in the notifications. For more information, see Home delivery settings (window).

Tags

Tag

Returns

EstimatedPickupTime

AutomaticEstimatedPickupTime

Date and time of collection. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

EstimatedPickupTime = the column Estimated pickup time in the dispatch of the first shipment on the order.

AutomaticEstimatedPickupTime = the column Estimated pickup time (automatically adjusted) in the dispatch of the first shipment on the order.

EstimatedDeliveryTime

AutomaticEstimatedDeliveryTime

Date and time of delivery. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

EstimatedDeliveryTime = the column Estimated delivery time in the dispatch of the last shipment on the order.

AutomaticEstimatedDeliveryTime = the column Estimated delivery time (automatically adjusted) in the dispatch of the last shipment on the order.

RoundedEstimatedPickupTimeString

RoundedAutomaticEstimatedPickupTimeString

Rounded time for collection. Displayed in the format "Today hh:mm" or "YYYY-MM-DD hh:mm", if the collection date is later than today.

Example: "Today 15:00".

RoundedEstimatedDeliveryTimeString

RoundedAutomaticEstimatedDeliveryTimeString

 

Rounded time for delivery. Displayed in the format "Today hh:mm" or "YYYY-MM-DD hh:mm", if the delivery date is later than today.

Example: "2025-06-29 15:00".

RoundedEstimatedPickupTimeOrTimeWindowString

RoundedAutomaticEstimatedPickupTimeOrTimeWindowString

 

Rounded time for collection.

If no route optimisation has been performed, the time window from the 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", if the collection date is later than today.

Example: "Today 15:00 - 15:30".

RoundedEstimatedDeliveryTimeOrTimeWindowString

RoundedAutomaticEstimatedDeliveryTimeOrTimeWindowString

Rounded time for delivery.

If no route optimisation has been performed, the time window from the 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”.

Example: "2025-06-29 15:00 - 15:30".

Shipments.SHI_EstimatedPickupTime

Shipments.SHI_AutomaticEstimatedPickupTime

Lists the pick-up time for all shipments on the order. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

Shipments.SHI_EstimatedPickupTime = Estimated pickup time column in the dispatch.

Shipments.SHI_AutomaticEstimatedPickupTime = Estimated pickup time (automatically adjusted) column in the dispatch.

Shipments.SHI_EstimatedDeliveryTime

Shipments.SHI_AutomaticEstimatedDeliveryTime

Lists the delivery time for all shipments on the order. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

Shipments.SHI_EstimatedDeliveryTime = Estimated delivery time column in the dispatch.

Shipments.SHI_AutomaticEstimatedDeliveryTime = Estimated delivery time (automatically adjusted) column in the dispatch.

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.

Report type HTML:

<p>Beräknad upphämtningstid: @Model.EstimatedPickupTime</p>
<p>
<b>Leveranser</b><br/>
@foreach(var item in Model.Shipments.ActiveItems)
{
   <text>- @item.SHI_EstimatedDeliveryTime</text><br/>
}
</p>

Report type Text:

Beräknad upphämtningstid: <item name="EstimatedPickupTime"/>

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

See also