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.

FieldType
order IDText
order numberText
dateDate
statusText
totalNumber
subtotalNumber
total taxNumber
shipping totalNumber
discount totalNumber
customer IDText
billing emailText
billing cityText
billing stateText
billing countryText
payment methodText
currencyText
items countInteger
line itemsText
date createdTimestamp
date modifiedTimestamp
date paidTimestamp

Products#

Product catalog.

FieldType
product IDText
nameText
skuText
priceNumber
regular priceNumber
sale priceNumber
statusText
stock quantityInteger
categoriesText
stock statusText
total salesInteger
date createdTimestamp
date modifiedTimestamp
dateDate

Customers#

Customer directory with billing/shipping location and paying-customer flag.

FieldType
customer IDInteger
emailText
first nameText
last nameText
usernameText
roleText
is paying customerTrue/false
avatar URLText
billing companyText
billing cityText
billing stateText
billing postcodeText
billing countryText
billing phoneText
shipping cityText
shipping stateText
shipping countryText
date createdTimestamp
date modifiedTimestamp
dateDate