The 18 datasets Maven lands from Shopify, every field in them, and how the connection syncs.
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.
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 |