E-commerce & Payments

Shopify schema

SightShark syncs Shopify into a data warehouse you own. It creates 130 tables, with field lists for 125 of them, refreshed daily. The store as a relational model rather than a flat order export. Orders, line items, refunds, transactions, products, variants, inventory, customers, companies, draft orders, fulfilment, discounts, media and payouts.

130 tables / 1290 fields / Tables from the production sync

Tables and fields

Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.

sf_orders

19 fields

id
customer_id
name
order_number
created_at
processed_at
cancelled_at
financial_status
fulfillment_status
currency
presentment_currency
subtotal_price
total_discounts
total_tax
total_price
landing_site
referring_site
source_name
test

sf_order_line

13 fields

id
order_id
product_id
variant_id
title
variant_title
sku
vendor
quantity
price
pre_tax_price
total_discount
fulfillable_quantity

sf_transactions

10 fields

id
order_id
kind
status
gateway
processed_at
amount_set_shop_amount
amount_set_pres_amount
authorization_code
error_code

sf_products

12 fields

id
title
handle
product_type
vendor
status
category_id
category_name
total_inventory
min_variant_price_amount
max_variant_price_amount
published_at

sf_product_variant

9 fields

id
product_id
inventory_item_id
sku
title
price
compare_at_price
inventory_quantity
available_for_sale

sf_customers

10 fields

id
email
first_name
last_name
orders_count
total_spent
state
verified_email
email_marketing_consent_state
created_at

sf_customer_visit

8 fields

id
order_id
landing_page
referrer_url
source
source_type
referral_code
occurred_at

sf_order_tag

3 fields, documented schema

index
order_id
value

sf_order_url_tag

3 fields, documented schema

key
order_id
value

sf_order_note_attribute

3 fields, documented schema

name
order_id
value

sf_order_discount_code

3 fields, documented schema

index
order_id
code

sf_order_line_refund

10 fields, documented schema

id
location_id
order_line_id
refund_id
quantity
restock_type
subtotal
subtotal_set
total_tax
total_tax_set

sf_order_line_tax_line

11 fields, documented schema

index
order_line_id
channel_liable
price_set_pres_amount
price_set_pres_currency_code
price_set_shop_amount
price_set_shop_currency_code
rate
rate_percentage
source
title

sf_order_line_custom_attribute

3 fields, documented schema

key
order_line_id
value

sf_order_shipping_line

23 fields, documented schema

id
order_id
carrier_identifier
code
current_discounted_price_set_pres_amount
current_discounted_price_set_pres_currency_code
current_discounted_price_set_shop_amount
current_discounted_price_set_shop_currency_code
custom
delivery_category
discounted_price_set_pres_amount
discounted_price_set_pres_currency_code
discounted_price_set_shop_amount
discounted_price_set_shop_currency_code
is_removed
original_price_set_pres_amount
original_price_set_pres_currency_code
original_price_set_shop_amount
original_price_set_shop_currency_code
phone
shipping_rate_handle
source
title

sf_order_shipping_tax_line

11 fields, documented schema

index
order_shipping_line_id
channel_liable
price_set_pres_amount
price_set_pres_currency_code
price_set_shop_amount
price_set_shop_currency_code
rate
rate_percentage
source
title

sf_order_adjustment

11 fields, documented schema

id
refund_id
amount_set_pres_amount
amount_set_pres_currency_code
amount_set_shop_amount
amount_set_shop_currency_code
reason
tax_amount_set_pres_amount
tax_amount_set_pres_currency_code
tax_amount_set_shop_amount
tax_amount_set_shop_currency_code

sf_order_risk_assessment

4 fields, documented schema

index
order_id
provider
risk_level

sf_order_risk_fact

5 fields, documented schema

index
order_id
order_risk_assessment_index
description
sentiment

sf_tax_line

6 fields, documented schema

index
order_line_id
price
price_set
rate
title

sf_refunds

0 fields

Field list not published yet. Ask and we will send it.

sf_refund

11 fields, documented schema

id
order_id
return_id
staff_member_id
created_at
note
total_refunded_set_pres_amount
total_refunded_set_pres_currency_code
total_refunded_set_shop_amount
total_refunded_set_shop_currency_code
updated_at

sf_refund_line_item

19 fields, documented schema

