EZ Exporter Update: New Shopify Order Fields and Templates

The fields below are now available when creating a Data Settings for exporting Shopify Order data in EZ Exporter:

app.name App Name (type: text). The name of the app that created the order. For example, 'Online Store', 'Point of Sale', or a custom app name. Use this to identify the order source for attribution and fulfillment workflows.
current_total_duties_set.shop_money.amount Current Total Duties (type: number). The current total duties amount in the shop currency for an order, after any returns or modifications. Modifications include returns, refunds, order edits, and cancellations.
display_fulfillment_status Display Fulfillment Status (type: text). The fulfillment status that displays in the Shopify admin to merchants. Valid values:
  • UNFULFILLED: Displayed as Unfulfilled. None of the items in the order have been fulfilled.
  • PARTIALLY_FULFILLED: Displayed as Partially fulfilled. Some of the items in the order have been fulfilled.
  • FULFILLED: Displayed as Fulfilled. All the items in the order have been fulfilled.
  • RESTOCKED: Displayed as Restocked. All the items in the order have been restocked. Replaced by the UNFULFILLED status.
  • PENDING_FULFILLMENT: Displayed as Pending fulfillment. A request for fulfillment of some items awaits a response from the fulfillment service. Replaced by the IN_PROGRESS status.
  • OPEN: Displayed as Open. None of the items in the order have been fulfilled. Replaced by UNFULFILLED status.
  • IN_PROGRESS: Displayed as In progress. All of the items in the order have had a request for fulfillment sent to the fulfillment service or all of the items have been marked as in progress.
  • ON_HOLD: Displayed as On hold. All of the unfulfilled items in this order are on hold.
  • SCHEDULED: Displayed as Scheduled. All of the unfulfilled items in this order are scheduled for fulfillment at later time.
  • REQUEST_DECLINED: Displayed as Request declined. Some of the items in the order have been rejected for fulfillment by the fulfillment service.
disputes.initiated_as Disputes Types (type: text). The type that the dispute was initiated as. Valid values:
  • CHARGEBACK: The dispute has turned into a chargeback.
  • INQUIRY: The dispute is in the inquiry phase.
disputes.status Disputes Status (type: text). The current status of the dispute. Valid values:
  • ACCEPTED
  • LOST
  • NEEDS_RESPONSE
  • PREVENTED
  • UNDER_REVIEW
  • WON
edited Edited (type: text). Whether the order has had any edits applied. For example, adding or removing line items, updating quantities, or changing prices. Value is either True or False.
net_payment_set.shop_money.amount Net Payment Amount (type: number). The net payment for the order, based on the total amount received minus the total amount refunded, in the shop currency.
original_total_duties_set.shop_money.amount Original Total Duties (type: number). The total amount of duties calculated in the shop currency when an order was created, before any modifications. Modifications include returns, refunds, order edits, and cancellations. Use current_total_duties_set to retrieve the current duties amount after adjustments.
shopify_protect.status Shopify Protect Status (type: text). The status of the order's protection against fraudulent chargebacks. Valid values:
  • PENDING: The protection for the order is pending and has not yet been determined.
  • ACTIVE: The protection for the order is active and eligible for reimbursement against fraudulent chargebacks. If an order is updated, the order's eligibility may change and protection could become inactive.
  • INACTIVE: The protection for an order isn't active because the order didn't meet eligibility requirements.
  • PROTECTED: The order received a fraudulent chargeback and it was protected.
  • NOT_PROTECTED: The order received a chargeback but the order wasn't protected because it didn't meet coverage requirements.
total_received_set.shop_money.amount Total Received Amount (type: number). The total amount received from the customer before returns, in the shop currency.

The following Templates have been added/updated as well to utilize these new fields:

  • Sales by App Name / Sales Channel (Last 30 Days)
  • Edited Orders (Last 30 Days)
  • Orders with Chargebacks/Disputes (Last 90 Days)
  • Orders with Fulfillment On Hold (Last 90 Days)
  • Unpaid Orders
  • Partially Paid Orders
  • Orders with Active Shopify Protect Status (Last 30 Days)


Tags: ez exporter, new features, shopify orders