Updated October 18, 2023
WooCommerce is an open-source e-commerce plugin for WordPress.
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
|Capture deletes||check||All tables|
|Data blocking||check||Column level|
|Re-sync||check||Table level. A table re-sync includes all the associated child tables.|
|API configurable||check||API configuration|
|Fivetran data models|
Follow our step-by-step WooCommerce setup guide to connect WooCommerce with your destination using Fivetran connectors.
To capture new records, we incrementally sync the following tables and their child tables:
We also re-import these tables once a week to capture updates and deletes.
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.
Use our MySQL connector.