id
location_id
order_line_id
refund_id
price_set_pres_amount
price_set_pres_currency_code
price_set_shop_amount
price_set_shop_currency_code
quantity
restock_type
restocked
subtotal_set_pres_amount
subtotal_set_pres_currency_code
subtotal_set_shop_amount
subtotal_set_shop_currency_code
total_tax_set_pres_amount
total_tax_set_pres_currency_code
total_tax_set_shop_amount
total_tax_set_shop_currency_code

sf_refund_shipping_line

10 fields, documented schema

id
refund_id
subtotal_amount_set_pres_amount
subtotal_amount_set_pres_currency_code
subtotal_amount_set_shop_amount
subtotal_amount_set_shop_currency_code
tax_amount_set_pres_amount
tax_amount_set_pres_currency_code
tax_amount_set_shop_amount
tax_amount_set_shop_currency_code

sf_return

9 fields, documented schema

id
order_id
created_at
decline_note
decline_reason
name
return_shipping_fees
status
total_quantity

sf_return_line_item

15 fields, documented schema

id
return_id
order_line_id
customer_note
quantity
refundable_quantity
refunded_quantity
restocking_fee_amount_set_pres_amount
restocking_fee_amount_set_pres_currency_code
restocking_fee_amount_set_shop_amount
restocking_fee_amount_set_shop_currency_code
restocking_fee_id
restocking_fee_percentage
return_reason
return_reason_note

sf_return_shipping_fee

6 fields, documented schema

id
return_id
amount_set_presentment_money_amount
amount_set_presentment_money_currency_code
amount_set_shop_money_amount
amount_set_shop_money_currency_code

sf_addresses

0 fields

Field list not published yet. Ask and we will send it.

sf_customer_tag

3 fields, documented schema

index
customer_id
value

sf_customer_segment

5 fields, documented schema

id
created_at
name
query
updated_at

sf_customer_tax_exemption

3 fields, documented schema

index
customer_id
tax_exemption

sf_inventory_items

0 fields

Field list not published yet. Ask and we will send it.

sf_inventory_item

19 fields, documented schema

id
country_code_of_origin
created_at
duplicate_sku_count
harmonized_system_code
inventory_history_url
legacy_resource_id
measurement_id
measurement_weight_unit
measurement_weight_value
province_code_of_origin
requires_shipping
sku
tracked
tracked_editable_locked
tracked_editable_reason
unit_cost_amount
unit_cost_currency_code
updated_at

sf_inventory_levels

0 fields

Field list not published yet. Ask and we will send it.

sf_inventory_level

7 fields, documented schema

id
inventory_item_id
location_id
can_deactivate
created_at
deactivation_alert
updated_at

sf_inventory_quantity

6 fields, documented schema

id
name
inventory_item_id
inventory_level_id
quantity
updated_at

sf_locations

29 fields, documented schema

id
fulfillment_service_id
activatable
address_1
address_2
address_verified
city
country
country_code
created_at
deactivatable
deactivated_at
deletable
fulfills_online_orders
has_active_inventory
has_unfulfilled_orders
is_active
is_fulfillment_service
latitude
local_pickup_settings_instructions
local_pickup_settings_pickup_time
longitude
name
phone
province
province_code
ships_inventory
updated_at
zip

sf_collection

14 fields, documented schema

id
applied_disjunctively
description
description_html
feedback_summary
handle
products_count
products_count_precision
seo_description
seo_title
sort_order
template_suffix
title
updated_at

sf_collection_product

2 fields, documented schema

collection_id
product_id

sf_collection_rule

5 fields, documented schema

index
collection_id
columns
condition
relation

sf_product_tag

3 fields, documented schema

index
product_id
value

sf_product_option

7 fields, documented schema

id
product_id
linked_metafield_key
linked_metafield_namespace
name
position
values

sf_product_option_value

5 fields, documented schema

id
product_option_id
has_variants
linked_metafield_value
name

sf_product_variant_option_value

2 fields, documented schema

option_value_id
variant_id

sf_product_media

2 fields, documented schema

media_id
product_id

sf_product_variant_media

2 fields, documented schema

media_id
product_variant_id

sf_product_publication

2 fields, documented schema

product_id
publication_id

sf_publication

4 fields, documented schema

id
catalog_id
auto_publish
supports_future_publishing

sf_catalog

7 fields, documented schema

sf_company

11 fields, documented schema

