EZ Exporter Update: Grouping and Aggregation Now Supports a LIST() Function

In addition to the MIN, MAX, SUM, MEAN, COUNT, and UNIQUE COUNT functions, EZ Exporter also now supports a LIST function.

This new function allows you to combine a group of field values in a JSON list/array.  If you're familiar with SQL, this is similar to MySQL's GROUP_CONCAT() function or PostgreSQL's STRING_AGG() function.

This enables creating summary reports where you can include a column including a comma-separated list of values from a grouped data.

Some examples:

  • Group orders by product …
Read more

EZ Exporter: June 2020 Updates

Below is a list of smaller updates we've pushed this month to our Shopify data export app, EZ Exporter.

New field: total_tip_received

Shopify added an online tipping option for web orders last month, which merchants can add to the checkout page. This option used to be only available through Shopify POS.

In EZ Exporter, you can now select a field called total_tip_received. This field is also available in the Custom Filters and the Grouping and Aggregation sections in the …

Read more

Automatically Export Your Data From Shopify to Google Sheets With EZ Exporter

A direct Google Sheets integrations is one of our most requested features for EZ Exporter and we're happy to announce that it's finally here!

We've had a Google Drive integration for a long time now where our users can automatically export a CSV or Excel file to a Google Drive folder.  However, we have customers who use Google Sheets heavily and prefer to have all the data they need in the same spreadsheet.

With this update, you can now do the …

Read more

EZ Exporter: Reference Shopify Metafields in Custom Fields and Calculated Fields

We've recently pushed an update to EZ Exporter to allow our users to reference Shopify Metafields in the Custom Fields and Calculated Fields sections of the app.

EZ Exporter has supported exporting metafields for a long time now, but it was limited to mapping each metafield value to a custom column in their CSV/Excel exports.

With this update, users of our app can extend that functionality by allowing them to combine the metafield values with other built-in Shopify field values …

Read more

Automatically Replace Multiple Characters in Your Shopify Data Export With EZ Exporter

When generating a CSV/Excel export of your Shopify data to be sent to third parties such as a supplier or another platform, the recipient may require the content of certain fields to be formatted in a certain way.

For example, some systems may require fields such as the shipping address to include only official abbreviations. There may also be cases where the system receiving the data only supports ASCII characters and if your customer base is global, you'll most likely …

Read more