LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Table mapping between V1 and V2
  • Snapshot
  • Tables/APIs Supported
  • Integrate Shopify with Daton
  • Workflow
  • Table level scope
  • Shopify Data
  • orders
  • transactions
  • refunds
  • fulfillment_orders
  • fulfillment_events
  • tender_transactions
  • customers
  • customer_address
  • events
  • products
  • payouts
  • balance_transactions
  • collects
  • custom_collections
  • smart_collections
  • abandoned_checkouts
  • policies
  • countries
  • shop
  • locations
  • inventory_levels
  • inventory_items
  • gift_cards
  • carrier_services
  • price_rules
  • disputes
  • order_customerjourneysummary
  • product_sessiondata
  • users

Was this helpful?

  1. Connectors
  2. Data Sources
  3. Ecommerce Platforms

Shopify V2

Shopify ETL connector for data replication

PreviousRelease NotesNextWalmart

Last updated 2 years ago

Was this helpful?

While we get the Shopify OAuth App ready to use on Daton, we request you create a Private Custom App and Generate a New Access Token from your Shopify Store.

If you are facing any issues with the Shopify OAuth flow, please to Generate a New Shopify Access Token.

Table mapping between V1 and V2

  • One of the major difference in V2 is that all tables that were dependent on parent will now be a separate table instead of a record column in parent table. For eg. fulfillment_orders is a dependent table on parents and it was available as a record in V1 but in V2 it will be a separate table.

  • Some additional tables such as fulfillment_events, gift_cards, disputes have been added in V2 connector.

    Note - gift_cards table is available only for Shopify Plus users and you need to reach out to your merchant success manager to get the scopes

V1
V2

orders

orders transactions refunds fulfillment_orders fulfillment_events

checkouts

abandoned_checkouts

customers

customers custome_address

products

products product_metafields

tender_transactions

tender_transactions

policies

policies

countries

countries

smart_collections

smart_collections

custom_collections

custom_collections

collects

collects

locations

locations

events

events

price_rules

price_rules

shop

shop

carrier_services

carrier_services

inventory

inventory_levels inventory_items

payouts

payouts

transactions

balance_transactions

-

disputes

-

gift_cards

-

users

Snapshot

Features

Details

Release Status

Released

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Shopify Shopname Shopify Access Token

Replication Type

Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

1hr

Tables/APIs Supported

orders

transactions

refunds

fulfillment_orders

fulfillment_events

tender_transactions

customers

customer_address

events

products

payouts

balance_transactions

smart_collections

custom_collections

collects

abandoned_checkouts

policies

countries

shops

locations

inventory_levels

inventory_items

gift_cards

carrier_services

price_rules

disputes

order_customerjourneysummary

product_sessiondata

users

Integrate Shopify with Daton

  1. Search for Shopify in the list of Connectors and click on the 'Configure' button.

  2. Provide the necessary Integration Name, Replication Frequency, and Replication Start Date data and click on the 'Authenticate' button. Please Note, the Integration Name would be used in creating tables for the integration and cannot be changed later.

  3. Post successful authentication, you will be prompted to choose from the list of available tables. Add the required Tables and click on 'Next.'

  4. Select all the fields you require for each table and Submit the integration.

  5. Once submitted, you will be prompted to select the destination for your Shop. Select your favorite destination and click on 'Confirm.'

    You will now receive a popup saying 'Integration Successful.'

    Congrats! Your Shop has been integrated with Daton.

Workflow

  1. Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully onto the configured warehouse.

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Table level scope

TableName
Scope Required

orders

read_orders

transactions

read_orders, read_shopify_payments_payouts

refunds

read_orders

fulfillment_orders

read_merchant_managed_fulfillment_orders/read_assigned_fulfillment_orders

fulfillment_events

read_orders

tender_transactions

read_orders

draft_orders

read_draft_orders

customers

read_customers

customer_address

read_customers

events

-

products

read_products

payouts

read_shopify_payments_payouts

balance_transactions

read_shopify_payments_payouts

collects

read_products

custom_collections

read_products

smart_collections

read_products

