Movatterモバイル変換

[0]ホーム
URL:

DOCS >INTEGRATIONS >SAAS >SHOPIFY >SHOPIFY (V2)

Get started with a free trial today

Already have an account? Sign in

Shopify (v2)

Shopify extraction is supported by Stitch
This integration is powered bySinger's Shopify tap and certified by Stitch.Check out and contribute to the repo on GitHub.

For support, contactSupport.

Shopify integration summary

Stitch’s Shopify integration replicates data using theShopify REST Admin API (v2025-02). Refer to theSchema section for a list of objects available for replication.

Shopify feature snapshot

A high-level look at Stitch's Shopify (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Deprecated on April 1, 2025

Supported by

Stitch

Stitch plan

Standard

API availability

Not available

Singer GitHub repository

singer-io/tap-shopify

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Shopify

Shopify setup requirements

To set up Shopify in Stitch, you need:

  • Admin access in Shopify. This is required to allow Stitch to replicate data.

    Note: If you’re on a Shopify Plus plan, the permissions required may differ. Store owners can grant users permissions to export orders, draft orders, products, inventory, and customer data. In general,view-level permissions should be sufficient.

    Refer to theShopify Staff permissions documentation for more information.

Step 1: Add Shopify as a Stitch data source

  1. Sign into your Stitch account.

  2. On the Stitch Dashboard page, click theAdd Integration button.

  3. Click theShopify icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Shopify” would create a schema calledstitch_shopify in the destination.Note: Schema names cannot be changed after you save the integration.

  5. In theShopify Shop field, enter the name of the shop you want to connect to Stitch. For example: If the shop URL wasstitch-data.shopify.com, you’d enterstitch-data into this field.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Shopify integration. This means that dataequal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Shopify’s default setting of1 year. For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to theReplication Scheduling documentation for more information.

In theReplication Frequency section, you’ll create the integration’sreplication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Shopify integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Shopify

  1. Next, you’ll be prompted to sign into your Shopify account. Enter your Shopify credentials.
  2. ClickLog in.
  3. After the authorization process is successfully completed, you’ll be directed back to Stitch.
  4. ClickAll Done.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements forselection andreplication.

The last step is to select the tables and columns you want to replicate.Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Shopify integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’sTables to Replicate tab, locate a table you want to replicate.

  2. To track a table, click thecheckbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click thecheckbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click theFinalize Your Selections button at the bottom of the screen to save your selections.
Important: Using theSelect All feature will overwrite any previous selections. However, selections aren’t final untilFinalize Your Selections is clicked. ClickingCancel will restore your previous selections.Refer to theSelect All guide for more info about this feature.
  1. Click into the integration from the Stitch Dashboard page.

  2. Click theTables to Replicate tab.

  3. In the list of tables, click the box next to theTable Names column.

  4. In the menu that displays, clickTrack all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click theFinalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Shopify, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to theAnchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure topause ordelete the integration to prevent unwanted usage.

Shopify replication

Replicating order refunds

To extract order refund data, Stitch queries every order in your account. If you have theorder_refunds table selected for replication, the process can potentially be very slow depending on how many orders and refunds exist in your Shopify account. As tables are extracted one at a time, this could cause extraction to not proceed for days at a time. To ensure timely replication of your other selected tables, consider creating a separate integration for only theorder_refunds table.

Note: Creating a separate integration for yourorder_refunds table may negatively affect your Shopify API quota.

Shopify table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is forversion 2 of this integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs >customers), while case is maintained in PostgreSQL destinations (CusTomERs >CusTomERs). Refer to theLoading Guide for your destination for more info.

abandoned_checkouts

Theabandoned_checkouts table contains info about abandoned checkouts. Shopify considers a checkout to be abandoned when a customer has entered billing and shipping details, but hasn’t completed the purchase.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

abandoned_checkouts schema on GitHub

Shopify API method

