Omnata Product Documentation
  • Omnata Sync for Snowflake
    • What is Omnata Sync for Snowflake?
    • How it works
      • Terminology
      • Branching Mode
      • Sync Directions and Strategies
        • Outbound
        • Inbound
      • Rate Limiting
      • Access Control
      • Notifications
      • Security and Privacy
      • Internal tables
      • Internal Stored Procedures
      • FAQ
    • Step-by-step guides
      • 1. Install the Omnata Sync Engine
      • 2. Install the Omnata Plugin
      • 3. Configure the Plugin
      • 4. Create a connection
      • 5. Create a sync
    • Apps
      • Aerobotics
        • 📘Release History
      • Airtable
        • 📘Release History
      • Amazon Ads
        • Privacy Notice
      • ApprovalMax
        • 📘Release History
      • Bamboo HR
        • 📘Release History
      • Clockify
        • 📘Release History
      • Contentful
        • 📘Release History
      • GitHub
        • 📘Release History
      • Github
      • Google Ads
        • 📘Release History
      • Google Sheets
        • 📘Release History
      • HubSpot
        • 📘Release History
      • Hubspot
      • Infor Data Lake
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Jira
        • 📘Release History
      • LinkedIn Ads
        • 📘Release History
      • Mailgun
        • 📘Release History
      • Marketo
        • 📘Release History
      • Meta Marketing
        • 📘Release History
      • Microsoft Ads
        • 📘Release History
      • Microsoft Dynamics 365 Business Central
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Microsoft Entra ID
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Microsoft Excel
      • Microsoft SQL Server
        • 📘Release History
      • Monday.com
        • 📘Release History
      • MRPeasy
        • 📘Release History
      • PayHero
        • 📘Release History
      • Pinterest Ads
        • Privacy Policy
      • PostgreSQL
        • 📘Release History
      • Salesforce
        • Salesforce Permissions needed
        • Formula Fields
        • How we use the Salesforce APIs
        • 📘Release History
      • Salesforce Marketing Cloud
        • OAuth for APIs, SFTP for file transfer with GPG on outbound
        • OAuth for APIs, SFTP for file transfer
        • OAuth for APIs, Cloud Storage for file transfer
        • 📘Release History
      • Shopify
        • Inbound sync data structures
        • Outbound sync data structures
        • 📘Release History
      • Slack
        • 📘Release History
      • Tiktok Ads
        • Privacy Policy
      • Typeform
        • 📘Release History
      • Wise
        • 📘Release History
      • Xero
        • 📘Release History
      • Zendesk Support
        • 📘Release History
        • 📘Release History
        • 📘Release History
    • Plugins
      • Anatomy of a Plugin
      • Example Plugins
        • Example Plugin: Slack
        • Example Plugin: Zoho CRM
      • Creating Plugins
      • Advanced Plugin topics
        • Advanced rate limiting / concurrency
        • Custom Jinja filters
        • Custom Record Transformers
        • Dynamic Configuration Forms
        • Test case generation
    • Branching
      • Inbound Sync branching
      • Outbound Sync branching
    • Integrations
      • dbt
        • Validation Tests (coming soon)
    • 📘Release History
  • Omnata Connect for Salesforce
    • Overview
    • Getting Started
      • Install the Salesforce App
      • Connect to your data warehouse
        • Snowflake
        • BigQuery
        • Rockset
        • Firebolt
        • SingleStore (previously MemSQL)
      • Deciding which mode to use
    • Omnata with Salesforce Connect (External Objects)
      • Object Configuration
      • View your data in a list
      • Link to other objects
      • Use in a Report
      • Database schema changes
      • Writing to External Objects
    • Omnata with Salesforce Lightning Components
      • Object Configuration
      • View your data in a list
      • Link to other objects
      • Using the Lightning Component on a page
      • Assigning Permissions
    • Advanced Features
      • Row Level Filtering
      • Multi-Currency handling
        • About Multi-Currency
        • Support in Omnata Connect
        • Apex Features
    • Integrations
      • Datadog
    • Omnata with Salesforce Apex
    • Security
    • Use cases
      • Linked object drill-downs
      • Global Search
      • ERP and historical data
      • Embedded product metrics
    • Best Practices
      • Global Search
      • Change Management
      • Snowflake table design
      • Salesforce page layout
      • Salesforce Caching
Powered by GitBook
On this page
  • Customer
  • Fields
  • Objects
  • Products
  • Fields
  • Objects
  • Product Variants
  • Fields
  • Objects
  • Locations
  • Fields
  • Objects
  • Shop
  • Fields
  • Objects
  1. Omnata Sync for Snowflake
  2. Apps
  3. Shopify

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

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

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

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

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

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

navigationSettings
  • id

  • title

  • url

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

PreviousShopifyNextOutbound sync data structures

Last updated 2 days ago