abandoned_checkouts

read_orders

policies

-

countries

-

shop

-

locations

read_locations

inventory_levels

read_inventory

inventory_items

read_inventory

gift_cards

read_gift_cards (Reach out to Shopify Merchant Success Manager)

users

read_users (Reach out to Shopify Merchant Success Manager)

carrier_services

read_shipping

price_rules

read_price_rules

disputes

read_shopify_payments_payouts

order_customerjourneysummary

read_orders, read_marketplace_orders, read_all_orders(if you need data for orders placed before 2 months)

product_sessiondata

Shopify Data

orders

Purpose: An order is a customer's completed request to purchase one or more products from a shop. An order is created when a customer completes the checkout process, during which time they provide an email address or phone number, billing address and payment information. This Retrieves a list of orders.

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

admin_graphql_api_id

STRING

browser_ip

STRING

buyer_accepts_marketing

BOOLEAN

cart_token

STRING

checkout_id

NUMERIC

checkout_token

STRING

client_details

RECORD

confirmed

BOOLEAN

contact_email

STRING

created_at

TIMESTAMP

currency

STRING

current_subtotal_price

STRING

current_subtotal_price_set

RECORD

current_total_discounts

STRING

current_total_discounts_set

RECORD

current_total_price

STRING

current_total_price_set

RECORD

current_total_tax

STRING

current_total_tax_set

RECORD

discount_codes

RECORD

email

STRING

financial_status

STRING

gateway

STRING

landing_site

STRING

landing_site_ref

STRING

name

STRING

note_attributes

RECORD

number

NUMERIC

order_number

NUMERIC

order_status_url

STRING

payment_gateway_names

STRING

phone

STRING

presentment_currency

STRING

processed_at

TIMESTAMP

processing_method

STRING

reference

STRING

referring_site

STRING

source_identifier

STRING

source_name

STRING

subtotal_price

STRING

subtotal_price_set

RECORD

tags

STRING

tax_lines

RECORD

taxes_included

BOOLEAN

test

BOOLEAN

token

STRING

total_discounts

STRING

total_discounts_set

RECORD

total_line_items_price

STRING

total_line_items_price_set

RECORD

total_outstanding

STRING

total_price

STRING

total_price_set

RECORD

total_price_usd

STRING

total_shipping_price_set

RECORD

total_tax

STRING

total_tax_set

RECORD

total_tip_received

STRING

total_weight

NUMERIC

updated_at

TIMESTAMP

billing_address

RECORD

customer

RECORD

discount_applications

RECORD

fulfillments

RECORD

line_items

RECORD

payment_details

RECORD

refunds

RECORD

shipping_address

RECORD

shipping_lines

RECORD

transactions

Purpose: Transactions are created for every order that results in an exchange of money. This table retrieves a list of transactions.

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

order_id

NUMERIC

kind

STRING

gateway

STRING

status

STRING

created_at

TIMESTAMP

test

BOOLEAN

authorization

STRING

parent_id

NUMERIC

processed_at

TIMESTAMP

source_name

STRING

amount

STRING

currency

STRING

payment_id

STRING

total_unsettled_set

RECORD

admin_graphql_api_id

STRING

refunds

Purpose: The Refund resource has two major components:

  • Transaction records of money returned to the customer

  • The line items included in the refund, along with restocking instructions

This table retrieves a list of refunds for an order

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

order_id

NUMERIC

created_at

TIMESTAMP

note

STRING

user_id

NUMERIC

processed_at

TIMESTAMP

restock

BOOLEAN

admin_graphql_api_id

STRING

refund_line_items

RECORD

transactions

RECORD

fulfillment_orders

Purpose: The FulfillmentOrder resource represents either an item or a group of items in an order that are to be fulfilled from the same location. There can be more than one fulfillment order for an order at a given location.This table retrieves a list of fulfillment orders for a specific order.

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

order_id

NUMERIC

status

STRING

created_at

TIMESTAMP

service

STRING

updated_at

TIMESTAMP

tracking_company

STRING

location_id

NUMERIC

line_items

RECORD

tracking_number