id
main_contact_id
created_at
default_role_id
default_role_name
default_role_note
external_id
has_timeline_comment
name
note
updated_at

sf_company_contact

8 fields, documented schema

id
company_id
customer_id
created_at
is_main_contact
locale
title
updated_at

sf_company_location

15 fields, documented schema

id
company_id
created_at
currency
external_id
has_timeline_comment
locale
name
note
phone
tax_settings_tax_exempt
tax_settings_tax_registration_id
total_spent_amount
total_spent_currency_code
updated_at

sf_company_location_catalog

2 fields, documented schema

catalog_id
company_location_id

sf_company_location_tax_exemption

2 fields, documented schema

tax_exemption
company_location_id

sf_draft_order

60 fields, documented schema

id
customer_id
order_id
purchasing_entity_company_contact_id
purchasing_entity_company_id
purchasing_entity_customer_id
accept_automatic_discounts
all_variant_prices_overridden
allow_discount_codes_in_checkout
any_variant_prices_overridden
completed_at
created_at
currency_code
email
has_timeline_comment
invoice_email_template_subject
invoice_sent_at
invoice_url
line_items_subtotal_price_pres_amount
line_items_subtotal_price_pres_currency_code
line_items_subtotal_price_shop_amount
line_items_subtotal_price_shop_currency_code
name
note
phone
po_number
presentment_currency_code
ready
reserve_inventory_until
status
subtotal_price_set_pres_amount
subtotal_price_set_pres_currency_code
subtotal_price_set_shop_amount
subtotal_price_set_shop_currency_code
tax_exempt
taxes_included
total_discounts_set_pres_amount
total_discounts_set_pres_currency_code
total_discounts_set_shop_amount
total_discounts_set_shop_currency_code
total_line_items_price_set_pres_amount
total_line_items_price_set_pres_currency_code
total_line_items_price_set_shop_amount
total_line_items_price_set_shop_currency_code
total_price_set_pres_amount
total_price_set_pres_currency_code
total_price_set_shop_amount
total_price_set_shop_currency_code
total_quantity_of_line_items
total_shipping_price_set_pres_amount
total_shipping_price_set_pres_currency_code
total_shipping_price_set_shop_amount
total_shipping_price_set_shop_currency_code
total_tax_set_pres_amount
total_tax_set_pres_currency_code
total_tax_set_shop_amount
total_tax_set_shop_currency_code
total_weight
updated_at
visible_to_customer

sf_draft_order_line

41 fields, documented schema

id
draft_order_id
fulfillment_service_id
product_id
variant_id
approximate_discounted_unit_price_set_pres_amount
approximate_discounted_unit_price_set_pres_currency_code
approximate_discounted_unit_price_set_shop_amount
approximate_discounted_unit_price_set_shop_currency_code
custom
discounted_total_set_pres_amount
discounted_total_set_pres_currency_code
discounted_total_set_shop_amount
discounted_total_set_shop_currency_code
is_gift_card
name
original_total_set_pres_amount
original_total_set_pres_currency_code
original_total_set_shop_amount
original_total_set_shop_currency_code
original_unit_price_set_pres_amount
original_unit_price_set_pres_currency_code
original_unit_price_set_shop_amount
original_unit_price_set_shop_currency_code
original_unit_price_with_amount
original_unit_price_with_currency_code
price_override_amount
price_override_currency_code
quantity
requires_shipping
sku
taxable
title
total_discount_set_pres_amount
total_discount_set_pres_currency_code
total_discount_set_shop_amount
total_discount_set_shop_currency_code
variant_title
vendor
weight_unit
weight_value

sf_draft_order_line_tax_line

12 fields, documented schema

index
draft_order_line_id
draft_order_id
channel_liable
price_set_pres_amount
price_set_pres_currency_code
price_set_shop_amount
price_set_shop_currency_code
rate
rate_percentage
source
title

sf_draft_order_tax_line

11 fields, documented schema

index
draft_order_id
channel_liable
price_set_pres_amount
price_set_pres_currency_code
price_set_shop_amount
price_set_shop_currency_code
rate
rate_percentage
source
title

sf_draft_order_tag

3 fields, documented schema

index
draft_order_id
value

sf_draft_order_custom_attribute

3 fields, documented schema

key
draft_order_id
value

sf_draft_order_line_custom_attribute

4 fields, documented schema

key
draft_order_line_id
draft_order_id
value

sf_draft_order_note_attribute

