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.Sign in to Daton.
2.Select WooCommerce from the list of Integrations.
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.Provide site-id/domain, WooCommerce consumer key and consumer secret. Follow this link for more information
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
WooCommerce Data
Coupons
Purpose: This API is used to fetch all coupons that have been created 
Source API Documentation https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-coupons​
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 
Source API Documentation  https://woocommerce.github.io/woocommerce-rest-api-docs/#list-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
Source API Documentation https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-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.
Source API Documentation  https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-refunds​
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.
Source API Documentation https://woocommerce.github.io/woocommerce-rest-api-docs/#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
Source API Documentation  https://woocommerce.github.io/woocommerce-rest-api-docs/#list-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.
Source API Documentation  https://woocommerce.github.io/woocommerce-rest-api-docs/#list-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

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

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

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

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

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

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

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

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

Release Notes

Loopreturns

Last modified 24d ago