Join abandoned_checkouts withon
customers
abandoned_checkouts.customer.default_address.customer_id = customers.id
abandoned_checkouts.customer.id = customers.id
abandoned_checkouts.customer.addresses.customer_id = customers.id
abandoned_checkouts.customer.default_address.customer_id = customers.addresses.id
abandoned_checkouts.customer.id = customers.addresses.id
abandoned_checkouts.customer.addresses.customer_id = customers.addresses.id
abandoned_checkouts.customer.last_order_id = customers.last_order_id
order_refunds
abandoned_checkouts.customer.last_order_id = order_refunds.order_id
abandoned_checkouts.line_items.product_id = order_refunds.refund_line_items.line_item.product_id
orders
abandoned_checkouts.customer.last_order_id = orders.id
abandoned_checkouts.customer.last_order_id = orders.refunds.order_adjustments.order_id
abandoned_checkouts.line_items.product_id = orders.fulfillments.line_items.product_id
abandoned_checkouts.line_items.product_id = orders.refunds.refund_line_items.line_item.product_id
abandoned_checkouts.line_items.product_id = orders.line_items.product_id
transactions
abandoned_checkouts.customer.last_order_id = transactions.order_id
collects
abandoned_checkouts.line_items.product_id = collects.product_id
products
abandoned_checkouts.line_items.product_id = products.id
abandoned_checkouts.line_items.product_id = products.options.product_id

abandoned_checkout_url

STRING

billing_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

first_name

STRING

last_name

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

buyer_accepts_marketing

BOOLEAN

buyer_accepts_sms_marketing

BOOLEAN

cart_token

STRING

closed_at

DATE-TIME

completed_at

DATE-TIME

created_at

DATE-TIME

currency

STRING

customer

OBJECT

addresses

ARRAY

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

country_name

STRING

customer_id

INTEGER

default

BOOLEAN

first_name

STRING

id

INTEGER

last_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

admin_graphql_api_id

STRING

created_at

DATE-TIME

default_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

country_name

STRING

customer_id

INTEGER

default

BOOLEAN

first_name

STRING

id

INTEGER

last_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

email

STRING

email_marketing_consent

OBJECT

consent_updated_at

DATE-TIME

opt_in_level

STRING

state

STRING

first_name

STRING

id

INTEGER

last_name

STRING

last_order_id

INTEGER

last_order_name

STRING

multipass_identifier

STRING

note

STRING

orders_count

INTEGER

phone

STRING

sms_marketing_consent

OBJECT

consent_collected_from

STRING

consent_updated_at

DATE-TIME

opt_in_level

STRING

state

STRING

state

STRING

tags

STRING

tax_exempt

BOOLEAN

tax_exemptions

ARRAY

total_spent

STRING

updated_at

DATE-TIME

verified_email

BOOLEAN

customer_locale

STRING

device_id

INTEGER

discount_codes

ARRAY

amount

NUMBER

code

STRING

type

STRING

email

STRING

gateway

STRING

id

INTEGER

landing_site

STRING

line_items

ARRAY

admin_graphql_api_id

STRING

applied_discount

INTEGER

applied_discounts

ARRAY

compare_at_price

STRING

destination_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

destination_location_id

INTEGER

discount_allocations

ARRAY

amount

NUMBER

discount_application_index

INTEGER

fulfillable_quantity

INTEGER

fulfillment_service

STRING

fulfillment_status

STRING

gift_card

BOOLEAN

grams

INTEGER

id

INTEGER, STRING

key

STRING

line_price

STRING

name

STRING

origin_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

origin_location_id

INTEGER

pre_tax_price

NUMBER

price

NUMBER

product_exists

BOOLEAN

product_id

INTEGER

properties

ARRAY

name

STRING

value

STRING

OBJECT

quantity

INTEGER

requires_shipping

BOOLEAN

sku

STRING

tax_code

STRING

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

taxable

BOOLEAN

title

STRING

total_discount

NUMBER

variant_id

INTEGER

variant_inventory_management

STRING

variant_title

STRING

vendor

STRING

location_id

INTEGER

name

STRING

note

STRING

note_attributes

ARRAY

name

STRING

value

STRING

phone

STRING

presentment_currency

STRING

referring_site

STRING

shipping_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

first_name

STRING

last_name

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

shipping_lines

ARRAY

api_client_id

INTEGER

applied_discounts

ARRAY

carrier_identifier

STRING

carrier_service_id

INTEGER

code

STRING

custom_tax_lines

ARRAY

delivery_category

STRING

id

STRING

markup

STRING

phone

STRING

price

NUMBER

requested_fulfillment_service_id

STRING

source

STRING

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

title

STRING

validation_context

STRING

sms_marketing_phone

STRING

source

STRING

source_identifier

STRING

source_name

STRING

source_url

STRING

subtotal_price

NUMBER

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

taxes_included

BOOLEAN

token

STRING

