Shopify
Shopify ETL connector for data replication

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.
    Signin to Daton
    2.
    Select Shopify from the list of Integrations
    3.
    Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
    4.
    Provide Shopify shop name. Follow the to get your details. You will be promted to get authenticated with credentials for the selected shop name.
    5.
    Post successful authentication, you will be prompted to choose from the list of available tables
    6.
    Then select all required fields for each table
    7.
    Submit the integration

Workflow

    1.
    Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to 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.
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 2yr ago