Note: functionality is still in development and is unavailable to all companies.
If you are using a delivery service, for which Order Management has package tracking configured, then the order obtains additional data, which describes what is happening with the package delivery (i.e when it was taken from the delivery service, when the user received it, when it arrived to parcel machine, etc.).
Data access
Access to data is possible in the following way:
1. Report "List of sales orders - delivery status" contains additional columns that describe events.
2. API call "get_document" for sales order may return data. More available at - https://github.com/metakocka/metakocka_api_base/blob/master/docs/documents_get_document_sales_order.md#get_document---sales-order-with-delivery-stats
3. If you have an automatic server and direct access to the database, you can read the column in the sales_order table on your own
Data content
Meaning of columns:
- order_create_ts - time of placing the order in the online store. Not directly connected with the delivery service.
- date_delivery_service_accepted - the date when the delivery service received the package.
- date_first_delivery - date of first successful or failed delivery.
- date_delivery_finished - date of successful delivery.
- first_delivery_date - date of successful first delivery
- second_delivery_date - date of successful second delivery. (if it has come to that)
- package_return_date - date of package return. (if it has come to that)
- package_rejected_date - date of package rejection. (if it has come to that)
- package_lost_damaged_date - date of losing or damaging the package.
- package_machine_put_date - package added to parcel machine/parcel shop.
- package_machine_leave_date - package taken from parcel machine/parcel shop.
- last_delivery_service_event_code - the code of the last event.
- last_delivery_service_event_date - the date of the last event.
- last_delivery_service_event_place - the place of the last event
- all_delivery_service_place - the list of all dates and places the package traveled through (for instance, 10.10.2019,KRANJ;12.10.2019,LJUBLJANA)
- delivery_hour_desc - expected delivery time today.
- tracking_last_event - the date and time of the last modification of the last event.
Delivery services support:
GLS_SI GLS_SK GLS_RO GLS_HU GLS_HR GLS_CH | GLS_AT GLS_DE GLS_FR | GLS_PL | GLS_IT | UNIFAUN_ SE | TNT_ TRAKPAK | POSTA _SI | POST _HR | |
date_delivery_service_accepted | DA | DA | DA | DA | DA | DA | ||
| date_first_delivery | DA | DA | DA | DA | DA | DA | ||
| date_delivery_finished | DA | DA | DA | DA | DA | DA | ||
| first_delivery_date | DA | DA | DA | DA | DA | DA | ||
| second_delivery_date | DA | DA | DA | DA | DA | DA | ||
| package_return_date | DA | DA | DA | DA | DA | DA | ||
| package_rejected_date | DA | DA | DA | DA | DA | DA | ||
| package_lost_damaged_date | DA | DA | ||||||
| package_machine_put_date | DA | DA | DA | DA | ||||
| package_machine_leave_date | DA | DA | DA | DA | ||||
| last_delivery_service_event_code | DA | DA | DA | DA | DA | DA | DA | |
| last_delivery_service_event_date | DA | DA | DA | DA | DA | DA | DA | |
| last_delivery_service_event_place | DA | DA | DA | DA | DA | DA | DA | |
| all_delivery_service_place | DA | DA | DA | DA | DA | DA | ||
| delivery_hour_desc | DA | DA | DA | DA | DA | DA | ||
| tracking_last_event | DA | DA | DA | DA | DA | DA | DA |
| PACKETA | OVERSEAS _HR | FANCOURIER _RO | ECONT _BG | DPD _SI | DPD _NL | DHL _SI | DHL _DE | UC_RO | |
date_delivery_service_accepted | |||||||||
| date_first_delivery | |||||||||
| date_delivery_finished | |||||||||
| first_delivery_date | |||||||||
| second_delivery_date | |||||||||
| package_return_date | |||||||||
| package_rejected_date | |||||||||
| package_lost_damaged_date | |||||||||
| package_machine_put_date | |||||||||
| package_machine_leave_date | |||||||||
| last_delivery_service_event_code | DA | DA | DA | ||||||
| last_delivery_service_event_date | DA | DA | DA | ||||||
| last_delivery_service_event_place | DA | DA | DA | ||||||
| all_delivery_service_place | |||||||||
| delivery_hour_desc | |||||||||
| tracking_last_event | DA | DA | DA |
| Delnext | |||||||||
date_delivery_service_accepted | |||||||||
| date_first_delivery | |||||||||
| date_delivery_finished | |||||||||
| first_delivery_date | |||||||||
| second_delivery_date | |||||||||
| package_return_date | |||||||||
| package_rejected_date | |||||||||
| package_lost_damaged_date | |||||||||
package_machine_put_date | |||||||||
| package_machine_leave_date | |||||||||
| last_delivery_service_event_code | DA | ||||||||
| last_delivery_service_event_date | DA | ||||||||
| last_delivery_service_event_place | DA | ||||||||
| all_delivery_service_place | |||||||||
| delivery_hour_desc | |||||||||
| tracking_last_event | DA |