# Shopify datasets and fields

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

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

Maven lands 18 datasets from Shopify in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Shopify integration page](https://mavendata.ai/integrations/shopify).

## Connection and sync

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

Each Shopify sync takes a fresh copy of the current records, so the workspace always reflects what is in Shopify now.

## Datasets

### Shop

| Field | Type |
| --- | --- |
| shop ID | Text |
| shop gid | Text |
| name | Text |
| myshopify domain | Text |
| primary domain | Text |
| currency | Text |
| iana timezone | Text |
| timezone abbreviation | Text |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| city | Text |
| contact email | Text |
| country | Text |
| created at | Text |
| email | Text |
| is shopify plus | Text |
| plan name | Text |
| province | Text |

### Orders

| Field | Type |
| --- | --- |
| order ID | Text |
| order gid | Text |
| checkout token | Text |
| order number | Text |
| date | Date |
| created at | Timestamp |
| updated at | Timestamp |
| processed at | Timestamp |
| closed at | Timestamp |
| cancelled at | Timestamp |
| cancel reason | Text |
| financial status | Text |
| fulfillment status | Text |
| is test | True/false |
| is confirmed | True/false |
| taxes included | True/false |
| total weight | Integer |
| payment gateway names | Text |
| currency | Text |
| total price | Number |
| current total price | Number |
| subtotal price | Number |
| current subtotal price | Number |
| total tax | Number |
| current total tax | Number |
| total discounts | Number |
| current total discounts | Number |
| total shipping | Number |
| total refunds | Number |
| total line items | Integer |
| total quantity | Integer |
| customer ID | Text |
| customer email | Text |
| source name | Text |
| referring site | Text |
| landing site | Text |
| customer journey ready | True/false |
| customer journey days to conversion | Integer |
| customer journey order index | Integer |
| first visit ID | Text |
| first visit occurred at | Timestamp |
| first visit source | Text |
| first visit source description | Text |
| first visit source type | Text |
| first visit landing page | Text |
| first visit referrer URL | Text |
| first visit referral code | Text |
| first visit UTM source | Text |
| first visit UTM medium | Text |
| first visit UTM campaign | Text |
| first visit UTM content | Text |
| first visit UTM term | Text |
| first visit UTM mc ID | Text |
| first visit UTM ID | Text |
| first visit gclid | Text |
| first visit gbraid | Text |
| first visit wbraid | Text |
| first visit fbclid | Text |
| first visit msclkid | Text |
| first visit ttclid | Text |
| first visit li fat ID | Text |
| last visit ID | Text |
| last visit occurred at | Timestamp |
| last visit source | Text |
| last visit source description | Text |
| last visit source type | Text |
| last visit landing page | Text |
| last visit referrer URL | Text |
| last visit referral code | Text |
| last visit UTM source | Text |
| last visit UTM medium | Text |
| last visit UTM campaign | Text |
| last visit UTM content | Text |
| last visit UTM term | Text |
| last visit UTM mc ID | Text |
| last visit UTM ID | Text |
| last visit gclid | Text |
| last visit gbraid | Text |
| last visit wbraid | Text |
| last visit fbclid | Text |
| last visit msclkid | Text |
| last visit ttclid | Text |
| last visit li fat ID | Text |
| discount codes | Text |
| tags | Text |
| note | Text |
| shipping country | Text |
| shipping province | Text |
| shipping city | Text |
| account ID | Text |
| account name | Text |
| customer gid | Text |

### Order line items

| Field | Type |
| --- | --- |
| line item ID | Text |
| order ID | Text |
| date | Date |
| product ID | Text |
| variant ID | Text |
| title | Text |
| variant title | Text |
| sku | Text |
| vendor | Text |
| quantity | Integer |
| price | Number |
| total discount | Number |
| fulfillment status | Text |
| requires shipping | True/false |
| taxable | True/false |
| account ID | Text |
| account name | Text |
| line item gid | Text |
| line total | Text |
| order gid | Text |
| product gid | Text |
| variant gid | Text |

### Products

| Field | Type |
| --- | --- |
| product ID | Text |
| title | Text |
| vendor | Text |
| product type | Text |
| status | Text |
| tags | Text |
| created at | Timestamp |
| updated at | Timestamp |
| published at | Timestamp |
| variants count | Integer |
| min price | Number |
| max price | Number |
| total inventory | Integer |
| account ID | Text |
| account name | Text |
| handle | Text |
| product gid | Text |

### Product variants

| Field | Type |
| --- | --- |
| variant ID | Text |
| variant gid | Text |
| product ID | Text |
| product gid | Text |
| title | Text |
| sku | Text |
| price | Number |
| inventory quantity | Integer |
| inventory item ID | Text |
| inventory item gid | Text |
| tracked | True/false |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |

### Collections

Product-to-collection memberships.

| Field | Type |
| --- | --- |
| collection ID | Text |
| collection gid | Text |
| product ID | Text |
| product gid | Text |
| title | Text |
| handle | Text |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |

### Customers

| Field | Type |
| --- | --- |
| customer ID | Text |
| email | Text |
| first name | Text |
| last name | Text |
| orders count | Integer |
| total spent | Number |
| currency | Text |
| created at | Timestamp |
| updated at | Timestamp |
| tags | Text |
| state | Text |
| verified email | True/false |
| accepts marketing | True/false |
| city | Text |
| province | Text |
| country | Text |
| account ID | Text |
| account name | Text |
| customer gid | Text |

### Transactions

Order payment/refund transactions.

| Field | Type |
| --- | --- |
| transaction ID | Text |
| order ID | Text |
| date | Date |
| kind | Text |
| status | Text |
| gateway | Text |
| amount | Number |
| currency | Text |
| account ID | Text |
| account name | Text |
| created at | Text |
| order gid | Text |
| payment ID | Text |
| receipt json | Text |
| transaction gid | Text |

### Refunds

Order refunds.

| Field | Type |
| --- | --- |
| refund ID | Text |
| order ID | Text |
| date | Date |
| total refunded | Number |
| currency | Text |
| account ID | Text |
| account name | Text |
| created at | Text |
| note | Text |
| order gid | Text |
| refund gid | Text |
| updated at | Text |

### Refund line items

Refund amounts and quantities linked to original Shopify order line items.

| Field | Type |
| --- | --- |
| refund line item ID | Text |
| refund ID | Text |
| order ID | Text |
| line item ID | Text |
| date | Date |
| quantity | Integer |
| restock type | Text |
| subtotal refunded | Number |
| tax refunded | Number |
| total refunded | Number |
| currency | Text |
| account ID | Text |
| account name | Text |
| line item gid | Text |
| order gid | Text |
| refund gid | Text |
| refund line item gid | Text |

### Returns

Order returns.

| Field | Type |
| --- | --- |
| return ID | Text |
| order ID | Text |
| name | Text |
| status | Text |
| created at | Timestamp |
| closed at | Timestamp |
| request approved at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| order gid | Text |
| return gid | Text |

### Return line items

Returned item quantity, value, reason, and original product hierarchy.

| Field | Type |
| --- | --- |
| return line item ID | Text |
| return line item gid | Text |
| return ID | Text |
| return gid | Text |
| order ID | Text |
| order gid | Text |
| line item ID | Text |
| line item gid | Text |
| product ID | Text |
| product gid | Text |
| variant ID | Text |
| variant gid | Text |
| quantity | Integer |
| return reason | Text |
| return reason name | Text |
| return reason note | Text |
| return value | Number |
| currency | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |

### Fulfillments

Order fulfillments and tracking.

| Field | Type |
| --- | --- |
| fulfillment ID | Text |
| order ID | Text |
| status | Text |
| tracking numbers | Text |
| account ID | Text |
| account name | Text |
| created at | Text |
| date | Date |
| fulfillment gid | Text |
| order gid | Text |
| tracking company | Text |
| tracking URLs | Text |
| updated at | Text |

### Fulfillment orders

Fulfillment order workflow state by order/location.

| Field | Type |
| --- | --- |
| fulfillment order ID | Text |
| order ID | Text |
| order name | Text |
| status | Text |
| request status | Text |
| assigned location ID | Text |
| assigned location name | Text |
| account ID | Text |
| account name | Text |
| created at | Text |
| destination city | Text |
| destination country | Text |
| destination province | Text |
| fulfill at | Text |
| fulfill by | Text |
| fulfillment order gid | Text |
| order gid | Text |
| order processed at | Text |
| updated at | Text |

### Inventory items

Inventory item master records.

| Field | Type |
| --- | --- |
| inventory item ID | Text |
| sku | Text |
| tracked | True/false |
| unit cost | Number |
| account ID | Text |
| account name | Text |
| currency | Text |
| inventory item gid | Text |
| updated at | Text |

### Inventory levels

Current inventory levels by item and location.

| Field | Type |
| --- | --- |
| inventory level ID | Text |
| inventory item ID | Text |
| location ID | Text |
| available | Integer |
| on hand | Integer |
| committed | Integer |
| reserved | Integer |
| incoming | Integer |
| account ID | Text |
| account name | Text |
| inventory item gid | Text |
| inventory level gid | Text |
| location gid | Text |
| location name | Text |
| updated at | Text |

### Locations

Shop locations used by inventory and fulfillment.

| Field | Type |
| --- | --- |
| location ID | Text |
| location gid | Text |
| name | Text |
| is active | True/false |
| city | Text |
| province | Text |
| country | Text |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |

### Discounts

Shop discount definitions and lifecycle state.

| Field | Type |
| --- | --- |
| discount ID | Text |
| discount gid | Text |
| discount type | Text |
| title | Text |
| status | Text |
| starts at | Timestamp |
| ends at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
