JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

Shopify Orders tables and relationships

Orders with line items, shipping lines, discount applications and allocations, tax lines, tags, discount codes and custom attributes; refunds (lines, shipping, adjustments); payment and tender transactions; fulfillments with tracking, fulfillment orders, events and fulfilled line items; the shop record. Tables and columns are named after the Shopify Admin API and share one shopify schema with Shopify Customers, Shopify Products & Inventory, Shopify Payments & Payouts, Shopify Checkouts & Discounts, Shopify Analytics.

Live25 tables · 32 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 Customers, 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.
  • Emails, names, phone numbers, street addresses, IPs and order notes load empty unless you turn on personal data; customer ids, city, province and country are kept.
  • fulfillment_orders, fulfillment_events and fulfillment_line_items need the app's fulfillment-order scopes; without read_third_party_fulfillment_orders, orders shipped by a 3PL are missing there (Shopify returns them silently incomplete). fulfillments comes from each order and is always complete.
ORDERSorder_discount_codes.order_id → orders.idorder_tags.order_id → orders.idorder_custom_attributes.order_id → orders.idorder_tax_lines.order_id → orders.idrefunds.order_id → orders.idorder_transactions.order_id → orders.idfulfillments.order_id → orders.idfulfillment_tracking_info.fulfillment_id → fulfillments.idorder_line_items.order_id → orders.idorder_shipping_lines.order_id → orders.idorder_discount_applications.order_id → orders.idrefund_line_items.refund_id → refunds.idrefund_shipping_lines.refund_id → refunds.idorder_adjustments.refund_id → refunds.idrefund_transactions.refund_id → refunds.idfulfillment_orders.order_id → orders.idfulfillment_events.fulfillment_id → fulfillments.idfulfillment_line_items.fulfillment_id → fulfillments.idtender_transactions.order_id → orders.idorder_line_item_tax_lines.line_item_id → order_line_items.idorder_line_item_discount_allocations.line_item_id → order_line_items.idorder_line_item_custom_attributes.line_item_id → order_line_items.idorder_shipping_line_tax_lines.shipping_line_id → order_shipping_lines.idrefund_line_items.line_item_id → order_line_items.idfulfillment_line_items.line_item_id → order_line_items.idrefund_transactions.transaction_id → order_transactions.idrefund_shipping_lines.shipping_line_id → order_shipping_lines.idorder_line_item_discount_allocations.discount_application_index joins order_discount_applications.index (Together with the order: the allocation belongs to the order's discount application with this index.)orders.customer_id → customers.idorder_line_items.variant_id → product_variants.idfulfillments.location_id → locations.idorders.retail_location_id → locations.idorder_tax_linesorder_tax_lines13order_id BIGINT · primary key · → orders.idorder_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_syncedtimestampfulfillment_eventsfulfillment_events17id BIGINT · primary keyidbigintfulfillment_id BIGINT · → fulfillments.idfulfillment_idbiginttypename VARCHAR(256)typenamevarcharstatus VARCHAR(256)statusvarcharhappened_at TIMESTAMPhappened_attimestampcreated_at TIMESTAMPcreated_attimestampestimated_delivery_at TIMESTAMPestimated_delivery_attimestampmessage VARCHAR(65535)messagevarcharaddress1 VARCHAR(65535)address1varcharcity VARCHAR(65535)cityvarcharprovince VARCHAR(65535)provincevarcharcountry VARCHAR(65535)countryvarcharzip VARCHAR(65535)zipvarcharlatitude DECIMAL(38,9)latitudedecimallongitude DECIMAL(38,9)longitudedecimal_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamprefund_line_itemsrefund_line_items21id BIGINT · primary keyidbigintrefund_id BIGINT · → refunds.idrefund_idbigintline_item_id BIGINT · → order_line_items.idline_item_idbigintquantity BIGINTquantitybigintrestock_type VARCHAR(256)restock_typevarcharrestocked BOOLEANrestockedboollocation_id BIGINTlocation_idbigintprice_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_codevarcharsubtotal_set_shop_money_amount DECIMAL(38,9)subtotal_set_shop_money_amountdecimalsubtotal_set_shop_money_currency_code VARCHAR(256)subtotal_set_shop_money_currency_codevarcharsubtotal_set_presentment_money_amount DECIMAL(38,9)subtotal_set_presentment_money_amountdecimalsubtotal_set_presentment_money_currency_code VARCHAR(256)subtotal_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_amountdecimaltotal_tax_set_presentment_money_currency_code VARCHAR(256)total_tax_set_presentment_money_currency_codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool+1 more (see below) +1 more (see below)tender_transactionstender_transactions13id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbigintprocessed_at TIMESTAMPprocessed_attimestamptest BOOLEANtestboolpayment_method VARCHAR(65535)payment_methodvarcharremote_reference VARCHAR(65535)remote_referencevarcharamount_amount DECIMAL(38,9)amount_amountdecimalamount_currency_code VARCHAR(256)amount_currency_codevarchartransaction_details_typename VARCHAR(256)transaction_details_typenamevarchartransaction_details_credit_card_company VARCHAR(65535)transaction_details_credit_card_companyvarchartransaction_details_credit_card_number VARCHAR(65535)transaction_details_credit_card_numbervarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_transactionsorder_transactions29id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbigintindex BIGINTindexbigintkind VARCHAR(256)kindvarcharstatus VARCHAR(256)statusvarchargateway VARCHAR(65535)gatewayvarcharformatted_gateway VARCHAR(65535)formatted_gatewayvarchartest BOOLEANtestboolerror_code VARCHAR(256)error_codevarcharcreated_at TIMESTAMPcreated_attimestampprocessed_at TIMESTAMPprocessed_attimestampauthorization_expires_at TIMESTAMPauthorization_expires_attimestamppayment_id VARCHAR(65535)payment_idvarcharaccount_number VARCHAR(65535)account_numbervarcharmanual_payment_gateway BOOLEANmanual_payment_gatewayboolamount_set_shop_money_amount DECIMAL(38,9)amount_set_shop_money_amountdecimalamount_set_shop_money_currency_code VARCHAR(256)amount_set_shop_money_currency_codevarcharamount_set_presentment_money_amount DECIMAL(38,9)amount_set_presentment_money_amountdecimalamount_set_presentment_money_currency_code VARCHAR(256)amount_set_presentment_money_currency_codevarcharparent_transaction_id BIGINTparent_transaction_idbigint+9 more (see below) +9 more (see below)fulfillment_ordersfulfillment_orders15id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbigintstatus VARCHAR(256)statusvarcharrequest_status VARCHAR(256)request_statusvarcharcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampfulfill_at TIMESTAMPfulfill_attimestampfulfill_by TIMESTAMPfulfill_bytimestamporder_name VARCHAR(65535)order_namevarcharorder_processed_at TIMESTAMPorder_processed_attimestampassigned_location_name VARCHAR(65535)assigned_location_namevarcharassigned_location_location_id BIGINTassigned_location_location_idbigintdelivery_method_method_type VARCHAR(256)delivery_method_method_typevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_line_itemsorder_line_items42id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbigintvariant_id BIGINT · → product_variants.idvariant_idbiginttypename VARCHAR(256)typenamevarcharname VARCHAR(65535)namevarchartitle VARCHAR(65535)titlevarcharvariant_title VARCHAR(65535)variant_titlevarcharsku VARCHAR(65535)skuvarcharvendor VARCHAR(65535)vendorvarcharquantity BIGINTquantitybigintcurrent_quantity BIGINTcurrent_quantitybigintunfulfilled_quantity BIGINTunfulfilled_quantitybigintrefundable_quantity BIGINTrefundable_quantitybigintnon_fulfillable_quantity BIGINTnon_fulfillable_quantitybigintrequires_shipping BOOLEANrequires_shippingbooltaxable BOOLEANtaxableboolis_gift_card BOOLEANis_gift_cardboolproduct_id BIGINTproduct_idbigintselling_plan_name VARCHAR(65535)selling_plan_namevarcharselling_plan_selling_plan_id BIGINTselling_plan_selling_plan_idbigint+22 more (see below) +22 more (see below)order_line_item_custom_attributesorder_line_item_custom_attributes6line_item_id BIGINT · primary key · → order_line_items.idline_item_idbigintindex BIGINT · primary keyindexbigintkey VARCHAR(65535)keyvarcharvalue VARCHAR(65535)valuevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcustomers (Shopify Customers)customers (Shopify Customers)extid BIGINT · primary keyidbigintcreated_at TIMESTAMPcreated_attimestampnumber_of_orders BIGINTnumber_of_ordersbigintorder_line_item_tax_linesorder_line_item_tax_lines13line_item_id BIGINT · primary key · → order_line_items.idline_item_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_syncedtimestampordersorders175id BIGINT · primary keyidbigintcustomer_id BIGINT · → customers.idcustomer_idbigintretail_location_id BIGINT · → locations.idretail_location_idbigintname VARCHAR(65535)namevarcharnumber BIGINTnumberbigintcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampprocessed_at TIMESTAMPprocessed_attimestampcancelled_at TIMESTAMPcancelled_attimestampclosed_at TIMESTAMPclosed_attimestampcancel_reason VARCHAR(256)cancel_reasonvarcharcancellation_staff_note VARCHAR(65535)cancellation_staff_notevarcharemail VARCHAR(65535)emailvarcharphone VARCHAR(65535)phonevarcharnote VARCHAR(65535)notevarcharpo_number VARCHAR(65535)po_numbervarcharconfirmation_number VARCHAR(65535)confirmation_numbervarcharsource_name VARCHAR(65535)source_namevarcharsource_identifier VARCHAR(65535)source_identifiervarcharcustomer_locale VARCHAR(65535)customer_localevarchar+155 more (see below) +155 more (see below)fulfillmentsfulfillments18id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbigintlocation_id BIGINT · → locations.idlocation_idbigintindex BIGINTindexbigintname VARCHAR(65535)namevarcharstatus VARCHAR(256)statusvarchardisplay_status VARCHAR(256)display_statusvarcharcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampdelivered_at TIMESTAMPdelivered_attimestampin_transit_at TIMESTAMPin_transit_attimestampestimated_delivery_at TIMESTAMPestimated_delivery_attimestamptotal_quantity BIGINTtotal_quantitybigintrequires_shipping BOOLEANrequires_shippingboolservice_id BIGINTservice_idbigintservice_service_name VARCHAR(65535)service_service_namevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamplocations (Shopify Products & Inventory)locations (Shopify Products & Inventory)extid BIGINT · primary keyidbigintname VARCHAR(65535)namevarcharis_active BOOLEANis_activeboolorder_shipping_line_tax_linesorder_shipping_line_tax_lines13shipping_line_id BIGINT · primary key · → order_shipping_lines.idshipping_line_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_syncedtimestamporder_discount_applicationsorder_discount_applications15order_id BIGINT · primary key · → orders.idorder_idbigintindex BIGINT · primary keyindexbiginttypename VARCHAR(256)typenamevarcharallocation_method VARCHAR(256)allocation_methodvarchartarget_selection VARCHAR(256)target_selectionvarchartarget_type VARCHAR(256)target_typevarcharvalue_typename VARCHAR(256)value_typenamevarcharvalue_amount DECIMAL(38,9)value_amountdecimalvalue_currency_code VARCHAR(256)value_currency_codevarcharvalue_percentage DECIMAL(38,9)value_percentagedecimalcode VARCHAR(65535)codevarchartitle VARCHAR(65535)titlevarchardescription VARCHAR(65535)descriptionvarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampfulfillment_line_itemsfulfillment_line_items15id BIGINT · primary keyidbigintfulfillment_id BIGINT · → fulfillments.idfulfillment_idbigintline_item_id BIGINT · → order_line_items.idline_item_idbiginttypename VARCHAR(256)typenamevarcharquantity BIGINTquantitybigintoriginal_total_set_shop_money_amount DECIMAL(38,9)original_total_set_shop_money_amountdecimaloriginal_total_set_shop_money_currency_code VARCHAR(256)original_total_set_shop_money_currency_codevarcharoriginal_total_set_presentment_money_amount DECIMAL(38,9)original_total_set_presentment_money_amountdecimaloriginal_total_set_presentment_money_currency_code VARCHAR(256)original_total_set_presentment_money_currency_codevarchardiscounted_total_set_shop_money_amount DECIMAL(38,9)discounted_total_set_shop_money_amountdecimaldiscounted_total_set_shop_money_currency_code VARCHAR(256)discounted_total_set_shop_money_currency_codevarchardiscounted_total_set_presentment_money_amount DECIMAL(38,9)discounted_total_set_presentment_money_amountdecimaldiscounted_total_set_presentment_money_currency_code VARCHAR(256)discounted_total_set_presentment_money_currency_co…varchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_custom_attributesorder_custom_attributes6order_id BIGINT · primary key · → orders.idorder_idbigintindex BIGINT · primary keyindexbigintkey VARCHAR(65535)keyvarcharvalue VARCHAR(65535)valuevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampproduct_variants (Shopify Products & Inventory)product_variants (Shopify Products & Inventory)extid BIGINT · primary keyidbigintproduct_id BIGINTproduct_idbiginttitle VARCHAR(65535)titlevarcharsku VARCHAR(65535)skuvarcharprice DECIMAL(38,9)pricedecimalorder_line_item_discount_allocationsorder_line_item_discount_allocations9line_item_id BIGINT · primary key · → order_line_items.idline_item_idbigintindex BIGINT · primary keyindexbigintdiscount_application_index BIGINT · → order_discount_applications.indexdiscount_application_indexbigintallocated_amount_set_shop_money_amount DECIMAL(38,9)allocated_amount_set_shop_money_amountdecimalallocated_amount_set_shop_money_currency_code VARCHAR(256)allocated_amount_set_shop_money_currency_codevarcharallocated_amount_set_presentment_money_amount DECIMAL(38,9)allocated_amount_set_presentment_money_amountdecimalallocated_amount_set_presentment_money_currency_code VARCHAR(256)allocated_amount_set_presentment_money_currency_co…varchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_shipping_linesorder_shipping_lines24id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbiginttypename VARCHAR(256)typenamevarchartitle VARCHAR(65535)titlevarcharcode VARCHAR(65535)codevarcharsource VARCHAR(65535)sourcevarcharcarrier_identifier VARCHAR(65535)carrier_identifiervarchardelivery_category VARCHAR(65535)delivery_categoryvarcharcustom BOOLEANcustomboolis_removed BOOLEANis_removedbooloriginal_price_set_shop_money_amount DECIMAL(38,9)original_price_set_shop_money_amountdecimaloriginal_price_set_shop_money_currency_code VARCHAR(256)original_price_set_shop_money_currency_codevarcharoriginal_price_set_presentment_money_amount DECIMAL(38,9)original_price_set_presentment_money_amountdecimaloriginal_price_set_presentment_money_currency_code VARCHAR(256)original_price_set_presentment_money_currency_codevarchardiscounted_price_set_shop_money_amount DECIMAL(38,9)discounted_price_set_shop_money_amountdecimaldiscounted_price_set_shop_money_currency_code VARCHAR(256)discounted_price_set_shop_money_currency_codevarchardiscounted_price_set_presentment_money_amount DECIMAL(38,9)discounted_price_set_presentment_money_amountdecimaldiscounted_price_set_presentment_money_currency_code VARCHAR(256)discounted_price_set_presentment_money_currency_co…varcharcurrent_discounted_price_set_shop_money_amount DECIMAL(38,9)current_discounted_price_set_shop_money_amountdecimalcurrent_discounted_price_set_shop_money_currency_code VARCHAR(256)current_discounted_price_set_shop_money_currency_c…varchar+4 more (see below) +4 more (see below)fulfillment_tracking_infofulfillment_tracking_info7fulfillment_id BIGINT · primary key · → fulfillments.idfulfillment_idbigintindex BIGINT · primary keyindexbigintcompany VARCHAR(65535)companyvarcharnumber VARCHAR(65535)numbervarcharurl VARCHAR(65535)urlvarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_discount_codesorder_discount_codes5order_id BIGINT · primary key · → orders.idorder_idbigintindex BIGINT · primary keyindexbigintcode VARCHAR(65535)codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamprefund_shipping_linesrefund_shipping_lines15id BIGINT · primary keyidbigintrefund_id BIGINT · → refunds.idrefund_idbigintshipping_line_id BIGINT · → order_shipping_lines.idshipping_line_idbigintshipping_line_title VARCHAR(65535)shipping_line_titlevarcharshipping_line_code VARCHAR(65535)shipping_line_codevarcharsubtotal_amount_set_shop_money_amount DECIMAL(38,9)subtotal_amount_set_shop_money_amountdecimalsubtotal_amount_set_shop_money_currency_code VARCHAR(256)subtotal_amount_set_shop_money_currency_codevarcharsubtotal_amount_set_presentment_money_amount DECIMAL(38,9)subtotal_amount_set_presentment_money_amountdecimalsubtotal_amount_set_presentment_money_currency_code VARCHAR(256)subtotal_amount_set_presentment_money_currency_codevarchartax_amount_set_shop_money_amount DECIMAL(38,9)tax_amount_set_shop_money_amountdecimaltax_amount_set_shop_money_currency_code VARCHAR(256)tax_amount_set_shop_money_currency_codevarchartax_amount_set_presentment_money_amount DECIMAL(38,9)tax_amount_set_presentment_money_amountdecimaltax_amount_set_presentment_money_currency_code VARCHAR(256)tax_amount_set_presentment_money_currency_codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_tagsorder_tags5order_id BIGINT · primary key · → orders.idorder_idbigintindex BIGINT · primary keyindexbigintvalue VARCHAR(65535)valuevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamprefundsrefunds13id BIGINT · primary keyidbigintorder_id BIGINT · → orders.idorder_idbigintindex BIGINTindexbigintcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampprocessed_at TIMESTAMPprocessed_attimestampnote VARCHAR(65535)notevarchartotal_refunded_set_shop_money_amount DECIMAL(38,9)total_refunded_set_shop_money_amountdecimaltotal_refunded_set_shop_money_currency_code VARCHAR(256)total_refunded_set_shop_money_currency_codevarchartotal_refunded_set_presentment_money_amount DECIMAL(38,9)total_refunded_set_presentment_money_amountdecimaltotal_refunded_set_presentment_money_currency_code VARCHAR(256)total_refunded_set_presentment_money_currency_codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamprefund_transactionsrefund_transactions4refund_id BIGINT · primary key · → refunds.idrefund_idbiginttransaction_id BIGINT · primary key · → order_transactions.idtransaction_idbigint_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamporder_adjustmentsorder_adjustments13id BIGINT · primary keyidbigintrefund_id BIGINT · → refunds.idrefund_idbigintreason VARCHAR(256)reasonvarcharamount_set_shop_money_amount DECIMAL(38,9)amount_set_shop_money_amountdecimalamount_set_shop_money_currency_code VARCHAR(256)amount_set_shop_money_currency_codevarcharamount_set_presentment_money_amount DECIMAL(38,9)amount_set_presentment_money_amountdecimalamount_set_presentment_money_currency_code VARCHAR(256)amount_set_presentment_money_currency_codevarchartax_amount_set_shop_money_amount DECIMAL(38,9)tax_amount_set_shop_money_amountdecimaltax_amount_set_shop_money_currency_code VARCHAR(256)tax_amount_set_shop_money_currency_codevarchartax_amount_set_presentment_money_amount DECIMAL(38,9)tax_amount_set_presentment_money_amountdecimaltax_amount_set_presentment_money_currency_code VARCHAR(256)tax_amount_set_presentment_money_currency_codevarchar_jsdata_deleted BOOLEAN_jsdata_deletedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampshopshop24id BIGINT · primary keyidbigintname VARCHAR(65535)namevarcharemail VARCHAR(65535)emailvarcharcontact_email VARCHAR(65535)contact_emailvarcharmyshopify_domain VARCHAR(65535)myshopify_domainvarcharurl VARCHAR(65535)urlvarcharcurrency_code VARCHAR(256)currency_codevarcharenabled_presentment_currencies VARCHAR(65535)enabled_presentment_currenciesvarchariana_timezone VARCHAR(65535)iana_timezonevarchartimezone_offset VARCHAR(65535)timezone_offsetvarchartaxes_included BOOLEANtaxes_includedbooltax_shipping BOOLEANtax_shippingboolweight_unit VARCHAR(256)weight_unitvarcharunit_system VARCHAR(256)unit_systemvarcharcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampshop_owner_name VARCHAR(65535)shop_owner_namevarcharplan_public_display_name VARCHAR(65535)plan_public_display_namevarcharplan_shopify_plus BOOLEANplan_shopify_plusboolplan_partner_development BOOLEANplan_partner_developmentbool+4 more (see below) +4 more (see below)
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

25 tables · click a table for its columns
orders175 columns · Ordersshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
namevarchar(65535)
numberbigint
created_attimestamp
updated_attimestamp
processed_attimestamp
cancelled_attimestamp
closed_attimestamp
cancel_reasonvarchar(256)
cancellation_staff_notevarchar(65535)
emailvarchar(65535)
phonevarchar(65535)
notevarchar(65535)
po_numbervarchar(65535)
confirmation_numbervarchar(65535)
source_namevarchar(65535)
source_identifiervarchar(65535)
customer_localevarchar(65535)
client_ipvarchar(65535)
currency_codevarchar(256)
presentment_currency_codevarchar(256)
taxes_includedboolean
tax_exemptboolean
duties_includedboolean
testboolean
confirmedboolean
closedboolean
editedboolean
display_financial_statusvarchar(256)
display_fulfillment_statusvarchar(256)
subtotal_line_items_quantitybigint
current_subtotal_line_items_quantitybigint
total_weightbigint
discount_codevarchar(65535)
payment_gateway_namesvarchar(65535)
customer_idReferences customers.id.bigintFKReferences customers.id.
app_idbigint
app_namevarchar(65535)
retail_location_idReferences locations.id.bigintFKReferences locations.id.
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)
customer_journey_summary_customer_order_indexbigint
customer_journey_summary_days_to_conversionbigint
customer_journey_summary_first_visit_idbigint
customer_journey_summary_first_visit_occurred_attimestamp
customer_journey_summary_first_visit_sourcevarchar(65535)
customer_journey_summary_first_visit_source_typevarchar(256)
customer_journey_summary_first_visit_source_descriptionvarchar(65535)
customer_journey_summary_first_visit_landing_pagevarchar(65535)
customer_journey_summary_first_visit_referrer_urlvarchar(65535)
customer_journey_summary_first_visit_referral_codevarchar(65535)
customer_journey_summary_first_visit_utm_parameters_sourcevarchar(65535)
customer_journey_summary_first_visit_utm_parameters_mediumvarchar(65535)
customer_journey_summary_first_visit_utm_parameters_campaignvarchar(65535)
customer_journey_summary_first_visit_utm_parameters_contentvarchar(65535)
customer_journey_summary_first_visit_utm_parameters_termvarchar(65535)
customer_journey_summary_last_visit_idbigint
customer_journey_summary_last_visit_occurred_attimestamp
customer_journey_summary_last_visit_sourcevarchar(65535)
customer_journey_summary_last_visit_source_typevarchar(256)
customer_journey_summary_last_visit_source_descriptionvarchar(65535)
customer_journey_summary_last_visit_landing_pagevarchar(65535)
customer_journey_summary_last_visit_referrer_urlvarchar(65535)
customer_journey_summary_last_visit_referral_codevarchar(65535)
customer_journey_summary_last_visit_utm_parameters_sourcevarchar(65535)
customer_journey_summary_last_visit_utm_parameters_mediumvarchar(65535)
customer_journey_summary_last_visit_utm_parameters_campaignvarchar(65535)
customer_journey_summary_last_visit_utm_parameters_contentvarchar(65535)
customer_journey_summary_last_visit_utm_parameters_termvarchar(65535)
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_discounts_set_shop_money_amountdecimal(38,9)
total_discounts_set_shop_money_currency_codevarchar(256)
total_discounts_set_presentment_money_amountdecimal(38,9)
total_discounts_set_presentment_money_currency_codevarchar(256)
total_shipping_price_set_shop_money_amountdecimal(38,9)
total_shipping_price_set_shop_money_currency_codevarchar(256)
total_shipping_price_set_presentment_money_amountdecimal(38,9)
total_shipping_price_set_presentment_money_currency_codevarchar(256)
total_tip_received_set_shop_money_amountdecimal(38,9)
total_tip_received_set_shop_money_currency_codevarchar(256)
total_tip_received_set_presentment_money_amountdecimal(38,9)
total_tip_received_set_presentment_money_currency_codevarchar(256)
total_refunded_set_shop_money_amountdecimal(38,9)
total_refunded_set_shop_money_currency_codevarchar(256)
total_refunded_set_presentment_money_amountdecimal(38,9)
total_refunded_set_presentment_money_currency_codevarchar(256)
total_refunded_shipping_set_shop_money_amountdecimal(38,9)
total_refunded_shipping_set_shop_money_currency_codevarchar(256)
total_refunded_shipping_set_presentment_money_amountdecimal(38,9)
total_refunded_shipping_set_presentment_money_currency_codevarchar(256)
total_received_set_shop_money_amountdecimal(38,9)
total_received_set_shop_money_currency_codevarchar(256)
total_received_set_presentment_money_amountdecimal(38,9)
total_received_set_presentment_money_currency_codevarchar(256)
total_outstanding_set_shop_money_amountdecimal(38,9)
total_outstanding_set_shop_money_currency_codevarchar(256)
total_outstanding_set_presentment_money_amountdecimal(38,9)
total_outstanding_set_presentment_money_currency_codevarchar(256)
net_payment_set_shop_money_amountdecimal(38,9)
net_payment_set_shop_money_currency_codevarchar(256)
net_payment_set_presentment_money_amountdecimal(38,9)
net_payment_set_presentment_money_currency_codevarchar(256)
cart_discount_amount_set_shop_money_amountdecimal(38,9)
cart_discount_amount_set_shop_money_currency_codevarchar(256)
cart_discount_amount_set_presentment_money_amountdecimal(38,9)
cart_discount_amount_set_presentment_money_currency_codevarchar(256)
current_subtotal_price_set_shop_money_amountdecimal(38,9)
current_subtotal_price_set_shop_money_currency_codevarchar(256)
current_subtotal_price_set_presentment_money_amountdecimal(38,9)
current_subtotal_price_set_presentment_money_currency_codevarchar(256)
current_total_price_set_shop_money_amountdecimal(38,9)
current_total_price_set_shop_money_currency_codevarchar(256)
current_total_price_set_presentment_money_amountdecimal(38,9)
current_total_price_set_presentment_money_currency_codevarchar(256)
current_total_tax_set_shop_money_amountdecimal(38,9)
current_total_tax_set_shop_money_currency_codevarchar(256)
current_total_tax_set_presentment_money_amountdecimal(38,9)
current_total_tax_set_presentment_money_currency_codevarchar(256)
current_total_discounts_set_shop_money_amountdecimal(38,9)
current_total_discounts_set_shop_money_currency_codevarchar(256)
current_total_discounts_set_presentment_money_amountdecimal(38,9)
current_total_discounts_set_presentment_money_currency_codevarchar(256)
current_shipping_price_set_shop_money_amountdecimal(38,9)
current_shipping_price_set_shop_money_currency_codevarchar(256)
current_shipping_price_set_presentment_money_amountdecimal(38,9)
current_shipping_price_set_presentment_money_currency_codevarchar(256)
current_total_duties_set_shop_money_amountdecimal(38,9)
current_total_duties_set_shop_money_currency_codevarchar(256)
current_total_duties_set_presentment_money_amountdecimal(38,9)
current_total_duties_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)
_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.
order_discount_codes5 columns · Ordersshow in diagram

