WooCommerce
WooCommerce is an open-source ecommerce plugin for WordPress.
Supported instances
The WooCommerce plugin is available for self-hosted, WordPress-hosted, and non-WordPress-hosted instances. Fivetran supports all the three instances of the WooCommerce plugin:
- WordPress-hosted and non-WordPress-hosted instances: Our WooCommerce Lite connector pulls data using the WooCommerce API.
- Self-hosted instances: Our MySQL database connector pulls data directly from the source database.
WooCommerce Lite
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support both SaaS and Hybrid deployment models for this connector.
NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step WooCommerce setup guide to connect WooCommerce with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
COUPONORDERPRODUCT
We also re-import the following tables once a week to capture updates and deletes:
COUPONPRODUCT
NOTE: We can retrieve historical data upto January 1, 2015, for the COUPON, ORDERS, and PRODUCT tables.
Schema information
This schema applies to all WooCommerce connectors.
WooCommerce (using MySQL)
WooCommerce is built on the MySQL database. We pull data directly from the source database, saving time and effort.
Setup guide
Use our MySQL connector.
Schema information
The schema is documented in WooCommerce's documentation. You can find more information about the schema rules in our MySQL connector documentation.