# BigCommerce datasets and fields

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

Source: https://mavendata.ai/docs/integrations/bigcommerce

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](https://mavendata.ai/integrations/bigcommerce).

## 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 |
| email | 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 |