3 fields, documented schema

name
draft_order_id
value

sf_fulfillment

14 fields, documented schema

id
location_id
order_id
service_id
created_at
delivered_at
display_status
estimated_delivery_at
in_transit_at
name
requires_shipping
status
total_quantity
updated_at

sf_fulfillment_order

35 fields, documented schema

id
order_id
assigned_location_id
destination_location_id
assigned_location_address_1
assigned_location_address_2
assigned_location_city
assigned_location_country_code
assigned_location_name
assigned_location_phone
assigned_location_province
assigned_location_zip
channel_id
created_at
destination_address_1
destination_address_2
destination_city
destination_company
destination_country_code
destination_email
destination_first_name
destination_id
destination_last_name
destination_phone
destination_province
destination_zip
fulfill_at
fulfill_by
international_duties_incoterm
order_name
order_processed_at
request_status
status
supported_actions
updated_at

sf_fulfillment_order_line_item

14 fields, documented schema

id
fulfillment_order_id
inventory_item_id
order_line_item_id
product_variant_id
product_title
remaining_quantity
requires_shipping
sku
total_quantity
variant_title
vendor
weight_unit
weight_value

sf_fulfillment_order_fulfillment_hold

7 fields, documented schema

id
fulfillment_order_id
display_reason
handle
held_by_requesting_app
reason
reason_notes

sf_fulfillment_line_item

14 fields, documented schema

id
fulfillment_id
order_line_id
product_id
product_variant_id
discounted_total_set_pres_amount
discounted_total_set_pres_currency_code
discounted_total_set_shop_amount
discounted_total_set_shop_currency_code
original_total_set_pres_amount
original_total_set_pres_currency_code
original_total_set_shop_amount
original_total_set_shop_currency_code
quantity

sf_fulfillment_event

14 fields, documented schema

id
fulfillment_id
address_1
city
country
created_at
estimated_delivery_at
happened_at
latitude
longitude
message
province
status
zip

sf_fulfillment_service

11 fields, documented schema

id
shop_id
location_id
callback_url
fulfillment_orders_opt_in
handle
inventory_management
permits_sku_sharing
service_name
tracking_support
type

sf_fulfillment_tracking_info

5 fields, documented schema

index
fulfillment_id
company
number
url

sf_abandoned_checkout

33 fields, documented schema

id
customer_id
abandoned_checkout_url
completed_at
created_at
name
note
subtotal_price_set_pres_amount
subtotal_price_set_pres_currency_code
subtotal_price_set_shop_amount
subtotal_price_set_shop_currency_code
taxes_included
total_discount_set_pres_amount
total_discount_set_pres_currency_code
total_discount_set_shop_amount
total_discount_set_shop_currency_code
total_duties_set_pres_amount
total_duties_set_pres_currency_code
total_duties_set_shop_amount
total_duties_set_shop_currency_code
total_line_items_price_set_pres_amount
total_line_items_price_set_pres_currency_code
total_line_items_price_set_shop_amount
total_line_items_price_set_shop_currency_code
total_price_set_pres_amount
total_price_set_pres_currency_code
total_price_set_shop_amount
total_price_set_shop_currency_code
total_tax_set_pres_amount
total_tax_set_pres_currency_code
total_tax_set_shop_amount
total_tax_set_shop_currency_code
updated_at

sf_abandoned_checkout_line

32 fields, documented schema

index
checkout_id
product_id
variant_id
discounted_total_price_set_pres_amount
discounted_total_price_set_pres_currency_code
discounted_total_price_set_shop_amount
discounted_total_price_set_shop_currency_code
discounted_total_price_with_code_pres_amount
discounted_total_price_with_code_pres_currency_code
discounted_total_price_with_code_shop_amount
discounted_total_price_with_code_shop_currency_code
discounted_unit_price_set_pres_amount
discounted_unit_price_set_pres_currency_code
discounted_unit_price_set_shop_amount
discounted_unit_price_set_shop_currency_code
discounted_unit_price_with_code_pres_amount
discounted_unit_price_with_code_pres_currency_code
discounted_unit_price_with_code_shop_amount
discounted_unit_price_with_code_shop_currency_code
original_total_price_set_pres_amount
original_total_price_set_pres_currency_code
original_total_price_set_shop_amount
original_total_price_set_shop_currency_code
original_unit_price_set_pres_amount
original_unit_price_set_pres_currency_code
original_unit_price_set_shop_amount
original_unit_price_set_shop_currency_code
quantity
sku
title
variant_title