total_discounts

NUMBER

total_duties

NUMBER

total_line_items_price

NUMBER

total_price

NUMBER

total_tax

NUMBER

total_weight

INTEGER

updated_at

DATE-TIME

user_id

INTEGER

collects

Thecollects table contains info about collects, which are used to manage relationships between products and custom collections. For every product in a custom collection, there’s a collect that tracks the ID of both the product and the custom collection.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

collects schema on GitHub

Shopify API method

Join collects withon
custom_collections
collects.collection_id = custom_collections.id
abandoned_checkouts
collects.product_id = abandoned_checkouts.line_items.product_id
order_refunds
collects.product_id = order_refunds.refund_line_items.line_item.product_id
orders
collects.product_id = orders.fulfillments.line_items.product_id
collects.product_id = orders.refunds.refund_line_items.line_item.product_id
collects.product_id = orders.line_items.product_id
products
collects.product_id = products.id
collects.product_id = products.options.product_id

collection_id

INTEGER

created_at

DATE-TIME

id

INTEGER

position

INTEGER

product_id

INTEGER

sort_value

STRING

updated_at

DATE-TIME

custom_collections

Thecustom_collections table contains info about custom collections. A custom collection is a grouping of products that a merchant creates to make their store easier to browse.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

custom_collections schema on GitHub

Shopify API method

Join custom_collections withon
collects
custom_collections.id = collects.collection_id

admin_graphql_api_id

STRING

body_html

STRING

handle

STRING

id

INTEGER

image

OBJECT

alt

STRING

created_at

STRING

height

INTEGER

src

STRING

width

INTEGER

published_at

STRING

published_scope

STRING

sort_order

STRING

template_suffix

STRING

title

STRING

updated_at

STRING

customers

Thecustomers table contains info about the shop’s customers. This includes their contact details, order history, and email marketing preferences.

Customer metafield data

To replicate customer metafield data, you must set this table and themetafields table to replicate.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Shopify documentation

customers schema on GitHub

Shopify API method

Join customers withon
abandoned_checkouts
customers.id = abandoned_checkouts.customer.default_address.customer_id
customers.addresses.id = abandoned_checkouts.customer.default_address.customer_id
customers.id = abandoned_checkouts.customer.id
customers.addresses.id = abandoned_checkouts.customer.id
customers.id = abandoned_checkouts.customer.addresses.customer_id
customers.addresses.id = abandoned_checkouts.customer.addresses.customer_id
customers.last_order_id = abandoned_checkouts.customer.last_order_id
order_refunds
customers.last_order_id = order_refunds.order_id
orders
customers.last_order_id = orders.id
customers.last_order_id = orders.refunds.order_adjustments.order_id
transactions
customers.last_order_id = transactions.order_id

addresses

ARRAY

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

country_name

STRING

customer_id

INTEGER

default

BOOLEAN

first_name

STRING

id

INTEGER

last_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

admin_graphql_api_id

STRING

created_at

DATE-TIME

default_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

country_name

STRING

customer_id

INTEGER

default

BOOLEAN

first_name

STRING

id

INTEGER

last_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

email

STRING

email_marketing_consent

OBJECT

consent_updated_at

DATE-TIME

opt_in_level

STRING

state

STRING

first_name

STRING

id

INTEGER

last_name

STRING

last_order_id

INTEGER

last_order_name

STRING

multipass_identifier

STRING

note

STRING

orders_count

INTEGER

phone

STRING

sms_marketing_consent

OBJECT

consent_collected_from

STRING

consent_updated_at

DATE-TIME

opt_in_level

STRING

state

STRING

state

STRING

tags

STRING

tax_exempt

BOOLEAN

tax_exemptions

ARRAY

total_spent

STRING

updated_at

DATE-TIME

verified_email

BOOLEAN

events

Theevents table contains info about events in the shop.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

created_at

Useful links

Shopify documentation

events schema on GitHub

Shopify API method

arguments

ARRAY

STRING

author

STRING

body

STRING

created_at

DATE-TIME

description

STRING

id

INTEGER

message

STRING

path

STRING

subject_id

INTEGER

subject_type

STRING

verb

STRING

inventory_items

Theinventory_items table contains info about items in a shop.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

Shopify documentation

inventory_items schema on GitHub

Shopify API method

id

STRING

sku

STRING

createdAt

STRING

updatedAt

STRING

requiresShipping

