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).
currency Currency (type: text). The three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency.
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.country_name Country Name (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_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.
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).
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.
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.
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