Shopify
Shopify ETL connector for data replication
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 | |
- 1.
- 2.Search for Shopify in the list of Connectors and click on the 'Configure' button.
- 3.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.
- 4.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.)
- 5.Post successful authentication, you will be prompted to choose from the list of available tables. Add the required Tables and click on 'Next.'
- 6.Select all the fields you require for each table and Submit the integration.
- 7.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.
- 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
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.
Fields
Name | Target Datatype |
admin_graphql_api_id | STRING |
id | NUMERIC |
email | 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
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 |
email | 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
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 |
Last modified 3mo ago