sf_abandoned_checkout_discount_code

3 fields, documented schema

index
checkout_id
code

sf_abandoned_checkout_tax_line

11 fields, documented schema

index
checkout_id
channel_liable
price_set_pres_amount
price_set_pres_currency_code
price_set_shop_amount
price_set_shop_currency_code
rate
rate_percentage
source
title

sf_abandoned_checkout_url

0 fields

Field list not published yet. Ask and we will send it.

sf_discount_code

6 fields, documented schema

id
price_rule_id
code
created_at
updated_at
usage_count

sf_discount_code_basic

26 fields, documented schema

id
applies_once_per_customer
async_usage_count
codes_count
codes_precision
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
customer_selection_all_customers
discount_class
ends_at
has_timeline_comment
minimum_requirement_greater_than_or_equal_to_quantity
minimum_requirement_gte_subtotal_amount
minimum_requirement_gte_subtotal_currency_code
recurring_cycle_limit
short_summary
starts_at
status
summary
title
total_sales_amount
total_sales_currency_code
updated_at
usage_limit

sf_discount_code_bxgy

22 fields, documented schema

id
applies_once_per_customer
async_usage_count
codes_count
codes_precision
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
customer_selection_all_customers
discount_class
ends_at
has_timeline_comment
starts_at
status
summary
title
total_sales_amount
total_sales_currency_code
updated_at
usage_limit
uses_per_order_limit

sf_discount_code_app

33 fields, documented schema

id
app_discount_type_app_id
app_discount_type_app_bridge_create_path
app_discount_type_app_bridge_details_path
app_discount_type_app_key
app_discount_type_description
app_discount_type_discount_class
app_discount_type_function_id
app_discount_type_target_type
app_discount_type_title
applies_on_one_time_purchase
applies_on_subscription
applies_once_per_customer
async_usage_count
codes_count_count
codes_count_precision
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
customer_selection_all_customers
discount_class
discount_id
ends_at
has_timeline_comment
recurring_cycle_limit
starts_at
status
title
total_sales_amount
total_sales_currency_code
updated_at
usage_limit

sf_discount_code_free_shipping

32 fields, documented schema

id
applies_on_one_time_purchase
applies_on_subscription
applies_once_per_customer
async_usage_count
codes_count
codes_precision
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
customer_selection_all_customers
destination_selection_all_countries
destination_selection_include_rest_of_world
discount_class
ends_at
has_timeline_comment
maximum_shipping_price_amount
maximum_shipping_price_currency_code
minimum_requirement_greater_than_or_equal_to_quantity
minimum_requirement_gte_subtotal_amount
minimum_requirement_gte_subtotal_currency_code
recurring_cycle_limit
short_summary
starts_at
status
summary
title
total_sales_amount
total_sales_currency_code
updated_at
usage_limit

sf_discount_redeem_code

5 fields, documented schema

discount_id
discount_type
id
created_by_id
code

sf_discount_shareable_url

6 fields, documented schema

discount_id
discount_type
index
target_type
title
url

sf_discount_automatic_basic

18 fields, documented schema

id
async_usage_count
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
discount_class
ends_at
minimum_requirement_greater_than_or_equal_to_quantity
minimum_requirement_gte_subtotal_amount
minimum_requirement_gte_subtotal_currency_code
recurring_cycle_limit
short_summary
starts_at
status
summary
title
updated_at

sf_discount_automatic_bxgy

14 fields, documented schema

id
async_usage_count
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
discount_class
ends_at
starts_at
status
summary
title
updated_at
uses_per_order_limit

sf_discount_automatic_app

25 fields, documented schema

id
app_discount_type_app_id
app_discount_type_app_bridge_create_path
app_discount_type_app_bridge_details_path
app_discount_type_app_key
app_discount_type_description
app_discount_type_discount_class
app_discount_type_function_id
app_discount_type_target_type
app_discount_type_title
applies_on_one_time_purchase
applies_on_subscription
async_usage_count
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
discount_class
discount_id
ends_at
recurring_cycle_limit
starts_at
status
title
updated_at

sf_discount_automatic_free_shipping

27 fields, documented schema

