Retrieving Shopify Discount Data on the Line Item Level with EZ Exporter

Shopify recently updated their Order API and it now provides more information about the discounts applied to the order on the line item level.

There's actually a field called total_discount under the line items data for a long time, but it's a bit misleading as it only applied to line item discounts when using the Shopify POS and not for web orders. With this API update, we can now pull the discount amount and discount codes that were applied to …

Read more

Grouping and Aggregating Your Shopify Data with EZ Exporter

Grouping and aggregating data is now available in EZ Exporter!

This feature allows you to generate all kinds of summary reports to get more insights from your Shopify data. Below is just small list of the different types of reports you can now create thanks to this new feature:

  • Sales by Hour, Week, Day, Month, Year, Day of Week (which days have the highest sales, for example)
  • Sales by Customer, Customer Lifetime Value (CLTV), Average Order Value
  • Sales by …
Read more

EZ Exporter: get_attribute_value() and get_total() Functions Now Available

We've recently pushed an update to EZ Exporter to include two additional functions that can be used in the Calculated Fields: get_attribute_value() and get_total().

A couple use cases came up while talking to our customers and we thought the best way to handle them was to add these functions.

get_attribute_value(data, attribute_name, results_separator=",")

Retrieve an attribute's value from a list of attributes.

The data may look something like this:

"discount_codes": [
  {
    "code": "SPRING30",
    "amount": "30.00",
    "type": "fixed_amount"
  }
]

Examples: …

Read more

New Functions: to_list() and search_list() Now Available in EZ Exporter

We've recently added 2 new functions which can be used in the formulas of our app, EZ Exporter. These functions could come in handy for fields such as tags where you may need to filter them based on specific values.

to_list(data, separator=",")

Convert text data into a list/array.

For example, a tags field data may look something like this: "men, xxl, sale"

Applying this function like this:

to_list({{ tags }})

Will return this result: ['men', 'xxl', 'sale']

This is …

Read more

EZ Exporter: Re-Download Your Shopify Data Exports

We've just pushed an update to EZ Exporter to allow our users to be able to re-download files that were previously generated within our app. Note that this feature is currently only available to users subscribed to the Professional or Premium plans.

We have our systems set up to keep a temporary backup of all exported files. Professional plan subscribers can re-download those files generated within the last 30 days and 90 days for Premium plan subscribers.

A few use …

Read more