Shopify schema and ERD

92 tables

Loading diagram…

abandoned_checkout

balance_transaction

collection

company

customer

draft_order

inventory_level

metaobject

order_agreement

order_customer_journey_summary

order_returns

order_risk

order

payment_dispute

price_rule

product_variant

product

publication

transaction

abandoned_checkout

long

customer_id

long

name

string

buyer_accepts_marketing

boolean

currency

string

completed_at

date

discount_codes

string

billing_address_id

string

billing_address_phone

string

billing_address_country

string

abandoned_checkout_line

string

product_id

long

checkout_id

long

gift_card

boolean

presentment_title

string

product_title

string

product_type

string

product_is_gift_card

boolean

quantity

int

sku

string

abandoned_checkout_tax_line

checkout_id

long

position

int

price

double

price_set_shop_money_amount

double

price_set_shop_money_currency_code

string

price_set_presentment_money_amount

double

price_set_presentment_money_currency_code

string

compare_at

double

balance_transaction

string

type

string

test

boolean

transaction_date

date

currency

string

amount

double

fee_amount

double

fee_currency_code

string

net_amount

double

balance_transaction_adjustments_orders

balance_transaction_id

string

order_transaction_id

string

name

string

link

string

amount_amount

double

amount_currency_code

string

fees_amount

double

fees_currency_code

string

net_amount

double

net_currency_code

string

_weld_synced

date

collection

long

handle

string

sort_order

string

body_html

string

title

string

updated_at

date

template_suffix

string

disjunctive

boolean

type

string

_weld_synced

date

collection_product

collection_id

long

product_id

long

_weld_synced

date

collection_rule

collection_id

long

column

string

relation

string

condition

string

index

int

_weld_synced

date

company

string

contact_count

int

created_at

date

customer_since

date

default_role_id

string

default_role_name

string

default_role_note

string

external_id

string

has_timeline_comment

boolean

company_contact

string

company_id

string

customer_id

string

customer_first_name

string

customer_last_name

string

customer_display_name

string

is_main_contact

boolean

lifetime_duration

string

title

string

updated_at

date

created_at

date

_weld_synced

date

company_location

string

company_id

string

name

string

external_id

string

note

string

phone

string

locale

string

currency

string

tax_registration_id

string

created_at

date

company_location_catalog

string

company_location_id

string

publication_id

string

title

string

status

string

catalog_type

string

price_list_id

string

price_list_name

string

price_list_currency

string

_weld_synced

date

customer_metafield

long

customer_id

long

namespace

string

key

string

value

string

description

string

created_at

date

updated_at

date

type

string

_weld_synced

date

customer

long

currency

string

multipass_identifier

string

order_count

long

state

string

verified_email

boolean

total_spent

double

first_name

string

customer_tag

customer_id

long

index

int

value

string

_weld_synced

date

customer_tax_exemption

customer_id

long

index

int

tax_exemption

string

_weld_synced

date

customer_address

long

customer_id

long

first_name

string

last_name

string

company

string

address1

string

address2

string

city

string

province

string

country

string

discount_code

long

price_rule_id

long

discount_id

long

code

string

status

string

summary

string

title

string

usage_count

long

async_usage_count

long

created_at

date

draft_order

long

order_id

long

customer_id

long

subtotal_price

double

name

string

shipping_address_phone

string

shipping_address_country

string

shipping_address_name

string

shipping_address_address1

string

shipping_address_longitude

double

shipping_address_address2

string

draft_order_note_attribute

draft_order_id

long

name

string

value

string

_weld_synced

date

draft_order_line

long

draft_order_id

long

product_id

long

variant_id

long

title

string

variant_title

string

sku

string

vendor

string

quantity

int

requires_shipping

boolean

taxable

boolean

draft_order_line_tax_line

draft_order_id

long

draft_order_line_id

long

rate

double

title

string

price

double

index

int

_weld_synced

date

draft_order_tag

draft_order_id

long

index

int

value

string

_weld_synced

date

fulfillment_event

long

fulfillment_id

long

fulfillment_order_id

long

order_id

long

shop_id

long

address1

string

city

string

country

string

created_at

date

estimated_delivery_at

date

fulfillment_created_at

date

fulfillment_updated_at

date

happened_at

date

fulfillment_order

string

shop_id

string

order_id

string

order_name

string

order_app_id

string

order_app_name

string

order_processed_at

date

request_status

string

status

string

fulfill_at

date

fulfill_by

date

inventory_item

long

cost

double

country_code_of_origin

string

created_at

date

province_code_of_origin

string

sku

string

tracked

boolean

updated_at

date

requires_shipping

boolean

_weld_synced

date

inventory_level

string

location_id

string

inventory_item_id

string

created_at

date

updated_at

date

can_deactivate

boolean

deactivation_alert

string

available

double

_weld_synced

date

inventory_level_quantities

inventory_level_id

string

inventory_item_id

string

location_id

string

name

string

quantity

double

updated_at

date

_weld_synced

date

line_item_group

string

order_id

string

line_item_id

string

quantity

int

title

string

variant_id

string

variant_sku

string

