JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

Shopify Checkouts & Discounts tables and relationships

Abandoned checkouts with line items, discount codes, tax lines and custom attributes, and every discount (code and automatic: basic, buy X get Y, free shipping, app) with its redeem codes and usage. Tables and columns are named after the Shopify Admin API and share one shopify schema with Shopify Orders, Shopify Customers, Shopify Products & Inventory, Shopify Payments & Payouts, Shopify Analytics.

Live7 tables · 7 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 Customers, Shopify Products & Inventory, Shopify Payments & Payouts, 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.
  • Checkout names, phone numbers and street addresses load empty unless you turn on personal data. Checkouts later completed or deleted in Shopify drop out of Shopify's list, so older rows are not updated any more.
  • The discounts applied to each order are in Shopify Orders (order_discount_applications, order_line_item_discount_allocations, order_discount_codes).
abandoned_checkout_discount_codes.abandoned_checkout_id → abandoned_checkouts.idabandoned_checkout_custom_attributes.abandoned_checkout_id → abandoned_checkouts.idabandoned_checkout_tax_lines.abandoned_checkout_id → abandoned_checkouts.idabandoned_checkout_line_items.abandoned_checkout_id → abandoned_checkouts.idabandoned_checkouts.customer_id → customers.iddiscount_redeem_codes.discount_id → discounts.idorder_discount_codes.code joins discount_redeem_codes.code (Codes used on orders (Shopify Orders) match redeem codes by text.)abandoned_checkout_tax_linesabandoned_checkout_tax_lines13abandoned_checkout_id BIGINT · primary key · → abandoned_checkouts.idabandoned_checkout_idbigintindex BIGINT · primary keyindexbiginttitle VARCHAR(65535)titlevarcharrate DECIMAL(38,9)ratedecimalrate_percentage DECIMAL(38,9)rate_percentagedecimalsource VARCHAR(65535)sourcevarcharchannel_liable BOOLEANchannel_liableboolprice_set_shop_money_amount DECIMAL(38,9)price_set_shop_money_amountdecimalprice_set_shop_money_currency_code VARCHAR(256)price_set_shop_money_currency_codevarcharprice_set_presentment_money_amount DECIMAL(38,9)price_set_presentment_money_amountdecimalprice_set_presentment_money_currency_code VARCHAR(256)price_set_presentment_money_currency_codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampabandoned_checkout_custom_attributesabandoned_checkout_custom_attributes6abandoned_checkout_id BIGINT · primary key · → abandoned_checkouts.idabandoned_checkout_idbigintindex BIGINT · primary keyindexbigintkey VARCHAR(65535)keyvarcharvalue VARCHAR(65535)valuevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampabandoned_checkoutsabandoned_checkouts65id BIGINT · primary keyidbigintcustomer_id BIGINT · → customers.idcustomer_idbigintname VARCHAR(65535)namevarcharcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampcompleted_at TIMESTAMPcompleted_attimestampnote VARCHAR(65535)notevarcharabandoned_checkout_url VARCHAR(65535)abandoned_checkout_urlvarchartaxes_included BOOLEANtaxes_includedboolsubtotal_price_set_shop_money_amount DECIMAL(38,9)subtotal_price_set_shop_money_amountdecimalsubtotal_price_set_shop_money_currency_code VARCHAR(256)subtotal_price_set_shop_money_currency_codevarcharsubtotal_price_set_presentment_money_amount DECIMAL(38,9)subtotal_price_set_presentment_money_amountdecimalsubtotal_price_set_presentment_money_currency_code VARCHAR(256)subtotal_price_set_presentment_money_currency_codevarchartotal_price_set_shop_money_amount DECIMAL(38,9)total_price_set_shop_money_amountdecimaltotal_price_set_shop_money_currency_code VARCHAR(256)total_price_set_shop_money_currency_codevarchartotal_price_set_presentment_money_amount DECIMAL(38,9)total_price_set_presentment_money_amountdecimaltotal_price_set_presentment_money_currency_code VARCHAR(256)total_price_set_presentment_money_currency_codevarchartotal_tax_set_shop_money_amount DECIMAL(38,9)total_tax_set_shop_money_amountdecimaltotal_tax_set_shop_money_currency_code VARCHAR(256)total_tax_set_shop_money_currency_codevarchartotal_tax_set_presentment_money_amount DECIMAL(38,9)total_tax_set_presentment_money_amountdecimal+45 more (see below) +45 more (see below)customers (Shopify Customers)customers (Shopify Customers)extid BIGINT · primary keyidbigintcreated_at TIMESTAMPcreated_attimestampabandoned_checkout_discount_codesabandoned_checkout_discount_codes5abandoned_checkout_id BIGINT · primary key · → abandoned_checkouts.idabandoned_checkout_idbigintindex BIGINT · primary keyindexbigintcode VARCHAR(65535)codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampabandoned_checkout_line_itemsabandoned_checkout_line_items28id BIGINT · primary keyidbigintabandoned_checkout_id BIGINT · → abandoned_checkouts.idabandoned_checkout_idbiginttypename VARCHAR(256)typenamevarchartitle VARCHAR(65535)titlevarcharvariant_title VARCHAR(65535)variant_titlevarcharsku VARCHAR(65535)skuvarcharquantity BIGINTquantitybigintproduct_id BIGINTproduct_idbigintvariant_id BIGINTvariant_idbigintoriginal_unit_price_set_shop_money_amount DECIMAL(38,9)original_unit_price_set_shop_money_amountdecimaloriginal_unit_price_set_shop_money_currency_code VARCHAR(256)original_unit_price_set_shop_money_currency_codevarcharoriginal_unit_price_set_presentment_money_amount DECIMAL(38,9)original_unit_price_set_presentment_money_amountdecimaloriginal_unit_price_set_presentment_money_currency_code VARCHAR(256)original_unit_price_set_presentment_money_currency…varcharoriginal_total_price_set_shop_money_amount DECIMAL(38,9)original_total_price_set_shop_money_amountdecimaloriginal_total_price_set_shop_money_currency_code VARCHAR(256)original_total_price_set_shop_money_currency_codevarcharoriginal_total_price_set_presentment_money_amount DECIMAL(38,9)original_total_price_set_presentment_money_amountdecimaloriginal_total_price_set_presentment_money_currency_code VARCHAR(256)original_total_price_set_presentment_money_currenc…varchardiscounted_unit_price_set_shop_money_amount DECIMAL(38,9)discounted_unit_price_set_shop_money_amountdecimaldiscounted_unit_price_set_shop_money_currency_code VARCHAR(256)discounted_unit_price_set_shop_money_currency_codevarchardiscounted_unit_price_set_presentment_money_amount DECIMAL(38,9)discounted_unit_price_set_presentment_money_amountdecimal+8 more (see below) +8 more (see below)discount_redeem_codesdiscount_redeem_codes7id BIGINT · primary keyidbigintdiscount_id BIGINT · → discounts.iddiscount_idbigintcode VARCHAR(65535)codevarchartypename VARCHAR(256)typenamevarcharasync_usage_count BIGINTasync_usage_countbigint_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampdiscountsdiscounts23id BIGINT · primary keyidbigintdiscount_typename VARCHAR(256)discount_typenamevarchardiscount_title VARCHAR(65535)discount_titlevarchardiscount_status VARCHAR(256)discount_statusvarchardiscount_summary VARCHAR(65535)discount_summaryvarchardiscount_starts_at TIMESTAMPdiscount_starts_attimestampdiscount_ends_at TIMESTAMPdiscount_ends_attimestampdiscount_created_at TIMESTAMPdiscount_created_attimestampdiscount_updated_at TIMESTAMPdiscount_updated_attimestampdiscount_async_usage_count BIGINTdiscount_async_usage_countbigintdiscount_customer_gets_value_typename VARCHAR(256)discount_customer_gets_value_typenamevarchardiscount_customer_gets_value_percentage DECIMAL(38,9)discount_customer_gets_value_percentagedecimaldiscount_customer_gets_value_amount_amount DECIMAL(38,9)discount_customer_gets_value_amount_amountdecimaldiscount_customer_gets_value_amount_currency_code VARCHAR(256)discount_customer_gets_value_amount_currency_codevarchardiscount_customer_gets_value_applies_on_each_item BOOLEANdiscount_customer_gets_value_applies_on_each_itembooldiscount_total_sales_amount DECIMAL(38,9)discount_total_sales_amountdecimaldiscount_total_sales_currency_code VARCHAR(256)discount_total_sales_currency_codevarchardiscount_usage_limit BIGINTdiscount_usage_limitbigintdiscount_applies_once_per_customer BOOLEANdiscount_applies_once_per_customerbooldiscount_codes_count_count BIGINTdiscount_codes_count_countbigint+3 more (see below) +3 more (see below)order_discount_codes (Shopify Orders)order_discount_codes (Shopify Orders)extcode VARCHAR(65535) · → discount_redeem_codes.codecodevarcharorder_id BIGINTorder_idbigintindex BIGINTindexbigint
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

