Inbound sync data structures

Inbound syncs uses Shopify's GraphQL endpoints to sync data into Snowflake. Each object has been predefined to sync certain fields and objects. Below are breakdowns of how Shopify fields and objects are fetch by Omnata.

Once the data is landed by Omnata in the Raw Table, fields and objects are split into columns with corresponding data type in Snowflake in the Normalized View created by Omnata.


Customer

Required access scopes:

  • read_customers

Fields

  • canDelete

  • createdAt

  • dataSaleOptOut

  • displayName

  • firstName

  • id

  • lastName

  • lifetimeDuration

  • locale

  • multipassIdentifier

  • note

  • numberOfOrders

  • productSubscriberStatus

  • state

  • tags

  • taxExempt

  • taxExemptions

  • updatedAt

  • verifiedEmail

Objects

addresses
  • address1

  • address2

  • city

  • company

  • coordinatesValidated

  • country

  • countryCodeV2

  • firstName

  • formatted

  • formattedArea

  • id

  • lastName

  • latitude

  • longitude

  • name

  • phone

  • province

  • provinceCode

  • timeZone

  • validationResultSummary

defaultAddress
  • address1

  • address2

  • city

  • company

  • coordinatesValidated

  • country

  • countryCodeV2

  • firstName

  • formatted

  • formattedArea

  • id

  • lastName

  • latitude

  • longitude

  • name

  • phone

  • province

  • provinceCode

  • timeZone

  • validationResultSummary

  • zip

defaultEmailAddress
  • emailAddress

  • marketingOptInLevel

  • marketingState

  • marketingUnsubscribeUrl

  • marketingUpdatedAt

  • openTrackingLevel

  • openTrackingUrl

  • validFormat

defaultPhoneNumber
  • marketingCollectedFrom

  • marketingOptInLevel

  • marketingState

  • marketingUpdatedAt

  • phoneNumber

amountSpent
  • amount

  • currencyCode

metafields
  • compareDigest

  • createdAt

  • id

  • jsonValue

  • key

  • legacyResourceId

statistics
  • predictedSpendTier

  • rfmGroup


Products

Required access scopes:

  • read_products

  • read_publications

Fields

  • combinedListingRole

  • createdAt

  • defaultCursor

  • description

  • descriptionHtml

  • giftCardTemplateSuffix

  • handle

  • hasOnlyDefaultVariant

  • hasOutOfStockVariants

  • hasVariantsThatRequiresComponents

  • id

  • isGiftCard

  • onlineStorePreviewUrl

  • onlineStoreUrl

  • productType

  • publishedAt

  • requiresSellingPlan

  • status

  • tags

  • templateSuffix

  • title

  • totalInventory

  • tracksInventory

  • updatedAt

  • vendor

Objects

availablePublicationsCount
  • count

  • precision

category
  • ancestorIds

  • childrenIds

  • fullName

  • id

  • isArchived

  • isLeaf

  • isRoot

  • level

  • name

compareAtPriceRange
  • maxVariantCompareAtPrice

    • amount

    • currencyCode

  • minVariantCompareAtPrice

    • amount

    • currencyCode

feedback
  • details

    • feedbackGeneratedAt

    • link

      • label

      • url

    • messages

      • field

      • message

    • state

  • summary

mediaCount
  • count

  • precision

metafields
  • compareDigest

  • createdAt

  • id

  • jsonValue

  • key

  • legacyResourceId

  • namespace

  • ownerType

  • type

  • updatedAt

  • value

options
  • id

  • linkedMetafield

    • key

    • namespace

  • name

  • optionValues

    • hasVariants

    • id

    • linkedMetafieldValue

    • name

    • swatch

      • color

  • position

  • values

priceRangeV2
  • maxVariantPrice

    • amount

    • currencyCode

  • minVariantPrice

    • amount

    • currencyCode

sellingPlanGroupsCount
  • count

  • precision

seo
  • description

  • title

variantsCount
  • count

  • precision


Product Variants

Required access scopes:

  • read_products

  • read_inventory

  • read_shipping

Fields

  • availableForSale

  • barcode

  • compareAtPrice

  • createdAt

  • defaultCursor

  • displayName

  • id

  • inventoryPolicy

  • inventoryQuantity

  • position

  • price

  • requiresComponents

  • sellableOnlineQuantity

  • sku

  • taxable

  • taxCode

  • title

Objects

