Schema · Entity relationship diagram
Shopify Payments & Payouts tables and relationships
Shopify Payments payouts (with charge, refund and fee summaries), balance transactions (every charge, refund, fee and adjustment with its payout) and disputes. For stores that take payments through Shopify Payments. Tables and columns are named after the Shopify Admin API and share one shopify schema with Shopify Orders, Shopify Customers, Shopify Products & Inventory, Shopify Checkouts & Discounts, Shopify Analytics.
ConnectPaste an API key
Default schema
shopifySource API docshelp.shopify.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
- The six Shopify connectors load into one
shopifyschema. The others: Shopify Orders, Shopify Customers, Shopify Products & Inventory, 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, itslineItems→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_syncedis the load time;_jsdata_deletedis always false. - Only stores that take payments through Shopify Payments have these tables; PayPal and other processors are not in Shopify's API.
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
3 tables · click a table for its columnspayouts35 columns · Shopify Paymentsshow in diagram
Primary key: id
| Column | Type | Key | Description |
|---|---|---|---|
| idPrimary key. | bigint | PK | Primary key. |
| status | varchar(256) | ||
| issued_at | timestamp | ||
| transaction_type | varchar(256) | ||
| external_trace_id | varchar(65535) | ||
| net_amount | decimal(38,9) | ||
| net_currency_code | varchar(256) | ||
| business_entity_id | varchar(256) | ||
| business_entity_display_name | varchar(65535) | ||
| summary_charges_gross_amount | decimal(38,9) | ||
| summary_charges_gross_currency_code | varchar(256) | ||
| summary_charges_fee_amount | decimal(38,9) | ||
| summary_charges_fee_currency_code | varchar(256) | ||
| summary_refunds_fee_gross_amount | decimal(38,9) | ||
| summary_refunds_fee_gross_currency_code | varchar(256) | ||
| summary_refunds_fee_amount | decimal(38,9) | ||
| summary_refunds_fee_currency_code | varchar(256) | ||
| summary_adjustments_gross_amount | decimal(38,9) | ||
| summary_adjustments_gross_currency_code | varchar(256) | ||
| summary_adjustments_fee_amount | decimal(38,9) | ||
| summary_adjustments_fee_currency_code | varchar(256) | ||
| summary_advance_gross_amount | decimal(38,9) | ||
| summary_advance_gross_currency_code | varchar(256) | ||
| summary_advance_fees_amount | decimal(38,9) | ||
| summary_advance_fees_currency_code | varchar(256) | ||
| summary_reserved_funds_gross_amount | decimal(38,9) | ||
| summary_reserved_funds_gross_currency_code | varchar(256) | ||
| summary_reserved_funds_fee_amount | decimal(38,9) | ||
| summary_reserved_funds_fee_currency_code | varchar(256) | ||
| summary_retried_payouts_gross_amount | decimal(38,9) | ||
| summary_retried_payouts_gross_currency_code | varchar(256) | ||
| summary_retried_payouts_fee_amount | decimal(38,9) | ||
| summary_retried_payouts_fee_currency_code | varchar(256) | ||
| _jsdata_deletedTrue when the record was deleted at the source. | boolean | True when the record was deleted at the source. | |
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
balance_transactions20 columns · Shopify Paymentsshow in diagram
Primary key: id
| Column | Type | Key | Description |
|---|---|---|---|
| idPrimary key. | bigint | PK | Primary key. |
| type | varchar(256) | ||
| test | boolean | ||
| transaction_date | timestamp | ||
| source_id | bigint | ||
| source_type | varchar(256) | ||
| source_order_transaction_idReferences order_transactions.id. | bigint | FK | References order_transactions.id. |
| adjustment_reason | varchar(65535) | ||
| amount_amount | decimal(38,9) | ||
| amount_currency_code | varchar(256) | ||
| fee_amount | decimal(38,9) | ||
| fee_currency_code | varchar(256) | ||
| net_amount | decimal(38,9) | ||
| net_currency_code | varchar(256) | ||
| associated_order_idReferences orders.id. | bigint | FK | References orders.id. |
| associated_order_name | varchar(65535) | ||
| associated_payout_idReferences payouts.id. | bigint | FK | References payouts.id. |
| associated_payout_statusMoves from PENDING to PAID after the payout: the last 14 days are re-read every sync. | varchar(256) | Moves from PENDING to PAID after the payout: the last 14 days are re-read every sync. | |
| _jsdata_deletedTrue when the record was deleted at the source. | boolean | True when the record was deleted at the source. | |
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
disputes14 columns · Shopify Paymentsshow in diagram
Primary key: id
| Column | Type | Key | Description |
|---|---|---|---|
| idPrimary key. | bigint | PK | Primary key. |
| status | varchar(256) | ||
| type | varchar(256) | ||
| initiated_at | timestamp | ||
| evidence_due_by | timestamp | ||
| evidence_sent_on | timestamp | ||
| finalized_on | timestamp | ||
| amount_amount | decimal(38,9) | ||
| amount_currency_code | varchar(256) | ||
| order_idReferences orders.id. | bigint | FK | References orders.id. |
| reason_details_reason | varchar(256) | ||
| reason_details_network_reason_code | varchar(65535) | ||
| _jsdata_deletedTrue when the record was deleted at the source. | boolean | True when the record was deleted at the source. | |
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |