Ask or search…
K
Links
Comment on page

WooCommerce

WooCommerce ETL connector for data replication

Snapshot

Features
Details
Release Status
Released
Source API Version
V3
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
WordPress site-id/ Domain WooCommerce Consumer key WooCommerce Consumer secret
Replication Type
Full Replication Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
1 hour

Tables/APIs supported

Coupons
Customers
Orders
Refunds
Products
Variations
Reviews

Integrate WooCommerce with Daton

You can use Templates to create new integrations quickly, this may help you in configuring your Tables, Fields, or Column selection with ease.
  1. 1.
    Sign in to Daton.
  2. 2.
    Select WooCommerce from the list of Integrations.
  3. 3.
    Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later
  4. 4.
    Provide site-id/domain, WooCommerce consumer key and consumer secret. Follow this link for more information
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

WooCommerce Data

Coupons

Purpose: This API is used to fetch all coupons that have been created
Replication: Key Based Incremental
Replication Key: modified_after, modified_before
Fields
Name
Data Type
id
NUMERIC
code
STRING
amount
STRING
status
STRING
date_created
DATETIME
date_created_gmt
DATETIME
date_modified
DATETIME
date_modified_gmt
DATETIME
discount_type
STRING
description
STRING
usage_count
NUMERIC
individual_use
BOOLEAN
free_shipping
BOOLEAN
exclude_sale_items
BOOLEAN
minimum_amount
STRING
maximum_amount
STRING
_links
RECORD

Customers

Purpose: This API is used to fetch all customers
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
id
NUMERIC
date_created
DATETIME
date_created_gmt
DATETIME
date_modified
DATETIME
date_modified_gmt
DATETIME
email
STRING
first_name
STRING
last_name
STRING
role
STRING
username
STRING
billing
RECORD
shipping
RECORD
is_paying_customer
BOOLEAN
avatar_url
STRING
meta_data
RECORD
_links
RECORD

Orders

Purpose: This API is to fetch all the orders
Replication: Key Based Incremental
Replication Key: modified_after, modified_before
Fields
Name
Data Type
id
NUMERIC
parent_id
NUMERIC
status
STRING
currency
STRING
version
STRING
prices_include_tax
BOOLEAN
date_created
DATETIME
date_modified
DATETIME
discount_total
STRING
discount_tax
STRING
shipping_total
STRING
shipping_tax
STRING
cart_tax
STRING
total
STRING
total_tax
STRING
customer_id
NUMERIC
order_key
STRING
billing
RECORD
shipping
RECORD
payment_method
STRING
payment_method_title
STRING
transaction_id
STRING
customer_ip_address
STRING
customer_user_agent
STRING
created_via
STRING
customer_note
STRING
date_completed
DATETIME
date_paid
DATETIME
cart_hash
STRING
number
STRING
meta_data
RECORD
line_items
RECORD
shipping_lines
RECORD
payment_url
STRING
date_created_gmt
DATETIME
date_modified_gmt
DATETIME
date_completed_gmt
DATETIME
date_paid_gmt
DATETIME
currency_symbol
STRING
_links
RECORD

Refunds

Purpose: This API is used to get the list of all the refunds from an order.
Replication: Key Based Incremental
Replication Key: modified_after, modified_before
Fields
Name
Data Type
id
NUMERIC
order_id
STRING
date_created
DATETIME
date_created_gmt
DATETIME
amount
STRING
reason
STRING
refunded_by
NUMERIC
refunded_payment
BOOLEAN
line_items
RECORD
_links
RECORD

Products

Purpose: This API is used to get the list of all products.
Replication: Key Based Incremental
Replication Key: modified_after, modified_before
Fields
Name
Data Type
id
NUMERIC
name
STRING
slug
STRING
permalink
STRING
date_created
DATETIME
date_created_gmt
DATETIME
date_modified
DATETIME
date_modified_gmt
DATETIME
type
STRING
status
STRING
featured
BOOLEAN
catalog_visibility
STRING
description
STRING
short_description
STRING
sku
STRING
price
STRING
regular_price
STRING
sale_price
STRING
on_sale
BOOLEAN
purchasable
BOOLEAN
total_sales
NUMERIC
virtual
BOOLEAN
downloadable
BOOLEAN
download_limit
NUMERIC
download_expiry
NUMERIC
external_url
STRING
button_text
STRING
tax_status
STRING
tax_class
STRING
manage_stock
BOOLEAN
backorders
STRING
backorders_allowed
BOOLEAN
backordered
BOOLEAN
sold_individually
BOOLEAN
weight
STRING
dimensions
RECORD
shipping_required
BOOLEAN
shipping_taxable
BOOLEAN
shipping_class
STRING
shipping_class_id
NUMERIC
reviews_allowed
BOOLEAN
average_rating
STRING
rating_count
NUMERIC
parent_id
NUMERIC
purchase_note
STRING
categories
RECORD
tags
RECORD
images
RECORD
attributes
RECORD
menu_order
NUMERIC
price_html
STRING
related_ids
STRING
meta_data
RECORD
stock_status
STRING
has_options
BOOLEAN
yoast_head
STRING
yoast_head_json
RECORD
_links
RECORD

Variations

Purpose: This API returns the list of all product variations
Replication: Key Based Incremental
Replication Key: modified_after, modified_before
Fields
Name
Data Type
id
NUMERIC
product_id
STRING
date_created
DATETIME
date_created_gmt
DATETIME
date_modified
DATETIME
date_modified_gmt
DATETIME
description
STRING
permalink
STRING
sku
STRING
price
STRING
regular_price
STRING
sale_price
STRING
on_sale
BOOLEAN
status
STRING
purchasable
BOOLEAN
virtual
BOOLEAN
downloadable
BOOLEAN
download_limit
NUMERIC
download_expiry
NUMERIC
tax_status
STRING
tax_class
STRING
manage_stock
BOOLEAN
stock_status
STRING
backorders
STRING
backorders_allowed
BOOLEAN
backordered
BOOLEAN
weight
STRING
dimensions
RECORD
shipping_class
STRING
shipping_class_id
NUMERIC
image
RECORD
attributes
RECORD
menu_order
NUMERIC
_links
RECORD
Reviews
Purpose: This API returns the list of all product reviews.
Replication: Full Replication
Replication Key: NA
Fields
Name
Data Type
id
NUMERIC
date_created
DATETIME
date_created_gmt
DATETIME
product_id
NUMERIC
status
STRING
reviewer
STRING
reviewer_email
STRING
review
STRING
rating
NUMERIC
verified
BOOLEAN
reviewer_avatar_urls
RECORD
_links
RECORD
Last modified 6mo ago