EZ Exporter Update: Events (Timeline) Fields Now Available in Shopify Order Exports

EZ Exporter now supports order "Events" fields when exporting Shopify order data.  These "Events" are the entries displayed in the Order Timeline section of the Shopify Admin's order detail page:

In our app, the following fields can now be selected when creating an order export template:

events.action  Order Events Actions (type: text). A comma-separated list of actions that occurred.
events.app_title  Order Events App Titles (type: text). A comma-separated list of app names that created the events.
events.created_at  Order Events Dates (type: text). A comma-separated list of dates and times when the events were created.
events.last_event.action  Last Order Event Action (type: text). The action that occurred.
events.last_event.app_title  Last Order Event App Title (type: text). The name of the app that created the event.
events.last_event.created_at  Last Order Event Date (type: datetime). The date and time when the event was created.
events.last_event.message  Last Order Event Message (type: text). The event description.
events.message  Order Events Messages (type: text). A comma-separated list of event descriptions.

Please note that our app can't export the full event details.  The message field is just the short decription displayed in the timeline.

For "comment" events, we can export the comment text and date/time of the comment, but we can't export the name of the user/Staff Member who left the comment or files attached to the comment.

Below is an example of what the export will look like:

We can also use Calculated Fields to manipulate the raw events data and customize the output.

For example, the formula below will display each event in the format datetime [action] [app_title] message with a line break in between event records:

"\n".join(event.created_at + " [" + event.action + "]" + (" [" + event.app_title + "]" if event.app_title else "") + " " + strip_html_tags(event.message) for event in load_json_data({{ events }}))

Sample output:

We can also filter the events to include. For example, to only export "comment" events, we can use a formula like this:

"\n".join(event.created_at + " " + strip_html_tags(event.message) for event in load_json_data({{ events }}) if event.action == "comment")

Most of the preset fields are also available under the Custom Filters section of the Data Settings.  So you could create reports specifically for orders where a specitic event occurred, if a specific app triggered an event, or whether the event messages contained certain texts.

On the "Templates" page, we've also added the following templates related to Order Events and can be customized further:

  • Order Events (Timeline) (Last 30 Days) 
  • Orders with Timeline Comments (Last 30 Days)
  • Edited Orders (Last 30 Days)

If you need any assistance customizing your order exports, just let us know!


Tags: ez exporter, new features