_weld_synced

date

location

long

name

string

address1

string

address2

string

city

string

zip

string

province

string

country

string

phone

string

metaobject

string

handle

string

type

string

display_name

string

updated_at

date

created_by_app_id

string

_weld_synced

date

metaobject_field

metaobject_id

string

field_key

string

field_value

string

_weld_synced

date

order_agreement

string

order_id

string

app_id

string

app_handle

string

happened_at

date

reason

string

_weld_synced

date

order_agreement_sale

string

order_agreement_id

string

order_id

string

line_type

string

action_type

string

quantity

int

taxes

string

total_amount_presentment_money_amount

string

total_amount_presentment_money_currency_code

string

total_amount_shop_money_amount

string

total_amount_shop_money_currency_code

string

order_customer_journey_summary

order_id

long

customer_order_index

int

days_to_conversion

int

first_visit_id

long

last_visit_id

long

ready

boolean

_weld_synced

date

order_customer_journey_summary_moment

order_id

long

occurred_at

date

_weld_synced

date

order_customer_journey_summary_visit

long

order_id

long

landing_page

string

landing_page_html

string

marketing_event_id

long

occurred_at

date

referral_code

string

referral_info_html

string

referrer_url

string

source

string

order_customer_journey_summary_visit_marketing_event

long

visit_id

long

app_id

long

channel_handle

string

description

string

ended_at

date

manage_url

string

marketing_channel_type

string

preview_url

string

order_metafield

long

order_id

long

definition_description

string

definition_id

string

definition_key

string

definition_name

string

definition_namespace

string

namespace

string

key

string

value

string

order_returns

string

order_id

string

status

string

name

string

total_quantity

double

decline

string

object_type

string

created_at

date

request_approved_at

date

closed_at

date

_weld_synced

date

order_returns_line_items

string

return_id

string

quantity

double

customer_note

string

refundable_quantity

double

refunded_quantity

double

return_reason

string

return_reason_note

string

object_type

string

fulfillment_line_item_id

string

index

double

fulfillment_line_item_line_item_id

string

_weld_synced

date

order_returns_exchange_line_items

string

return_id

string

variant_id

string

processable_quantity

int

processed_quantity

int

quantity

int

unprocessed_quantity

int

line_item_ids

string

_weld_synced

date

order_risk

order_id

long

recommendation

string

_weld_synced

date

order_risk_assessment

order_id

long

risk_level

string

provider_name

string

_weld_synced

date

order_risk_assessment_fact

order_id

long

assessment_provider_name

string

description

string

sentiment

string

index

int

_weld_synced

date

order

137

long

customer_id

long

location_id

long

name

string

shipping_address_phone

string

shipping_address_country

string

shipping_address_name

string

shipping_address_address1

string

shipping_address_longitude

double

shipping_address_address2

string

shipping_address_last_name

string

order_tag

order_id

long

index

int

value

string

_weld_synced

date

fulfillment

long

location_id

long

order_id

long

created_at

date

shipment_status

string

name

string

receipt_authorization

string

service

string

status

string

tracking_company

string

updated_at

date

tracking_numbers

string

tracking_urls

string

_weld_synced

date

fulfillment_order_line

fulfillment_id

long

order_id

long

order_line_id

long

product_id

long

fulfillment_line_id

string

variant_id

long

fulfillable_quantity

double

fulfillment_service

string

gift_card

boolean

grams

int

name

string

price

double

fulfillment_order_line_property

fulfillment_id

long

order_id

long

order_line_id

long

name

string

value

string

fulfillment_line_id

string

_weld_synced

date

order_refund

long

order_id

long

restock

boolean

processed_at

date

user_id

long

note

string

created_at

date

total_duties_set_shop_money_amount

string

total_duties_set_shop_money_currency

string

total_duties_set_presentment_money_amount

string

total_duties_set_presentment_money_currency

string

_weld_synced

date

order_adjustment

long

order_id

long

kind

string

amount

double

reason

string

refund_id

long

amount_set_shop_money_amount

double

amount_set_shop_money_currency

string

amount_set_presentment_money_amount

double

amount_set_presentment_money_currency

string

order_line_refund

long

order_id

long

location_id

long

order_line_id

long

refund_line_item_id

long

refund_id

long

restock_type

string

quantity

int

subtotal

double

total_tax

double

total_tax_set_shop_money_amount

double

total_tax_set_shop_money_currency

string

order_note_attribute

order_id

long

name

string

value

string

_weld_synced

date

discount_application

order_id

long

type

string

title

string

value

string

value_type

string

description

string

target_type

string

target_selection

string

allocation_method

string

index

int

code

string

_weld_synced

date

order_shipping_line

long

order_id

long

index

int

code

string

price

double

title

string

source

string

price_set_shop_money_amount

double

price_set_shop_money_currency_code

string

price_set_presentment_money_amount

double

order_shipping_tax_line

order_shipping_line_id

long

order_id

long

rate

double

price

double

title

string

index

int

_weld_synced

date

order_url_tag

order_id

long

key

string

value

string

index

int

_weld_synced

date

order_line

long

order_id

long

product_id

