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 …

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.

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 …

Shopify has supported Metafields for a long time now but there was no option to manage them directly via the Shopify Admin so merchants often had to use third-party apps to add/update metafields.

A recent update takes care of this where Shopify merchants can now manage metafields directly from the Shopify Admin wihout the need of an app or writing custom code to interact with the API.

Metafields allow merchants to attach additional attributes to resources such as …

Google Sheets has a "Pivot table" option which allows you to create summary reports from your existing data.

In this tutorial, we'll show you how to create a basic pivot table from a list of individual order data.

The pivot table will group the data by the "Created At" column and will display the following:

1. Number of orders per day.
2. Total quantity of all line items ordered per day.
3. Average order value per day.
…