This integration is powered by Singer's Shopify tap and certified by Stitch. Check out and contribute to the repo on GitHub.
For support, contact Stitch support.
Shopify integration summary
Stitch’s Shopify integration replicates data using the Shopify REST Admin API. Refer to the Schema section for a list of objects available for replication.
Shopify feature snapshot
A high-level look at Stitch's Shopify (v1.0) integration, including release status, useful links, and the features supported in Stitch.
STITCH | |||
Release Status |
Released |
Supported By | |
Stitch Plan |
Free |
Singer GitHub Repository | |
DATA SELECTION | |||
Table Selection |
Supported |
Column Selection |
Supported |
REPLICATION SETTINGS | |||
Anchor Scheduling |
Supported |
Advanced Scheduling |
Unsupported |
Table-level Reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
TRANSPARENCY | |||
Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting Shopify
Step 1: Add Shopify as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Shopify icon.
-
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. - 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 enterstitch-data
into this field.
Step 2: Define the historical sync
The Sync Historical Data setting will define 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 guide.
Step 3: Create a replication schedule
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Shopify integrations support the following replication scheduling methods:
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 4: Authorize Stitch to access Shopify
- Next, you’ll be prompted to sign into your Shopify account. Enter your Shopify credentials.
- Click Log in.
- After the authorization process is successfully completed, you’ll be directed back to Stitch.
- Click All Done.
Step 5: Set tables and columns to replicate
To complete the setup, you’ll need to select the tables and columns you want to replicate to your data warehouse.
Check out the Schema section to learn more about the available tables in Shopify and how they replicate.
- In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A green checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.
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.
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 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.
Shopify table schemas
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 1.0 of this integration.
This is the latest version of the Shopify integraiton.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
abandoned_checkouts
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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.
id
The abandoned checkout ID. |
||||||||||||||||||||||||||||||||||||||||||||
updated_at
The date and time in ISO 8601 format when the checkout was last updated. |
||||||||||||||||||||||||||||||||||||||||||||
abandoned_checkout_url
The recovery URL that is sent to a customer so they can recover their checkout. |
||||||||||||||||||||||||||||||||||||||||||||
billing_address
The customer’s billing address details. |
||||||||||||||||||||||||||||||||||||||||||||
buyer_accepts_marketing
Indicates whether the customer wants to receive email updates from the shop. |
||||||||||||||||||||||||||||||||||||||||||||
cart_token
The ID of the cart that is attached to the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
closed_at
The date and time in ISO 8601 format when the checkout was closed.
If the checkout wasn’t closed, this value will be |
||||||||||||||||||||||||||||||||||||||||||||
completed_at
The date and time in ISO 8601 format when the checkout was completed.
For abandoned checkouts, this value will always be |
||||||||||||||||||||||||||||||||||||||||||||
created_at
The date and time in ISO 8601 format when the checkout was created. |
||||||||||||||||||||||||||||||||||||||||||||
currency
The three-letter ISO 4217 code of the shop’s default currency at the time of checkout. For the currency the customer used at checkout, see |
||||||||||||||||||||||||||||||||||||||||||||
customer
Details about the customer associated with the abandoned checkout. |
||||||||||||||||||||||||||||||||||||||||||||
customer_id
The ID of the customer associated with the abandoned checkout. |
||||||||||||||||||||||||||||||||||||||||||||
customer_locale
The two or three-letter language code, optionally followed by a region modifier. |
||||||||||||||||||||||||||||||||||||||||||||
device_id
The ID of the Shopify POS device that created the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
discount_codes
The discount codees applied to the checkout.
|
||||||||||||||||||||||||||||||||||||||||||||
email
The customer’s email address. |
||||||||||||||||||||||||||||||||||||||||||||
gateway
The payment gateway used by the checkout. For abandoned checkouts, this value will always be |
||||||||||||||||||||||||||||||||||||||||||||
landing_site
The URL for the page where the customer entered the shop. |
||||||||||||||||||||||||||||||||||||||||||||
line_items
A list of line items in the checkout.
|
||||||||||||||||||||||||||||||||||||||||||||
location_id
The ID of the physical location where the checkout was processed. |
||||||||||||||||||||||||||||||||||||||||||||
name
The order name as represented by a number. |
||||||||||||||||||||||||||||||||||||||||||||
note
An optional note attached to the order. |
||||||||||||||||||||||||||||||||||||||||||||
phone
The customer’s phone number. |
||||||||||||||||||||||||||||||||||||||||||||
presentment_currency
The three-letter ISO 4217 code of the currency that the customer used at checkout. |
||||||||||||||||||||||||||||||||||||||||||||
referring_site
The website that referred the cusomter to the shop. |
||||||||||||||||||||||||||||||||||||||||||||
shipping_address
Details about the shipping address associated with the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
shipping_lines
Details about the shipping methods associated with the order.
|
||||||||||||||||||||||||||||||||||||||||||||
source
The channel where the checkout originated. |
||||||||||||||||||||||||||||||||||||||||||||
source_identifier
|
||||||||||||||||||||||||||||||||||||||||||||
source_name
Where the checkout originated. Possible values are:
|
||||||||||||||||||||||||||||||||||||||||||||
source_url
|
||||||||||||||||||||||||||||||||||||||||||||
subtotal_price
The price of the checkout before shipping and taxes. |
||||||||||||||||||||||||||||||||||||||||||||
tax_lines
Details about the taxes applicable to the checkout.
|
||||||||||||||||||||||||||||||||||||||||||||
taxes_included
Indicates if taxes are included in the price. |
||||||||||||||||||||||||||||||||||||||||||||
token
A unique ID for the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
total_discounts
The total amount of discounts to be applied. |
||||||||||||||||||||||||||||||||||||||||||||
total_line_items_price
The sum of the prices of all line items in the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
total_price
The sum of the prices of all line items in the checkout, discounts, shipping costs, and taxes |
||||||||||||||||||||||||||||||||||||||||||||
total_tax
The sum of all the taxes applied to the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
total_weight
The sum of all the weights in grams of the line items in the checkout. |
||||||||||||||||||||||||||||||||||||||||||||
user_id
The ID of the user who created the checkout. |
collects
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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.
id
The collect ID. |
updated_at
The date and time in ISO 8601 format when the collect was last updated. |
collection_id
The ID of the custom collection containing the product. Reference: |
created_at
The date and time in ISO 8601 format when the collect was created. |
featured
Indicates whether the collect is featured. |
position
The position of the product in a manually sorted custom collection. |
product_id
The ID of the product in the custom collection. Reference: |
sort_value
The same value as |
custom_collections
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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.
id
The custom collection ID. Reference: |
updated_at
The date and time in ISO 8601 format when the custom collection was last updated. |
body_html
The description of the custom collection in HTML format. |
handle
A human-readable string for the custom collection, automatically generated from its title. |
image
Details about images associated with the custom collection. |
published_at
The date and time in ISO 8601 format when the custom collection was published.
This will be |
published_scope
Indicates if the collection is published to the Point of Sale channel. Possible values are:
|
sort_order
The order in which products in the custom collection appear. Possible values are:
|
template_suffix
The suffix of the Liquid template being used. For example: If the value is |
title
The name of the custom collection. |
customers
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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
table to replicate.
id
The customer ID. Reference: |
|||||||||||||||||
updated_at
The date and time in ISO 8601 format when the customer was last updated. |
|||||||||||||||||
accepts_marketing
Indicates if the customer has consented to receive marketing emails. |
|||||||||||||||||
addresses
A list of the 10 most recently updated addresses for the customer.
|
|||||||||||||||||
created_at
The date and time in ISO 8601 format when the customer was created. |
|||||||||||||||||
default_address
Details about the default address for the customer. |
|||||||||||||||||
email
The customer’s email address. |
|||||||||||||||||
first_name
The customer’s first name. |
|||||||||||||||||
last_name
The customer’s last name. |
|||||||||||||||||
last_order_id
The ID of the customer’s last order. Reference: |
|||||||||||||||||
last_order_name
The name of the customer’s last order. |
|||||||||||||||||
multipass_identifier
The ID of the cu stomer’s Multipass login. |
|||||||||||||||||
note
A note about the customer. |
|||||||||||||||||
orders_count
The number of orders associated with the customer. |
|||||||||||||||||
phone
The phone number for the customer, in E.164 format. |
|||||||||||||||||
state
The state of the customer’s account with a shop. Possible values are:
|
|||||||||||||||||
tags
Tags that the shop owner has attached to the customer. |
|||||||||||||||||
tax_exempt
Indicates if the customer is exempt from paying taxes on their order. If |
|||||||||||||||||
total_spent
The total amount of money that the customer has spent across their order history. |
|||||||||||||||||
verified_email
Indicates if the customer has verified their email address. |
metafields
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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
, products
, and orders
.
id
The metafield ID. |
updated_at
The date and time in ISO 8601 format when the metafield was last updated. |
created_at
The date and time in ISO 8601 format when the customer was created. |
description
A description of the info that the metafield contains. |
key
The name of the metafield. |
namespace
A container for a set of metafields. |
owner_id
The ID of the resource that the metafield is attached to. |
owner_resource
The type of resource that the metafield is attached to. Possible values are:
|
value
The information to be stored as metadata. |
value_type
The metafield’s information type. Possible values are:
|
order_refunds
Replication Method : |
Key-based Incremental |
Replication Key : |
created_at |
Primary Key : |
id |
API endpoint : |
The order_refunds
table contains info about refunds associated with orders.
id
The refund ID. Reference: |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
created_at
The date and time in ISO 8601 format when the refund was created. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
note
An optional note attached to a refund. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
order_id
The ID of the order the refund is associated with. Reference: |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
processed_at
The date and time in ISO 8601 format when the refund was processed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
refund_line_items
Details about the line items associated with the refund.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
restock
Indicates whether line items will be added back to the store’s inventory. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id
The ID of the user who performed the refund. |
orders
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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
table to replicate.
id
The order ID. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
updated_at
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
app_id
The ID of the app that created the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
billing_address
Details about the mailing address associated with the payment method. This address is an optional field that won’t be available on orders that don’t require a payment method.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
browser_ip
The IP address of the browser used by the customer when they placed the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
buyer_accepts_marketing
Indicates whether the customer consented to receive email updates from the shop. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cancel_reason
The reason why the order was canceled. Possible values are:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cancelled_at
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cart_token
The ID for the cart associated with the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
checkout_id
The checkout ID associated with the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
checkout_token
The checkout token associated with the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
client_details
Details about the browser the customer used when the order was placed.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
closed_at
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
confirmed
Indicates if the order has been confirmed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
contact_email
The contact email associated with the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
created_at
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
currency
The three-letter ISO 4217 code for the currency used for the payment. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
customer
Details about the customer associated with the abandoned checkout. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
customer_locale
The two or three-letter language code, optionally followed by a region modifier. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
device_id
The ID of the Shopify POS device that created the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
discount_applications
Details about the discount applications associated with the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
discount_codes
The discount codees applied to the checkout.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
email
The customer’s email address. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
financial_status
The order’s financial status. Possible falues are:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fulfillment_status
The order’s fulfillment status. Possible values are:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fulfillments
Details about the fulfillments associated with the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
gateway
The payment gateway used by the checkout. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
landing_site
The URL for the page where the customer entered the shop. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
line_items
Details about the line items in the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
location_id
The ID of the physical location where the order was processed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
name
The order name as represented by a number. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
note
An optional note the shop owner attached to the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
note_attributes
Additional info added to the order, as it appears in the Additional details section of an order page.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
number
An identifier unique to the shop. Numbers are sequential and start at |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
order_adjustments
A list of order adjustments attached to the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
order_number
A unique identifier for the order, used by the shop owner and customer. This is different from the |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
order_status_url
The URL of the order’s status page. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payment_details
Details about the payment used for the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payment_gateway_names
The list of payment gateways used for the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phone
The customer’s phone number. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
processed_at
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
processing_method
Indicates how the payment was processed. Possible values are:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
reference
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
referring_site
The website where the customer clicked a link to the shop. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
refunds
A list of refunds applied to the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
shipping_address
Details about the shipping address associated with the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
shipping_lines
Details about the shipping methods associated with the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
source_identifier
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
source_name
Where the order originated. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
source_url
The URL where the order originated. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
subtotal_price
The price of the order after discounts but before shipping, taxes, and tips. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tags
Tags attached to the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tax_lines
Details about the order’s tax lines, each of which is a tax applicable to the order.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
taxes_included
Indicates if taxes are included in the order subtotal. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
test
Indicates if the order is a test order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
token
A unique identifier for the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_discounts
The total discounts applied to the price of the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_line_items_price
The sum of all line item prices. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_price
The sum of all line item prices, discounts, shipping, taxes, and tips. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_price_usd
The sum of all line item prices, discounts, shipping, taxes, and tips in USD. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_tax
The sum of all the taxes applied to the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_tip_received
The sum of all the tips in the order. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
total_weight
The sum of all line item weights, in grams. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id
The ID of th euser logged into the Shopify POS that processed the order, if applicable. |
products
Replication Method : |
Key-based Incremental |
Replication Key : |
updated_at |
Primary Key : |
id |
API endpoint : |
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
table to replicate.
id
The product ID. Reference: |
|||||||||||||||||||||||||
updated_at
The date and time in ISO 8601 format when the product was last updated. |
|||||||||||||||||||||||||
body_html
A description of the product. |
|||||||||||||||||||||||||
created_at
The date and time in ISO 8601 format when the product was created. |
|||||||||||||||||||||||||
handle
The human-friendly string for the product, automatically generated from the product’s |
|||||||||||||||||||||||||
images
The product images associated with the product.
|
|||||||||||||||||||||||||
options
The custom properties associated with the product, like
|
|||||||||||||||||||||||||
product_type
The categorization for the product, used for filtering and searching. |
|||||||||||||||||||||||||
published_at
The date and time in ISO 8601 format when the product was published. |
|||||||||||||||||||||||||
published_scope
Indicates whether the product is published to the Point of Sale channel. Possible values are:
|
|||||||||||||||||||||||||
tags
The tags associated with the product. |
|||||||||||||||||||||||||
template_suffix
The suffix of the Liquid template applied to the product. The default template is |
|||||||||||||||||||||||||
title
The product title. |
|||||||||||||||||||||||||
variants
The product variants associated with the product, each representing a different version of the product.
|
|||||||||||||||||||||||||
vendor
The name of the product’s vendor. |
transactions
Replication Method : |
Key-based Incremental |
Replication Key : |
created_at |
Primary Key : |
id |
API endpoint : |
The transactions
table contains info about transactions.
id
The transaction ID. Reference: |
|
created_at
The date and time in ISO 8601 format when the transaction was created. |
|
amount
The amount of money that the transaction was for. |
|
authorization
The authorization code associated with the transaction. |
|
currency
The three-letter ISO 4217 code for the currency used for payment. For example: |
|
device_id
The ID for the device. |
|
error_code
A standardized error code, independent of the payment provider. Possible values are:
|
|
gateway
The name of the gateway the transaction was issued through. For a list of possible values, refer to Shopify’s payment gateways documentation. |
|
kind
The transaction type. Possible values are:
|
|
location_id
The ID of the location that processed the transaction. |
|
message
A message generated by the payment provider with additional info about why the transaction succeeded or failed. |
|
order_id
The ID of the order the transaction is associated with. Reference: |
|
parent_id
The ID of an associated transaction.
Reference: |
|
payment_details
Details about the credit card used for the transaction. |
|
receipt
A transaction receipt attached to the transaction by the gateway.
|
|
source_name
The origin of the transaction, set by Shopify. Possible values are:
|
|
status
The status of the transaction. Possible values are:
|
|
test
Indicates if the transaction was a test transaction. |
|
user_id
The ID of the user who was logged into the Shopify POS device when the order was processed, if applicable. |
Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.