long

index

int

sku

string

name

string

grams

int

price

double

title

string

vendor

string

taxable

boolean

order_tax_line

order_id

long

line_item_id

long

index

int

rate

double

price

double

title

string

price_set_shop_money_amount

double

price_set_shop_money_currency_code

string

price_set_presentment_money_amount

double

price_set_presentment_money_currency_code

string

_weld_synced

date

order_line_property

order_id

long

line_item_id

long

name

string

value

string

index

int

_weld_synced

date

discount_allocation

order_line_id

long

order_id

long

index

int

amount

double

amount_set_shop_money_amount

double

amount_set_shop_money_currency_code

string

amount_set_presentment_money_amount

double

amount_set_presentment_money_currency_code

string

discount_application_index

int

_weld_synced

date

payment_dispute

long

order_id

long

type

string

currency

string

amount

string

reason

string

network_reason_code

string

status

string

evidence_due_by

date

evidence_sent_on

date

finalized_on

date

initiated_at

date

_weld_synced

date

payment_dispute_evidence

long

payments_dispute_id

long

access_activity_log

string

customer_email_address

string

customer_first_name

string

customer_last_name

string

uncategorized_text

string

dispute_shipping_address_address1

string

dispute_shipping_address_address2

string

payout

string

business_entity_id

string

business_entity_shopify_payments_account_id

string

business_entity_legal_entity_id

string

business_entity_archived

boolean

business_entity_company_name

string

business_entity_display_name

string

business_entity_primary

boolean

business_entity_address_address_1

string

price_rule

long

allocation_method

string

created_at

date

updated_at

date

customer_selection

string

ends_at

date

once_per_customer

boolean

prerequisite_quantity_range

long

prerequisite_shipping_price_range

double

price_rule_prereq_product

price_rule_id

long

product_id

long

_weld_synced

date

price_rule_prereq_collection

price_rule_id

long

collection_id

long

_weld_synced

date

price_rule_prereq_variant

price_rule_id

long

variant_id

long

_weld_synced

date

price_rule_prereq_customer

price_rule_id

long

customer_id

long

_weld_synced

date

price_rule_prereq_saved_search

price_rule_id

long

saved_search_id

long

_weld_synced

date

price_rule_ent_variant

price_rule_id

long

variant_id

long

_weld_synced

date

price_rule_ent_product

price_rule_id

long

product_id

long

_weld_synced

date

price_rule_ent_country

price_rule_id

long

country_id

long

_weld_synced

date

price_rule_ent_collection

price_rule_id

long

collection_id

long

_weld_synced

date

product_image

long

product_id

long

src

string

width

int

height

int

position

int

created_at

date

updated_at

date

media_image_id

string

_weld_synced

date

product_metafield

long

product_id

long

namespace

string

key

string

value

string

description

string

created_at

date

updated_at

date

type

string

_weld_synced

date

product_variant

long

product_id

long

inventory_item_id

long

image_id

long

sku

string

grams

double

price

double

title

string

weight

double

barcode

string

option1

string

product_variant_option

product_id

long

product_variant_id

long

name

string

value

string

_weld_synced

date

product_variant_metafield

long

product_variant_id

long

namespace

string

key

string

value

string

description

string

created_at

date

updated_at

date

type

string

_weld_synced

date

product_variant_contextual_pricing

product_id

string

product_variant_id

string

context_country_code

string

contextual_pricing_compare_at_price_amount

double

contextual_pricing_compare_at_price_currency_code

string

contextual_pricing_price_amount

double

contextual_pricing_price_currency_code

string

_weld_synced

date

product

long

published_at

date

created_at

date

published_scope

string

status

string

vendor

string

updated_at

date

body_html

string

product_type

string

product_option

long

product_id

long

name

string

position

int

_weld_synced

date

product_option_value

product_option_id

long

product_id

long

index

int

value

string

_weld_synced

date

product_tag

product_id

long

index

int

value

string

_weld_synced

date

publication

string

name

string

auto_publish

boolean

supports_future_publishing

boolean

app_id

string

catalog_id

string

catalog_status

string

catalog_title

string

_weld_synced

date

publication_product

publication_id

string

product_id

string

_weld_synced

date

shop

long

name

string

domain

string

province

string

country

string

address1

string

zip

string

city

string

tender_transaction

long

order_id

long

amount

double

currency

string

user_id

long

test

boolean

processed_at

date

remote_reference

string

payment_details_credit_card_number

string

payment_details_credit_card_company

string

payment_method

string

_weld_synced

date

transaction

long

order_id

long

error_code

string

device_id

string

user_id

long

parent_id

long

test

boolean

kind

string

amount

double

authorization

string

transaction_fees

string

transaction_id

string

order_id

string

amount_amount

double

amount_currency_code

string

flat_fee_amount

double

flat_fee_currency_code

string

flat_fee_name

string

rate

double

rate_name

string

tax_amount_amount

double

tax_amount_currency_code

string

type

string

_weld_synced

date

translatable_resource

resource_id

string

resource_type

string

key

string

locale

string

value

string

primary_locale

boolean

_weld_synced

date