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:

…

EZ Exporter has supported exporting fulfillment locations from the Shopify order for some time now, but they were only available for orders or line items that were already fulfilled.

In the last couple of months, we've gotten more inquiries from merchants on how to export and filter based on the assigned/allocation location to fulfill the orders and line items from.

One use case for this is to allow merchants to create separate CSV exports to be …

We've just pushed 2 additional options in the Data Settings configuration of EZ Exporter:

1. Sort by a custom column.
2. Extra option to exclude specific columns.

Both of these options are applied near the end of the export process, after Custom Fields and Calculated Fields have already been evaluated so they'll often be used together with these fields.

Sort by a Custom Column

This one is pretty straightforward. You might want to sort …

Shopify regularly pushes updates to their APIs which often involve new fields being added as well.

Below is a list of new fields we've added to EZ Exporter when exporting order data. Many of these fields can be used in the filters as well.

• current_subtotal_price: Current Subtotal Price (type: number). The current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
• current_total_discounts: Current Total Discounts …

It's no longer uncommon for Shopify merchants to have multiple fulfillment centers or locations to ship their products from. When we first launched EZ Importer Shopify didn't even have support for multiple warehouse locations. Now a days, it's much more common and something we hear more and more merchants asking about. In order to help as many merchants as we can, we now allow you to add your location to your order when importing orders into Shopify.

Data Mapping