WooCommerce
Vendo syncs orders, subscriptions, customers, products and coupons from WooCommerce and transforms them into commerce events for revenue analytics.
Last reviewed September 15, 2026
Source: Vendo imports store data from the WooCommerce REST API. It transforms the data 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 does not have it, Vendo skips the stream automatically and the sync still succeeds.
Produced Events
Vendo transforms raw data 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 Cancelled | 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
- Vendo stores and manages the keys securely
Setup
- In the Vendo app (app2.vendodata.com ), go to Apps and click Add App.
- Select WooCommerce from the list of sources.
- Enter your Store URL (for example,
https://store.com), Consumer Key and Consumer Secret. - Vendo validates the credentials against your store and starts to sync.
- Vendo imports historical order and subscription data first. Incremental syncs then 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 you connect, check that the app status shows Active.
- Verify that 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