# Shopify (v2)

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 REST Admin API (v2025-02)](https://shopify.dev/docs/admin-api/rest/reference). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#schema) section for a list of objects available for replication.

## Shopify feature snapshot

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

| **STITCH** |  |  |  |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Deprecated on April 1, 2025 | **Supported by**<br><br>the Info icon<br><br>Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**<br><br>the Info icon<br><br>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)**<br><br>the Info icon<br><br>Indicates if the integration is available as a source in Stitch Connect. | the Remove icon<br><br>This version of the integration isn't available via the API.<br><br><br>Not available |
| **Singer GitHub repository** | [singer-io/tap-shopify](https://github.com/singer-io/tap-shopify) |  |  |
| **REPLICATION SETTINGS** |  |  |  |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Table-level reset**<br><br>the Info icon<br><br>Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon<br><br>Table-level resets are not supported for this integration. Resets are only supported at the integration level.<br><br><br>Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**<br><br>the Info icon<br><br>Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon<br><br>Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.<br><br><br>Unsupported |
| **DATA SELECTION** |  |  |  |
| **Table selection**<br><br>the Info icon<br><br>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<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **Column selection**<br><br>the Info icon<br><br>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<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Select all**<br><br>the Info icon<br><br>Indicates if the integration supports selecting all available tables and columns. | the Success icon<br><br>Supported<br><br><br>Supported |  |  |
| **TRANSPARENCY** |  |  |  |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**<br><br>the Info icon<br><br>Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**<br><br>the Info icon<br><br>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<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |

## Connecting Shopify

### Shopify setup requirements

To set up Shopify in Stitch, you need:

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

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

  Refer to the [Shopify Staff permissions documentation](https://help.shopify.com/en/manual/your-account/staff-accounts/staff-permissions#store-owner-permissions) for more information.

### 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.

5. In the **Shopify Shop** field, enter the name of the shop you want to connect to Stitch. For example: If the shop URL was `stitch-data.shopify.com`, you’d enter `stitch-data` into this field.

### Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Shopify integration. This means that 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 3: 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 4: Authorize Stitch to access Shopify

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

### Step 5: 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/v2#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 tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)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 2** of this 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` &gt; `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` &gt; `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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **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")<br><br><br>[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/v2#customers) | ```<br>abandoned_checkouts.customer.default_address.customer_id = customers.id<br>```<br><br>```<br>abandoned_checkouts.customer.id = customers.id<br>```<br><br>```<br>abandoned_checkouts.customer.addresses.customer_id = customers.id<br>```<br><br>```<br>abandoned_checkouts.customer.default_address.customer_id = customers.addresses.id<br>```<br><br>```<br>abandoned_checkouts.customer.id = customers.addresses.id<br>```<br><br>```<br>abandoned_checkouts.customer.addresses.customer_id = customers.addresses.id<br>```<br><br>```<br>abandoned_checkouts.customer.last_order_id = customers.last_order_id<br>``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#order-refunds) | ```<br>abandoned_checkouts.customer.last_order_id = order_refunds.order_id<br>```<br><br>```<br>abandoned_checkouts.line_items.product_id = order_refunds.refund_line_items.line_item.product_id<br>``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#orders) | ```<br>abandoned_checkouts.customer.last_order_id = orders.id<br>```<br><br>```<br>abandoned_checkouts.customer.last_order_id = orders.refunds.order_adjustments.order_id<br>```<br><br>```<br>abandoned_checkouts.line_items.product_id = orders.fulfillments.line_items.product_id<br>```<br><br>```<br>abandoned_checkouts.line_items.product_id = orders.refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>abandoned_checkouts.line_items.product_id = orders.line_items.product_id<br>``` |
| [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#transactions) | ```<br>abandoned_checkouts.customer.last_order_id = transactions.order_id<br>``` |
| [collects](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#collects) | ```<br>abandoned_checkouts.line_items.product_id = collects.product_id<br>``` |
| [products](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#products) | ```<br>abandoned_checkouts.line_items.product_id = products.id<br>```<br><br>```<br>abandoned_checkouts.line_items.product_id = products.options.product_id<br>``` |

abandoned\_checkouts table schema

| **abandoned\_checkout\_url**<br><br><br>STRING |
| --- |
| **billing\_address**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand billing\_address<br><br><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								latitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								longitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **buyer\_accepts\_marketing**<br><br><br>BOOLEAN |
| **buyer\_accepts\_sms\_marketing**<br><br><br>BOOLEAN |
| **cart\_token**<br><br><br>STRING |
| **closed\_at**<br><br><br>DATE-TIME |
| **completed\_at**<br><br><br>DATE-TIME |
| **created\_at**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **customer**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand customer<br><br><table> <tr> <td> <p> <strong>								addresses							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand addresses</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								default							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								default_address							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand default_address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								default							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								email_marketing_consent							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand email_marketing_consent</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								consent_updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last_order_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_order_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								multipass_identifier							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								note							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								orders_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								sms_marketing_consent							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sms_marketing_consent</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								consent_collected_from							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								consent_updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tags							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_exempt							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								tax_exemptions							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								total_spent							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								verified_email							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **customer\_locale**<br><br><br>STRING |
| **device\_id**<br><br><br>INTEGER |
| **discount\_codes**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount\_codes<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **email**<br><br><br>STRING |
| **gateway**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **landing\_site**<br><br><br>STRING |
| **line\_items**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand line\_items<br><br><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discounts							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								compare_at_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								destination_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand destination_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								destination_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_allocations							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand discount_allocations</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_application_index							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fulfillable_quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_service							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gift_card							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								grams							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER, STRING													</p> </td> </tr> <tr> <td> <p> <strong>								key							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								origin_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand origin_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								origin_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								pre_tax_price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								product_exists							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								product_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								properties							</strong> </p> <p> </p> <p>ARRAY																																</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand properties</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> <p>OBJECT																																</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								requires_shipping							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								sku							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								taxable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								total_discount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_inventory_management							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								variant_title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								vendor							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **location\_id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **note**<br><br><br>STRING |
| **note\_attributes**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand note\_attributes<br><br><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **phone**<br><br><br>STRING |
| **presentment\_currency**<br><br><br>STRING |
| **referring\_site**<br><br><br>STRING |
| **shipping\_address**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand shipping\_address<br><br><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								latitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								longitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **shipping\_lines**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand shipping\_lines<br><br><table> <tr> <td> <p> <strong>								api_client_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discounts							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								carrier_identifier							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								carrier_service_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								custom_tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								delivery_category							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								markup							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								requested_fulfillment_service_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								validation_context							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **sms\_marketing\_phone**<br><br><br>STRING |
| **source**<br><br><br>STRING |
| **source\_identifier**<br><br><br>STRING |
| **source\_name**<br><br><br>STRING |
| **source\_url**<br><br><br>STRING |
| **subtotal\_price**<br><br><br>NUMBER |
| **tax\_lines**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_lines<br><br><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **taxes\_included**<br><br><br>BOOLEAN |
| **token**<br><br><br>STRING |
| **total\_discounts**<br><br><br>NUMBER |
| **total\_duties**<br><br><br>NUMBER |
| **total\_line\_items\_price**<br><br><br>NUMBER |
| **total\_price**<br><br><br>NUMBER |
| **total\_tax**<br><br><br>NUMBER |
| **total\_weight**<br><br><br>INTEGER |
| **updated\_at**<br><br><br>DATE-TIME |
| **user\_id**<br><br><br>INTEGER |

### collects

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

| **Replication Method [](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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **Useful links** | [collects schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/collects.json "Opens in new tab: collects schema on GitHub")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/products/collect?api[version]=2019-07 "Opens in new tab: Shopify API method") |

collects table foreign keys

| Join collects with | on |
| --- | --- |
| [custom_collections](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#custom-collections) | ```<br>collects.collection_id = custom_collections.id<br>``` |
| [abandoned_checkouts](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#abandoned-checkouts) | ```<br>collects.product_id = abandoned_checkouts.line_items.product_id<br>``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#order-refunds) | ```<br>collects.product_id = order_refunds.refund_line_items.line_item.product_id<br>``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#orders) | ```<br>collects.product_id = orders.fulfillments.line_items.product_id<br>```<br><br>```<br>collects.product_id = orders.refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>collects.product_id = orders.line_items.product_id<br>``` |
| [products](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#products) | ```<br>collects.product_id = products.id<br>```<br><br>```<br>collects.product_id = products.options.product_id<br>``` |

collects table schema

| **collection\_id**<br><br><br>INTEGER |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **position**<br><br><br>INTEGER |
| **product\_id**<br><br><br>INTEGER |
| **sort\_value**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |

### custom\_collections

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

| **Replication Method [](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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **Useful links** | [custom_collections schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/custom_collections.json "Opens in new tab: custom_collections schema on GitHub")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/products/customcollection?api[version]=2019-07 "Opens in new tab: Shopify API method") |

custom\_collections table foreign keys

| Join custom\_collections with | on |
| --- | --- |
| [collects](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#collects) | ```<br>custom_collections.id = collects.collection_id<br>``` |

custom\_collections table schema

| **admin\_graphql\_api\_id**<br><br><br>STRING |
| --- |
| **body\_html**<br><br><br>STRING |
| **handle**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **image**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand image<br><br><table> <tr> <td> <p> <strong>								alt							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								height							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								src							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **published\_at**<br><br><br>STRING |
| **published\_scope**<br><br><br>STRING |
| **sort\_order**<br><br><br>STRING |
| **template\_suffix**<br><br><br>STRING |
| **title**<br><br><br>STRING |
| **updated\_at**<br><br><br>STRING |

### customers

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

#### Customer metafield data

To replicate customer metafield data, you must set this table and the [`metafields`](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#metafields) table to replicate.

| **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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/admin-api/rest/reference/customers "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/customers/customer?api[version]=2019-07 "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/v2#abandoned-checkouts) | ```<br>customers.id = abandoned_checkouts.customer.default_address.customer_id<br>```<br><br>```<br>customers.addresses.id = abandoned_checkouts.customer.default_address.customer_id<br>```<br><br>```<br>customers.id = abandoned_checkouts.customer.id<br>```<br><br>```<br>customers.addresses.id = abandoned_checkouts.customer.id<br>```<br><br>```<br>customers.id = abandoned_checkouts.customer.addresses.customer_id<br>```<br><br>```<br>customers.addresses.id = abandoned_checkouts.customer.addresses.customer_id<br>```<br><br>```<br>customers.last_order_id = abandoned_checkouts.customer.last_order_id<br>``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#order-refunds) | ```<br>customers.last_order_id = order_refunds.order_id<br>``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#orders) | ```<br>customers.last_order_id = orders.id<br>```<br><br>```<br>customers.last_order_id = orders.refunds.order_adjustments.order_id<br>``` |
| [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#transactions) | ```<br>customers.last_order_id = transactions.order_id<br>``` |

customers table schema

| **addresses**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand addresses<br><br><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								default							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| --- |
| **admin\_graphql\_api\_id**<br><br><br>STRING |
| **created\_at**<br><br><br>DATE-TIME |
| **default\_address**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand default\_address<br><br><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								default							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **email**<br><br><br>STRING |
| **email\_marketing\_consent**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand email\_marketing\_consent<br><br><table> <tr> <td> <p> <strong>								consent_updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **first\_name**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **last\_name**<br><br><br>STRING |
| **last\_order\_id**<br><br><br>INTEGER |
| **last\_order\_name**<br><br><br>STRING |
| **multipass\_identifier**<br><br><br>STRING |
| **note**<br><br><br>STRING |
| **orders\_count**<br><br><br>INTEGER |
| **phone**<br><br><br>STRING |
| **sms\_marketing\_consent**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand sms\_marketing\_consent<br><br><table> <tr> <td> <p> <strong>								consent_collected_from							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								consent_updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **state**<br><br><br>STRING |
| **tags**<br><br><br>STRING |
| **tax\_exempt**<br><br><br>BOOLEAN |
| **tax\_exemptions**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **total\_spent**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **verified\_email**<br><br><br>BOOLEAN |

### 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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created\_at |
| **Useful links** | [Shopify documentation](https://shopify.dev/api/admin-rest/2022-01/resources/event#top "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/api/admin-rest/2022-01/resources/event#get-events "Opens in new tab: Shopify API method") |

events table schema

| **arguments**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>STRING |
| --- |
| **author**<br><br><br>STRING |
| **body**<br><br><br>STRING |
| **created\_at**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **message**<br><br><br>STRING |
| **path**<br><br><br>STRING |
| **subject\_id**<br><br><br>INTEGER |
| **subject\_type**<br><br><br>STRING |
| **verb**<br><br><br>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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/api/admin-rest/2022-01/resources/inventoryitem#top "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/api/admin-rest/2022-01/resources/inventoryitem#get-inventory-items "Opens in new tab: Shopify API method") |

inventory\_items table schema

| **id**<br><br><br>STRING |
| --- |
| **sku**<br><br><br>STRING |
| **createdAt**<br><br><br>STRING |
| **updatedAt**<br><br><br>STRING |
| **requiresShipping**<br><br><br>BOOLEAN |
| **unitCost**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand unitCost<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **countryCodeOfOrigin**<br><br><br>STRING |
| **provinceCodeOfOrigin**<br><br><br>STRING |
| **harmonizedSystemCode**<br><br><br>STRING |
| **tracked**<br><br><br>BOOLEAN |
| **countryHarmonizedSystemCodes**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand countryHarmonizedSystemCodes<br><br><table> <tr> <td> <p> <strong>								countryCode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								harmonizedSystemCode							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |

### 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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | inventory\_item\_id<br><br>location\_id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **Useful links** | [Shopify documentation](https://shopify.dev/api/admin-rest/2022-01/resources/inventorylevel#top "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/api/admin-rest/2022-01/resources/inventorylevel#get-inventory-levels "Opens in new tab: Shopify API method") |

inventory\_levels table schema

| **admin\_graphql\_api\_id**<br><br><br>STRING |
| --- |
| **available**<br><br><br>INTEGER |
| **inventory\_item\_id**<br><br><br>INTEGER |
| **location\_id**<br><br><br>INTEGER |
| **updated\_at**<br><br><br>DATE-TIME |

### 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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **Useful links** | [Shopify documentation](https://shopify.dev/api/admin-rest/2022-01/resources/location#top "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/api/admin-rest/2022-01/resources/location#get-locations "Opens in new tab: Shopify API method") |

locations table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **address1**<br><br><br>STRING |
| **address2**<br><br><br>STRING |
| **admin\_graphql\_api\_id**<br><br><br>STRING |
| **city**<br><br><br>STRING |
| **country**<br><br><br>STRING |
| **country\_code**<br><br><br>STRING |
| **country\_name**<br><br><br>STRING |
| **created\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **legacy**<br><br><br>BOOLEAN |
| **localized\_country\_name**<br><br><br>STRING |
| **localized\_province\_name**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **phone**<br><br><br>STRING |
| **province**<br><br><br>STRING |
| **province\_code**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **zip**<br><br><br>STRING |

### metafields

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

#### Metafield replication and resource types

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

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

Metafield data is available for [`customers`](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#customers), [`products`](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#products), and [`orders`](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updatedAt |
| **Useful links** | [metafields schema on GitHub](https://github.com/singer-io/tap-shopify/blob/master/tap_shopify/schemas/metafields.json "Opens in new tab: metafields schema on GitHub")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/metafield?api[version]=2019-07 "Opens in new tab: Shopify API method") |

metafields table schema

| **owner**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand owner<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| --- |
| **ownerType**<br><br><br>STRING |
| **value\_type**<br><br><br>STRING |
| **key**<br><br><br>STRING |
| **createdAt**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **namespace**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **value**<br><br><br>INTEGER, OBJECT, STRING<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **updatedAt**<br><br><br>STRING |
| **type**<br><br><br>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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created\_at |
| **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")<br><br><br>[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/v2#abandoned-checkouts) | ```<br>order_refunds.order_id = abandoned_checkouts.customer.last_order_id<br>```<br><br>```<br>order_refunds.refund_line_items.line_item.product_id = abandoned_checkouts.line_items.product_id<br>``` |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#customers) | ```<br>order_refunds.order_id = customers.last_order_id<br>``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#orders) | ```<br>order_refunds.order_id = orders.id<br>```<br><br>```<br>order_refunds.order_id = orders.refunds.order_adjustments.order_id<br>```<br><br>```<br>order_refunds.id = orders.refunds.id<br>```<br><br>```<br>order_refunds.id = orders.refunds.order_adjustments.refund_id<br>```<br><br>```<br>order_refunds.refund_line_items.line_item.product_id = orders.fulfillments.line_items.product_id<br>```<br><br>```<br>order_refunds.refund_line_items.line_item.product_id = orders.refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>order_refunds.refund_line_items.line_item.product_id = orders.line_items.product_id<br>``` |
| [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#transactions) | ```<br>order_refunds.order_id = transactions.order_id<br>``` |
| [collects](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#collects) | ```<br>order_refunds.refund_line_items.line_item.product_id = collects.product_id<br>``` |
| [products](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#products) | ```<br>order_refunds.refund_line_items.line_item.product_id = products.id<br>```<br><br>```<br>order_refunds.refund_line_items.line_item.product_id = products.options.product_id<br>``` |

order\_refunds table schema

| **admin\_graphql\_api\_id**<br><br><br>STRING |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **note**<br><br><br>STRING |
| **order\_adjustments**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand order\_adjustments<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								kind							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								order_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> </table> |
| **order\_id**<br><br><br>INTEGER |
| **processed\_at**<br><br><br>STRING |
| **refund\_line\_items**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand refund\_line\_items<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								line_item							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand line_item</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								discount_allocations							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand discount_allocations</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand amount_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								discount_application_index							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fulfillable_quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_service							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gift_card							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								grams							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								pre_tax_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								pre_tax_price_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand pre_tax_price_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								price_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand price_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								product_exists							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								product_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								properties							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand properties</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								requires_shipping							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								sku							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								price_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand price_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								taxable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								total_discount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								total_discount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand total_discount_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								variant_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_inventory_management							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								variant_title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								vendor							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								line_item_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								restock_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								subtotal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								subtotal_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand subtotal_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								total_tax							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								total_tax_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand total_tax_set</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |
| **restock**<br><br><br>BOOLEAN |
| **transactions**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand transactions<br><br><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								authorization							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								device_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								error_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gateway							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								kind							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								message							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								order_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								parent_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								payment_details							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand payment_details</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								acquirer_reference_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								avs_result_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_bin							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvv_result_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								payments_refund_attributes							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								processed_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								payments_refund_attributes							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand payments_refund_attributes</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								acquirer_reference_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								processed_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								source_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								test							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								user_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **user\_id**<br><br><br>INTEGER |

### orders

The `orders` table contains info about a shop’s completed orders.

#### Order metafield data

To replicate order metafield data, you must set this table and the [`metafields`](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#metafields) table to replicate.

| **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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_at |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/admin-api/rest/reference/orders/ "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/orders/order?api[version]=2019-07 "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/v2#abandoned-checkouts) | ```<br>orders.id = abandoned_checkouts.customer.last_order_id<br>```<br><br>```<br>orders.refunds.order_adjustments.order_id = abandoned_checkouts.customer.last_order_id<br>```<br><br>```<br>orders.fulfillments.line_items.product_id = abandoned_checkouts.line_items.product_id<br>```<br><br>```<br>orders.refunds.refund_line_items.line_item.product_id = abandoned_checkouts.line_items.product_id<br>```<br><br>```<br>orders.line_items.product_id = abandoned_checkouts.line_items.product_id<br>``` |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#customers) | ```<br>orders.id = customers.last_order_id<br>```<br><br>```<br>orders.refunds.order_adjustments.order_id = customers.last_order_id<br>``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#order-refunds) | ```<br>orders.id = order_refunds.order_id<br>```<br><br>```<br>orders.refunds.order_adjustments.order_id = order_refunds.order_id<br>```<br><br>```<br>orders.refunds.id = order_refunds.id<br>```<br><br>```<br>orders.refunds.order_adjustments.refund_id = order_refunds.id<br>```<br><br>```<br>orders.fulfillments.line_items.product_id = order_refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>orders.refunds.refund_line_items.line_item.product_id = order_refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>orders.line_items.product_id = order_refunds.refund_line_items.line_item.product_id<br>``` |
| [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#transactions) | ```<br>orders.id = transactions.order_id<br>```<br><br>```<br>orders.refunds.order_adjustments.order_id = transactions.order_id<br>``` |
| [collects](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#collects) | ```<br>orders.fulfillments.line_items.product_id = collects.product_id<br>```<br><br>```<br>orders.refunds.refund_line_items.line_item.product_id = collects.product_id<br>```<br><br>```<br>orders.line_items.product_id = collects.product_id<br>``` |
| [products](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#products) | ```<br>orders.fulfillments.line_items.product_id = products.id<br>```<br><br>```<br>orders.refunds.refund_line_items.line_item.product_id = products.id<br>```<br><br>```<br>orders.line_items.product_id = products.id<br>```<br><br>```<br>orders.fulfillments.line_items.product_id = products.options.product_id<br>```<br><br>```<br>orders.refunds.refund_line_items.line_item.product_id = products.options.product_id<br>```<br><br>```<br>orders.line_items.product_id = products.options.product_id<br>``` |

orders table schema

| **admin\_graphql\_api\_id**<br><br><br>STRING |
| --- |
| **app\_id**<br><br><br>INTEGER |
| **billing\_address**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand billing\_address<br><br><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								latitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								longitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **browser\_ip**<br><br><br>STRING |
| **buyer\_accepts\_marketing**<br><br><br>BOOLEAN |
| **cancel\_reason**<br><br><br>STRING |
| **cancelled\_at**<br><br><br>DATE-TIME |
| **cart\_token**<br><br><br>STRING |
| **checkout\_id**<br><br><br>INTEGER |
| **checkout\_token**<br><br><br>STRING |
| **client\_details**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand client\_details<br><br><table> <tr> <td> <p> <strong>								accept_language							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								browser_height							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								browser_ip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								browser_width							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								session_hash							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								user_agent							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **closed\_at**<br><br><br>DATE-TIME |
| **confirmed**<br><br><br>BOOLEAN |
| **contact\_email**<br><br><br>STRING |
| **created\_at**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **current\_subtotal\_price**<br><br><br>NUMBER |
| **current\_subtotal\_price\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **current\_total\_additional\_fees\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand current\_total\_additional\_fees\_set<br><br><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |
| **current\_total\_discounts**<br><br><br>NUMBER |
| **current\_total\_discounts\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **current\_total\_duties\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **current\_total\_price**<br><br><br>NUMBER |
| **current\_total\_price\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **current\_total\_tax**<br><br><br>NUMBER |
| **current\_total\_tax\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **customer**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand customer<br><br><table> <tr> <td> <p> <strong>								accepts_marketing							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								accepts_marketing_updated_at							</strong> </p> <p> </p> <p>DATE-TIME																				</p> <p>STRING																				</p> </td> </tr> <tr> <td> <p> <strong>								addresses							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand addresses</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								default							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								default_address							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand default_address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								default							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								email_marketing_consent							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand email_marketing_consent</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								consent_updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								marketing_opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								multipass_identifier							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								note							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								sms_marketing_consent							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sms_marketing_consent</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								consent_collected_from							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								consent_updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								opt_in_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tags							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_exempt							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								tax_exemptions							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								verified_email							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **customer\_locale**<br><br><br>STRING |
| **device\_id**<br><br><br>INTEGER |
| **discount\_applications**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount\_applications<br><br><table> <tr> <td> <p> <strong>								allocation_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								target_selection							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								target_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								value_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **discount\_codes**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount\_codes<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **email**<br><br><br>STRING |
| **estimated\_taxes**<br><br><br>BOOLEAN |
| **financial\_status**<br><br><br>STRING |
| **fulfillment\_status**<br><br><br>STRING |
| **fulfillments**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand fulfillments<br><br><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								line_items							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand line_items</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discounts							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								compare_at_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								destination_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand destination_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								destination_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_allocations							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand discount_allocations</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_application_index							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fulfillable_quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_service							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gift_card							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								grams							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER, STRING													</p> </td> </tr> <tr> <td> <p> <strong>								key							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								origin_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand origin_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								origin_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								pre_tax_price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								product_exists							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								product_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								properties							</strong> </p> <p> </p> <p>ARRAY																																</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand properties</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> <p>OBJECT																																</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								requires_shipping							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								sku							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								taxable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								total_discount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_inventory_management							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								variant_title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								vendor							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								receipt							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand receipt</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								authorization							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								testcase							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								service							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipment_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tracking_company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tracking_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tracking_numbers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								tracking_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tracking_urls							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table> |
| **id**<br><br><br>INTEGER |
| **landing\_site**<br><br><br>STRING |
| **landing\_site\_ref**<br><br><br>STRING |
| **line\_items**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand line\_items<br><br><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discounts							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								compare_at_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								destination_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand destination_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								destination_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_allocations							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand discount_allocations</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_application_index							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fulfillable_quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_service							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gift_card							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								grams							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER, STRING													</p> </td> </tr> <tr> <td> <p> <strong>								key							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								origin_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand origin_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								origin_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								pre_tax_price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								product_exists							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								product_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								properties							</strong> </p> <p> </p> <p>ARRAY																																</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand properties</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> <p>OBJECT																																</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								requires_shipping							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								sku							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								taxable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								total_discount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_inventory_management							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								variant_title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								vendor							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **location\_id**<br><br><br>INTEGER |
| **merchant\_of\_record\_app\_id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **note**<br><br><br>STRING |
| **note\_attributes**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand note\_attributes<br><br><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **number**<br><br><br>INTEGER |
| **order\_adjustments**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand order\_adjustments<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								kind							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								order_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> </table> |
| **order\_number**<br><br><br>INTEGER |
| **order\_status\_url**<br><br><br>STRING |
| **original\_total\_additional\_fees\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand original\_total\_additional\_fees\_set<br><br><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |
| **original\_total\_duties\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **payment\_gateway\_names**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **payment\_terms**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand payment\_terms<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER, STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								due_in_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								payment_schedules							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand payment_schedules</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER, STRING													</p> </td> </tr> <tr> <td> <p> <strong>								completed_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								due_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								expected_payment_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								issued_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								payment_terms_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								payment_terms_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **phone**<br><br><br>STRING |
| **poNumber**<br><br><br>STRING |
| **presentment\_currency**<br><br><br>STRING |
| **processed\_at**<br><br><br>DATE-TIME |
| **reference**<br><br><br>STRING |
| **referring\_site**<br><br><br>STRING |
| **refunds**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand refunds<br><br><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								note							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								order_adjustments							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand order_adjustments</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								kind							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								order_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount_set							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								processed_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								refund_line_items							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand refund_line_items</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								line_item							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand line_item</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								applied_discounts							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								compare_at_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								destination_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand destination_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								destination_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_allocations							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand discount_allocations</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_application_index							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fulfillable_quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_service							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fulfillment_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gift_card							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								grams							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER, STRING													</p> </td> </tr> <tr> <td> <p> <strong>								key							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line_price							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								origin_location							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand origin_location</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								admin_graphql_api_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								legacy							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								localized_country_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								localized_province_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								updated_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								origin_location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								pre_tax_price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								product_exists							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								product_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								properties							</strong> </p> <p> </p> <p>ARRAY																																</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand properties</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> <p>OBJECT																																</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								requires_shipping							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								sku							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								taxable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								total_discount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								variant_inventory_management							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								variant_title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								vendor							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								line_item_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								location_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								quantity							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								restock_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								subtotal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								total_tax							</strong> </p> <p>							NUMBER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								restock							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								user_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **shipping\_address**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand shipping\_address<br><br><table> <tr> <td> <p> <strong>								address1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								first_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								latitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								longitude							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								province_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zip							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **shipping\_lines**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand shipping\_lines<br><br><table> <tr> <td> <p> <strong>								carrier_identifier							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								delivery_category							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								discount_allocations							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand discount_allocations</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								discount_application_index							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								discounted_price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								requested_fulfillment_service_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_lines							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tax_lines</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **source\_identifier**<br><br><br>STRING |
| **source\_name**<br><br><br>STRING |
| **source\_url**<br><br><br>STRING |
| **subtotal\_price**<br><br><br>NUMBER |
| **tags**<br><br><br>STRING |
| **taxExempt**<br><br><br>BOOLEAN |
| **tax\_lines**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_lines<br><br><table> <tr> <td> <p> <strong>								channel_liable							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								compare_at							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								price							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								rate							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								source							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								title							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								zone							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **taxes\_included**<br><br><br>BOOLEAN |
| **test**<br><br><br>BOOLEAN |
| **token**<br><br><br>STRING |
| **total\_discounts**<br><br><br>NUMBER |
| **total\_line\_items\_price**<br><br><br>NUMBER |
| **total\_outstanding**<br><br><br>NUMBER |
| **total\_price**<br><br><br>NUMBER |
| **total\_tax**<br><br><br>NUMBER |
| **total\_tip\_received**<br><br><br>STRING |
| **total\_weight**<br><br><br>INTEGER |
| **updated\_at**<br><br><br>DATE-TIME |
| **user\_id**<br><br><br>INTEGER |

### 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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/api/admin-rest/2025-01/resources/product-variant#top "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/docs/api/admin-rest/2025-01/resources/product-variant#get-products-product-id-variants "Opens in new tab: Shopify API method") |

product\_variants table schema

| **id**<br><br><br>STRING |
| --- |
| **createdAt**<br><br><br>STRING |
| **barcode**<br><br><br>STRING |
| **availableForSale**<br><br><br>BOOLEAN |
| **compareAtPrice**<br><br><br>STRING |
| **displayName**<br><br><br>STRING |
| **image**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand image<br><br><table> <tr> <td> <p> <strong>								altText							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								height							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **inventoryPolicy**<br><br><br>STRING |
| **inventoryQuantity**<br><br><br>INTEGER |
| **position**<br><br><br>INTEGER |
| **price**<br><br><br>STRING |
| **requiresComponents**<br><br><br>BOOLEAN |
| **sellableOnlineQuantity**<br><br><br>INTEGER |
| **sku**<br><br><br>STRING |
| **taxCode**<br><br><br>STRING |
| **taxable**<br><br><br>BOOLEAN |
| **title**<br><br><br>STRING |
| **updatedAt**<br><br><br>STRING |
| **product**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand product<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |

### products

The `products` table contains info about a shop’s products.

#### Product metafield data

To replicate product metafield data, you must set this table and the [`metafields`](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#metafields) table to replicate.

| **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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updatedAt |
| **Useful links** | [Shopify documentation](https://shopify.dev/docs/admin-api/rest/reference/products "Opens in new tab: Shopify documentation")<br><br><br>[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")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/products/product?api[version]=2019-07 "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/v2#abandoned-checkouts) | ```<br>products.id = abandoned_checkouts.line_items.product_id<br>```<br><br>```<br>products.options.product_id = abandoned_checkouts.line_items.product_id<br>``` |
| [collects](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#collects) | ```<br>products.id = collects.product_id<br>```<br><br>```<br>products.options.product_id = collects.product_id<br>``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#order-refunds) | ```<br>products.id = order_refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>products.options.product_id = order_refunds.refund_line_items.line_item.product_id<br>``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#orders) | ```<br>products.id = orders.fulfillments.line_items.product_id<br>```<br><br>```<br>products.options.product_id = orders.fulfillments.line_items.product_id<br>```<br><br>```<br>products.id = orders.refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>products.options.product_id = orders.refunds.refund_line_items.line_item.product_id<br>```<br><br>```<br>products.id = orders.line_items.product_id<br>```<br><br>```<br>products.options.product_id = orders.line_items.product_id<br>``` |

products table schema

| **status**<br><br><br>STRING |
| --- |
| **publishedAt**<br><br><br>STRING |
| **createdAt**<br><br><br>STRING |
| **vendor**<br><br><br>STRING |
| **updatedAt**<br><br><br>STRING |
| **productType**<br><br><br>STRING |
| **tags**<br><br><br>STRING |
| **options**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand options<br><br><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								values							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								position							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **handle**<br><br><br>STRING |
| **templateSuffix**<br><br><br>STRING |
| **title**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **giftCardTemplateSuffix**<br><br><br>STRING |
| **hasOnlyDefaultVariant**<br><br><br>STRING |
| **hasOutOfStockVariants**<br><br><br>BOOLEAN |
| **hasVariantsThatRequiresComponents**<br><br><br>BOOLEAN |
| **isGiftCard**<br><br><br>BOOLEAN |
| **description**<br><br><br>STRING |
| **descriptionHtml**<br><br><br>STRING |
| **category**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand category<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **featuredMedia**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand featuredMedia<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								mediaContentType							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **requiresSellingPlan**<br><br><br>BOOLEAN |
| **totalInventory**<br><br><br>INTEGER |
| **tracksInventory**<br><br><br>BOOLEAN |
| **media**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand media<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								alt							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								mediaContentType							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								embedUrl							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								mimeType							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								filename							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								image							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand image</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								height							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								sources							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sources</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								format							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								mimeType							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fileSize							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								mediaWarnings							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand mediaWarnings</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								message							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								mediaErrors							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand mediaErrors</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								details							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								message							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |

### 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 ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created\_at |
| **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")<br><br><br>[Shopify API method](https://shopify.dev/docs/admin-api/rest/reference/orders/transaction?api[version]=2019-07 "Opens in new tab: Shopify API method") |

transactions table foreign keys

| Join transactions with | on |
| --- | --- |
| [abandoned_checkouts](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#abandoned-checkouts) | ```<br>transactions.order_id = abandoned_checkouts.customer.last_order_id<br>``` |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#customers) | ```<br>transactions.order_id = customers.last_order_id<br>``` |
| [order_refunds](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#order-refunds) | ```<br>transactions.order_id = order_refunds.order_id<br>``` |
| [orders](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v2#orders) | ```<br>transactions.order_id = orders.id<br>```<br><br>```<br>transactions.order_id = orders.refunds.order_adjustments.order_id<br>``` |

transactions table schema

| **error\_code**<br><br><br>STRING |
| --- |
| **device\_id**<br><br><br>INTEGER |
| **user\_id**<br><br><br>INTEGER |
| **parent\_id**<br><br><br>INTEGER |
| **test**<br><br><br>BOOLEAN |
| **kind**<br><br><br>STRING |
| **order\_id**<br><br><br>INTEGER |
| **amount**<br><br><br>STRING |
| **authorization**<br><br><br>STRING |
| **currency**<br><br><br>STRING |
| **source\_name**<br><br><br>STRING |
| **message**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **created\_at**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **payment\_details**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand payment\_details<br><br><table> <tr> <td> <p> <strong>								cvv_result_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_bin							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_company							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_expiration_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_expiration_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								credit_card_wallet							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								avs_result_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **gateway**<br><br><br>STRING |
| **admin\_graphql\_api\_id**<br><br><br>STRING |
| **receipt**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand receipt<br><br><table> <tr> <td> <p> <strong>								fee_amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								gross_amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_amount							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **location\_id**<br><br><br>INTEGER |
| **processed\_at**<br><br><br>STRING |
| **payments\_refund\_attributes**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand payments\_refund\_attributes<br><br><table> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								acquirer_reference_number							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **payment\_id**<br><br><br>STRING |
| **total\_unsettled\_set**<br><br><br>OBJECT<br><br>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand total\_unsettled\_set<br><br><table> <tr> <td> <p> <strong>								presentment_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand presentment_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								shop_money							</strong> </p> <p>							OBJECT																							</p><div><button><div>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. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shop_money</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |