JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

Shopify Customers tables and relationships

Customers with email and SMS marketing consent, addresses and tags, the store visits behind each order (first and last visit source, landing page, referrer, UTM parameters) and customer segments. Tables and columns are named after the Shopify Admin API and share one shopify schema with Shopify Orders, Shopify Products & Inventory, Shopify Payments & Payouts, Shopify Checkouts & Discounts, Shopify Analytics.

Live5 tables · 6 relationships
ConnectPaste an API key
Default schemashopify
Source API docshelp.shopify.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
  • The six Shopify connectors load into one shopify schema. The others: Shopify Orders, Shopify Products & Inventory, Shopify Payments & Payouts, Shopify Checkouts & Discounts, Shopify Analytics. Dashed boxes are their tables.
  • Tables and columns are named after the Shopify Admin GraphQL API (2026-07): a table per object (Order → orders, its lineItems → order_line_items), a column per field path in snake_case (totalPriceSet.shopMoney.amount → total_price_set_shop_money_amount). Ids are the number in Shopify's global id, so they join across connectors.
  • Lists inside an object (tags, tax lines, custom attributes ...) are child tables keyed by the parent id and index, replaced as a set whenever the parent changes. _jsdata_synced is the load time; _jsdata_deleted is always false.
  • Names, emails, phone numbers and street addresses load empty unless you turn on personal data; customer ids, city, province, country and email / SMS marketing consent are kept.
CUSTOMERScustomer_tags.customer_id → customers.idcustomer_addresses.customer_id → customers.idcustomer_visits.order_id → orders.idcustomers.last_order_id → orders.idorders.customer_id → customers.idcustomers.default_address_id → customer_addresses.idcustomer_addressescustomer_addresses20id BIGINT · primary keyidbigintcustomer_id BIGINT · → customers.idcustomer_idbiginttypename VARCHAR(256)typenamevarcharfirst_name VARCHAR(65535)first_namevarcharlast_name VARCHAR(65535)last_namevarcharname VARCHAR(65535)namevarcharcompany VARCHAR(65535)companyvarcharaddress1 VARCHAR(65535)address1varcharaddress2 VARCHAR(65535)address2varcharcity VARCHAR(65535)cityvarcharprovince VARCHAR(65535)provincevarcharprovince_code VARCHAR(65535)province_codevarcharcountry VARCHAR(65535)countryvarcharcountry_code_v2 VARCHAR(256)country_code_v2varcharzip VARCHAR(65535)zipvarcharphone VARCHAR(65535)phonevarcharlatitude DECIMAL(38,9)latitudedecimallongitude DECIMAL(38,9)longitudedecimal_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcustomerscustomers33id BIGINT · primary keyidbigintdefault_address_id BIGINT · → customer_addresses.iddefault_address_idbigintlast_order_id BIGINT · → orders.idlast_order_idbigintcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampfirst_name VARCHAR(65535)first_namevarcharlast_name VARCHAR(65535)last_namevarchardisplay_name VARCHAR(65535)display_namevarcharnote VARCHAR(65535)notevarcharstate VARCHAR(256)statevarcharlocale VARCHAR(65535)localevarcharverified_email BOOLEANverified_emailbooltax_exempt BOOLEANtax_exemptbooldata_sale_opt_out BOOLEANdata_sale_opt_outboollifetime_duration VARCHAR(65535)lifetime_durationvarcharproduct_subscriber_status VARCHAR(256)product_subscriber_statusvarcharnumber_of_orders BIGINTnumber_of_ordersbigintamount_spent_amount DECIMAL(38,9)amount_spent_amountdecimalamount_spent_currency_code VARCHAR(256)amount_spent_currency_codevarchardefault_email_address_email_address VARCHAR(65535)default_email_address_email_addressvarchar+13 more (see below) +13 more (see below)orders (Shopify Orders)orders (Shopify Orders)extid BIGINT · primary keyidbigintcustomer_id BIGINT · → customers.idcustomer_idbigintname VARCHAR(65535)namevarcharcreated_at TIMESTAMPcreated_attimestampcustomer_visitscustomer_visits17id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbiginttypename VARCHAR(256)typenamevarcharoccurred_at TIMESTAMPoccurred_attimestampsource VARCHAR(65535)sourcevarcharsource_type VARCHAR(256)source_typevarcharsource_description VARCHAR(65535)source_descriptionvarcharlanding_page VARCHAR(65535)landing_pagevarcharreferrer_url VARCHAR(65535)referrer_urlvarcharreferral_code VARCHAR(65535)referral_codevarcharutm_parameters_source VARCHAR(65535)utm_parameters_sourcevarcharutm_parameters_medium VARCHAR(65535)utm_parameters_mediumvarcharutm_parameters_campaign VARCHAR(65535)utm_parameters_campaignvarcharutm_parameters_content VARCHAR(65535)utm_parameters_contentvarcharutm_parameters_term VARCHAR(65535)utm_parameters_termvarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcustomer_tagscustomer_tags5customer_id BIGINT · primary key · → customers.idcustomer_idbigintindex BIGINT · primary keyindexbigintvalue VARCHAR(65535)valuevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampsegmentssegments7id BIGINT · primary keyidbigintname VARCHAR(65535)namevarcharquery VARCHAR(65535)queryvarcharcreation_date TIMESTAMPcreation_datetimestamplast_edit_date TIMESTAMPlast_edit_datetimestamp_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamp
Primary keyForeign keyReferencesJoins on (not a key)

Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.

