You can reference the Field IDs below in a Custom Field or Calculated Field by enclosing them in double curly braces (e.g. {…

The following fields can be used in the Custom Fields or Calculated Fields of any type of data export. The leading underscore is intentional to avoid…

In the Data Settings, you can enter the variable {{ _current_datetime }} in the Calculated Fields section to include a column displaying when the rep…

The Shopify Order API endpoint doesn't have a field for "new or returning customer".  However, there's a field called custo…

The Shopify Order API doesn't have a field for the order's current status, but what we can do instead is look at the closed_at and cancelled_…

Shopify doesn't have a "Sale Price" field in the backend. It instead uses a field called "Compare At Price" which basically m…

You may want to add a delay to your order CSV exports based on the order's created date if you allow your customers to edit or cancel orders with…

You might want to pad your data with zeros to make sure it's of a certain length.  This could come in handy when sorting string data or for …

EZ Exporter has a direct Google Sheets integration where you can push new orders directly to an existing Google Sheets spreadsheet. 1. Create…

You can use the formula below in the Calculated Fields to automatically include the country dial code (e.g. +44) to the shipping address' phone n…

Note: Google Merchant Center also supports reading from an existing Google Sheets spreadsheet.  Since EZ Exporter also has a direct Google Sheet…

You can use the formula below in the Calculated Fields section of the Data Settings to calculate the number of days from when an order…

You can use the formula below in the Calculated Fields section of the Data Settings to calculate the number of days from when an order…

In EZ Exporter, it's possible to subtract 2 dates and get the number of days between them using Calculated Fields.For example, you might want a custo…

The shipping discount applied to the order is stored in the discount_applications field, which is an array of discounts. You can use this formula …