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