EZ Exporter: Shopify Customer Fields Reference

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

Field ID Description
addresses Addresses (type: text). A list of the 10 most recently updated addresses for the customer.
created_at Created At (type: datetime).
default_address.address1 Address1 (type: text).
default_address.address2 Address2 (type: text).
default_address.city City (type: text).
default_address.company Company (type: text).
default_address.country Country (type: text).
default_address.country_code Country Code (type: text).
default_address.phone Default Address Phone (type: text).
default_address.province Province (type: text). The customer's province or state name.
default_address.province_code Province Code (type: text). The two-letter code for the customer's province or state.
default_address.zip Zip (type: text).
email Email (type: text).
email_marketing_consent.consent_updated_at Email Marketing Consent Updated At (type: datetime). The date and time when the customer consented to receive marketing material by email. If no date is provided, then the date and time when the consent information was sent is used.
email_marketing_consent.opt_in_level Email Marketing Consent Opt-In Level (type: text). The marketing subscription opt-in level that the customer gave when they consented to receive marketing material by email.
email_marketing_consent.state Email Marketing Consent Status (type: text). The current email marketing state for the customer. Valid values:
  • subscribed
  • not_subscribed
  • unsubscribed
first_name First Name (type: text).
id Customer ID (type: number). A unique numeric identifier for the customer.
last_name Last Name (type: text).
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.
last_order_id Last Order ID (type: number). The id of the customer's last order.
last_order_name Last Order Name (type: text). The name of the customer's last order. This is directly related to the Order's name field.
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.
multipass_identifier Multipass Identifier (type: text). The customer's identifier used with Multipass login
note Note (type: text). A note about the customer.
orders_count Total Orders (type: number). The number of orders associated with this customer.
phone Phone (type: text).
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.
sms_marketing_consent.consent_collected_from SMS Marketing Consent Collected From (type: text). The source for whether the customer has consented to receive marketing material by SMS.
sms_marketing_consent.consent_updated_at SMS Marketing Consent Updated At (type: datetime). The date and time when the customer consented to receive marketing material by SMS. If no date is provided, then the date and time when the consent information was sent is used.
sms_marketing_consent.opt_in_level SMS Marketing Consent Opt-In Level (type: text). The marketing subscription opt-in level that the customer gave when they consented to receive marketing material by SMS.
sms_marketing_consent.state SMS Marketing Consent Status (type: text). The current SMS marketing state for the customer. Valid values:
  • subscribed
  • not_subscribed
  • unsubscribed
state Account Status (type: text). The state of the customer's account in a shop. Valid values:
  • disabled: The customer doesn't have an active account. Customer accounts can be disabled from the Shopify admin at any time.
  • invited: The customer has received an email invite to create an account.
  • enabled: The customer has created an account.
  • declined: The customer declined the email invite to create an account.
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.
tags Tags (type: text).
tax_exempt Tax Exempt (type: text). Whether the customer is exempt from paying taxes on their order. Value is either True or False. If True, then taxes won't be applied to an order at checkout. If False, then taxes will be applied at checkout.
tax_exemptions Tax Exemptions (type: text). The list of tax exemptions applied to the customer in JSON format.
total_spent Total Spent (type: number). The total amount of money that the customer has spent at the shop.
updated_at Updated At (type: datetime).
verified_email Verified Email (type: text). Whether the customer has verified their email address. Value is either True or False

Related Articles:

App: EZ Exporter

Tags: shopify, field reference, shopify fields