deliveryProfile
  • activeMethodDefinitionsCount

  • default

  • id

  • legacyMode

  • locationsWithoutRatesCount

  • name

  • originLocationCount

  • productVariantsCount

    • count

    • precision

  • unassignedLocations

    • activatable

    • addresses

      • address1

      • address2

      • city

      • country

      • countryCode

      • formatted

      • latitude

      • longitude

      • phone

      • province

      • provinceCode

      • zip

    • addressVerified

    • createdAt

    • deactivatable

    • deactivatedAt

    • deletable

    • fulfillmentService

      • callbackUrl

      • handle

      • id

      • inventoryManagement

      • permitsSkuSharing

      • serviceName

      • trackingSupport

      • type

    • fulfillsOnlineOrders

    • hasActiveInventory

    • hasUnfulfilledOrders

    • id

    • isActive

    • isFulfillmentService

    • legacyResourceId

    • localPickupSettingsV2

      • instructions

      • pickupTime

    • name

    • shipsInventory

    • suggestedAddresses

      • address1

      • address2

      • city

      • country

      • countryCode

      • formatted

      • province

      • provinceCode

      • zip

    • updatedAt

    • isPrimary

  • zoneCountryCount

inventoryItem
  • countryCodeOfOrigin

  • countryHarmonizedSystemCodes

    • countryCode

    • harmonizedSystemCode

  • createdAt

  • duplicateSkuCount

  • harmonizedSystemCode

  • id

  • inventoryHistoryUrl

  • legacyResourceId

  • locationsCount

    • count

    • precision

  • measurement

    • id

    • weight

      • unit

      • value

  • provinceCodeOfOrigin

  • requiresShipping

  • sku

  • tracked

  • trackedEditable

    • locked

    • reason

  • unitCost

    • amount

    • currencyCode

  • updatedAt

metafields
  • compareDigest

  • createdAt

  • id

  • jsonValue

  • key

  • legacyResourceId

  • namespace

  • ownerType

  • type

  • updatedAt

  • value

selectedOptions
  • name

  • optionValue

    • hasVariants

    • id

    • linkedMetafieldValue

    • name

    • swatch

      • color

  • value

unitPriceMeasurement
  • measuredType

  • quantityUnit

  • quantityValue

  • referenceUnit

  • referenceValue


Locations

Required access scopes:

  • read_locations

Fields

  • activatable

  • addressVerified

  • createdAt

  • deactivatable

  • deactivatedAt

  • deletable

  • fulfillsOnlineOrders

  • hasActiveInventory

  • hasUnfulfilledOrders

  • id

  • isActive

  • isFulfillmentService

  • legacyResourceId

  • name

  • shipsInventory

  • updatedAt

  • isPrimary

Objects

addresses
  • address1

  • address2

  • city

  • country

  • countryCode

  • formatted

  • latitude

  • longitude

  • phone

  • province

  • provinceCode

  • zip

fulfillmentService
  • callbackUrl

  • handle

  • id

  • inventoryManagement

  • permitsSkuSharing

  • serviceName

  • trackingSupport

  • type

localPickupSettingsV2
  • instructions

  • pickupTime

suggestedAddresses
  • address1

  • address2

  • city

  • country

  • countryCode

  • formatted

  • province

  • provinceCode

  • zip


Shop

Required access scopes:

  • read_products

  • read_locations

  • read_markets

  • read_legal_policies

  • read_locales

Fields

  • checkoutApiSupported

  • contactEmail

  • createdAt

  • currencyCode

  • description

  • email

  • enabledPresentmentCurrencies

  • ianaTimezone

  • id

  • marketingSmsConsentEnabledAtCheckout

  • myshopifyDomain

  • name

  • orderNumberFormatPrefix

  • orderNumberFormatSuffix

  • richTextEditorUrl

  • setupRequired

  • shipsToCountries

  • shopOwnerName

  • taxesIncluded

  • taxShipping

  • timezoneAbbreviation

  • timezoneOffset

  • timezoneOffsetMinutes

  • transactionalSmsDisabled

  • unitSystem

  • updatedAt

  • url

Objects

alerts
  • action

    • title

    • url

  • description

allProductCategoriesList
  • ancestorIds

  • childrenIds

  • fullName

  • id

  • isArchived

  • isLeaf

  • isRoot

  • level

  • name

  • parent

billingAddress
  • address1

  • address2

  • city

  • company

  • coordinatesValidated

  • country

  • countryCodeV2

  • formatted

  • formattedArea

  • id

  • latitude

  • longitude

  • phone

  • province

  • provinceCode