STRING

tracking_numbers

STRING

tracking_url

STRING

tracking_urls

STRING

receipt

RECORD

name

STRING

admin_graphql_api_id

STRING

fulfillment_events

Purpose: This table retrieves a list of fulfillment events for a specific fulfillment

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

fulfillment_id

NUMERIC

status

STRING

message

STRING

happened_at

TIMESTAMP

city

STRING

province

STRING

country

STRING

zip

STRING

address1

STRING

latitude

STRING

longitude

STRING

shop_id

NUMERIC

created_at

TIMESTAMP

updated_at

TIMESTAMP

estimated_delivery_at

TIMESTAMP

order_id

NUMERIC

admin_graphql_api_id

STRING

tender_transactions

Purpose: Each tender transaction represents money passing between the merchant and a customer. A tender transaction with a positive amount represents a transaction where the customer paid money to the merchant. A negative amount represents a transaction where the merchant refunded money back to the customer. Tender transactions represent transactions that modify the shop's balance.

Replication: Key Based Incremental

Replication Key: processed_at_min, processed_at_max

Fields

Name
Data Type

id

NUMERIC

order_id

NUMERIC

amount

STRING

currency

STRING

test

BOOLEAN

processed_at

TIMESTAMP

remote_reference

STRING

payment_method

STRING

customers

Purpose: The Customer resource stores information about a shop's customers, such as their contact details, their order history, and whether they've agreed to receive email marketing. This table retrieves a list of customers

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

email

STRING

accepts_marketing

BOOLEAN

created_at

TIMESTAMP

updated_at

TIMESTAMP

first_name

STRING

last_name

STRING

orders_count

NUMERIC

state

STRING

total_spent

STRING

verified_email

BOOLEAN

tax_exempt

BOOLEAN

tags

STRING

currency

STRING

phone

STRING

addresses

RECORD

accepts_marketing_updated_at

TIMESTAMP

admin_graphql_api_id

STRING

default_address

RECORD

customer_address

Purpose: This table retrieves the list of address stored for all the customers

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

customer_id

NUMERIC

address1

STRING

address2

STRING

city

STRING

province

STRING

country

STRING

zip

STRING

phone

STRING

name

STRING

province_code

STRING

country_code

STRING

country_name

STRING

default

BOOLEAN

events

Purpose: Events are generated by some Shopify resources when certain actions are completed, such as the creation of an article, the fulfillment of an order, or the addition of a product. This table retrieves the list of events

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

products

Purpose: This table retrieves the list of products in the given shopify store

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

subject_id

NUMERIC

created_at

TIMESTAMP

subject_type

STRING

verb

STRING

arguments

STRING

message

STRING

author

STRING

description

STRING

path

STRING

payouts

Purpose: Payouts represent the movement of money between a Shopify Payments account balance and a connected bank account. This table retrieves the list of all payouts

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

status

STRING

date

DATE

currency

STRING

amount

STRING

summary

RECORD

balance_transactions

Purpose: Balance Transactions make up the canonical "statement of account", or ledger for a Shopify Payments account. Every single movement of money in or out of the account is recorded here.

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

type

STRING

test

BOOLEAN

payout_id

NUMERIC

payout_status

STRING

currency

STRING

amount

STRING

fee

STRING

net

STRING

source_id

NUMERIC

source_type

STRING

processed_at

TIMESTAMP

collects

Purpose: This table retrieves a list of collects associated with the shopify store

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

collection_id

NUMERIC

product_id

NUMERIC

created_at

TIMESTAMP

updated_at

TIMESTAMP

position

NUMERIC

sort_value

STRING

custom_collections

Purpose: This table retrieves a list of custom collections.

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

handle

STRING

title

STRING

updated_at

TIMESTAMP

body_html

STRING

published_at

TIMESTAMP

sort_order

STRING

published_scope

STRING

admin_graphql_api_id

STRING

image

RECORD

smart_collections

Purpose: This table retrieves a list of smart collections.

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

handle

STRING

title

STRING

updated_at

TIMESTAMP

published_at

TIMESTAMP

sort_order

