Integrations

BigCommerce datasets and fields

The 4 datasets Maven lands from BigCommerce, every field in them, and how the connection syncs.

Maven lands 4 datasets from BigCommerce in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the BigCommerce integration page.

Connection and sync#

You connect BigCommerce by signing in to it and approving access, so nobody shares a password.

The first BigCommerce 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#

FieldType
order IDText
dateDate
created atTimestamp
updated atTimestamp
statusText
payment methodText
currencyText
subtotal ex taxNumber
subtotal inc taxNumber
total ex taxNumber
total inc taxNumber
total taxNumber
discount amountNumber
shipping cost ex taxNumber
shipping cost inc taxNumber
refund amountNumber
items countInteger
customer IDText
customer emailText
billing countryText
billing cityText
billing stateText
sourceText
channel IDText
order sourceText

Order line items#

FieldType
line item IDText
order IDText
dateDate
product IDText
variant IDText
nameText
skuText
quantityInteger
price ex taxNumber
price inc taxNumber
total ex taxNumber
total inc taxNumber
discount amountNumber

Products#

FieldType
product IDText
nameText
typeText
skuText
priceNumber
sale priceNumber
categoriesText
brand IDText
availabilityText
inventory levelInteger
total soldInteger
date createdTimestamp
date modifiedTimestamp
is visibleTrue/false
conditionText
weightNumber

Customers#

FieldType
customer IDText
emailText
first nameText
last nameText
date createdTimestamp
date modifiedTimestamp
orders countInteger
total spentNumber
customer group IDText
store creditNumber
accepts marketingTrue/false
cityText
stateText
countryText