id
applies_on_one_time_purchase
applies_on_subscription
async_usage_count
combines_with_order_discounts
combines_with_product_discounts
combines_with_shipping_discounts
created_at
destination_selection_all_countries
destination_selection_include_rest_of_world
discount_class
ends_at
has_timeline_comment
maximum_shipping_price_amount
maximum_shipping_price_currency_code
minimum_requirement_greater_than_or_equal_to_quantity
minimum_requirement_gte_subtotal_amount
minimum_requirement_gte_subtotal_currency_code
recurring_cycle_limit
short_summary
starts_at
status
summary
title
total_sales_amount
total_sales_currency_code
updated_at

sf_discount_application

12 fields, documented schema

index
order_id
allocation_method
code
description
target_selection
target_type
title
type
value_amount
value_currency_code
value_percentage

sf_discount_allocation

7 fields, documented schema

index
order_line_id
discount_application_index
allocated_amount_set_pres_amount
allocated_amount_set_pres_currency_code
allocated_amount_set_shop_amount
allocated_amount_set_shop_currency_code

sf_discount_customer_selection

4 fields, documented schema

discount_id
discount_type
index
customer_id

sf_discount_customer_segment_selection

4 fields, documented schema

discount_id
discount_type
index
segment_id

sf_discount_destination_selection_country

4 fields, documented schema

discount_id
discount_type
index
country_code

sf_discount_customer_gets_collection

3 fields, documented schema

discount_id
discount_resource
collection_id

sf_discount_customer_buys_collection

3 fields, documented schema

discount_id
discount_resource
collection_id

sf_discount_customer_gets_product

3 fields, documented schema

discount_id
discount_resource
product_id

sf_discount_customer_buys_product

3 fields, documented schema

discount_id
discount_resource
product_id

sf_discount_customer_gets_product_variant

3 fields, documented schema

discount_id
discount_resource
product_variant_id

sf_discount_customer_buys_product_variant

3 fields, documented schema

discount_id
discount_resource
product_variant_id

sf_price_rule_ent_product

2 fields, documented schema

price_rule_id
product_id

sf_price_rule_ent_variant

2 fields, documented schema

price_rule_id
variant_id

sf_price_rule_ent_collection

2 fields, documented schema

collection_id
price_rule_id

sf_price_rule_prereq_product

2 fields, documented schema

price_rule_id
product_id

sf_price_rule_prereq_variant

2 fields, documented schema

price_rule_id
variant_id

sf_price_rule_prereq_collection

2 fields, documented schema

collection_id
price_rule_id

sf_price_rule_prereq_customer

2 fields, documented schema

customer_id
price_rule_id

sf_price_rule_prereq_customer_segment

2 fields, documented schema

price_rule_id
segment_id

sf_media

13 fields, documented schema

id
alt
created_at
file_status
media_content_type
preview_image_alt_text
preview_image_height
preview_image_id
preview_image_url
preview_image_width
preview_status
status
updated_at

sf_media_image

4 fields, documented schema

media_id
mime_type
original_source_file_size
original_source_url

sf_media_source

8 fields, documented schema

index
media_id
file_size
format
height
mime_type
url
width

sf_media_error

5 fields, documented schema

index
media_id
code
details
message

sf_media_warning

4 fields, documented schema

index
media_id
code
message

sf_media_file_error

5 fields, documented schema

index
media_id
code
details
message

sf_video

3 fields, documented schema

media_id
duration
file_name

sf_external_video

4 fields, documented schema

media_id
embed_url
host
origin_url

sf_model_3d

5 fields, documented schema

media_id
bounding_box_size_x
bounding_box_size_y
bounding_box_size_z
file_name

sf_gift_card

20 fields, documented schema

id
customer_id
order_id
recipient_attributes_recipient_id
balance_amount
balance_currency_code
created_at
deactivated_at
enabled
expires_on
initial_value_amount
initial_value_currency_code
last_characters
masked_code
note
recipient_attributes_message
recipient_attributes_preferred_name
recipient_attributes_send_notification_at
template_suffix
updated_at

sf_dispute

12 fields, documented schema

id
order_id
amount
currency_code
evidence_due_by
evidence_sent_on
finalized_on
initiated_at
network_reason_code
reason
status
type

sf_payout

6 fields, documented schema

id
issued_at
net_amount
net_currency_code
status
transaction_type

sf_balance_transaction

16 fields, documented schema