STRING

disjunctive

BOOLEAN

rules

RECORD

published_scope

STRING

admin_graphql_api_id

STRING

abandoned_checkouts

Purpose: This table retrieves a count of checkouts from the past 90 days

Replication: Key Based Incremental

Replication Key: updated_at_min, updated_at_max

Fields

Name
Data Type

id

NUMERIC

token

STRING

cart_token

STRING

email

STRING

buyer_accepts_marketing

BOOLEAN

created_at

TIMESTAMP

updated_at

TIMESTAMP

landing_site

STRING

note

STRING

note_attributes

RECORD

referring_site

STRING

shipping_lines

RECORD

taxes_included

BOOLEAN

total_weight

NUMERIC

currency

STRING

completed_at

TIMESTAMP

line_items

RECORD

name

STRING

abandoned_checkout_url

STRING

source_name

STRING

presentment_currency

STRING

buyer_accepts_sms_marketing

BOOLEAN

total_discounts

STRING

total_line_items_price

STRING

total_price

STRING

total_tax

STRING

subtotal_price

STRING

billing_address

RECORD

shipping_address

RECORD

customer

RECORD

policies

Purpose: You can use the Policy resource to access the policies that a merchant has configured for their shop, such as their refund and privacy policies.

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

body

STRING

created_at

TIMESTAMP

updated_at

TIMESTAMP

handle

STRING

title

STRING

url

STRING

countries

Purpose: The Country resource represents the tax rates applied to orders from the different countries where a shop sells its products.

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

name

STRING

code

STRING

tax_name

STRING

tax

NUMERIC

provinces

RECORD

shop

Purpose: The Shop resource is a collection of general business and store management settings and information about the store. The resource lets you retrieve information about the store, but it doesn't let you update any information.

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

address1

STRING

zip

STRING

city

STRING

phone

STRING

latitude

NUMERIC

longitude

NUMERIC

primary_locale

STRING

address2

STRING

created_at

TIMESTAMP

updated_at

TIMESTAMP

country_code

STRING

country_name

STRING

currency

STRING

customer_email

STRING

timezone

STRING

iana_timezone

STRING

shop_owner

STRING

money_format

STRING

money_with_currency_format

STRING

weight_unit

STRING

province_code

STRING

county_taxes

BOOLEAN

plan_display_name

STRING

plan_name

STRING

has_discounts

BOOLEAN

has_gift_cards

BOOLEAN

myshopify_domain

STRING

money_in_emails_format

STRING

money_with_currency_in_emails_format

STRING

eligible_for_payments

BOOLEAN

requires_extra_payments_agreement

BOOLEAN

password_enabled

BOOLEAN

has_storefront

BOOLEAN

finances

BOOLEAN

primary_location_id

NUMERIC

cookie_consent_level

STRING

visitor_tracking_consent_preference

STRING

checkout_api_supported

BOOLEAN

multi_location_enabled

BOOLEAN

setup_required

BOOLEAN

pre_launch_enabled

BOOLEAN

enabled_presentment_currencies

STRING

transactional_sms_disabled

BOOLEAN

marketing_sms_consent_enabled_at_checkout

BOOLEAN

locations

Purpose: A location represents a geographical location where your stores, pop-up stores, headquarters, and warehouses exist. This table retrieves a list of locations

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

name

STRING

address1

STRING

city

STRING

zip

STRING

province

STRING

country

STRING

created_at

TIMESTAMP

updated_at

TIMESTAMP

country_code

STRING

country_name

STRING

province_code

STRING

legacy

BOOLEAN

active

BOOLEAN

admin_graphql_api_id

STRING

localized_country_name

STRING

localized_province_name

STRING

inventory_levels

Purpose: An inventory level represents the quantities of an inventory item for a location. Each inventory level belongs to one inventory item and has one location. This table fetches all the inventory_levels in all locations

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

inventory_item_id

NUMERIC

location_id

NUMERIC

available

NUMERIC

updated_at

TIMESTAMP

admin_graphql_api_id

STRING

inventory_items