Table reference

5 tables · click a table for its columns
customers33 columns · Customersshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
created_attimestamp
updated_attimestamp
first_namevarchar(65535)
last_namevarchar(65535)
display_namevarchar(65535)
notevarchar(65535)
statevarchar(256)
localevarchar(65535)
verified_emailboolean
tax_exemptboolean
data_sale_opt_outboolean
lifetime_durationvarchar(65535)
product_subscriber_statusvarchar(256)
number_of_ordersbigint
amount_spent_amountdecimal(38,9)
amount_spent_currency_codevarchar(256)
default_email_address_email_addressvarchar(65535)
default_email_address_marketing_statevarchar(256)
default_email_address_marketing_opt_in_levelvarchar(256)
default_email_address_marketing_updated_attimestamp
default_email_address_valid_formatboolean
default_phone_number_phone_numbervarchar(65535)
default_phone_number_marketing_statevarchar(256)
default_phone_number_marketing_opt_in_levelvarchar(256)
default_phone_number_marketing_updated_attimestamp
default_phone_number_marketing_collected_fromvarchar(256)
default_address_idReferences customer_addresses.id.bigintFKReferences customer_addresses.id.
last_order_idReferences orders.id.bigintFKReferences orders.id.
statistics_predicted_spend_tiervarchar(256)
statistics_rfm_groupvarchar(256)
_jsdata_deletedTrue when the record was deleted at the source.booleanTrue when the record was deleted at the source.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
customer_tags5 columns · Customersshow in diagram

Primary key: customer_id, index

ColumnTypeKeyDescription
customer_idPrimary key (with index). References customers.id.bigintPK FKPrimary key (with index). References customers.id.
indexPrimary key (with customer_id).bigintPK Primary key (with customer_id).
valuevarchar(65535)
_jsdata_deletedTrue when the record was deleted at the source.booleanTrue when the record was deleted at the source.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
customer_addresses20 columns · Customersshow in diagram

Primary key: id

ColumnTypeKeyDescription
customer_idReferences customers.id.bigintFKReferences customers.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
first_namevarchar(65535)
last_namevarchar(65535)
namevarchar(65535)
companyvarchar(65535)
address1varchar(65535)
address2varchar(65535)
cityvarchar(65535)
provincevarchar(65535)
province_codevarchar(65535)
countryvarchar(65535)
country_code_v2varchar(256)
zipvarchar(65535)
phonevarchar(65535)
latitudedecimal(38,9)
longitudedecimal(38,9)
_jsdata_deletedTrue when the record was deleted at the source.booleanTrue when the record was deleted at the source.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
segments7 columns · Customersshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
namevarchar(65535)
queryThe segment definition (ShopifyQL). Segment membership is not included.varchar(65535)The segment definition (ShopifyQL). Segment membership is not included.
creation_datetimestamp
last_edit_datetimestamp
_jsdata_deletedTrue when the record was deleted at the source.booleanTrue when the record was deleted at the source.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
customer_visits17 columns · Visitsshow in diagram

Primary key: id

ColumnTypeKeyDescription
order_idReferences orders.id. The order this visit led to (source, landing page, referrer, UTM parameters of each visit).bigintFKReferences orders.id. The order this visit led to (source, landing page, referrer, UTM parameters of each visit).
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
occurred_attimestamp
sourcevarchar(65535)
source_typevarchar(256)
source_descriptionvarchar(65535)
landing_pagevarchar(65535)
referrer_urlvarchar(65535)
referral_codevarchar(65535)
utm_parameters_sourcevarchar(65535)
utm_parameters_mediumvarchar(65535)
utm_parameters_campaignvarchar(65535)
utm_parameters_contentvarchar(65535)
utm_parameters_termvarchar(65535)
_jsdata_deletedTrue when the record was deleted at the source.booleanTrue when the record was deleted at the source.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.

Connect Shopify Customers All connectors