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 …

One of the biggest benefits of automating your fulfillment process with tools like EZ Fulfill is you can email your customers as soon as the order is fulfilled.  This is one of the easiest ways to help build trust and confidences with your customers while at the same time lowering your support costs as customers no longer need to reach out and ask if their order has shipped.

Automating Fulfillment Emails With Shopify's Email System

As a Shopify merchant one …

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 sent to different warehouses for …

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 the data based on the output of Custom …

When opening a file in Excel or LibreOffice, you may notice some characters don't display properly.  This can be frustrating, and feel overwhelming but we've found a pretty easy fix that we think can help you get this figured out. 

One way to solve this problem is to ensure your file is encoding in UTF-8.  This can get tricky as tools like Excel and LibreOffice have many different versions, so figuring out where the settings are can be confusing.

We've …