Purpose: An inventory item represents a physical good. It holds essential information about the physical good, including its SKU and whether its inventory is tracked. There is a 1:1 relationship between a product variant and an inventory item. This table fetches all the inventory_items

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

sku

STRING

created_at

TIMESTAMP

updated_at

TIMESTAMP

requires_shipping

BOOLEAN

cost

STRING

tracked

BOOLEAN

admin_graphql_api_id

STRING

gift_cards

Purpose: In order to use this API, you need to reach out to the Merchant Success Manager and ask them to enable the gift cards API. This table fetches all the gift cards associated with the store

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

balance

STRING

created_at

TIMESTAMP

updated_at

TIMESTAMP

currency

STRING

initial_value

STRING

disabled_at

TIMESTAMP

line_item_id

NUMERIC

api_client_id

NUMERIC

user_id

NUMERIC

customer_id

NUMERIC

note

STRING

template_suffix

STRING

expires_on

DATE

last_characters

STRING

order_id

NUMERIC

carrier_services

Purpose: A carrier service (also known as a carrier calculated service or shipping service) provides real-time shipping rates to Shopify. Some common carrier services include Canada Post, FedEx, UPS, and USPS.

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

name

STRING

active

BOOLEAN

service_discovery

BOOLEAN

carrier_service_type

STRING

admin_graphql_api_id

STRING

price_rules

Purpose: This table lists all the price_rules associated with the entered shopify store

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

value_type

STRING

value

STRING

customer_selection

STRING

target_type

STRING

target_selection

STRING

allocation_method

STRING

once_per_customer

BOOLEAN

starts_at

TIMESTAMP

ends_at

TIMESTAMP

created_at

TIMESTAMP

updated_at

TIMESTAMP

title

STRING

admin_graphql_api_id

STRING

disputes

Purpose: This table lists all the disputes associated with the entered shopify store

Replication: Full Replication

Replication Key: N/A

Fields

Name
Data Type

id

NUMERIC

order_id

NUMERIC

type

STRING

amount

STRING

currency

STRING

reason

STRING

network_reason_code

STRING

status

STRING

evidence_due_by

TIMESTAMP

evidence_sent_on

TIMESTAMP

finalized_on

TIMESTAMP

initiated_at

TIMESTAMP

order_customerjourneysummary

Purpose: This table has all the data related to customer's visiting activities on a shop's online store associated with the orders placed.

Note: The Sessions data is huge so currently, we only provide support for a 60-day history for this specific table. If you require data from a period before these 60 days, you will need to have the "read_all_orders" scope. Feel free to contact us if you require access to a longer history of data.

Scope: This table fetches

Replication: Key Based Incremental

Replication Key: created_at

Name
Datatype

momentsCount

NUMERIC

moments

RECORD

daysToConversion

NUMERIC

customerOrderIndex

NUMERIC

name

STRING

id

STRING

landingPageUrl

STRING

customer

RECORD

createdAt

TIMESTAMP

confirmed

BOOLEAN

closedAt

TIMESTAMP

closed

BOOLEAN

capturable

BOOLEAN

product_sessiondata

Purpose: This table has data to analyse about product performance. This dataset combines sales and sessions data at a product_id grain to provide a holistic view of product performance.

Note: The Sessions data is huge so currently we only provide support for a 60-day history for this specific table. Reach out to us if you require access to a longer history of data.

Replication: Key Based Incremental

Replication Key: date of product sold(since, until)

Name
DataType

product_id

NUMERIC

product_title

STRING

product_type

STRING

view_sessions

NUMERIC

cart_sessions

NUMERIC

checkout_sessions

NUMERIC

purchase_sessions

NUMERIC

view_cart_sessions

NUMERIC

view_cart_checkout_sessions

NUMERIC

view_cart_checkout_purchase_sessions

NUMERIC

checkout_purchase_sessions

NUMERIC

view_purchase_sessions

NUMERIC

quantity_added_to_cart

NUMERIC

quantity_purchased

NUMERIC

gross_sales

NUMERIC

ordered_product_quantity

NUMERIC

returned_product_quantity

NUMERIC

net_product_quantity

