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.

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