Integration guideSourcesAvailable
WooCommerce
Vendo syncs orders, subscriptions, customers, products, and coupons from WooCommerce and transforms them into commerce events for revenue analytics.
Last reviewed July 13, 2026
Source — Vendo imports store data from the WooCommerce REST API and transforms it into order and subscription events, plus customer profiles, for revenue analytics.
What Vendo Syncs
Source Streams
Vendo fetches five raw data streams from the WooCommerce REST API (v3):
| Stream | Description | Sync Style |
|---|---|---|
| Orders | Full order records with line items, totals, billing, and shipping | Incremental (by last-modified date) |
| Subscriptions | Recurring orders from the WooCommerce Subscriptions extension | Incremental (by last-modified date) |
| Customers | Customer profiles with contact and address details | Snapshot, merged by ID |
| Products | Product catalog, including a Product Variations side table for variable products | Snapshot, merged by ID |
| Coupons | Discount coupon definitions | Snapshot, merged by ID |
The Subscriptions stream requires the WooCommerce Subscriptions extension. If your store doesn’t have it, the stream is skipped automatically and the sync still succeeds.
Produced Events
Raw data is transformed into production tables for analytics:
| Event | Description |
|---|---|
| Order Received | New orders with revenue, products, and customer details |
| Order Fulfilled | Orders marked as completed/fulfilled |
| Order Refunded | Fully refunded orders |
| Order Partially Refunded | Orders with partial refunds |
| Subscription Started | New subscription activations |
| Subscription Renewed | Recurring subscription renewals |
| Subscription Canceled | Subscription cancellations |
| Customers | Customer master profiles |
Authentication
WooCommerce uses REST API keys (consumer key and secret with Basic authentication).
- Requires a Store URL, Consumer Key (
ck_...), and Consumer Secret (cs_...) - Create a Read-access key in WooCommerce under Settings → Advanced → REST API
- Keys are securely stored and managed by Vendo
Setup
- In the Vendo app (app2.vendodata.com ), navigate to Apps and click Add App
- Select WooCommerce from the integration catalog
- Enter your Store URL (e.g.
https://store.com), Consumer Key, and Consumer Secret - Vendo validates the credentials against your store and begins syncing
- Historical order and subscription data is imported first, then incremental syncs run on your source schedule
Platform Details
| Setting | Value |
|---|---|
| Sync Method | Server-side via WooCommerce REST API v3 |
| Incremental Cursor | date_modified_gmt (last-modified timestamp) |
| Page Size | 100 records per request |
| Rate Handling | Conservative request rate with automatic backoff on 429/5xx responses |
| Deduplication | id on all streams, merged idempotently |
| Subscriptions | Requires the WooCommerce Subscriptions extension (skipped if absent) |
Verify Setup
- After connecting, check the app status shows Active
- Verify order and customer data appears in your Vendo BigQuery dataset
- Compare recent order counts and totals against your WooCommerce admin
- Review Vendo job logs for sync activity and any errors
Last updated on