BOOLEAN

unitCost

OBJECT

countryCodeOfOrigin

STRING

provinceCodeOfOrigin

STRING

harmonizedSystemCode

STRING

tracked

BOOLEAN

countryHarmonizedSystemCodes

ARRAY

countryCode

STRING

harmonizedSystemCode

STRING

inventory_levels

Theinventory_levels table contains info about quantities of an inventory item for a location.

Replication Method

Key-based Incremental

Primary Keys

inventory_item_id

location_id

Replication Key

updated_at

Useful links

Shopify documentation

inventory_levels schema on GitHub

Shopify API method

admin_graphql_api_id

STRING

available

INTEGER

inventory_item_id

INTEGER

location_id

INTEGER

updated_at

DATE-TIME

locations

Thelocations table contains info about .

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Shopify documentation

locations schema on GitHub

Shopify API method

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

metafields

Themetafields table contains info about resource metafields. These are arbitrary fields used to store additional information about resources.

Metafield replication and resource types

By default, this table will include only shop-level metafield data. To replicate the metafields for a given resource type, this table and the table for the resource must be set to replicate.

For example: To replicate metafield data for Orders, theorders table must also be set to replicate.

Metafield data is available forcustomers,products, andorders.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

metafields schema on GitHub

Shopify API method

owner

OBJECT

ownerType

STRING

value_type

STRING

key

STRING

createdAt

STRING

id

STRING

namespace

STRING

description

STRING

value

INTEGER, OBJECT, STRING

updatedAt

STRING

type

STRING

order_refunds

Theorder_refunds table contains info about refunds associated with orders.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

created_at

Useful links

order_refunds schema on GitHub

Shopify API method

Join order_refunds withon
abandoned_checkouts
order_refunds.order_id = abandoned_checkouts.customer.last_order_id
order_refunds.refund_line_items.line_item.product_id = abandoned_checkouts.line_items.product_id
customers
order_refunds.order_id = customers.last_order_id
orders
order_refunds.order_id = orders.id
order_refunds.order_id = orders.refunds.order_adjustments.order_id
order_refunds.id = orders.refunds.id
order_refunds.id = orders.refunds.order_adjustments.refund_id
order_refunds.refund_line_items.line_item.product_id = orders.fulfillments.line_items.product_id
order_refunds.refund_line_items.line_item.product_id = orders.refunds.refund_line_items.line_item.product_id
order_refunds.refund_line_items.line_item.product_id = orders.line_items.product_id
transactions
order_refunds.order_id = transactions.order_id
collects
order_refunds.refund_line_items.line_item.product_id = collects.product_id
products
order_refunds.refund_line_items.line_item.product_id = products.id
order_refunds.refund_line_items.line_item.product_id = products.options.product_id

admin_graphql_api_id

STRING

created_at

DATE-TIME

id

INTEGER

note

STRING

order_adjustments

ARRAY

amount

NUMBER

amount_set

OBJECT

id

INTEGER

kind

STRING

order_id

INTEGER

reason

STRING

refund_id

INTEGER

tax_amount

NUMBER

tax_amount_set

OBJECT

order_id

INTEGER

processed_at

STRING

refund_line_items

ARRAY

id

INTEGER

line_item

OBJECT

admin_graphql_api_id

STRING

discount_allocations

ARRAY

amount

STRING

amount_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

discount_application_index

INTEGER

fulfillable_quantity

INTEGER

fulfillment_service

STRING

fulfillment_status

STRING

gift_card

BOOLEAN

grams

INTEGER

id

INTEGER

name

STRING

pre_tax_price

STRING

pre_tax_price_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

price

STRING

price_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

product_exists

BOOLEAN

product_id

INTEGER

properties

ARRAY

name

STRING

value

STRING

quantity

INTEGER

requires_shipping

BOOLEAN

sku

STRING

tax_lines

ARRAY

price

STRING

price_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

rate

NUMBER

title

STRING

taxable

BOOLEAN

title

STRING

total_discount

STRING

total_discount_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

variant_id

INTEGER

variant_inventory_management

STRING

variant_title

STRING

vendor

STRING

line_item_id

INTEGER

location_id

INTEGER

quantity

INTEGER

restock_type

STRING

subtotal

NUMBER

subtotal_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

total_tax

NUMBER

total_tax_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency_code

STRING

shop_money

OBJECT

amount

STRING

currency_code

STRING

restock

