Integrations

Shopify datasets and fields

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#

FieldType
shop IDText
shop gidText
nameText
myshopify domainText
primary domainText
currencyText
iana timezoneText
timezone abbreviationText
updated atTimestamp
account IDText
account nameText
cityText
contact emailText
countryText
created atText
emailText
is shopify plusText
plan nameText
provinceText

Orders#

FieldType
order IDText
order gidText
checkout tokenText
order numberText
dateDate
created atTimestamp
updated atTimestamp
processed atTimestamp
closed atTimestamp
cancelled atTimestamp
cancel reasonText
financial statusText
fulfillment statusText
is testTrue/false
is confirmedTrue/false
taxes includedTrue/false
total weightInteger
payment gateway namesText
currencyText
total priceNumber
current total priceNumber
subtotal priceNumber
current subtotal priceNumber
total taxNumber
current total taxNumber
total discountsNumber
current total discountsNumber
total shippingNumber
total refundsNumber
total line itemsInteger
total quantityInteger
customer IDText
customer emailText
source nameText
referring siteText
landing siteText
customer journey readyTrue/false
customer journey days to conversionInteger
customer journey order indexInteger
first visit IDText
first visit occurred atTimestamp
first visit sourceText
first visit source descriptionText
first visit source typeText
first visit landing pageText
first visit referrer URLText
first visit referral codeText
first visit UTM sourceText
first visit UTM mediumText
first visit UTM campaignText
first visit UTM contentText
first visit UTM termText
first visit UTM mc IDText
first visit UTM IDText
first visit gclidText
first visit gbraidText
first visit wbraidText
first visit fbclidText
first visit msclkidText
first visit ttclidText
first visit li fat IDText
last visit IDText
last visit occurred atTimestamp
last visit sourceText
last visit source descriptionText
last visit source typeText
last visit landing pageText
last visit referrer URLText
last visit referral codeText
last visit UTM sourceText
last visit UTM mediumText
last visit UTM campaignText
last visit UTM contentText
last visit UTM termText
last visit UTM mc IDText
last visit UTM IDText
last visit gclidText
last visit gbraidText
last visit wbraidText
last visit fbclidText
last visit msclkidText
last visit ttclidText
last visit li fat IDText
discount codesText
tagsText
noteText
shipping countryText
shipping provinceText
shipping cityText
account IDText
account nameText
customer gidText

Order line items#

FieldType
line item IDText
order IDText
dateDate
product IDText
variant IDText
titleText
variant titleText
skuText
vendorText
quantityInteger
priceNumber
total discountNumber
fulfillment statusText
requires shippingTrue/false
taxableTrue/false
account IDText
account nameText
line item gidText
line totalText
order gidText
product gidText
variant gidText

Products#

FieldType
product IDText
titleText
vendorText
product typeText
statusText
tagsText
created atTimestamp
updated atTimestamp
published atTimestamp
variants countInteger
min priceNumber
max priceNumber
total inventoryInteger
account IDText
account nameText
handleText
product gidText

Product variants#

FieldType
variant IDText
variant gidText
product IDText
product gidText
titleText
skuText
priceNumber
inventory quantityInteger
inventory item IDText
inventory item gidText
trackedTrue/false
updated atTimestamp
account IDText
account nameText

Collections#

Product-to-collection memberships.

FieldType
collection IDText
collection gidText
product IDText
product gidText
titleText
handleText
updated atTimestamp
account IDText
account nameText

Customers#

FieldType
customer IDText
emailText
first nameText
last nameText
orders countInteger
total spentNumber
currencyText
created atTimestamp
updated atTimestamp
tagsText
stateText
verified emailTrue/false
accepts marketingTrue/false
cityText
provinceText
countryText
account IDText
account nameText
customer gidText

Transactions#

Order payment/refund transactions.

FieldType
transaction IDText
order IDText
dateDate
kindText
statusText
gatewayText
amountNumber
currencyText
account IDText
account nameText
created atText
order gidText
payment IDText
receipt jsonText
transaction gidText

Refunds#

Order refunds.

FieldType
refund IDText
order IDText
dateDate
total refundedNumber
currencyText
account IDText
account nameText
created atText
noteText
order gidText
refund gidText
updated atText

Refund line items#

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

FieldType
refund line item IDText
refund IDText
order IDText
line item IDText
dateDate
quantityInteger
restock typeText
subtotal refundedNumber
tax refundedNumber
total refundedNumber
currencyText
account IDText
account nameText
line item gidText
order gidText
refund gidText
refund line item gidText

Returns#

Order returns.

FieldType
return IDText
order IDText
nameText
statusText
created atTimestamp
closed atTimestamp
request approved atTimestamp
updated atTimestamp
account IDText
account nameText
order gidText
return gidText

Return line items#

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

FieldType
return line item IDText
return line item gidText
return IDText
return gidText
order IDText
order gidText
line item IDText
line item gidText
product IDText
product gidText
variant IDText
variant gidText
quantityInteger
return reasonText
return reason nameText
return reason noteText
return valueNumber
currencyText
created atTimestamp
updated atTimestamp
account IDText
account nameText

Fulfillments#

Order fulfillments and tracking.

FieldType
fulfillment IDText
order IDText
statusText
tracking numbersText
account IDText
account nameText
created atText
dateDate
fulfillment gidText
order gidText
tracking companyText
tracking URLsText
updated atText

Fulfillment orders#

Fulfillment order workflow state by order/location.

FieldType
fulfillment order IDText
order IDText
order nameText
statusText
request statusText
assigned location IDText
assigned location nameText
account IDText
account nameText
created atText
destination cityText
destination countryText
destination provinceText
fulfill atText
fulfill byText
fulfillment order gidText
order gidText
order processed atText
updated atText

Inventory items#

Inventory item master records.

FieldType
inventory item IDText
skuText
trackedTrue/false
unit costNumber
account IDText
account nameText
currencyText
inventory item gidText
updated atText

Inventory levels#

Current inventory levels by item and location.

FieldType
inventory level IDText
inventory item IDText
location IDText
availableInteger
on handInteger
committedInteger
reservedInteger
incomingInteger
account IDText
account nameText
inventory item gidText
inventory level gidText
location gidText
location nameText
updated atText

Locations#

Shop locations used by inventory and fulfillment.

FieldType
location IDText
location gidText
nameText
is activeTrue/false
cityText
provinceText
countryText
updated atTimestamp
account IDText
account nameText

Discounts#

Shop discount definitions and lifecycle state.

FieldType
discount IDText
discount gidText
discount typeText
titleText
statusText
starts atTimestamp
ends atTimestamp
created atTimestamp
updated atTimestamp
account IDText
account nameText