How do I export the delivery date from the Shopify order?

Note: This refers to the date when the delivered fulfillment event (from the shipping carrier) occurred. Also, this information may not be avallable for certain shipping carriers (e.g. DHL).

More detailed shipping information is available in the field called fulfillments.events in EZ Exporter.

Order Level

To export all the delivery dates (if an order has multiple fulfillments), you can select this field to include them in the export:

  • fulfillments.events.delivery_dates

The dates will be separated by a comma if there are multiple delivery dates.

To export just the final delivery date, you can select this field:

  • fulfillments.events.last_delivered_event.happened_at

You can also include the message associated with the delivery event by selecting this field:

  • fulfillments.events.last_delivered_event.message

Line Item Level

For the delivery dates at the line item level, you can use this formula in the Calculated Fields:

",".join([i.happened_at for i in load_json_data({{ fulfillments.events }}) if i.status == "delivered" and str(i.fulfillment_id) in to_list({{ line_items.fulfillment_ids }})])

Related Articles:


App: EZ Exporter

Tags: shipping, fulfillments