Shopify
Shopify ETL connector for data replication
Last updated
Daton
Shopify ETL connector for data replication
Last updated
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 click here to Generate a New Shopify Access Token.
Features
Details
Release Status
Released
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Shopify Shopname Shopify Username Shopify Password
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
1hr
Tables/APIs Supported
Orders
Customers
Products
Sign in to your existing Daton account.
Search for Shopify in the list of Connectors and click on the 'Configure' button.
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.
Provide your Shopify 'Shop Name' and the generated 'Access Token' and click on 'Next.' (Click here to read how to generate an Access Token in Shopify.)
Post successful authentication, you will be prompted to choose from the list of available tables. Add the required Tables and click on 'Next.'
Select all the fields you require for each table and Submit the integration.
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.
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.
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
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.
Source API Documentation https://help.shopify.com/en/api/reference/orders/order#index
Fields
Name
Target Datatype
admin_graphql_api_id
STRING
id
NUMERIC
STRING
closed_at
STRING
created_at
TIMESTAMP
updated_at
TIMESTAMP
number
INTEGER
note
STRING
token
STRING
gateway
STRING
test
BOOLEAN
total_price
FLOAT
subtotal_price
FLOAT
total_weight
INTEGER
total_tax
STRING
taxes_included
BOOLEAN
currency
STRING
financial_status
STRING
confirmed
BOOLEAN
total_discounts
STRING
total_line_items_price
FLOAT
cart_token
STRING
buyer_accepts_marketing
BOOLEAN
name
STRING
referring_site
STRING
landing_site
STRING
cancelled_at
STRING
cancel_reason
STRING
total_price_usd
FLOAT
checkout_token
STRING
reference
STRING
user_id
FLOAT
location_id
FLOAT
source_identifier
STRING
source_url
STRING
processed_at
TIMESTAMP
device_id
FLOAT
phone
STRING
customer_locale
STRING
app_id
INTEGER
browser_ip
STRING
landing_site_ref
STRING
order_number
INTEGER
discount_codes
RECORD
note_attributes
RECORD
payment_gateway_names
STRING
processing_method
STRING
checkout_id
FLOAT
source_name
STRING
fulfillment_status
STRING
tax_lines
RECORD
tags
STRING
contact_email
STRING
order_status_url
STRING
line_items
RECORD
shipping_lines
RECORD
billing_address
RECORD
shipping_address
RECORD
fulfillments
RECORD
client_details
RECORD
refunds
RECORD
payment_details
RECORD
customer
RECORD
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. The Customer resource also holds information on the status of a customer's account. Customers with accounts save time at checkout when they're logged in because they don't need to enter their contact information. This Retrieves a list of customers
Source API Documentation https://help.shopify.com/en/api/reference/customers/customer#index
Fields
Name
Target Datatype
tags
STRING
phone
STRING
orders_count
INTEGER
total_spent
FLOAT
multipass_identifier
STRING
accepts_marketing
BOOLEAN
addresses
RECORD
verified_email
BOOLEAN
state
STRING
created_at
TIMESTAMP
default_address
RECORD
note
STRING
STRING
first_name
STRING
updated_at
TIMESTAMP
last_order_id
FLOAT
id
NUMERIC
last_name
STRING
tax_exempt
BOOLEAN
last_order_name
STRING
admin_graphql_api_id
STRING
Products
Purpose: Retrieves a list of products
Source API Documentation https://help.shopify.com/en/api/reference/products/product#index
Fields
Name
Target Datatype
vendor
STRING
tags
STRING
body_html
STRING
title
STRING
created_at
TIMESTAMP
handle
STRING
id
NUMERIC
image
RECORD
template_suffix
STRING
published_at
TIMESTAMP
variants
RECORD
images
RECORD
published_scope
STRING
options
RECORD
updated_at
TIMESTAMP
product_type
STRING
Click here if you are facing troubles in the OAuth flow.
