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.

Snapshot

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

Integrate Shopify with Daton

1. Sign in to your existing Daton account.

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.

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

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.

Source API Documentation https://help.shopify.com/en/api/reference/orders/order#index

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

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
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

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.