Primary key: order_id, index

ColumnTypeKeyDescription
order_idPrimary key (with index). References orders.id.bigintPK FKPrimary key (with index). References orders.id.
indexPrimary key (with order_id).bigintPK Primary key (with order_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.
order_tags5 columns · Ordersshow in diagram

Primary key: order_id, index

ColumnTypeKeyDescription
order_idPrimary key (with index). References orders.id.bigintPK FKPrimary key (with index). References orders.id.
indexPrimary key (with order_id).bigintPK Primary key (with order_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.
order_custom_attributes6 columns · Ordersshow in diagram

Primary key: order_id, index

ColumnTypeKeyDescription
order_idPrimary key (with index). References orders.id.bigintPK FKPrimary key (with index). References orders.id.
indexPrimary key (with order_id).bigintPK Primary key (with order_id).
keyvarchar(65535)
valueCart / checkout attribute value; values whose key looks personal (email, phone, name, address) are blanked unless personal data is included.varchar(65535)Cart / checkout attribute value; values whose key looks personal (email, phone, name, address) are blanked unless personal data is included.
_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.
order_tax_lines13 columns · Ordersshow in diagram

Primary key: order_id, index

ColumnTypeKeyDescription
order_idPrimary key (with index). References orders.id.bigintPK FKPrimary key (with index). References orders.id.
indexPrimary key (with order_id).bigintPK Primary key (with order_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.
shop24 columns · Ordersshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
namevarchar(65535)
emailvarchar(65535)
contact_emailvarchar(65535)
myshopify_domainvarchar(65535)
urlvarchar(65535)
currency_codevarchar(256)
enabled_presentment_currenciesvarchar(65535)
iana_timezonevarchar(65535)
timezone_offsetvarchar(65535)
taxes_includedboolean
tax_shippingboolean
weight_unitvarchar(256)
unit_systemvarchar(256)
created_attimestamp
updated_attimestamp
shop_owner_namevarchar(65535)
plan_public_display_namevarchar(65535)
plan_shopify_plusboolean
plan_partner_developmentboolean
primary_domain_hostvarchar(65535)
primary_domain_urlvarchar(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.
order_line_items42 columns · Line items & shippingshow in diagram

Primary key: id

ColumnTypeKeyDescription
order_idReferences orders.id.bigintFKReferences orders.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
namevarchar(65535)
titlevarchar(65535)
variant_titlevarchar(65535)
skuvarchar(65535)
vendorvarchar(65535)
quantitybigint
current_quantityQuantity after removals and edits; line items removed from an order keep their row.bigintQuantity after removals and edits; line items removed from an order keep their row.
unfulfilled_quantitybigint
refundable_quantitybigint
non_fulfillable_quantitybigint
requires_shippingboolean
taxableboolean
is_gift_cardboolean
product_idbigint
variant_idReferences product_variants.id.bigintFKReferences product_variants.id.
selling_plan_namevarchar(65535)
selling_plan_selling_plan_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_set_shop_money_amountdecimal(38,9)
original_total_set_shop_money_currency_codevarchar(256)
original_total_set_presentment_money_amountdecimal(38,9)
original_total_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_set_shop_money_amountdecimal(38,9)
discounted_total_set_shop_money_currency_codevarchar(256)
discounted_total_set_presentment_money_amountdecimal(38,9)
discounted_total_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)
_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.
order_line_item_tax_lines13 columns · Line items & shippingshow in diagram

Primary key: line_item_id, index

ColumnTypeKeyDescription
line_item_idPrimary key (with index). References order_line_items.id.bigintPK FKPrimary key (with index). References order_line_items.id.
indexPrimary key (with line_item_id).bigintPK Primary key (with line_item_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.
order_line_item_discount_allocations9 columns · Line items & shippingshow in diagram

Primary key: line_item_id, index

ColumnTypeKeyDescription
line_item_idPrimary key (with index). References order_line_items.id.bigintPK FKPrimary key (with index). References order_line_items.id.
indexPrimary key (with line_item_id).bigintPK Primary key (with line_item_id).
allocated_amount_set_shop_money_amountdecimal(38,9)
allocated_amount_set_shop_money_currency_codevarchar(256)
allocated_amount_set_presentment_money_amountdecimal(38,9)
allocated_amount_set_presentment_money_currency_codevarchar(256)
discount_application_indexJoins to order_discount_applications.index (Together with the order: the allocation belongs to the order's discount application with this index.).bigintFKJoins to order_discount_applications.index (Together with the order: the allocation belongs to the order's discount application with this index.).
_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.
order_line_item_custom_attributes6 columns · Line items & shippingshow in diagram

Primary key: line_item_id, index

ColumnTypeKeyDescription
line_item_idPrimary key (with index). References order_line_items.id.bigintPK FKPrimary key (with index). References order_line_items.id.
indexPrimary key (with line_item_id).bigintPK Primary key (with line_item_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.
order_shipping_lines24 columns · Line items & shippingshow in diagram

Primary key: id

ColumnTypeKeyDescription
order_idReferences orders.id.bigintFKReferences orders.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
titlevarchar(65535)
codevarchar(65535)
sourcevarchar(65535)
carrier_identifiervarchar(65535)
delivery_categoryvarchar(65535)
customboolean
is_removedboolean
original_price_set_shop_money_amountdecimal(38,9)
original_price_set_shop_money_currency_codevarchar(256)
original_price_set_presentment_money_amountdecimal(38,9)
original_price_set_presentment_money_currency_codevarchar(256)
discounted_price_set_shop_money_amountdecimal(38,9)
discounted_price_set_shop_money_currency_codevarchar(256)
discounted_price_set_presentment_money_amountdecimal(38,9)
discounted_price_set_presentment_money_currency_codevarchar(256)
current_discounted_price_set_shop_money_amountdecimal(38,9)
current_discounted_price_set_shop_money_currency_codevarchar(256)
current_discounted_price_set_presentment_money_amountdecimal(38,9)
current_discounted_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.
order_shipping_line_tax_lines13 columns · Line items & shippingshow in diagram

Primary key: shipping_line_id, index

ColumnTypeKeyDescription
shipping_line_idPrimary key (with index). References order_shipping_lines.id.bigintPK FKPrimary key (with index). References order_shipping_lines.id.
indexPrimary key (with shipping_line_id).bigintPK Primary key (with shipping_line_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.
order_discount_applications15 columns · Line items & shippingshow in diagram

Primary key: order_id, index

ColumnTypeKeyDescription
order_idPrimary key (with index). References orders.id.bigintPK FKPrimary key (with index). References orders.id.
typenamevarchar(256)
indexPrimary key (with order_id).bigintPK Primary key (with order_id).
allocation_methodvarchar(256)
target_selectionvarchar(256)
target_typevarchar(256)
value_typenamevarchar(256)
value_amountdecimal(38,9)
value_currency_codevarchar(256)
value_percentagedecimal(38,9)
codevarchar(65535)
titlevarchar(65535)
descriptionvarchar(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.
refunds13 columns · Refunds & paymentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
order_idReferences orders.id.bigintFKReferences orders.id.
indexbigint
idPrimary key.bigintPK Primary key.
created_attimestamp
updated_attimestamp
processed_attimestamp
notevarchar(65535)
total_refunded_set_shop_money_amountdecimal(38,9)
total_refunded_set_shop_money_currency_codevarchar(256)
total_refunded_set_presentment_money_amountdecimal(38,9)
total_refunded_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.
order_transactions29 columns · Refunds & paymentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
order_idReferences orders.id.bigintFKReferences orders.id.
indexbigint
idPrimary key.bigintPK Primary key.
kindvarchar(256)
statusvarchar(256)
gatewayvarchar(65535)
formatted_gatewayvarchar(65535)
testboolean
error_codevarchar(256)
created_attimestamp
processed_attimestamp
authorization_expires_attimestamp
payment_idvarchar(65535)
account_numbervarchar(65535)
manual_payment_gatewayboolean
amount_set_shop_money_amountdecimal(38,9)
amount_set_shop_money_currency_codevarchar(256)
amount_set_presentment_money_amountdecimal(38,9)
amount_set_presentment_money_currency_codevarchar(256)
parent_transaction_idbigint
payment_details_typenamevarchar(256)
payment_details_companyvarchar(65535)
payment_details_binvarchar(65535)
payment_details_walletvarchar(256)
payment_details_namevarchar(65535)
payment_details_numbervarchar(65535)
receipt_jsonThe payment gateway receipt (JSON); personal-looking keys are removed unless personal data is included.varchar(65535)The payment gateway receipt (JSON); personal-looking keys are removed unless personal data is included.
_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.
refund_line_items21 columns · Refunds & paymentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
refund_idReferences refunds.id.bigintFKReferences refunds.id.
idPrimary key.bigintPK Primary key.
quantitybigint
restock_typevarchar(256)
restockedboolean
location_idbigint
line_item_idReferences order_line_items.id.bigintFKReferences order_line_items.id.
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)
subtotal_set_shop_money_amountdecimal(38,9)
subtotal_set_shop_money_currency_codevarchar(256)
subtotal_set_presentment_money_amountdecimal(38,9)
subtotal_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)
_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.
refund_shipping_lines15 columns · Refunds & paymentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
refund_idReferences refunds.id.bigintFKReferences refunds.id.
idPrimary key.bigintPK Primary key.
shipping_line_idReferences order_shipping_lines.id.bigintFKReferences order_shipping_lines.id.
shipping_line_titlevarchar(65535)
shipping_line_codevarchar(65535)
subtotal_amount_set_shop_money_amountdecimal(38,9)
subtotal_amount_set_shop_money_currency_codevarchar(256)
subtotal_amount_set_presentment_money_amountdecimal(38,9)
subtotal_amount_set_presentment_money_currency_codevarchar(256)
tax_amount_set_shop_money_amountdecimal(38,9)
tax_amount_set_shop_money_currency_codevarchar(256)
tax_amount_set_presentment_money_amountdecimal(38,9)
tax_amount_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.
order_adjustments13 columns · Refunds & paymentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
refund_idReferences refunds.id.bigintFKReferences refunds.id.
idPrimary key.bigintPK Primary key.
reasonvarchar(256)
amount_set_shop_money_amountdecimal(38,9)
amount_set_shop_money_currency_codevarchar(256)
amount_set_presentment_money_amountdecimal(38,9)
amount_set_presentment_money_currency_codevarchar(256)
tax_amount_set_shop_money_amountdecimal(38,9)
tax_amount_set_shop_money_currency_codevarchar(256)
tax_amount_set_presentment_money_amountdecimal(38,9)
tax_amount_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.
refund_transactions4 columns · Refunds & paymentsshow in diagram

Primary key: refund_id, transaction_id

ColumnTypeKeyDescription
refund_idPrimary key (with transaction_id). References refunds.id.bigintPK FKPrimary key (with transaction_id). References refunds.id.
transaction_idPrimary key (with refund_id). References order_transactions.id.bigintPK FKPrimary key (with refund_id). References order_transactions.id.
_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.
tender_transactions13 columns · Refunds & paymentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
processed_attimestamp
testboolean
payment_methodvarchar(65535)
remote_referencevarchar(65535)
amount_amountdecimal(38,9)
amount_currency_codevarchar(256)
order_idReferences orders.id.bigintFKReferences orders.id.
transaction_details_typenamevarchar(256)
transaction_details_credit_card_companyvarchar(65535)
transaction_details_credit_card_numbervarchar(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.
fulfillments18 columns · Fulfillmentshow in diagram

Primary key: id

ColumnTypeKeyDescription
order_idReferences orders.id.bigintFKReferences orders.id.
indexbigint
idPrimary key.bigintPK Primary key.
namevarchar(65535)
statusvarchar(256)
display_statusvarchar(256)
created_attimestamp
updated_attimestamp
delivered_attimestamp
in_transit_attimestamp
estimated_delivery_attimestamp
total_quantitybigint
requires_shippingboolean
location_idReferences locations.id.bigintFKReferences locations.id.
service_idbigint
service_service_namevarchar(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.
fulfillment_tracking_info7 columns · Fulfillmentshow in diagram

Primary key: fulfillment_id, index

ColumnTypeKeyDescription
fulfillment_idPrimary key (with index). References fulfillments.id.bigintPK FKPrimary key (with index). References fulfillments.id.
indexPrimary key (with fulfillment_id).bigintPK Primary key (with fulfillment_id).
companyvarchar(65535)
numbervarchar(65535)
urlvarchar(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.
fulfillment_orders15 columns · Fulfillmentshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.bigintPK Primary key.
statusvarchar(256)
request_statusvarchar(256)
created_attimestamp
updated_attimestamp
fulfill_attimestamp
fulfill_bytimestamp
order_idReferences orders.id.bigintFKReferences orders.id.
order_namevarchar(65535)
order_processed_attimestamp
assigned_location_namevarchar(65535)
assigned_location_location_idbigint
delivery_method_method_typevarchar(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.
fulfillment_events17 columns · Fulfillmentshow in diagram

Primary key: id

ColumnTypeKeyDescription
fulfillment_idReferences fulfillments.id.bigintFKReferences fulfillments.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
statusvarchar(256)
happened_attimestamp
created_attimestamp
estimated_delivery_attimestamp
messagevarchar(65535)
address1varchar(65535)
cityvarchar(65535)
provincevarchar(65535)
countryvarchar(65535)
zipvarchar(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.
fulfillment_line_items15 columns · Fulfillmentshow in diagram

Primary key: id

ColumnTypeKeyDescription
fulfillment_idReferences fulfillments.id.bigintFKReferences fulfillments.id.
typenamevarchar(256)
idPrimary key.bigintPK Primary key.
quantitybigint
line_item_idReferences order_line_items.id.bigintFKReferences order_line_items.id.
original_total_set_shop_money_amountdecimal(38,9)
original_total_set_shop_money_currency_codevarchar(256)
original_total_set_presentment_money_amountdecimal(38,9)
original_total_set_presentment_money_currency_codevarchar(256)
discounted_total_set_shop_money_amountdecimal(38,9)
discounted_total_set_shop_money_currency_codevarchar(256)
discounted_total_set_presentment_money_amountdecimal(38,9)
discounted_total_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.

Connect Shopify Orders All connectors