channelDefinitionsForInstalledChannels
  • channelDefinitions

    • channelName

    • handle

    • id

    • isMarketplace

    • subChannelName

  • channelName

countriesInShippingZones
  • countryCodes

  • includeRestOfWorld

currencyFormats
  • moneyFormat

  • moneyInEmailsFormat

  • moneyWithCurrencyFormat

  • moneyWithCurrencyInEmailsFormat

customerAccountsV2
  • customerAccountsVersion

  • loginLinksVisibleOnStorefrontAndCheckout

  • loginRequiredAtCheckout

  • url

entitlements
  • Markets

    • B2B

      • Catalogs

        • Enabled

      • Enabled

    • Regions

      • Catalogs

        • Enabled

      • Enabled

    • Retail

      • Catalogs

        • Enabled

      • Enabled

    • Themes

      • Enabled

features
  • avalaraAvatax

  • branding

  • bundles

    • eligibleForBundles

    • ineligibilityReason

    • sellsBundles

  • captcha

  • cartTransform

    • eligibleOperations

      • expandOperation

      • mergeOperation

      • updateOperation

  • dynamicRemarketing

  • eligibleForSubscriptionMigration

  • eligibleForSubscriptions

  • giftCards

  • harmonizedSystemCode

  • legacySubscriptionGatewayEnabled

  • liveView

  • paypalExpressSubscriptionGatewayStatus

  • reports

  • sellsSubscriptions

  • showMetrics

  • storefront

  • unifiedMarkets

fulfillmentServices
  • callbackUrl

  • handle

  • id

  • inventoryManagement

  • location

    • activatable

    • addresses

      • address1

      • address2

      • city

      • country

      • countryCode

      • formatted

      • latitude

      • longitude

      • phone

      • province

      • provinceCode

      • zip

    • addressVerified

    • createdAt

    • deactivatable

    • deactivatedAt

    • deletable

    • fulfillmentService

      • callbackUrl

      • handle

      • id

      • inventoryManagement

      • permitsSkuSharing

      • serviceName

      • trackingSupport

      • type

    • fulfillsOnlineOrders

    • hasActiveInventory

    • hasUnfulfilledOrders

    • id

    • isActive

    • isFulfillmentService

    • legacyResourceId

    • localPickupSettingsV2

      • instructions

      • pickupTime

    • name

    • shipsInventory

    • suggestedAddresses

      • address1

      • address2

      • city

      • country

      • countryCode

      • formatted

      • province

      • provinceCode

      • zip

    • updatedAt

    • isPrimary

  • permitsSkuSharing

  • requiresShippingMethod

  • serviceName

  • trackingSupport

  • type

paymentSettings
  • supportedDigitalWallets

plan
  • partnerDevelopment

  • shopifyPlus

primaryDomain
  • host

  • id

  • localization

    • alternateLocales

    • country

    • defaultLocale

  • marketWebPresence

    • alternateLocales

      • locale

      • name

      • primary

      • published

    • defaultLocale

      • locale

      • name

      • primary

      • published

    • domain

      • host

      • id

      • localization

        • alternateLocales

        • country

        • defaultLocale

      • sslEnabled

      • url

    • id

    • rootUrls

      • locale

      • url

    • subfolderSuffix

  • sslEnabled

  • url

resourceLimits
  • locationLimit

  • maxProductOptions

  • maxProductVariants

  • redirectLimitReached

searchFilters
  • productAvailability

    • label

    • value

shopPolicies
  • body

  • createdAt

  • id

  • title

  • type

  • updated


Inventory Items

Required access scopes:

  • read_inventory


Inventory Levels

Dependent on Inventory Items

Required access scopes:

  • read_inventory

  • read_locations


Shopify Payments Account

Required access scopes:

  • read_shopify_payments_accounts


Balance Transactions

Required access scopes:

  • read_shopify_payments_accounts


Payouts

Required access scopes:

  • read_shopify_payments_accounts


Orders

Required access scopes:

  • read_orders

  • read_customer

  • read_products

  • read_payment_terms


Returns

Dependent on Orders

Required access scopes:

  • read_orders

  • read_customer

  • read_products

  • read_payment_terms

  • read_returns


Fulfillments

Dependent on Orders

Required access scopes:

  • read_orders

  • read_customer

  • read_products

  • read_payment_terms

  • read_fulfillments

  • read_locations


Shipping Line

Dependent on Orders

Required access scopes:

  • read_orders

  • read_customer

  • read_products

  • read_payment_terms


Last updated