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 …

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: …

We've just added RSA private key authentication to EZ Exporter for SFTP/SSH connections. This authentication method provides extra security compared to regular passwords as SSH keys are much longer, making brute-force attacks pretty much impossible.

One of our customers requested it as one of their partners who they send their data to requires it to authenticate to their SFTP servers. I'm actually quite happy to see more users using SFTP vs regular FTP which is insecure by default.

To use …

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 …

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 …