NUMERIC

discounts

NUMERIC

returns

NUMERIC

net_sales

NUMERIC

taxes

NUMERIC

product_price

NUMERIC

product_price_after_discounts

NUMERIC

users

Purpose: This table provides all users for the shopify store.In order to use this API, you need to reach out to the Merchant Success Manager and ask them to enable the read_users scope

Replication: Full Replication

Replication Key: NA Fields

Name
Data Type

id

NUMERIC

first_name

STRING

email

STRING

last_name

STRING

account_owner

BOOLEAN

receive_announcements

NUMERIC

permissions

STRING

locale

STRING

user_type

STRING

admin_graphql_api_id

STRING

tfa_enabled

BOOLEAN

to your existing Daton account.

Provide your Shopify 'Shop Name' and the generated 'Access Token' and click on 'Next.' ( to read how to generate an Access Token in Shopify.)

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

Source API Documentation:

click here
Sign in
https://shopify.dev/docs/api/admin-rest/2023-04/resources/order#get-orders?status=any
https://shopify.dev/docs/api/admin-rest/2023-04/resources/transaction#get-orders-order-id-transactions
https://shopify.dev/docs/api/admin-rest/2023-04/resources/refund#get-orders-order-id-refunds
https://shopify.dev/docs/api/admin-rest/2023-04/resources/fulfillmentorder#get-orders-order-id-fulfillment-orders
https://shopify.dev/docs/api/admin-rest/2023-04/resources/fulfillmentevent#get-orders-order-id-fulfillments-fulfillment-id-events
https://shopify.dev/docs/api/admin-rest/2023-04/resources/tendertransaction#get-tender-transactions
https://shopify.dev/docs/api/admin-rest/2023-04/resources/customer#get-customers?ids=207119551,1073339465
https://shopify.dev/docs/api/admin-rest/2023-04/resources/customer-address#get-customers-customer-id-addresses?limit=1
https://shopify.dev/docs/api/admin-rest/2023-04/resources/event#get-events
https://shopify.dev/docs/api/admin-rest/2023-04/resources/product#get-products?ids=632910392,921728736
https://shopify.dev/docs/api/admin-rest/2023-04/resources/payouts
https://shopify.dev/docs/api/admin-rest/2023-04/resources/transactions
https://shopify.dev/docs/api/admin-rest/2023-04/resources/collect
https://shopify.dev/docs/api/admin-rest/2023-04/resources/customcollection#get-custom-collections?ids=395646240,691652237,841564295
https://shopify.dev/docs/api/admin-rest/2023-04/resources/smartcollection#get-smart-collections?since-id=482865238
https://shopify.dev/docs/api/admin-rest/2023-04/resources/abandoned-checkouts#get-checkouts?created-at-max=2013-10-12T07:05:27-02:00
https://shopify.dev/docs/api/admin-rest/2023-04/resources/policy
https://shopify.dev/docs/api/admin-rest/2023-04/resources/country
https://shopify.dev/docs/api/admin-rest/2023-04/resources/shop
https://shopify.dev/docs/api/admin-rest/2023-04/resources/location#get-locations
https://shopify.dev/docs/api/admin-rest/2023-04/resources/inventorylevel#get-inventory-levels?location-ids=655441491
https://shopify.dev/docs/api/admin-rest/2023-04/resources/inventoryitem#get-inventory-items?ids=808950810,39072856,457924702
https://shopify.dev/docs/api/admin-rest/2023-04/resources/gift-card
https://shopify.dev/docs/api/admin-rest/2023-04/resources/carrierservice#get-carrier-services
https://shopify.dev/docs/api/admin-rest/2023-04/resources/pricerule#get-price-rules
https://shopify.dev/docs/api/admin-rest/2023-04/resources/dispute#get-shopify-payments-disputes?initiated-at=2013-05-03
https://shopify.dev/docs/api/admin-graphql/2023-07/objects/Order
https://shopify.dev/docs/api/shopifyql/datasets/products-dataset
https://shopify.dev/docs/api/admin-rest/2023-07/resources/user#get-users
Click here