Integrations
WooCommerce datasets and fields
The 3 datasets Maven lands from WooCommerce, every field in them, and how the connection syncs.
Maven lands 3 datasets from WooCommerce in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the WooCommerce integration page.
Connection and sync#
You connect WooCommerce with consumer key, consumer secret and store URL from the WooCommerce account. Maven stores them encrypted.
The first WooCommerce sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.
Datasets#
Orders#
Orders with line items, totals, customer refs.
| Field | Type |
|---|---|
| order ID | Text |
| order number | Text |
| date | Date |
| status | Text |
| total | Number |
| subtotal | Number |
| total tax | Number |
| shipping total | Number |
| discount total | Number |
| customer ID | Text |
| billing email | Text |
| billing city | Text |
| billing state | Text |
| billing country | Text |
| payment method | Text |
| currency | Text |
| items count | Integer |
| line items | Text |
| date created | Timestamp |
| date modified | Timestamp |
| date paid | Timestamp |
Products#
Product catalog.
| Field | Type |
|---|---|
| product ID | Text |
| name | Text |
| sku | Text |
| price | Number |
| regular price | Number |
| sale price | Number |
| status | Text |
| stock quantity | Integer |
| categories | Text |
| stock status | Text |
| total sales | Integer |
| date created | Timestamp |
| date modified | Timestamp |
| date | Date |
Customers#
Customer directory with billing/shipping location and paying-customer flag.
| Field | Type |
|---|---|
| customer ID | Integer |
| Text | |
| first name | Text |
| last name | Text |
| username | Text |
| role | Text |
| is paying customer | True/false |
| avatar URL | Text |
| billing company | Text |
| billing city | Text |
| billing state | Text |
| billing postcode | Text |
| billing country | Text |
| billing phone | Text |
| shipping city | Text |
| shipping state | Text |
| shipping country | Text |
| date created | Timestamp |
| date modified | Timestamp |
| date | Date |