WooCommercelink
Updated October 18, 2023
WooCommerce is an open-source e-commerce plugin for WordPress.
Supported instanceslink
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 link
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | All tables |
| Custom data | ||
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Table level. A table re-sync includes all the associated child tables. |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step WooCommerce setup guide to connect WooCommerce with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables and their child tables:
COUPONORDERPRODUCT
We also re-import these tables once a week to capture updates and deletes.
Schema informationlink
This schema applies to all WooCommerce connectors.
To zoom, open the ERD in a new window.WooCommerce (using MySQL)link
WooCommerce is built on the MySQL database. We pull data directly from the source database, saving time and effort.
Setup guidelink
Use our MySQL connector.
Schema informationlink
The schema is documented in WooCommerce's documentation. You can find more information about the schema rules in our MySQL connector documentation.