BOOLEAN

transactions

ARRAY

admin_graphql_api_id

STRING

amount

NUMBER

authorization

STRING

created_at

STRING

currency

STRING

device_id

INTEGER

error_code

STRING

gateway

STRING

id

INTEGER

kind

STRING

location_id

INTEGER

message

STRING

order_id

INTEGER

parent_id

INTEGER

payment_details

OBJECT

acquirer_reference_number

STRING

avs_result_code

STRING

credit_card_bin

STRING

credit_card_company

STRING

credit_card_number

STRING

cvv_result_code

STRING

payments_refund_attributes

STRING

processed_at

STRING

status

STRING

payments_refund_attributes

OBJECT

acquirer_reference_number

STRING

status

STRING

processed_at

STRING

source_name

STRING

status

STRING

test

BOOLEAN

user_id

INTEGER

user_id

INTEGER

orders

Theorders table contains info about a shop’s completed orders.

Order metafield data

To replicate order metafield data, you must set this table and themetafields table to replicate.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Shopify documentation

orders schema on GitHub

Shopify API method

Join orders withon
abandoned_checkouts
orders.id = abandoned_checkouts.customer.last_order_id
orders.refunds.order_adjustments.order_id = abandoned_checkouts.customer.last_order_id
orders.fulfillments.line_items.product_id = abandoned_checkouts.line_items.product_id
orders.refunds.refund_line_items.line_item.product_id = abandoned_checkouts.line_items.product_id
orders.line_items.product_id = abandoned_checkouts.line_items.product_id
customers
orders.id = customers.last_order_id
orders.refunds.order_adjustments.order_id = customers.last_order_id
order_refunds
orders.id = order_refunds.order_id
orders.refunds.order_adjustments.order_id = order_refunds.order_id
orders.refunds.id = order_refunds.id
orders.refunds.order_adjustments.refund_id = order_refunds.id
orders.fulfillments.line_items.product_id = order_refunds.refund_line_items.line_item.product_id
orders.refunds.refund_line_items.line_item.product_id = order_refunds.refund_line_items.line_item.product_id
orders.line_items.product_id = order_refunds.refund_line_items.line_item.product_id
transactions
orders.id = transactions.order_id
orders.refunds.order_adjustments.order_id = transactions.order_id
collects
orders.fulfillments.line_items.product_id = collects.product_id
orders.refunds.refund_line_items.line_item.product_id = collects.product_id
orders.line_items.product_id = collects.product_id
products
orders.fulfillments.line_items.product_id = products.id
orders.refunds.refund_line_items.line_item.product_id = products.id
orders.line_items.product_id = products.id
orders.fulfillments.line_items.product_id = products.options.product_id
orders.refunds.refund_line_items.line_item.product_id = products.options.product_id
orders.line_items.product_id = products.options.product_id

admin_graphql_api_id

STRING

app_id

INTEGER

billing_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

first_name

STRING

last_name

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

browser_ip

STRING

buyer_accepts_marketing

BOOLEAN

cancel_reason

STRING

cancelled_at

DATE-TIME

cart_token

STRING

checkout_id

INTEGER

checkout_token

STRING

client_details

OBJECT

accept_language

STRING

browser_height

INTEGER

browser_ip

STRING

browser_width

INTEGER

session_hash

STRING

user_agent

STRING

closed_at

DATE-TIME

confirmed

BOOLEAN

contact_email

STRING

created_at

DATE-TIME

currency

STRING

current_subtotal_price

NUMBER

current_subtotal_price_set

OBJECT

current_total_additional_fees_set

OBJECT

presentment_money

OBJECT

amount

NUMBER

currency

STRING

shop_money

OBJECT

amount

NUMBER

currency

STRING

current_total_discounts

NUMBER

current_total_discounts_set

OBJECT

current_total_duties_set

OBJECT

current_total_price

NUMBER

current_total_price_set

OBJECT

current_total_tax

NUMBER

current_total_tax_set

OBJECT

customer

OBJECT

accepts_marketing

BOOLEAN

accepts_marketing_updated_at

DATE-TIME

STRING

addresses

ARRAY

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

country_name

STRING

customer_id

INTEGER

default

BOOLEAN

first_name

STRING

id

INTEGER

last_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

admin_graphql_api_id

STRING

created_at

DATE-TIME

currency

STRING

default_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

country_name

STRING

customer_id

INTEGER

default

