EZ Exporter: Built-In Export Templates Now Available

EZ Exporter just got easier to use!

We're really excited to announce that our app now has support for built-in templates, making it super-easy to get started with our app! Just select a template and a pair of Export Profile and Data Settings will be created from that template, with most (if not all) of the things you'll most likely need already configured for you. You can then modify them at any time to customize them further.

It's also a …

Read more

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

EZ Exporter: Private Key Authentication for SFTP Now Available

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 …

Read more