Shopify (v15-10-2015)

checkouts & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

checkouts Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Checkout ID (id)

• abandoned_checkout_url

• billing_address__address1

• billing_address__address2

• billing_address__city

• billing_address__company

• billing_address__country

• billing_address__firstname

• billing_address__id

• billing_address__lastname

• billing_address__phone

• billing_address__province

• billing_address__zip

• billing_address__name

• billing_address__province_code

• billing_address__country_code

• billing_address__default

• buyer_accepts_marketing

• cancel_reason

• cart_token

• closed_at

• completed_at

• created_at

• currency

• customer__accepts_marketing

• customer__created_at

• customer__email

• customer__first_name

• customer__id

• customer__last_name

• customer__note

• customer__orders_count

• customer__state

• customer__total_spent

• customer__updated_at

• customer__tags

• discount_codes*

• email

• gateway

• landing_site

• line_items__fulfillment_service

• line_items__grams

• line_items__price

• line_items__product_id

• line_items__quantity

• line_items__requires_shipping

• line_items__sku

• line_items__title

• line_items__variant_id

• line_items__variant_title

• line_items__vendor

• note

• referring_site

• shipping_address__address1

• shipping_address__address2

• shipping_address__city

• shipping_address__company

• shipping_address__country

• shipping_address__firstname

• shipping_address__latitude

• shipping_address__longitude

• shipping_address__lastname

• shipping_address__phone

• shipping_address__province

• shipping_address__zip

• shipping_address__name

• shipping_address__province_code

• shipping_address__country_code

• shipping_lines*

• source_name

• subtotal_price

• tax_lines*

• taxes_included

• token

• total_discounts

• total_line_items_price

• total_price

• total_tax

• total_weight

• updated_at

collects Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Collect ID (id)

• collection_id

• created_at

• featured

• position

• product_id

• sort_value

• updated_at

custom_collections Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Custom Collection ID (id)

• body_html

• handle

• image

• published

• published_at

• published_scope

• sort_order

• template_suffix

• title

• updated_at

customers & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

customers Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Customer ID (id)

• accepts_marketing

• addresses*

• created_at

• default_address*

• email

• first_name

• multipass_identifier

• last_name

• last_order_id

• last_order_name

• note

• orders_count

• state

• tags

• tax_exempt

• total_spent

• updated_at

• verified_email

metafields Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Metafield ID (id)

• created_at

• description

• key

• namespace

• owner_id

• owner_resource

• value

• value_type

• updated_at

order_refunds & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

order_refunds Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Order Refund ID (id)

• created_at

• note

• restock

• refund_line_items*

• transactions*

• user_id

orders & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

orders Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Order ID (id)

• billing_address*

• browser_ip

• buyer_accepts_marketing

• cancel_reason

• cancelled_at

• cart_token

• client_details__accept_language

• client_details__browser_height

• client_details__browser_ip

• client_details__browser_width

• client_details__session_hash

• client_details__user_agent

• closed_at

• created_at

• currency

• customer__accepts_marketing

• customer__created_at

• customer__email

• customer__first_name

• customer__id

• customer__last_name

• customer__note

• customer__orders_count

• customer__state

• customer__total_spent

• customer__updated_at

• customer__tags

• discount_codes*

• email

• financial_status

• fulfillments*

• fulfillment_status

• tags*

• gateway

• landing_site

• line_items*

• location_id

• name

• note

• note_attributes*

• number

• order_number

• payment_gateway_names

• processed_at

• processing_method

• referring_site

• refunds

• shipping_address*

• shipping_lines*

• source_name

• subtotal_price

• tax_lines*

• taxes_included

• token

• total_discounts

• total_line_items_price

• total_price

• total_tax

• total_weight

• updated_at

• user_id

• order_status_url

products & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

products Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Product ID (id)

• body_html

• created_at

• handle

• images*

• options*

• product_type

• published_at

• published_scope

• tags*

• template_suffix

• title

• metafields_global_title_tag

• metafields_global_description_tag

• updated_at

• variants*

• vendor

transactions Attributes

While we try to include everything Shopify has here, this may not be a full list of attributes. Refer to Shopify's documentation for a full list and description of each attribute.

• Transaction ID (id)

• amount

• authorization

• created_at

• device_id

• gateway

• source_name

• payment_details

• kind

• order_id

• receipt

• error_code

• status

• test

• user_id

• currency