EZ Exporter: Shopify Company 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
contacts_count.count Contacts Count (type: number). The number of contacts that belong to the company.
created_at Created At (type: datetime).
external_id Company External ID (type: text). A unique externally-supplied ID for the company.
id Company ID (type: number).
locations.billing_address.address1 Location Billing Address1 (type: text).
locations.billing_address.address2 Location Billing Address2 (type: text).
locations.billing_address.city Location Billing City (type: text).
locations.billing_address.country Location Billing Country (type: text).
locations.billing_address.first_name Location Billing First Name (type: text).
locations.billing_address.last_name Location Billing Last Name (type: text).
locations.billing_address.phone Location Billing Phone (type: text).
locations.billing_address.province Location Billing Province (type: text).
locations.billing_address.zip Location Billing Zip (type: text).
locations.buyer_experience_configuration.payment_terms_template.name Location Payment Terms Name (type: text).
locations.catalogs.id Location Catalogs IDs (type: text).
locations.catalogs.status Location Catalogs Status (type: text). A comma-separated list of catalog status values. Valid values:
  • ACTIVE
  • ARCHIVED
  • DRAFT
locations.catalogs.title Location Catalogs Titles (type: text). A comma-separated list of catalog names.
locations.created_at Location Created At (type: text).
locations.external_id Location External ID (type: text). A unique externally-supplied ID for the company location.
locations.id Location ID (type: text).
locations.name Location Name (type: text). The name of the company location.
locations.note Location Note (type: text). A note about the company location.
locations.orders_count.count Location Orders Count (type: number). The total number of orders placed for the location.
locations.shipping_address.address1 Location Shipping Address1 (type: text).
locations.shipping_address.address2 Location Shipping Address2 (type: text).
locations.shipping_address.city Location Shipping City (type: text).
locations.shipping_address.country Location Shipping Country (type: text).
locations.shipping_address.first_name Location Shipping First Name (type: text).
locations.shipping_address.last_name Location Shipping Last Name (type: text).
locations.shipping_address.phone Location Shipping Phone (type: text).
locations.shipping_address.province Location Shipping Province (type: text).
locations.shipping_address.zip Location Shipping Zip (type: text).
locations.tax_settings.tax_exempt Location Tax Exempt (type: text). Whether the location is exempt from taxes. Value is either True or False.
locations.tax_settings.tax_exemptions Location Tax Exemptions (type: text). The list of tax exemptions applied to the location in JSON format.
locations.tax_settings.tax_registration_id Location Tax ID (type: text). The tax registration ID for the company location.
locations.total_spent.amount Location Total Spent Amount (type: number). The total amount spent by the location.
locations.total_spent.currency_code Location Total Spent Currency Code (type: text).
locations.updated_at Location Updated At (type: text).
locations_count.count Locations Count (type: number). The number of locations that belong to the company.
main_contact.customer.default_email_address.email_address Main Contact Email (type: text).
main_contact.customer.default_phone_number.phone_number Main Contact Phone (type: text).
main_contact.customer.first_name Main Contact First Name (type: text).
main_contact.customer.last_name Main Contact Last Name (type: text).
main_contact.title Main Contact Title (type: text). The job title of the company contact.
name Company Name (type: text). The name of the company.
note Note (type: text). A note about the company.
orders_count.count Orders Count (type: number). The total number of orders placed for this company, across all its locations.
total_spent.amount Total Spent Amount (type: number). The total amount spent by this company, across all its locations.
total_spent.currency_code Total Spent Currency Code (type: text).
updated_at Updated At (type: datetime).

Related Articles:

App: EZ Exporter

Tags: field reference, shopify b2b, shopify b2b companies, shopify fields