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 …

By default, EZ Exporter will put each line item in the order in a separate row in the CSV export, duplicating the data at the order level like this: …

The Shopify API only provides the values of the variant options in the fields option1, option2, and option3 where the ordering of the options could v…

In EZ Exporter, you can add a Custom Field in the Data Settings with this value to automatically load the image when opening the Excel export fi…

The field line_items.properties is typically used to capture additional custom options or personalization data from the customer for e…

Shopify stores this data in the Transaction Receipt field. In EZ Exporter, you can use Custom Filters as shown below to filter only orders whose T…

Most of the price/money fields, such as total_price and line_items.price, are in the shop's currency by default (except those in the tr…

In the Product export, there's a field called images.src that you can select which will export all product image URLs in one column separated by …

Depending on the payment gateway, the transaction fee may or may not be availabe in the Shopify order transaction data.  The data structure coul…

EZ Exporter can pull the current inventory levels of each line item at the inventory locations where they're stocked as part of an order dat…

When you edit an order and remove a shipping line, the value of the shipping_lines.total_price field will still include that removed shipping li…

You can use the formula below in the Calculated Fields to calculate the line item total price after discounts: {{ line_items.total_price }}…

The referral code displayed in the Shopify Admin's "Conversion summary" section is part of the landing_site data. The raw data may look something li…

In EZ Exporter, we have a preset field called refunds.id, which is a comma-separated list of refund IDs for the entire order. If you nee…

You can use the formulas below in the Calculated Fields to export tracking info of Shopify Order Returns at the order level or line item le…