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#
| Field | Type |
|---|---|
| order ID | Text |
| date | Date |
| created at | Timestamp |
| updated at | Timestamp |
| status | Text |
| payment method | Text |
| currency | Text |
| subtotal ex tax | Number |
| subtotal inc tax | Number |
| total ex tax | Number |
| total inc tax | Number |
| total tax | Number |
| discount amount | Number |
| shipping cost ex tax | Number |
| shipping cost inc tax | Number |
| refund amount | Number |
| items count | Integer |
| customer ID | Text |
| customer email | Text |
| billing country | Text |
| billing city | Text |
| billing state | Text |
| source | Text |
| channel ID | Text |
| order source | Text |
Order line items#
| Field | Type |
|---|---|
| line item ID | Text |
| order ID | Text |
| date | Date |
| product ID | Text |
| variant ID | Text |
| name | Text |
| sku | Text |
| quantity | Integer |
| price ex tax | Number |
| price inc tax | Number |
| total ex tax | Number |
| total inc tax | Number |
| discount amount | Number |
Products#
| Field | Type |
|---|---|
| product ID | Text |
| name | Text |
| type | Text |
| sku | Text |
| price | Number |
| sale price | Number |
| categories | Text |
| brand ID | Text |
| availability | Text |
| inventory level | Integer |
| total sold | Integer |
| date created | Timestamp |
| date modified | Timestamp |
| is visible | True/false |
| condition | Text |
| weight | Number |
Customers#
| Field | Type |
|---|---|
| customer ID | Text |
| Text | |
| first name | Text |
| last name | Text |
| date created | Timestamp |
| date modified | Timestamp |
| orders count | Integer |
| total spent | Number |
| customer group ID | Text |
| store credit | Number |
| accepts marketing | True/false |
| city | Text |
| state | Text |
| country | Text |