7 tables · click a table for its columns
abandoned_checkouts65 columns · Abandoned checkoutsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
namevarchar(65535)
created_attimestamp
updated_attimestamp
completed_attimestamp
notevarchar(65535)
abandoned_checkout_urlvarchar(65535)
taxes_includedboolean
customer_idReferences customers.id.bigintFKReferences customers.id.
subtotal_price_set_shop_money_amountdecimal(38,9)
subtotal_price_set_shop_money_currency_codevarchar(256)
subtotal_price_set_presentment_money_amountdecimal(38,9)
subtotal_price_set_presentment_money_currency_codevarchar(256)
total_price_set_shop_money_amountdecimal(38,9)
total_price_set_shop_money_currency_codevarchar(256)
total_price_set_presentment_money_amountdecimal(38,9)
total_price_set_presentment_money_currency_codevarchar(256)
total_tax_set_shop_money_amountdecimal(38,9)
total_tax_set_shop_money_currency_codevarchar(256)
total_tax_set_presentment_money_amountdecimal(38,9)
total_tax_set_presentment_money_currency_codevarchar(256)
total_discount_set_shop_money_amountdecimal(38,9)
total_discount_set_shop_money_currency_codevarchar(256)
total_discount_set_presentment_money_amountdecimal(38,9)
total_discount_set_presentment_money_currency_codevarchar(256)
total_line_items_price_set_shop_money_amountdecimal(38,9)
total_line_items_price_set_shop_money_currency_codevarchar(256)
total_line_items_price_set_presentment_money_amountdecimal(38,9)
total_line_items_price_set_presentment_money_currency_codevarchar(256)
total_duties_set_shop_money_amountdecimal(38,9)
total_duties_set_shop_money_currency_codevarchar(256)
total_duties_set_presentment_money_amountdecimal(38,9)
total_duties_set_presentment_money_currency_codevarchar(256)
shipping_address_first_namevarchar(65535)
shipping_address_last_namevarchar(65535)
shipping_address_namevarchar(65535)
shipping_address_companyvarchar(65535)
shipping_address_address1varchar(65535)
shipping_address_address2varchar(65535)
shipping_address_cityvarchar(65535)
shipping_address_provincevarchar(65535)
shipping_address_province_codevarchar(65535)
shipping_address_countryvarchar(65535)
shipping_address_country_code_v2varchar(256)
shipping_address_zipvarchar(65535)
shipping_address_phonevarchar(65535)
shipping_address_latitudedecimal(38,9)
shipping_address_longitudedecimal(38,9)
billing_address_first_namevarchar(65535)
billing_address_last_namevarchar(65535)
billing_address_namevarchar(65535)
billing_address_companyvarchar(65535)
billing_address_address1varchar(65535)
billing_address_address2varchar(65535)
billing_address_cityvarchar(65535)
billing_address_provincevarchar(65535)
billing_address_province_codevarchar(65535)
billing_address_countryvarchar(65535)
billing_address_country_code_v2varchar(256)
billing_address_zipvarchar(65535)
billing_address_phonevarchar(65535)
billing_address_latitudedecimal(38,9)
billing_address_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.
abandoned_checkout_discount_codes5 columns · Abandoned checkoutsshow in diagram

