WooCommerce

WooCommerce ETL connector for data replication

Snapshot

FeaturesDetails

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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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 updated