BOOLEAN

first_name

STRING

id

INTEGER

last_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

email

STRING

email_marketing_consent

OBJECT

consent_updated_at

DATE-TIME

opt_in_level

STRING

state

STRING

first_name

STRING

id

INTEGER

last_name

STRING

marketing_opt_in_level

STRING

multipass_identifier

STRING

note

STRING

phone

STRING

sms_marketing_consent

OBJECT

consent_collected_from

STRING

consent_updated_at

DATE-TIME

opt_in_level

STRING

state

STRING

state

STRING

tags

STRING

tax_exempt

BOOLEAN

tax_exemptions

ARRAY

updated_at

DATE-TIME

verified_email

BOOLEAN

customer_locale

STRING

device_id

INTEGER

discount_applications

ARRAY

allocation_method

STRING

code

STRING

description

STRING

target_selection

STRING

target_type

STRING

title

STRING

type

STRING

value

NUMBER

value_type

STRING

discount_codes

ARRAY

amount

NUMBER

code

STRING

type

STRING

email

STRING

estimated_taxes

BOOLEAN

financial_status

STRING

fulfillment_status

STRING

fulfillments

ARRAY

admin_graphql_api_id

STRING

created_at

DATE-TIME

id

INTEGER

line_items

ARRAY

admin_graphql_api_id

STRING

applied_discount

INTEGER

applied_discounts

ARRAY

compare_at_price

STRING

destination_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

destination_location_id

INTEGER

discount_allocations

ARRAY

amount

NUMBER

discount_application_index

INTEGER

fulfillable_quantity

INTEGER

fulfillment_service

STRING

fulfillment_status

STRING

gift_card

BOOLEAN

grams

INTEGER

id

INTEGER, STRING

key

STRING

line_price

STRING

name

STRING

origin_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

origin_location_id

INTEGER

pre_tax_price

NUMBER

price

NUMBER

product_exists

BOOLEAN

product_id

INTEGER

properties

ARRAY

name

STRING

value

STRING

OBJECT

quantity

INTEGER

requires_shipping

BOOLEAN

sku

STRING

tax_code

STRING

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

taxable

BOOLEAN

title

STRING

total_discount

NUMBER

variant_id

INTEGER

variant_inventory_management

STRING

variant_title

STRING

vendor

STRING

location_id

INTEGER

name

STRING

receipt

OBJECT

authorization

STRING

testcase

BOOLEAN

service

STRING

shipment_status

STRING

status

STRING

tracking_company

STRING

tracking_number

STRING

tracking_numbers

ARRAY

tracking_url

STRING

tracking_urls

ARRAY

updated_at

DATE-TIME

id

INTEGER

landing_site

STRING

landing_site_ref

STRING

line_items

ARRAY

admin_graphql_api_id

STRING

applied_discount

INTEGER

applied_discounts

ARRAY

compare_at_price

STRING

destination_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

destination_location_id

INTEGER

discount_allocations

ARRAY

amount

NUMBER

discount_application_index

INTEGER

fulfillable_quantity

INTEGER

fulfillment_service

STRING

fulfillment_status

STRING

gift_card

BOOLEAN

grams

INTEGER

id

INTEGER, STRING

key

STRING

line_price

STRING

name

STRING

origin_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

origin_location_id

INTEGER

pre_tax_price

NUMBER

price

NUMBER

product_exists

BOOLEAN

product_id

INTEGER

properties

ARRAY

name

STRING

value

STRING

OBJECT

quantity

INTEGER

requires_shipping

BOOLEAN

sku

STRING

tax_code

STRING

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

taxable

BOOLEAN

title

STRING

total_discount

NUMBER

variant_id

INTEGER

variant_inventory_management

STRING

variant_title

STRING

vendor

STRING

location_id

INTEGER

merchant_of_record_app_id

INTEGER

name

STRING

note

STRING

note_attributes

ARRAY

name

STRING

value

STRING

number

INTEGER

order_adjustments

ARRAY

amount

NUMBER

amount_set

OBJECT

id

INTEGER

kind

STRING

order_id

INTEGER

reason

STRING

refund_id

INTEGER

tax_amount

NUMBER

tax_amount_set

OBJECT

order_number

INTEGER

order_status_url

STRING

original_total_additional_fees_set

OBJECT

presentment_money

OBJECT

amount

NUMBER

currency

STRING

shop_money

OBJECT

amount