Primary key: abandoned_checkout_id, index

ColumnTypeKeyDescription
abandoned_checkout_idPrimary key (with index). References abandoned_checkouts.id.bigintPK FKPrimary key (with index). References abandoned_checkouts.id.
indexPrimary key (with abandoned_checkout_id).bigintPK Primary key (with abandoned_checkout_id).
codevarchar(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.
abandoned_checkout_custom_attributes6 columns · Abandoned checkoutsshow in diagram

Primary key: abandoned_checkout_id, index

ColumnTypeKeyDescription
abandoned_checkout_idPrimary key (with index). References abandoned_checkouts.id.bigintPK FKPrimary key (with index). References abandoned_checkouts.id.
indexPrimary key (with abandoned_checkout_id).bigintPK Primary key (with abandoned_checkout_id).
keyvarchar(65535)
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.
abandoned_checkout_tax_lines13 columns · Abandoned checkoutsshow in diagram

Primary key: abandoned_checkout_id, index

ColumnTypeKeyDescription
abandoned_checkout_idPrimary key (with index). References abandoned_checkouts.id.bigintPK FKPrimary key (with index). References abandoned_checkouts.id.
indexPrimary key (with abandoned_checkout_id).bigintPK Primary key (with abandoned_checkout_id).
titlevarchar(65535)
ratedecimal(38,9)
rate_percentagedecimal(38,9)
sourcevarchar(65535)
channel_liableboolean
price_set_shop_money_amountdecimal(38,9)
price_set_shop_money_currency_codevarchar(256)
price_set_presentment_money_amountdecimal(38,9)
price_set_presentment_money_currency_codevarchar(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.
abandoned_checkout_line_items28 columns · Abandoned checkoutsshow in diagram

Primary key: id

ColumnTypeKeyDescription
abandoned_checkout_idReferences abandoned_checkouts.id.bigintFKReferences abandoned_checkouts.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
titlevarchar(65535)
variant_titlevarchar(65535)
skuvarchar(65535)
quantitybigint
product_idbigint
variant_idbigint
original_unit_price_set_shop_money_amountdecimal(38,9)
original_unit_price_set_shop_money_currency_codevarchar(256)
original_unit_price_set_presentment_money_amountdecimal(38,9)
original_unit_price_set_presentment_money_currency_codevarchar(256)
original_total_price_set_shop_money_amountdecimal(38,9)
original_total_price_set_shop_money_currency_codevarchar(256)
original_total_price_set_presentment_money_amountdecimal(38,9)
original_total_price_set_presentment_money_currency_codevarchar(256)
discounted_unit_price_set_shop_money_amountdecimal(38,9)
discounted_unit_price_set_shop_money_currency_codevarchar(256)
discounted_unit_price_set_presentment_money_amountdecimal(38,9)
discounted_unit_price_set_presentment_money_currency_codevarchar(256)
discounted_total_price_set_shop_money_amountdecimal(38,9)
discounted_total_price_set_shop_money_currency_codevarchar(256)
discounted_total_price_set_presentment_money_amountdecimal(38,9)
discounted_total_price_set_presentment_money_currency_codevarchar(256)
custom_attributesvarchar(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.
discounts23 columns · Discountsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
discount_typenameDiscountCodeBasic, DiscountCodeBxgy, DiscountCodeFreeShipping, DiscountCodeApp or the DiscountAutomatic* equivalent.varchar(256)DiscountCodeBasic, DiscountCodeBxgy, DiscountCodeFreeShipping, DiscountCodeApp or the DiscountAutomatic* equivalent.
discount_titlevarchar(65535)
discount_statusvarchar(256)
discount_summaryvarchar(65535)
discount_starts_attimestamp
discount_ends_attimestamp
discount_created_attimestamp
discount_updated_attimestamp
discount_async_usage_countbigint
discount_customer_gets_value_typenamevarchar(256)
discount_customer_gets_value_percentagedecimal(38,9)
discount_customer_gets_value_amount_amountdecimal(38,9)
discount_customer_gets_value_amount_currency_codevarchar(256)
discount_customer_gets_value_applies_on_each_itemboolean
discount_total_sales_amountdecimal(38,9)
discount_total_sales_currency_codevarchar(256)
discount_usage_limitbigint
discount_applies_once_per_customerboolean
discount_codes_count_countbigint
discount_uses_per_order_limitbigint
_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.
discount_redeem_codes7 columns · Discountsshow in diagram

Primary key: id

ColumnTypeKeyDescription
discount_idReferences discounts.id.bigintFKReferences discounts.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
codevarchar(65535)
async_usage_countbigint
_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 Checkouts & Discounts All connectors