id
associated_order_id
associated_payout_id
source_order_transaction_id
adjustment_reason
amount
currency_code
fee_amount
fee_currency_code
net_amount
net_currency_code
source_id
source_type
test
transaction_date
type

sf_adjustment_order

5 fields, documented schema

balance_transaction_id
id
amount
currency_code
link

sf_adjustment_order_transaction

5 fields, documented schema

balance_transaction_id
id
order_id
amount
order_name

sf_tender_transaction

11 fields, documented schema

id
order_id
user_id
amount
currency_code
payment_method
processed_at
remote_reference
test
transaction_details_credit_card_company
transaction_details_credit_card_number

sf_sales_agreement

8 fields, documented schema

id
app_id
order_id
refund_id
return_id
user_id
happened_at
reason

sf_sale

22 fields, documented schema

id
sales_agreement_id
action_type
line_item_id
line_type
quantity
total_amount_pres_amount
total_amount_pres_currency_code
total_amount_shop_amount
total_amount_shop_currency_code
total_discount_amount_after_taxes_pres_amount
total_discount_amount_after_taxes_pres_currency_code
total_discount_amount_after_taxes_shop_amount
total_discount_amount_after_taxes_shop_currency_code
total_discount_amount_before_taxes_pres_amount
total_discount_amount_before_taxes_pres_currency_code
total_discount_amount_before_taxes_shop_amount
total_discount_amount_before_taxes_shop_currency_code
total_tax_amount_pres_amount
total_tax_amount_pres_currency_code
total_tax_amount_shop_amount
total_tax_amount_shop_currency_code

sf_sale_tax

6 fields, documented schema

id
sale_id
pres_amount
pres_currency_code
shop_amount
shop_currency_code

sf_marketing_event

16 fields, documented schema

id
app_id
channel_handle
description
ended_at
manage_url
marketing_channel_type
preview_url
remote_id
scheduled_to_end_at
source_and_medium
started_at
type
utm_campaign
utm_medium
utm_source

sf_metafield

10 fields, documented schema

id
owner_id
created_at
description
key
namespace
owner_resource
type
updated_at
value

sf_app

19 fields, documented schema

id
app_store_app_url
app_store_developer_url
description
developer_name
developer_type
embedded
features
handle
install_url
is_post_purchase_app_in_use
previously_installed
pricing_details
pricing_details_summary
privacy_policy_url
published
shopify_developed
title
uninstall_message

sf_shop

37 fields, documented schema

id
account_owner_id
checkout_api_supported
contact_email
countries_in_shipping_zones_country_codes
countries_in_shipping_zones_include_rest_of_world
created_at
currency_code
customer_accounts
description
email
enabled_presentment_currencies
iana_timezone
marketing_sms_consent_enabled_at_checkout
myshopify_domain
name
order_number_format_prefix
order_number_format_suffix
password_enabled
payment_settings_supported_digital_wallets
plan_display_name
plan_partner_development
plan_shopify_plus
rich_text_editor_url
setup_required
ships_to_countries
shop_owner_name
tax_shipping
taxes_included
timezone_abbreviation
timezone_offset
timezone_offset_minutes
transactional_sms_disabled
unit_system
updated_at
url
weight_unit

sf_staff_member

12 fields, documented schema

id
account_type
active
email
exists
first_name
initials
is_shop_owner
last_name
locale
name
phone

sf_user

13 fields, documented schema

id
bio
email
first_name
im_address
is_account_owner
last_name
locale
permissions
phone
receive_announcements
url
user_type

Where it lands

Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.

Google BigQuery
Snowflake
Databricks
AWS Redshift
Azure Synapse

The store and the payment processor both report revenue and they rarely match, because one counts an order and the other counts a settled payment.

Questions people ask

What tables does SightShark create from Shopify?

130 tables, including sf_orders, sf_order_line, sf_transactions. sf_orders is one row per order. Every one is listed on this page, with its fields where the list is published.

Which Shopify fields can I get?

The 1290 fields on this page, table by table. Lists marked documented schema follow the published schema for Shopify, and your own warehouse may carry a few more or fewer.

How often does Shopify data refresh?

Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.

Can I join Shopify data to my other platforms?

Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Shopify and another source needs no reconciling of field names first.

Related connectors

Reporting on this data

Get started

Want Shopify in your own warehouse?

A call with someone who can answer the schema questions.

Book a demo Contact us