NUMBER

currency

STRING

original_total_duties_set

OBJECT

payment_gateway_names

ARRAY

payment_terms

OBJECT

amount

INTEGER, STRING

currency

STRING

due_in_days

INTEGER

payment_schedules

ARRAY

amount

INTEGER, STRING

completed_at

STRING

currency

STRING

due_at

DATE-TIME

expected_payment_method

STRING

issued_at

DATE-TIME

payment_terms_name

STRING

payment_terms_type

STRING

phone

STRING

poNumber

STRING

presentment_currency

STRING

processed_at

DATE-TIME

reference

STRING

referring_site

STRING

refunds

ARRAY

admin_graphql_api_id

STRING

created_at

DATE-TIME

id

INTEGER

note

STRING

order_adjustments

ARRAY

amount

NUMBER

amount_set

OBJECT

id

INTEGER

kind

STRING

order_id

INTEGER

reason

STRING

refund_id

INTEGER

tax_amount

NUMBER

tax_amount_set

OBJECT

processed_at

DATE-TIME

refund_line_items

ARRAY

id

INTEGER

line_item

OBJECT

admin_graphql_api_id

STRING

applied_discount

INTEGER

applied_discounts

ARRAY

compare_at_price

STRING

destination_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

destination_location_id

INTEGER

discount_allocations

ARRAY

amount

NUMBER

discount_application_index

INTEGER

fulfillable_quantity

INTEGER

fulfillment_service

STRING

fulfillment_status

STRING

gift_card

BOOLEAN

grams

INTEGER

id

INTEGER, STRING

key

STRING

line_price

STRING

name

STRING

origin_location

OBJECT

active

BOOLEAN

address1

STRING

address2

STRING

admin_graphql_api_id

STRING

city

STRING

country

STRING

country_code

STRING

country_name

STRING

created_at

DATE-TIME

id

INTEGER

legacy

BOOLEAN

localized_country_name

STRING

localized_province_name

STRING

name

STRING

phone

STRING

province

STRING

province_code

STRING

updated_at

DATE-TIME

zip

STRING

origin_location_id

INTEGER

pre_tax_price

NUMBER

price

NUMBER

product_exists

BOOLEAN

product_id

INTEGER

properties

ARRAY

name

STRING

value

STRING

OBJECT

quantity

INTEGER

requires_shipping

BOOLEAN

sku

STRING

tax_code

STRING

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

taxable

BOOLEAN

title

STRING

total_discount

NUMBER

variant_id

INTEGER

variant_inventory_management

STRING

variant_title

STRING

vendor

STRING

line_item_id

INTEGER

location_id

INTEGER

quantity

INTEGER

restock_type

STRING

subtotal

NUMBER

total_tax

NUMBER

restock

BOOLEAN

user_id

INTEGER

shipping_address

OBJECT

address1

STRING

address2

STRING

city

STRING

company

STRING

country

STRING

country_code

STRING

first_name

STRING

last_name

STRING

latitude

NUMBER

longitude

NUMBER

name

STRING

phone

STRING

province

STRING

province_code

STRING

zip

STRING

shipping_lines

ARRAY

carrier_identifier

STRING

code

STRING

delivery_category

STRING

discount_allocations

ARRAY

amount

NUMBER

discount_application_index

INTEGER

discounted_price

NUMBER

id

INTEGER

phone

STRING

price

NUMBER

requested_fulfillment_service_id

STRING

source

STRING

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

title

STRING

source_identifier

STRING

source_name

STRING

source_url

STRING

subtotal_price

NUMBER

tags

STRING

taxExempt

BOOLEAN

tax_lines

ARRAY

channel_liable

BOOLEAN

compare_at

STRING

position

INTEGER

price

NUMBER

rate

NUMBER

source

STRING

title

STRING

zone

STRING

taxes_included

BOOLEAN

test

BOOLEAN

token

STRING

total_discounts

NUMBER

total_line_items_price

NUMBER

total_outstanding

NUMBER

total_price

NUMBER

total_tax

NUMBER

total_tip_received

STRING

total_weight

INTEGER

updated_at

DATE-TIME

user_id

INTEGER

product_variants

Theproduct_variants table contains info about variants that can be added to a product to represent one version of a product with several options.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

Shopify documentation

product_variants schema on GitHub

Shopify API method

id

STRING

createdAt

STRING

barcode

STRING

availableForSale

BOOLEAN

compareAtPrice

STRING

displayName

STRING

image

OBJECT

altText

STRING

height

INTEGER

id

STRING

url

STRING

width

INTEGER

inventoryPolicy

STRING

inventoryQuantity

INTEGER

position

INTEGER

price

STRING

requiresComponents

BOOLEAN

sellableOnlineQuantity

INTEGER

sku

STRING

taxCode

STRING

taxable

BOOLEAN

title

STRING

updatedAt

STRING

product

OBJECT

products

Theproducts table contains info about a shop’s products.

Product metafield data

To replicate product metafield data, you must set this table and themetafields table to replicate.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

Shopify documentation

products schema on GitHub

Shopify API method

Join products withon
abandoned_checkouts
products.id = abandoned_checkouts.line_items.product_id
products.options.product_id = abandoned_checkouts.line_items.product_id
collects
products.id = collects.product_id
products.options.product_id = collects.product_id
order_refunds
products.id = order_refunds.refund_line_items.line_item.product_id
products.options.product_id = order_refunds.refund_line_items.line_item.product_id
orders
products.id = orders.fulfillments.line_items.product_id
products.options.product_id = orders.fulfillments.line_items.product_id
products.id = orders.refunds.refund_line_items.line_item.product_id
products.options.product_id = orders.refunds.refund_line_items.line_item.product_id
products.id = orders.line_items.product_id
products.options.product_id = orders.line_items.product_id

status

STRING

publishedAt

STRING

createdAt

STRING

vendor

STRING

updatedAt

STRING

productType

STRING

tags

STRING

options

ARRAY

name

STRING

values

ARRAY

id

STRING

position

INTEGER

handle

STRING

templateSuffix

STRING

title

STRING

id

STRING

giftCardTemplateSuffix

STRING

hasOnlyDefaultVariant

STRING

hasOutOfStockVariants

BOOLEAN

hasVariantsThatRequiresComponents

BOOLEAN

isGiftCard

BOOLEAN

description

STRING

descriptionHtml

STRING

category

OBJECT

featuredMedia

OBJECT

id

STRING

mediaContentType

STRING

status

STRING

requiresSellingPlan

BOOLEAN

totalInventory

INTEGER

tracksInventory

BOOLEAN

media

ARRAY

id

STRING

alt

STRING

status

STRING

mediaContentType

STRING

embedUrl

STRING

mimeType

STRING

filename

STRING

image

OBJECT

id

STRING

url

STRING

width

STRING

height

STRING

sources

ARRAY

url

STRING

format

STRING

mimeType

STRING

fileSize

STRING

mediaWarnings

ARRAY

code

STRING

message

STRING

mediaErrors

ARRAY

code

STRING

details

STRING

message

STRING

transactions

Thetransactions table contains info about transactions.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

created_at

Useful links

transactions schema on GitHub

Shopify API method

Join transactions withon
abandoned_checkouts
transactions.order_id = abandoned_checkouts.customer.last_order_id
customers
transactions.order_id = customers.last_order_id
order_refunds
transactions.order_id = order_refunds.order_id
orders
transactions.order_id = orders.id
transactions.order_id = orders.refunds.order_adjustments.order_id

error_code

STRING

device_id

INTEGER

user_id

INTEGER

parent_id

INTEGER

test

BOOLEAN

kind

STRING

order_id

INTEGER

amount

STRING

authorization

STRING

currency

STRING

source_name

STRING

message

STRING

id

INTEGER

created_at

STRING

status

STRING

payment_details

OBJECT

cvv_result_code

STRING

credit_card_bin

STRING

credit_card_company

STRING

credit_card_expiration_month

INTEGER

credit_card_expiration_year

INTEGER

credit_card_name

STRING

credit_card_number

STRING

credit_card_wallet

STRING

avs_result_code

STRING

gateway

STRING

admin_graphql_api_id

STRING

receipt

OBJECT

fee_amount

STRING

gross_amount

STRING

tax_amount

STRING

location_id

INTEGER

processed_at

STRING

payments_refund_attributes

OBJECT

status

STRING

acquirer_reference_number

STRING

payment_id

STRING

total_unsettled_set

OBJECT

presentment_money

OBJECT

amount

STRING

currency

STRING

shop_money

OBJECT

amount

STRING

currency

STRING

RelatedTroubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.

[8]ページ先頭
©2009-2026 Movatter.jp