# Shopify (v3)
Information note **Shopify extraction is supported by Stitch**
This integration is powered by [Singer's](https://www.singer.io/) Shopify tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-shopify).
For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport).
## Shopify integration summary
Stitch’s Shopify integration replicates data using the [Shopify GraphQL Admin API (v2025-01)](https://shopify.dev/docs/api/admin-graphql/2025-01). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#schema) section for a list of objects available for replication.
#### Shopify is now powered by GraphQL
We’ve enhanced the Stitch’s Shopify integration by replacing REST Admin API by the Shopify GraphQL API. This provides:
* More structured and complete data
* Better performance and scalability
* Access to new fields that are unavailable in REST
#### What has changed?
The data structure has been reorganized for consistency and clarity. Some fields may look different or appear in new locations. Also, a few fields are deprecated from the Shopify side.
If you need help, you can compare the structures. Refer to Shopify documentation:
* [REST Admin API](https://shopify.dev/docs/api/admin-rest)
* [GraphQL Admin API](https://shopify.dev/docs/api/admin-graphql)
Check out our updated Shopify docs for stream-level details and examples.
## Shopify feature snapshot
A high-level look at Stitch's Shopify (v3) integration, including release status, useful links, and the features supported in Stitch.
| **STITCH** | | | |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on April 1, 2025 | **Supported by**
the Info icon
Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**
the Info icon
The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**
the Info icon
Indicates if the integration is available as a source in Stitch Connect. | the Success icon
This version of the integration is available via the API.
Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon
This feature is supported for this version of the integration.
Supported | **Column selection**
the Info icon
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon
This feature is supported for this version of the integration.
Supported |
| **Select all**
the Info icon
Indicates if the integration supports selecting all available tables and columns. | the Success icon
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported |
## Connecting Shopify
### Shopify setup requirements
To set up Shopify in Stitch, you need:
* **Admin access in Shopify**. This is required to create and manage custom apps.
**Note: If you’re on a Shopify Plus plan**, the permissions required may differ. Store owners can grant users permissions to manage apps and custom integrations. In general, **app management** permissions should be sufficient.
Refer to the [Shopify Staff permissions documentation](https://help.shopify.com/en/manual/your-account/staff-accounts/staff-permissions#store-owner-permissions) for more information.
* **Access to Shopify Developer Dashboard** with app management permissions. You’ll use this to create a custom app and generate credentials.
* **Note:** Access tokens refresh automatically every 24 hours and are managed server-side by Stitch. You don’t need to manually refresh your credentials.
### Step 1: Add Shopify as a Stitch data source
1. [Sign into your Stitch account](https://app.stitchdata.com/).
2. On the Stitch Dashboard page, click the **Add Integration** button.
3. Click the **Shopify** 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 called `stitch_shopify` in the destination. **Note**: Schema names cannot be changed after you save the integration.
### Step 2: Create a Shopify custom app
A custom app allows you to securely generate credentials that Stitch will use to authenticate and replicate data from your Shopify store.
**To create a custom app:**
1. Log into your [Shopify Admin Dashboard](https://admin.shopify.com/).
2. In the sidebar, go to **Settings** > **Apps and integrations**.
3. Click **Develop apps** (or **App and sales channel settings** if using Shopify Plus).
4. Click **Create an app**.
5. Enter a name for your app (for example: `Stitch`).
6. Click **Create app**.
The app is created. Do not install it. You need to request some Shopify access first. See the next step.
### Step 3: Request access from Shopify
To access certain Shopify API scopes, you must request access from Shopify before installing your custom app. The following scopes require explicit approval:
##### read\_all\_orders scope
By default, you only have access to the last 60 days of orders. To access all historical orders, you must request the `read_all_orders` scope in the Shopify Partners dashboard.
**To request the `read_all_orders` scope:**
1. Go to the [Shopify Partners dashboard](https://partners.shopify.com/).
2. Navigate to **Apps** and select your app.
3. Open the **API access requests** section.
4. In the **Read all orders** section, click **Request access**.
5. In the access request justification, specify that the app needs full read-only access to historical orders for long-term analytics, reconciliation, and reporting.
6. Submit the request and wait for Shopify approval.
After Shopify approves the request, you can add the `read_all_orders` scope to your app scope list. If the app was already installed before this permission was granted, you must uninstall and reinstall the app for the new scope to take effect.
##### read\_users scope
To use the `read_users` scope, one of the following conditions must be true:
* The app must be a finance embedded app.
* The app must be installed on a Shopify Plus or Advanced store.
Contact Shopify Support to enable this scope if required.
### Step 4: Install the Shopify custom app
Follow this step only if you’ve created the app and requested access from Shopify. See the previous steps.
1. Go to the [Shopify Partners dashboard](https://partners.shopify.com/).
2. In the **Configuration** tab, click **Admin API access scopes**.
3. Select or copy-paste the following required scopes: `read_orders`,`read_all_orders`,`read_customers`,`read_products`,`read_checkouts`,`read_inventory`,`read_locations`, `read_assigned_fulfillment_orders`,`read_merchant_managed_fulfillment_orders`,`read_third_party_fulfillment_orders`.
| Scope | Purpose |
| --- | --- |
| `read_orders` | Replicate order data |
| `read_all_orders` | Replicate historical order data |
| `read_customers` | Replicate customer information |
| `read_products` | Replicate product catalog |
| `read_checkouts` | Replicate checkout data |
| `read_inventory` | Replicate inventory levels |
| `read_locations` | Replicate store locations |
| `read_assigned_fulfillment_orders` | Replicate assigned fulfillment orders |
| `read_merchant_managed_fulfillment_orders` | Replicate merchant-managed fulfillment orders |
| `read_third_party_fulfillment_orders` | Replicate third-party fulfillment orders |
4. Click **Save**.
5. In the **API credentials** tab, under **Admin API access token**, click **Reveal token once**. You’ll see your **Client ID** and **Client Secret**.
6. Store these credentials securely. You need them in the next step. Your Client Secret will only be visible once after initial creation. Store it securely before navigating away.
7. Click **Install app**.
### Step 5: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Shopify integration. This means that data **equal 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 of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide.
### Step 6: Create a replication schedule
Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information.
In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). 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:
* [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency)
* [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)
* [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage.
### Step 7: Set objects to replicate
Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements).
The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#schema)
**Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts.
* Selection options
* Individual tables and columns
* All tables and columns
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’s **Tables to Replicate tab**, locate a table you want to replicate.
2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate.
3. To track a column, click the **checkbox** 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 the **Finalize Your Selections** button at the bottom of the screen to save your selections.
Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature.
1. Click into the integration from the Stitch Dashboard page.
2. Click the **Tables to Replicate** tab.
3. In the list of tables, click the box next to the **Table Names** column.
4. In the menu that displays, click **Track all Tables and Fields**:
The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab
5. Click the **Finalize 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, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.**
Information note
**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 the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) 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.
Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** 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 the `order_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 the `order_refunds` table.
**Note**: Creating a separate integration for your `order_refunds` table may negatively affect your Shopify API quota.
## Shopify table reference
Information note
**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 for **version 3** of this integration.
This is the latest version of the Shopify integration.
Information note
**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 the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info.
### abandoned\_checkouts
The `abandoned_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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [abandoned_checkouts schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/abandoned_checkouts.json "Opens in new tab: abandoned_checkouts schema on GitHub")
[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/orders/abandoned-checkouts?api[version]=2019-07 "Opens in new tab: Shopify API method") |
abandoned\_checkouts table foreign keys
| Join abandoned\_checkouts with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#customers) | ``` abandoned_checkouts.customers.id = customers.id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand billingAddress
phone
STRING
country
STRING
firstName
STRING
name
STRING
latitude
NUMBER
zip
STRING
lastName
STRING
province
STRING
address2
STRING
address1
STRING
countryCodeV2
STRING
city
STRING
company
STRING
provinceCode
STRING
longitude
NUMBER
coordinatesValidated
BOOLEAN
formattedArea
STRING
id
STRING
timeZone
STRING
validationResultSummary
STRING
|
| **discountCodes**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **createdAt**
STRING |
| **updatedAt**
STRING |
| **taxLines**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand taxLines
priceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
title
STRING
rate
NUMBER
source
STRING
channelLiable
BOOLEAN
ratePercentage
NUMBER
|
| **totalLineItemsPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalLineItemsPriceSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **id**
STRING |
| **name**
STRING |
| **totalTaxSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalTaxSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **shippingAddress**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand shippingAddress
phone
STRING
country
STRING
firstName
STRING
name
STRING
latitude
STRING
zip
STRING
lastName
STRING
province
STRING
address2
STRING
address1
STRING
countryCodeV2
STRING
city
STRING
company
STRING
provinceCode
STRING
longitude
STRING
coordinatesValidated
BOOLEAN
formattedArea
STRING
id
STRING
timeZone
STRING
validationResultSummary
STRING
|
| **abandonedCheckoutUrl**
STRING |
| **totalDiscountSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalDiscountSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **taxesIncluded**
BOOLEAN |
| **totalDutiesSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalDutiesSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **totalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalPriceSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **lineItems**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand lineItems
id
STRING
quantity
INTEGER
sku
STRING
title
STRING
variantTitle
STRING
variant
OBJECT
title
STRING
id
STRING
discountedTotalPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
components
ARRAY
id
STRING
quantity
INTEGER
title
STRING
variantTitle
STRING
customAttributes
ARRAY
key
STRING
value
STRING
product
OBJECT
id
STRING
discountedUnitPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
discountedUnitPriceWithCodeDiscount
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
originalTotalPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
originalUnitPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **subtotalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand subtotalPriceSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **customer**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand customer
id
STRING
lastOrder
OBJECT
id
STRING
|
### collections
The `collections` table contains info about the collections.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [collections schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/collections.json "Opens in new tab: collections schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/collections "Opens in new tab: Shopify API method") |
collections table schema
| **id**
STRING |
| --- |
| **title**
STRING |
| **handle**
STRING |
| **collectionType**
STRING |
| **updatedAt**
STRING |
| **productsCount**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand productsCount
count
INTEGER
precision
STRING
|
| **sortOrder**
STRING |
| **ruleSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand ruleSet
appliedDisjunctively
BOOLEAN
rules
ARRAY
column
STRING
condition
STRING
relation
STRING
|
| **seo**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand seo
description
STRING
title
STRING
|
| **feedback**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand feedback
summary
STRING
|
| **products**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
### customers
The `customers` table contains info about the shop’s customers. This includes their contact details, order history, and email marketing preferences.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/customers "Opens in new tab: Shopify documentation")
[customers schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/customers.json "Opens in new tab: customers schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/customers "Opens in new tab: Shopify API method") |
customers table foreign keys
| Join customers with | on |
| --- | --- |
| [abandoned_checkouts](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#abandoned-checkouts) | ``` customers.id = abandoned_checkouts.customers.id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand defaultAddress
city
STRING
address1
STRING
zip
STRING
id
STRING
province
STRING
phone
STRING
country
STRING
firstName
STRING
lastName
STRING
countryCodeV2
STRING
name
STRING
provinceCode
STRING
address2
STRING
company
STRING
timeZone
STRING
validationResultSummary
STRING
latitude
STRING
longitude
STRING
coordinatesValidated
BOOLEAN
formattedArea
STRING
|
| **numberOfOrders**
STRING |
| **state**
STRING |
| **verifiedEmail**
BOOLEAN |
| **firstName**
STRING |
| **updatedAt**
STRING |
| **note**
STRING |
| **phone**
STRING |
| **addresses**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand addresses
city
STRING
address1
STRING
zip
STRING
id
STRING
province
STRING
phone
STRING
country
STRING
firstName
STRING
lastName
STRING
countryCodeV2
STRING
name
STRING
provinceCode
STRING
address2
STRING
company
STRING
timeZone
STRING
validationResultSummary
STRING
latitude
NUMBER
longitude
NUMBER
coordinatesValidated
BOOLEAN
formattedArea
STRING
|
| **lastName**
STRING |
| **tags**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **taxExempt**
BOOLEAN |
| **id**
STRING |
| **createdAt**
STRING |
| **taxExemptions**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **emailMarketingConsent**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand emailMarketingConsent
consentUpdatedAt
STRING
marketingOptInLevel
STRING
marketingState
STRING
|
| **smsMarketingConsent**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand smsMarketingConsent
consentCollectedFrom
STRING
consentUpdatedAt
STRING
marketingOptInLevel
STRING
marketingState
STRING
|
| **validEmailAddress**
BOOLEAN |
| **productSubscriberStatus**
STRING |
| **amountSpent**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand amountSpent
amount
STRING
currencyCode
STRING
|
| **dataSaleOptOut**
BOOLEAN |
| **displayName**
STRING |
| **locale**
STRING |
| **lifetimeDuration**
STRING |
| **lastOrder**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand lastOrder
id
STRING
|
### events
The `events` table contains info about events in the shop.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | createdAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/event "Opens in new tab: Shopify documentation")
[events schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/events.json "Opens in new tab: events schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/event "Opens in new tab: Shopify API method") |
events table schema
| **id**
STRING |
| --- |
| **createdAt**
STRING |
| **action**
STRING |
| **appTitle**
STRING |
| **attributeToApp**
BOOLEAN |
| **attributeToUser**
BOOLEAN |
| **criticalAlert**
BOOLEAN |
| **message**
STRING |
| **subjectId**
STRING |
| **subjectType**
STRING |
| **additionalContent**
STRING |
| **additionalData**
STRING |
| **arguments**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **hasAdditionalContent**
BOOLEAN |
| **secondaryMessage**
STRING |
| **attachments**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **author**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand author
id
STRING
|
| **canDelete**
BOOLEAN |
| **canEdit**
BOOLEAN |
| **edited**
BOOLEAN |
| **rawMessage**
STRING |
### fulfillment\_orders
The `fulfillment_orders` table contains datails about fulfillment orders.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/latest/queries/fulfillmentorders "Opens in new tab: Shopify documentation")
[fulfillment_orders schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/fulfillment_orders.json "Opens in new tab: fulfillment_orders schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/latest/queries/fulfillmentorders "Opens in new tab: Shopify API method") |
fulfillment\_orders table schema
| **id**
STRING |
| --- |
| **orderId**
STRING |
| **updatedAt**
STRING |
| **supportedActions**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand supportedActions
action
STRING
externalUrl
STRING
|
| **status**
STRING |
| **requestStatus**
STRING |
| **orderProcessedAt**
STRING |
| **orderName**
STRING |
| **channelId**
STRING |
| **fulfillAt**
STRING |
| **fulfillBy**
STRING |
| **createdAt**
STRING |
| **destination**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand destination
address1
STRING
address2
STRING
city
STRING
province
STRING
zip
STRING
countryCode
STRING
company
STRING
email
STRING
firstName
STRING
lastName
STRING
phone
STRING
id
STRING
location
OBJECT
id
STRING
|
| **fulfillmentHolds**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fulfillmentHolds
displayReason
STRING
handle
STRING
reason
STRING
reasonNotes
STRING
id
STRING
heldByRequestingApp
BOOLEAN
|
| **internationalDuties**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand internationalDuties
incoterm
STRING
|
| **deliveryMethod**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand deliveryMethod
id
STRING
methodType
STRING
presentedName
STRING
serviceCode
STRING
sourceReference
STRING
minDeliveryDateTime
STRING
maxDeliveryDateTime
STRING
brandedPromise
OBJECT
handle
STRING
name
STRING
additionalInformation
OBJECT
instructions
STRING
phone
STRING
|
| **assignedLocation**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand assignedLocation
address1
STRING
address2
STRING
city
STRING
province
STRING
zip
STRING
countryCode
STRING
name
STRING
phone
STRING
location
OBJECT
id
STRING
|
| **merchantRequests**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand merchantRequests
id
STRING
kind
STRING
message
STRING
requestOptions
OBJECT
responseData
OBJECT
sentAt
STRING
fulfillmentOrder
OBJECT
id
STRING
|
| **locationsForMove**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand locationsForMove
message
STRING
movable
BOOLEAN
unavailableLineItemsCount
OBJECT
count
INTEGER
precision
STRING
availableLineItemsCount
OBJECT
count
INTEGER
precision
STRING
location
OBJECT
id
STRING
availableLineItems
ARRAY
unavailableLineItems
ARRAY
id
STRING
|
| **fulfillmentOrdersForMerge**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fulfillmentOrdersForMerge
id
STRING
|
| **fulfillments**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fulfillments
id
STRING
name
STRING
status
STRING
displayStatus
STRING
requiresShipping
BOOLEAN
totalQuantity
INTEGER
createdAt
STRING
updatedAt
STRING
inTransitAt
STRING
deliveredAt
STRING
estimatedDeliveryAt
STRING
originAddress
OBJECT
address1
STRING
address2
STRING
city
STRING
provinceCode
STRING
zip
STRING
countryCode
STRING
trackingInfo
ARRAY
company
STRING
number
STRING
url
STRING
service
OBJECT
id
STRING
location
OBJECT
id
STRING
fulfillmentOrders
ARRAY
id
STRING
fulfillmentLineItems
ARRAY
id
STRING
quantity
NUMBER
originalTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
discountedTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
lineItem
OBJECT
id
STRING
legacyResourceId
STRING
order
OBJECT
id
STRING
events
ARRAY
id
STRING
|
### inventory\_items
The `inventory_items` table contains info about items in a shop.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/inventoryitems "Opens in new tab: Shopify documentation")
[inventory_items schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/inventory_items.json "Opens in new tab: inventory_items schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/inventoryitems "Opens in new tab: Shopify API method") |
inventory\_items table schema
| **id**
STRING |
| --- |
| **sku**
STRING |
| **createdAt**
STRING |
| **updatedAt**
STRING |
| **requiresShipping**
BOOLEAN |
| **unitCost**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand unitCost
amount
STRING
|
| **countryCodeOfOrigin**
STRING |
| **provinceCodeOfOrigin**
STRING |
| **harmonizedSystemCode**
STRING |
| **tracked**
BOOLEAN |
| **countryHarmonizedSystemCodes**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand countryHarmonizedSystemCodes
countryCode
STRING
harmonizedSystemCode
STRING
|
### inventory\_levels
The `inventory_levels` table contains info about quantities of an inventory item for a location.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Keys ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/inventorylevel "Opens in new tab: Shopify documentation")
[inventory_levels schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/inventory_levels.json "Opens in new tab: inventory_levels schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/inventorylevel "Opens in new tab: Shopify API method") |
inventory\_levels table schema
| **id**
STRING |
| --- |
| **canDeactivate**
BOOLEAN |
| **createdAt**
STRING |
| **updatedAt**
STRING |
| **deactivationAlert**
STRING |
| **item**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand item
id
STRING
variant
OBJECT
id
STRING
|
| **location**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand location
id
STRING
|
| **quantities**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand quantities
id
STRING
name
STRING
quantity
INTEGER
updatedAt
STRING
|
### locations
The `locations` table contains info about .
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | createdAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/locations "Opens in new tab: Shopify documentation")
[locations schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/locations.json "Opens in new tab: locations schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/locations "Opens in new tab: Shopify API method") |
locations table schema
| **id**
STRING |
| --- |
| **name**
STRING |
| **updatedAt**
STRING |
| **createdAt**
STRING |
| **isActive**
BOOLEAN |
| **addressVerified**
BOOLEAN |
| **deactivatable**
BOOLEAN |
| **deactivatedAt**
STRING |
| **deletable**
BOOLEAN |
| **fulfillsOnlineOrders**
BOOLEAN |
| **hasActiveInventory**
BOOLEAN |
| **hasUnfulfilledOrders**
BOOLEAN |
| **isFulfillmentService**
BOOLEAN |
| **legacyResourceId**
STRING |
| **shipsInventory**
BOOLEAN |
| **address**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand address
countryCode
STRING
address1
STRING
city
STRING
address2
STRING
provinceCode
STRING
zip
STRING
province
STRING
phone
STRING
country
STRING
formatted
ARRAY
latitude
STRING
longitude
STRING
|
| **localPickupSettingsV2**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand localPickupSettingsV2
instructions
STRING
pickupTime
STRING
|
### metafields\_collections
The `metafields_collections` table contains info about metafields for collections.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Keys ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [metafields_collections schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/metafields_collections.json "Opens in new tab: metafields_collections schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/objects/metafield "Opens in new tab: Shopify API method") |
metafields\_collections table schema
| **owner**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand owner
id
STRING
|
| --- |
| **ownerType**
STRING |
| **value\_type**
STRING |
| **key**
STRING |
| **createdAt**
STRING |
| **id**
STRING |
| **namespace**
STRING |
| **description**
STRING |
| **value**
INTEGER, OBJECT, STRING
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **updatedAt**
STRING |
| **type**
STRING |
### metafields\_customers
The `metafields_customers` table contains info about metafields for customers.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Keys ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [metafields_customers schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/metafields_customers.json "Opens in new tab: metafields_customers schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/objects/metafield "Opens in new tab: Shopify API method") |
metafields\_customers table schema
| **owner**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand owner
id
STRING
|
| --- |
| **ownerType**
STRING |
| **value\_type**
STRING |
| **key**
STRING |
| **createdAt**
STRING |
| **id**
STRING |
| **namespace**
STRING |
| **description**
STRING |
| **value**
INTEGER, OBJECT, STRING
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **updatedAt**
STRING |
| **type**
STRING |
### metafields\_orders
The `metafields_orders` table contains info about metafields for orders.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Keys ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [metafields_orders schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/metafields_orders.json "Opens in new tab: metafields_orders schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/objects/metafield "Opens in new tab: Shopify API method") |
metafields\_orders table schema
| **owner**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand owner
id
STRING
|
| --- |
| **ownerType**
STRING |
| **value\_type**
STRING |
| **key**
STRING |
| **createdAt**
STRING |
| **id**
STRING |
| **namespace**
STRING |
| **description**
STRING |
| **value**
INTEGER, OBJECT, STRING
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **updatedAt**
STRING |
| **type**
STRING |
### metafields\_products
The `metafields_products` table contains info about metafields for products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Keys ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [metafields_products schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/metafields_products.json "Opens in new tab: metafields_products schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/objects/metafield "Opens in new tab: Shopify API method") |
metafields\_products table schema
| **owner**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand owner
id
STRING
|
| --- |
| **ownerType**
STRING |
| **value\_type**
STRING |
| **key**
STRING |
| **createdAt**
STRING |
| **id**
STRING |
| **namespace**
STRING |
| **description**
STRING |
| **value**
INTEGER, OBJECT, STRING
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **updatedAt**
STRING |
| **type**
STRING |
### order\_refunds
The `order_refunds` table contains info about refunds associated with orders.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | createdAt |
| **Useful links** | [order_refunds schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/order_refunds.json "Opens in new tab: order_refunds schema on GitHub")
[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/orders/refund?api[version]=2019-07 "Opens in new tab: Shopify API method") |
order\_refunds table foreign keys
| Join order\_refunds with | on |
| --- | --- |
| [abandoned_checkouts](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#abandoned-checkouts) | ``` order_refunds.order.id = abandoned_checkouts.customers.lastOrder.id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand order
id
STRING
|
| **refundLineItems**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand refundLineItems
id
STRING
quantity
INTEGER
priceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
restockType
STRING
restocked
BOOLEAN
location
OBJECT
id
STRING
subtotalSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
totalTaxSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
lineItem
OBJECT
id
STRING
vendor
STRING
quantity
INTEGER
title
STRING
requiresShipping
BOOLEAN
originalTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
taxLines
ARRAY
priceSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
rate
NUMBER
title
STRING
source
STRING
channelLiable
BOOLEAN
taxable
BOOLEAN
isGiftCard
BOOLEAN
name
STRING
discountedTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
sku
STRING
product
OBJECT
id
STRING
discountAllocations
ARRAY
allocatedAmountSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
discountApplication
OBJECT
index
INTEGER
targetType
STRING
targetSelection
STRING
allocationMethod
STRING
value
OBJECT
__typename
STRING
amount
NUMBER
currencyCode
STRING
percentage
NUMBER
customAttributes
ARRAY
key
STRING
value
STRING
totalDiscountSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
duties
ARRAY
harmonizedSystemCode
STRING
id
STRING
taxLines
ARRAY
rate
NUMBER
source
STRING
title
STRING
channelLiable
BOOLEAN
priceSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
countryCodeOfOrigin
STRING
discountedUnitPriceSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
|
| **orderAdjustments**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand orderAdjustments
amountSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
id
STRING
reason
STRING
taxAmountSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **updatedAt**
STRING |
### order\_shipping\_lines
The `order_shipping_lines` table contains the shipping details that the customer chose for their order.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/latest/objects/ShippingLine "Opens in new tab: Shopify documentation")
[order_shipping_lines schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/order_shipping_lines.json "Opens in new tab: order_shipping_lines schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/latest/objects/ShippingLine "Opens in new tab: Shopify API method") |
order\_shipping\_lines table schema
| **carrierIdentifier**
STRING |
| --- |
| **code**
STRING |
| **orderId**
STRING |
| **currentDiscountedPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentDiscountedPriceSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **custom**
BOOLEAN |
| **deliveryCategory**
STRING |
| **discountAllocations**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand discountAllocations
allocatedAmountSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
discountApplication
OBJECT
__typename
STRING
allocationMethod
STRING
index
INTEGER
targetSelection
STRING
targetType
STRING
title
STRING
code
STRING
description
STRING
value
OBJECT
__typename
STRING
amount
STRING
currencyCode
STRING
percentage
NUMBER
|
| **discountedPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand discountedPriceSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **id**
STRING |
| **isRemoved**
BOOLEAN |
| **originalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand originalPriceSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **phone**
STRING |
| **shippingRateHandle**
STRING |
| **source**
STRING |
| **taxLines**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand taxLines
channelLiable
BOOLEAN
priceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
rate
NUMBER
ratePercentage
STRING
source
STRING
title
STRING
|
| **title**
STRING |
| **updatedAt**
STRING |
### orders
The `orders` table contains info about a shop’s completed orders.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/orders "Opens in new tab: Shopify documentation")
[orders schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/orders.json "Opens in new tab: orders schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/orders "Opens in new tab: Shopify API method") |
orders table foreign keys
| Join orders with | on |
| --- | --- |
| [abandoned_checkouts](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#abandoned-checkouts) | ``` orders.id = abandoned_checkouts.customers.lastOrder.id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand additionalFees
id
STRING
name
STRING
price
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
taxLines
ARRAY
channelLiable
BOOLEAN
priceSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
rate
NUMBER
ratePercentage
NUMBER
source
STRING
title
STRING
|
| --- |
| **app**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand app
id
STRING
name
STRING
icon
OBJECT
id
STRING
|
| **billingAddress**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand billingAddress
address1
STRING
address2
STRING
city
STRING
company
STRING
coordinatesValidated
BOOLEAN
country
STRING
countryCodeV2
STRING
firstName
STRING
formattedArea
STRING
id
STRING
lastName
STRING
latitude
NUMBER
longitude
NUMBER
name
STRING
phone
STRING
province
STRING
provinceCode
STRING
timeZone
STRING
validationResultSummary
STRING
zip
STRING
|
| **billingAddressMatchesShippingAddress**
BOOLEAN |
| **canMarkAsPaid**
BOOLEAN |
| **canNotifyCustomer**
BOOLEAN |
| **cancelReason**
STRING |
| **cancellation**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand cancellation
staffNote
STRING
|
| **cancelledAt**
STRING |
| **capturable**
BOOLEAN |
| **cartDiscountAmountSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand cartDiscountAmountSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **channelInformation**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand channelInformation
id
STRING
channelId
STRING
|
| **clientIp**
STRING |
| **closed**
BOOLEAN |
| **closedAt**
STRING |
| **confirmationNumber**
STRING |
| **confirmed**
BOOLEAN |
| **createdAt**
STRING |
| **currencyCode**
STRING |
| **currentCartDiscountAmountSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentCartDiscountAmountSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentShippingPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentShippingPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentSubtotalLineItemsQuantity**
INTEGER |
| **currentSubtotalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentSubtotalPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentTotalAdditionalFeesSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentTotalAdditionalFeesSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentTotalDiscountsSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentTotalDiscountsSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentTotalDutiesSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentTotalDutiesSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentTotalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentTotalPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentTotalTaxSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand currentTotalTaxSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **currentTotalWeight**
NUMBER |
| **customer**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand customer
id
STRING
email
STRING
firstName
STRING
lastName
STRING
state
STRING
verifiedEmail
BOOLEAN
lastOrder
OBJECT
id
STRING
updatedAt
STRING
createdAt
STRING
note
STRING
multipassIdentifier
STRING
tags
STRING
taxExempt
STRING
taxExemptions
STRING
defaultAddress
OBJECT
address1
STRING
address2
STRING
city
STRING
countryCodeV2
STRING
province
STRING
zip
STRING
id
STRING
country
STRING
lastName
STRING
phone
STRING
firstName
STRING
name
STRING
provinceCode
STRING
company
STRING
addresses
ARRAY
address1
STRING
address2
STRING
city
STRING
countryCodeV2
STRING
province
STRING
zip
STRING
id
STRING
country
STRING
lastName
STRING
phone
STRING
firstName
STRING
name
STRING
provinceCode
STRING
company
STRING
|
| **customerJourneySummary**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **merchantOfRecordApp**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand merchantOfRecordApp
id
STRING
|
| **customerAcceptsMarketing**
BOOLEAN |
| **customerLocale**
STRING |
| **discountCodes**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **discountCode**
STRING |
| **displayFinancialStatus**
STRING |
| **displayFulfillmentStatus**
STRING |
| **disputes**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand disputes
id
STRING
initiatedAs
STRING
status
STRING
|
| **dutiesIncluded**
BOOLEAN |
| **email**
STRING |
| **edited**
BOOLEAN |
| **estimatedTaxes**
BOOLEAN |
| **fulfillable**
BOOLEAN |
| **fullyPaid**
BOOLEAN |
| **hasTimelineComment**
BOOLEAN |
| **fulfillmentsCount**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fulfillmentsCount
count
INTEGER
precision
STRING
|
| **id**
STRING |
| **legacyResourceId**
STRING |
| **merchantBusinessEntity**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand merchantBusinessEntity
address
OBJECT
address1
STRING
address2
STRING
city
STRING
countryCode
STRING
province
STRING
zip
STRING
companyName
STRING
displayName
STRING
id
STRING
primary
BOOLEAN
|
| **name**
STRING |
| **note**
STRING |
| **netPaymentSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand netPaymentSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **originalTotalAdditionalFeesSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand originalTotalAdditionalFeesSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **originalTotalDutiesSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand originalTotalDutiesSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **originalTotalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand originalTotalPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **paymentGatewayNames**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **phone**
STRING |
| **poNumber**
STRING |
| **presentmentCurrencyCode**
STRING |
| **processedAt**
STRING |
| **refundable**
BOOLEAN |
| **refundDiscrepancySet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand refundDiscrepancySet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **registeredSourceUrl**
STRING |
| **requiresShipping**
BOOLEAN |
| **restockable**
BOOLEAN |
| **returnStatus**
STRING |
| **shippingAddress**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand shippingAddress
address1
STRING
address2
STRING
city
STRING
company
STRING
coordinatesValidated
BOOLEAN
country
STRING
countryCodeV2
STRING
firstName
STRING
formattedArea
STRING
id
STRING
lastName
STRING
latitude
NUMBER
longitude
NUMBER
name
STRING
phone
STRING
province
STRING
provinceCode
STRING
timeZone
STRING
validationResultSummary
STRING
zip
STRING
|
| **shopifyProtect**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand shopifyProtect
eligibility
OBJECT
status
STRING
status
STRING
|
| **sourceIdentifier**
STRING |
| **sourceName**
STRING |
| **statusPageUrl**
STRING |
| **subtotalLineItemsQuantity**
INTEGER |
| **subtotalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand subtotalPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **tags**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **taxExempt**
BOOLEAN |
| **taxLines**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand taxLines
channelLiable
BOOLEAN
priceSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
rate
NUMBER
ratePercentage
NUMBER
source
STRING
title
STRING
|
| **taxesIncluded**
BOOLEAN |
| **test**
BOOLEAN |
| **totalCapturableSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalCapturableSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalCashRoundingAdjustment**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalCashRoundingAdjustment
paymentSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
refundSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalDiscountsSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalDiscountsSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalOutstandingSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalOutstandingSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalReceivedSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalReceivedSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalRefundedSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalRefundedSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalRefundedShippingSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalRefundedShippingSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalShippingPriceSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalShippingPriceSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalTaxSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalTaxSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalTipReceivedSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalTipReceivedSet
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
|
| **totalWeight**
NUMBER |
| **transactionsCount**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand transactionsCount
count
INTEGER
precision
STRING
|
| **unpaid**
BOOLEAN |
| **updatedAt**
STRING |
| **fulfillments**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fulfillments
id
STRING
name
STRING
status
STRING
totalQuantity
NUMBER
updatedAt
STRING
deliveredAt
STRING
estimatedDeliveryAt
STRING
requiresShipping
BOOLEAN
inTransitAt
STRING
trackingInfo
ARRAY
number
STRING
company
STRING
url
STRING
service
OBJECT
serviceName
STRING
id
STRING
handle
STRING
trackingSupport
BOOLEAN
type
STRING
permitsSkuSharing
BOOLEAN
inventoryManagement
BOOLEAN
|
| **lineItems**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand lineItems
id
STRING
vendor
STRING
quantity
NUMBER
title
STRING
requiresShipping
BOOLEAN
originalTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
taxLines
ARRAY
priceSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
rate
NUMBER
title
STRING
source
STRING
channelLiable
BOOLEAN
taxable
BOOLEAN
isGiftCard
BOOLEAN
name
STRING
discountedTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
sku
STRING
product
OBJECT
id
STRING
discountAllocations
ARRAY
allocatedAmountSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
discountApplication
OBJECT
index
INTEGER
title
STRING
targetType
STRING
targetSelection
STRING
allocationMethod
STRING
value
OBJECT
__typename
STRING
amount
NUMBER
currencyCode
STRING
percentage
NUMBER
customAttributes
ARRAY
key
STRING
value
STRING
totalDiscountSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
duties
ARRAY
harmonizedSystemCode
STRING
id
STRING
taxLines
ARRAY
rate
NUMBER
source
STRING
title
STRING
channelLiable
BOOLEAN
priceSet
OBJECT
presentmentMoney
OBJECT
amount
NUMBER
currencyCode
STRING
shopMoney
OBJECT
amount
NUMBER
currencyCode
STRING
countryCodeOfOrigin
STRING
discountedUnitPriceSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
originalUnitPriceSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
unfulfilledDiscountedTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
unfulfilledOriginalTotalSet
OBJECT
presentmentMoney
OBJECT
currencyCode
STRING
amount
NUMBER
shopMoney
OBJECT
currencyCode
STRING
amount
NUMBER
variant
OBJECT
id
STRING
|
| **shippingLine**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand shippingLine
carrierIdentifier
STRING
code
STRING
currentDiscountedPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
custom
BOOLEAN
deliveryCategory
STRING
discountAllocations
ARRAY
allocatedAmountSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
discountApplication
OBJECT
__typename
STRING
allocationMethod
STRING
index
INTEGER
targetSelection
STRING
targetType
STRING
title
STRING
code
STRING
description
STRING
value
OBJECT
__typename
STRING
amount
STRING
currencyCode
STRING
percentage
NUMBER
discountedPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
id
STRING
isRemoved
BOOLEAN
originalPriceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
phone
STRING
shippingRateHandle
STRING
source
STRING
taxLines
ARRAY
channelLiable
BOOLEAN
priceSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
rate
NUMBER
ratePercentage
STRING
source
STRING
title
STRING
title
STRING
|
### product\_variants
The `product_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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/productvariants "Opens in new tab: Shopify documentation")
[product_variants schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/product_variants.json "Opens in new tab: product_variants schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/productvariants "Opens in new tab: Shopify API method") |
product\_variants table schema
| **id**
STRING |
| --- |
| **createdAt**
STRING |
| **barcode**
STRING |
| **availableForSale**
BOOLEAN |
| **compareAtPrice**
STRING |
| **displayName**
STRING |
| **image**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand image
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
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand product
id
STRING
|
| **inventoryItem**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand inventoryItem
id
STRING
measurement
OBJECT
weight
OBJECT
unit
STRING
value
STRING
|
### products
The `products` table contains info about a shop’s products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/products "Opens in new tab: Shopify documentation")
[products schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/products.json "Opens in new tab: products schema on GitHub")
[Shopify API method](https://shopify.dev/docs/api/admin-graphql/2025-01/queries/products "Opens in new tab: Shopify API method") |
products table foreign keys
| Join products with | on |
| --- | --- |
| [abandoned_checkouts](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#abandoned-checkouts) | ``` products.id = abandoned_checkouts.lineItems.product.id ``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#order-refunds) | ``` products.id = order_refunds.refundLineItems.lineItem.product.id ``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3#orders) | ``` products.id = orders.lineItems.product.id ``` |
products table schema
| **status**
STRING |
| --- |
| **publishedAt**
STRING |
| **createdAt**
STRING |
| **vendor**
STRING |
| **updatedAt**
STRING |
| **productType**
STRING |
| **tags**
STRING |
| **options**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand options
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
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand category
id
STRING
|
| **featuredMedia**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand featuredMedia
id
STRING
mediaContentType
STRING
status
STRING
|
| **requiresSellingPlan**
BOOLEAN |
| **totalInventory**
INTEGER |
| **tracksInventory**
BOOLEAN |
| **media**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand media
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
The `transactions` table contains info about transactions.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | createdAt |
| **Useful links** | [transactions schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/transactions.json "Opens in new tab: transactions schema on GitHub")
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand amountRoundingSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **amountSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand amountSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **authorizationCode**
STRING |
| **authorizationExpiresAt**
STRING |
| **createdAt**
STRING |
| **errorCode**
STRING |
| **formattedGateway**
STRING |
| **gateway**
STRING |
| **id**
STRING |
| **kind**
STRING |
| **manualPaymentGateway**
BOOLEAN |
| **maximumRefundableV2**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **multiCapturable**
BOOLEAN |
| **order**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand order
id
STRING
|
| **parentTransaction**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand parentTransaction
accountNumber
STRING
createdAt
STRING
id
STRING
status
STRING
paymentId
STRING
processedAt
STRING
amountSet
OBJECT
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **paymentId**
STRING |
| **processedAt**
STRING |
| **receiptJson**
STRING |
| **settlementCurrency**
STRING |
| **settlementCurrencyRate**
STRING |
| **shopifyPaymentsSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand shopifyPaymentsSet
extendedAuthorizationSet
OBJECT
extendedAuthorizationExpiresAt
STRING
standardAuthorizationExpiresAt
STRING
refundSet
OBJECT
acquirerReferenceNumber
STRING
|
| **status**
STRING |
| **test**
BOOLEAN |
| **totalUnsettledSet**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand totalUnsettledSet
presentmentMoney
OBJECT
amount
STRING
currencyCode
STRING
shopMoney
OBJECT
amount
STRING
currencyCode
STRING
|
| **fees**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fees
id
STRING
rate
NUMBER
rateName
STRING
taxAmount
OBJECT
amount
STRING
currencyCode
STRING
type
STRING
flatFeeName
STRING
amount
OBJECT
amount
STRING
currencyCode
STRING
flatFee
OBJECT
amount
STRING
currencyCode
STRING
|
| **manuallyCapturable**
BOOLEAN |
| **paymentDetails**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.