Customers

Contains customer profile data including contact info, marketing preferences, and order history.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

Id supports the '=, IN' comparison operators.
Email supports the '=, !=' comparison operators.
Phone supports the '=, !=' comparison operators.
CreatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
UpdatedAt supports the '=, !=, <, >, >=, <=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Customers WHERE Id = 'Val1'
  SELECT * FROM Customers WHERE Email = 'Val1'
  SELECT * FROM Customers WHERE Phone = 'Val1'
  SELECT * FROM Customers WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Customers WHERE UpdatedAt = '2023-01-01 11:10:00'

Insert

The following columns can be used to create a new record:

FirstName, LastName, Email, Locale, Note, Phone, Tags, TaxExempt, TaxExemptions, DefaultAddressFirstName, DefaultAddressLastName, DefaultAddressAddress1, DefaultAddressAddress2, DefaultAddressCity, DefaultAddressCompany, DefaultAddressCountry, DefaultAddressPhone, DefaultAddressProvince, DefaultAddressZip, DefaultAddressProvinceCode, DefaultAddressCountryCodeV2, SmsMarketingConsentMarketingState, SmsMarketingConsentMarketingOptInLevel, SmsMarketingConsentConsentUpdatedAt

Update

The following columns can be updated:

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A unique identifier for the customer record.
MultipassIdentifier	String	True		A unique identifier used for Multipass login, allowing customers to log in seamlessly between external systems and Shopify.
LegacyResourceId	String	True		The identifier of the corresponding customer resource in the REST Admin API.
ValidEmailAddress	Bool	True		Indicates whether the customer's email address is correctly formatted and associated with a valid domain. This does not confirm that the address actually exists.
DisplayName	String	True		The display name of the customer, generated from their first and last name. If unavailable, this falls back to their email address or phone number.
FirstName	String	False		The customer's given name.
LastName	String	False		The customer's family name or surname.
Email	String	False		The email address associated with the customer's account.
Locale	String	False		The locale or language preference set for the customer.
Note	String	False		A merchant-authored note containing additional information or internal context about the customer.
Phone	String	False		The customer's contact phone number, optionally formatted according to international standards.
State	String	True		The current state of the customer's account, such as active, disabled, or invited.
Tags	String	False		A comma-separated list of tags applied to the customer for segmentation or filtering purposes.
CanDelete	Bool	True		Indicates whether the customer can be deleted from the store. Customers with completed orders cannot be deleted.
LifetimeDuration	String	True		The total time elapsed since the customer was first added to the store, expressed in natural language (for example, 'about 12 years').
TaxExempt	Bool	False		Indicates whether the customer is exempt from tax charges on their orders.
TaxExemptions	String	False		A list of tax exemptions applied to the customer, such as resale or government exemptions.
UnsubscribeUrl	String	True		The direct URL that allows the customer to unsubscribe from marketing communications.
VerifiedEmail	Bool	True		Indicates whether the customer's email address has been verified. Defaults to true when created via the Admin or API.
NumberOfOrders	String	True		The total number of orders placed by the customer over their lifetime with the store.
ProductSubscriberStatus	String	True		The customer's current subscription contract status, reflecting their engagement in recurring product subscriptions.
CreatedAt	Datetime	True		The timestamp marking when the customer record was first created in Shopify.
UpdatedAt	Datetime	True		The timestamp marking the most recent update to the customer record.
AmountSpentAmount	Decimal	True		The total amount of money spent by the customer across all orders, expressed as a decimal value.
AmountSpentCurrencyCode	String	True		The three-letter ISO currency code corresponding to the total amount spent.
DefaultAddressId	String	True		The unique identifier of the customer's default address record.
DefaultAddressCoordinatesValidated	Bool	True		Indicates whether the default address contains verified latitude and longitude coordinates.
DefaultAddressValidationResultSummary	String	True		A summary of the validation status for the customer's default address, based on Shopify's address validation feature.
DefaultAddressName	String	True		The full name of the customer as displayed in the default address record.
DefaultAddressFirstName	String	False		The first name from the customer's default address.
DefaultAddressLastName	String	False		The last name from the customer's default address.
DefaultAddressAddress1	String	False		The first line of the default address, typically including the street address or PO Box number.
DefaultAddressAddress2	String	False		The second line of the default address, often used for apartment, suite, or unit numbers.
DefaultAddressCity	String	False		The city or locality specified in the default address.
DefaultAddressCompany	String	False		The name of the company or organization listed on the default address, if applicable.
DefaultAddressCountry	String	False		The country name specified in the default address.
DefaultAddressLatitude	Double	True		The latitude coordinate corresponding to the default address.
DefaultAddressLongitude	Double	True		The longitude coordinate corresponding to the default address.
DefaultAddressPhone	String	False		The contact phone number associated with the default address, formatted according to E.164 standards (for example, +16135551111).
DefaultAddressProvince	String	False		The administrative region, province, or state associated with the default address.
DefaultAddressZip	String	False		The postal or ZIP code for the default address.
DefaultAddressFormattedArea	String	True		A formatted string combining the city, province, and country for the default address.
DefaultAddressProvinceCode	String	False		The two-letter code representing the province or state for the default address (for example, ON).
DefaultAddressCountryCodeV2	String	False		The two-letter ISO country code representing the default address country (for example, US).
EmailMarketingConsentMarketingState	String	True		The customer's current email marketing consent state, indicating whether they are subscribed or unsubscribed.
EmailMarketingConsentMarketingOptInLevel	String	True		The opt-in level for marketing emails, defined by the M3AAWG best practice guidelines at the time of consent.
EmailMarketingConsentConsentUpdatedAt	Datetime	True		The timestamp marking when the customer last updated their email marketing consent. If not provided, the timestamp reflects when the consent record was received.
ImageId	String	True		The unique identifier of the customer's profile image, if available.
ImageWidth	Int	True		The width of the profile image in pixels. Returns null if the image is not hosted by Shopify.
ImageAltText	String	True		A short descriptive text explaining the content or purpose of the profile image.
ImageHeight	Int	True		The height of the profile image in pixels. Returns null if the image is not hosted by Shopify.
ImageUrl	String	True		The URL location of the customer's profile image.
LastOrderId	String	True		The unique identifier of the customer's most recent order.
MarketId	String	True		The unique identifier of the market associated with the customer's account.
MergeableReason	String	True		The reason why this customer record cannot currently be merged with another customer.
MergeableErrorFields	String	True		A list of fields or data elements preventing the customer from being merged.
MergeableIsMergeable	Bool	True		Indicates whether the customer can be merged with another record.
MergeableMergeInProgressJobId	String	True		The unique identifier of an in-progress customer merge job, if applicable.
MergeableMergeInProgressResultingCustomerId	String	True		The unique identifier of the resulting customer record after a merge operation.
MergeableMergeInProgressStatus	String	True		The current status of the merge operation for this customer, such as pending or completed.
SmsMarketingConsentMarketingState	String	False		The customer's current SMS marketing consent state, such as subscribed or unsubscribed.
SmsMarketingConsentConsentCollectedFrom	String	True		The source channel from which SMS marketing consent was collected, such as checkout or sign-up form.
SmsMarketingConsentMarketingOptInLevel	String	False		The level of opt-in given by the customer for SMS marketing communications.
SmsMarketingConsentConsentUpdatedAt	Datetime	False		The timestamp marking when the customer last consented to receive SMS marketing messages.
StatisticsPredictedSpendTier	String	True		The predicted spending tier assigned to the customer based on their purchase behavior and store data.