# Shopify (v15-10-2015)
Information note **Shopify (v15-10-2015) end of life**
This version of Shopify reached end of life on **April 15, 2019** and is no longer functioning.
[Upgrade to the latest version (v3) to continue replicating data.](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v3)
## Shopify integration summary
Stitch’s Shopify integration replicates data using the [Shopify REST Admin API](https://help.shopify.com/en/api/reference). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#schema) section for a list of objects available for replication.
## Shopify feature snapshot
A high-level look at Stitch's Shopify (v15-10-2015) 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)** | Sunset on April 15, 2019 | **Supported by**
the Info icon
Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**
the Info icon
The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**
the Info icon
Indicates if the integration is available as a source in Stitch Connect. | the Remove icon
This version of the integration isn't available via the API.
Not available |
| **Singer GitHub repository** | Not applicable | | |
| **REPLICATION SETTINGS** | | | |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**
the Info icon
A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Remove icon
Anchor Scheduling is not supported for this integration. The only available replication scheduling method is the Replication Frequency setting.
Unsupported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**
the Info icon
A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Remove icon
Advanced Scheduling is not supported for this integration.
Unsupported |
| **Table-level reset**
the Info icon
Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon
Table-level resets are not supported for this integration. Resets are only supported at the integration level.
Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**
the Info icon
Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
Unsupported |
| **DATA SELECTION** | | | |
| **Table selection**
the Info icon
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 Remove icon
Table selection is not supported for this integration. All available table and fields will be automatically selected for replication.
Unsupported | **Column selection**
the Info icon
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Remove icon
Column selection is not supported for this integration. All available columns in tables set to replicate will be selected.
Unsupported |
| **Select all**
the Info icon
Indicates if the integration supports selecting all available tables and columns. | the Remove icon
As this integration doesn't support table or column selection, all available tables and columns are automatically replicated.
Unsupported | | |
| **TRANSPARENCY** | | | |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**
the Info icon
Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Remove icon
This feature is not supported for this version of the integration.
Unsupported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**
the Info icon
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported |
## 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 15-10-2015** of this integration.
collects Replication Method: Full Table Full Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job. Primary Key: id Contains Nested Structures?: No The collects table contains info about collects, which is the link between products and custom collections. Table Info & Attributes
### collects Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/collect) for a full list and description of each attribute.
* Collect ID (`id`)
* collection\_id
* created\_at
* featured
* position
* product\_id
* sort\_value
* updated\_at
#### custom\_collections
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** No
The `custom_collections` table contains info about your custom collections.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#custom_collections-data)
### custom\_collections Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/customcollection) for a full list and description of each attribute.
* Custom Collection ID (`id`)
* body\_html
* handle
* image
* published
* published\_at
* published\_scope
* sort\_order
* template\_suffix
* title
* updated\_at
#### customers
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** Yes
If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.
The `customers` table contains info about your shop's customers.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#customers-data)
### customers & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
### customers Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/customer) for a full list and description of each attribute.
* Customer ID (`id`)
* accepts\_marketing
* addresses`*`
* created\_at
* default\_address`*`
* email
* first\_name
* multipass\_identifier
* last\_name
* last\_order\_id
* last\_order\_name
* note
* orders\_count
* state
* tags
* tax\_exempt
* total\_spent
* updated\_at
* verified\_email
#### metafields
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** No
The `metafields` table contains metadata for shop and order resources.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#metafields-data)
### metafields Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/metafield) for a full list and description of each attribute.
* Metafield ID (`id`)
* created\_at
* description
* key
* namespace
* owner\_id
* owner\_resource
* value
* value\_type
* updated\_at
#### order\_refunds
**Replication Method:** Full Table
Full Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job.
**Primary Key:** `id`
**Contains Nested Structures?:** Yes
If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.
The `order_refunds` table contains info about refunds applied to transactions.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#order_refunds-data)
### order\_refunds & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
### order\_refunds Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/refund/) for a full list and description of each attribute.
* Order Refund ID (`id`)
* created\_at
* note
* restock
* refund\_line\_items`*`
* transactions`*`
* user\_id
#### orders
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** Yes
If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.
The `orders` table contains information about your shop's completed orders.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#orders-data)
### orders & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
### orders Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/order) for a full list and description of each attribute.
* Order ID (`id`)
* billing\_address`*`
* browser\_ip
* buyer\_accepts\_marketing
* cancel\_reason
* cancelled\_at
* cart\_token
* client\_details\_\_accept\_language
* client\_details\_\_browser\_height
* client\_details\_\_browser\_ip
* client\_details\_\_browser\_width
* client\_details\_\_session\_hash
* client\_details\_\_user\_agent
* closed\_at
* created\_at
* currency
* customer\_\_accepts\_marketing
* customer\_\_created\_at
* customer\_\_email
* customer\_\_first\_name
* customer\_\_id
* customer\_\_last\_name
* customer\_\_note
* customer\_\_orders\_count
* customer\_\_state
* customer\_\_total\_spent
* customer\_\_updated\_at
* customer\_\_tags
* discount\_codes`*`
* email
* financial\_status
* fulfillments`*`
* fulfillment\_status
* tags`*`
* gateway
* landing\_site
* line\_items`*`
* location\_id
* name
* note
* note\_attributes`*`
* number
* order\_number
* payment\_gateway\_names
* processed\_at
* processing\_method
* referring\_site
* refunds
* shipping\_address`*`
* shipping\_lines`*`
* source\_name
* subtotal\_price
* tax\_lines`*`
* taxes\_included
* token
* total\_discounts
* total\_line\_items\_price
* total\_price
* total\_tax
* total\_weight
* updated\_at
* user\_id
* order\_status\_url
#### products
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** Yes
If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.
The `products` table contains info about the products for sale in your shop.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#products-data)
### products & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
### products Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/product) for a full list and description of each attribute.
* Product ID (`id`)
* body\_html
* created\_at
* handle
* images`*`
* options`*`
* product\_type
* published\_at
* published\_scope
* tags`*`
* template\_suffix
* title
* metafields\_global\_title\_tag
* metafields\_global\_description\_tag
* updated\_at
* variants`*`
* vendor
#### transactions
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** No
The `transactions` table contains info about transactions, which are created for every order that results in money exchange. This includes authorizations, sales, captures, voids, and refunds.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#transactions-data)
### transactions Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/transaction) for a full list and description of each attribute.
* Transaction ID (`id`)
* amount
* authorization
* created\_at
* device\_id
* gateway
* source\_name
* payment\_details
* kind
* order\_id
* receipt
* error\_code
* status
* test
* user\_id
* currency
#### checkouts
**Replication Method:** Key-based Incremental
Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.
**Primary Key:** `id`
**Contains Nested Structures?:** Yes
If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.
The `checkouts` table contains info about abandoned checkouts. Abandoned checkouts are defined as checkouts where the customer has entered their billing and shipping information, but not completed the ordering process.
[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/shopify/v15-10-2015#checkouts-data)
### checkouts & Nested Structures
**This table contains nested structures.** If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a `*`
### checkouts Attributes
While we try to include everything Shopify has here, **this may not be a full list of attributes.** Refer to [Shopify's documentation](https://help.shopify.com/api/reference/abandoned_checkouts) for a full list and description of each attribute.
* Checkout ID (`id`)
* abandoned\_checkout\_url
* billing\_address\_\_address1
* billing\_address\_\_address2
* billing\_address\_\_city
* billing\_address\_\_company
* billing\_address\_\_country
* billing\_address\_\_firstname
* billing\_address\_\_id
* billing\_address\_\_lastname
* billing\_address\_\_phone
* billing\_address\_\_province
* billing\_address\_\_zip
* billing\_address\_\_name
* billing\_address\_\_province\_code
* billing\_address\_\_country\_code
* billing\_address\_\_default
* buyer\_accepts\_marketing
* cancel\_reason
* cart\_token
* closed\_at
* completed\_at
* created\_at
* currency
* customer\_\_accepts\_marketing
* customer\_\_created\_at
* customer\_\_email
* customer\_\_first\_name
* customer\_\_id
* customer\_\_last\_name
* customer\_\_note
* customer\_\_orders\_count
* customer\_\_state
* customer\_\_total\_spent
* customer\_\_updated\_at
* customer\_\_tags
* discount\_codes`*`
* email
* gateway
* landing\_site
* line\_items\_\_fulfillment\_service
* line\_items\_\_grams
* line\_items\_\_price
* line\_items\_\_product\_id
* line\_items\_\_quantity
* line\_items\_\_requires\_shipping
* line\_items\_\_sku
* line\_items\_\_title
* line\_items\_\_variant\_id
* line\_items\_\_variant\_title
* line\_items\_\_vendor
* note
* referring\_site
* shipping\_address\_\_address1
* shipping\_address\_\_address2
* shipping\_address\_\_city
* shipping\_address\_\_company
* shipping\_address\_\_country
* shipping\_address\_\_firstname
* shipping\_address\_\_latitude
* shipping\_address\_\_longitude
* shipping\_address\_\_lastname
* shipping\_address\_\_phone
* shipping\_address\_\_province
* shipping\_address\_\_zip
* shipping\_address\_\_name
* shipping\_address\_\_province\_code
* shipping\_address\_\_country\_code
* shipping\_lines`*`
* source\_name
* subtotal\_price
* tax\_lines`*`
* taxes\_included
* token
* total\_discounts
* total\_line\_items\_price
* total\_price
* total\_tax
* total\_weight
* updated\_at