EZ Exporter Update: New Shopify Customer Fields

When creating a custom Shopify CSV export for customer data, you can now include the following customer fields with EZ Exporter:

last_order.created_at Last Order Date (type: datetime). The date and time when the customer's last order was created.
last_order.presentment_currency_code Last Order Presentment Currency Code (type: text). The 3-letter currency code used by the customer when placing the last order.
locale Locale (type: text). The customer's language and region preference. For example, 'en' for English, 'fr-CA' for French (Canada), or 'es-MX' for Spanish (Mexico). Use this to provide localized customer service and targeted marketing in the customer's preferred language.
product_subscriber_status Product Subscriber Status (type: text). Possible subscriber states of a customer defined by their subscription contracts. Valid values:
  • ACTIVE: The customer has at least one active subscription contract.
  • CANCELLED: The customer's last subscription contract was cancelled and there are no other active or paused subscription contracts.
  • EXPIRED: The customer's last subscription contract expired and there are no other active or paused subscription contracts.
  • FAILED: The customer's last subscription contract failed and there are no other active or paused subscription contracts.
  • NEVER_SUBSCRIBED: The customer has never had a subscription contract.
  • PAUSED: The customer has at least one paused subscription contract and there are no other active subscription contracts.
statistics.predicted_spend_tier Predicted Spend Tier (type: text). The predicted spend tier the customer. Valid values:
  • HIGH
  • LOW
  • MEDIUM
statistics.rfm_group RFM Group (type: text). The RFM (Recency, Frequency, Monetary) group of the customer. Valid values:
  • ACTIVE: Customers with recent purchases, some orders, and moderate spend.
  • ALMOST_LOST: Customers without recent purchases, fewer orders, and with lower spend.
  • AT_RISK: Customers without recent purchases, but with a strong history of orders and spend.
  • CHAMPIONS: Customers with very recent purchases, many orders, and the most spend.
  • DORMANT: Customers without recent orders, with infrequent orders, and with low spend.
  • LOYAL: Customers with recent purchases, many orders, and the most spend.
  • NEEDS_ATTENTION: Customers with recent purchases, some orders, and moderate spend.
  • NEW: Customers with very recent purchases, few orders, and low spend.
  • PREVIOUSLY_LOYAL: Customers without recent purchases, but with a very strong history of orders and spend.
  • PROMISING: Customers with recent purchases, few orders, and low spend.
  • PROSPECTS: Customers with no orders yet.
tax_exemptions Tax Exemptions (type: text). The list of tax exemptions applied to the customer in JSON format.

Simply select these fields in the "Fields" section of the Data Settings to include them. Most of them are also avaiable in the "Custom Filters" and "Grouping and Aggregation" sections.

We've added support for certain B2B company-related fields as well, but they currently can only be accessed via the Custom Fields and Calculated Fields section since we're currently seeing very few users that use the Shopify B2B features.  You can use the variables below to include them:

  • {{ company_contact_profiles.company.name }}
  • {{ company_contact_profiles.company.external_id }}
  • {{ company_contact_profiles.is_main_contact }}

We've also added the following Customer report templates that utilize these new fields:

  • Customers with an Active Product Subscription
  • Customers with High Predicted Spend Tier
  • Customers Grouped by Locale
  • Customers in "At Risk" RFM Group
  • Shopify B2B Customers

Tags: ez exporter, new features