Shopify's Fulfillment Events are basically the data displayed on the Order Status Page to update customers on the status of their shipment.

With EZ Exporter, you can now export this data to a CSV file. The data is joined with the order data so you can quickly see in one report all the order information associated with each event.

When you go to the Order Data Settings, you will now see a bunch of new selectable fields that start with fulfillments.events. Below are some examples of the data you can select:

• delivery dates
• last delivered event date
• last event date, message, and status

One use case that was actually requested by one of our customers is the ability to figure out the length of time from when the order was placed to when the products were delivered.

In addition to these new fields, we've also added a bunch of date and time-related functions so you can create a formula directly in EZ Exporter and export the time difference between order placement and delivery without having to do additional work in Excel.

For example, if you'd like to see how many days it took from order creation to delivery, you can use this formula in a Calculated Field:

days_diff(to_datetime({{ fulfillments.events.last_delivered_event.happened_at }}), to_datetime({{ created_at }}))

Note: The to_datetime() function simply converts the data to a datetime object so our app can properly do the calculation.

You can use the following functions as well to calculate the difference in hours, minutes, or seconds:

• hours_diff(end_date, start_date)
• minutes_diff(end_date, start_date)
• seconds_diff(end_date, start_date)

Hope these new additions prove useful!