Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • SKIO Schema
  • Base Order
  • Order Line Item
  • Product
  • Product Variant
  • Site
  • Storefront User
  • Subscription
  • Subscription Line

Was this helpful?

  1. Extract
  2. All Integrations
  3. SKIO

Integration Specifications

PreviousIntegration SetupNextSnapchat

Last updated 9 months ago

Was this helpful?

Integration Overview

SKIO is a subscription management platform that allows you to optimize your Shopify subscription program.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

This extractor takes data from a BigQuery database owned by SKIO and replicates the data into your database.

Entity Relationship Diagram (ERD)

SKIO Schema

The SKIO extractor creates these tables using a replication process from BigQuery to your database.

Base Order

  • Update Method: UPSERT

  • Table Name: [skio.base_order]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

platformId

PLATFORM_ID

deletedAt

DELETED_AT

cancelledAt

CANCELLED_AT

platformNumberBkp

PLATFORM_NUMBER_BKP

storefrontUserId

STOREFRONT_USER_ID

deliveredAt

DELIVERED_AT

fulfillAt

FULFILL_AT

prepaidSubscriptionId

PREPAID_SUBSCRIPTION_ID

firstOrderInPrepaidSequence

FIRST_ORDER_IN_PREPAID_SEQUENCE

fulfillmentOrderCredit

FULFILLMENT_ORDER_CREDIT

note

NOTE

processedAt

PROCESSED_AT

clientIp

CLIENT_IP

totalPrice

TOTAL_PRICE

siteId

SITE_ID

appId

APP_ID

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

platformNumber

PLATFORM_NUMBER

Order Line Item

  • Update Method: UPSERT

  • Table Name: [skio.order_line_item]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

productVariantId

PRODUCT_VARIANT_ID

orderId

ORDER_ID

quantity

QUANTITY

platformId

PLATFORM_ID

priceWithoutDiscount

PRICE_WITHOUT_DISCOUNT

groupId

GROUP_ID

subscriptionLineId

SUBSCRIPTION_LINE_ID

attributionGroupId

ATTRIBUTION_GROUP_ID

customAttributes

CUSTOM_ATTRIBUTES

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

Product

  • Update Method: UPSERT

  • Table Name: [skio.product]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

siteId

SITE_ID

platformId

PLATFORM_ID

slug

SLUG

imageSrc

IMAGE_SRC

title

TITLE

deletedAt

DELETED_AT

status

STATUS

isSwappable

IS_SWAPPABLE

canUpsell

CAN_UPSELL

smsTitle

SMS_TITLE

smsOrder

SMS_ORDER

swapTitle

SWAP_TITLE

isBuildable

IS_BUILDABLE

hideOnEditProductsPage

HIDE_ON_EDIT_PRODUCTS_PAGE

metafields

METAFIELDS

hideOn1TimeUpsells

HIDE_ON_1_TIME_UPSELLS

oneTimeUpsellPercentageOff

ONE_TIME_UPSELL_PERCENTAGE_OFF

limitOneTimeUpsellQuantity

LIMIT_ONE_TIME_UPSELL_QUANTITY

shopifyTags

SHOPIFY_TAGS

description

DESCRIPTION

images

IMAGES

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

Product Variant

  • Update Method: UPSERT

  • Table Name: [skio.product_variant]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

price

PRICE

title

TITLE

platformId

PLATFORM_ID

productId

PRODUCT_ID

sku

SKU

deletedAt

DELETED_AT

image

IMAGE

compareAtPrice

COMPARE_AT_PRICE

outOfStockAt

OUT_OF_STOCK_AT

marketPrices

MARKET_PRICES

billingPriceOverride

BILLING_PRICE_OVERRIDE

enableOneTimeUpsell

ENABLE_ONE_TIME_UPSELL

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

Site

  • Update Method: UPSERT

  • Table Name: [skio.site]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

domain

DOMAIN

url

URL

currencyCode

CURRENCY_CODE

email

EMAIL

name

NAME

slug

SLUG

hostname

HOSTNAME

syncing

SYNCING

snippetsSyncing

SNIPPETS_SYNCING

notificationEmail

NOTIFICATION_EMAIL

notificationEmailUnderReview

NOTIFICATION_EMAIL_UNDER_REVIEW

urlShortener

URL_SHORTENER

freeTrialEndsAt

FREE_TRIAL_ENDS_AT

awsPhoneNumber

AWS_PHONE_NUMBER

isPaying

IS_PAYING

plivoPhoneNumber

PLIVO_PHONE_NUMBER

contactFirstName

CONTACT_FIRST_NAME

contactLastName

CONTACT_LAST_NAME

klaviyoPublicKey

KLAVIYO_PUBLIC_KEY

klaviyoPrivateKey

KLAVIYO_PRIVATE_KEY

transactionCut

TRANSACTION_CUT

groupRevenueCut

GROUP_REVENUE_CUT

hideGroupSubscriptions

HIDE_GROUP_SUBSCRIPTIONS

backfilling

BACKFILLING

taxIncluded

TAX_INCLUDED

roundUpAnchors

ROUND_UP_ANCHORS

scriptLoadBehavior

SCRIPT_LOAD_BEHAVIOR

transactionFee

TRANSACTION_FEE

stripeSubscriptionItemId

STRIPE_SUBSCRIPTION_ITEM_ID

showSellingPlanId

SHOW_SELLING_PLAN_ID

quarterlyOverride

QUARTERLY_OVERRIDE

betaTesting

BETA_TESTING

transactionFeeAppliesToGroup

TRANSACTION_FEE_APPLIES_TO_GROUP

orderPrefix

ORDER_PREFIX

inventoryPolicy

INVENTORY_POLICY

groupDiscountOffOneTime

GROUP_DISCOUNT_OFF_ONE_TIME

featureSmsRemindersWithActions

FEATURE_SMS_REMINDERS_WITH_ACTIONS

updateShippingOnSubscriptionChanges

UPDATE_SHIPPING_ON_SUBSCRIPTION_CHANGES

vCardUrl

V_CARD_URL

gorgiasAccountName

GORGIAS_ACCOUNT_NAME

gorgiasRefreshToken

GORGIAS_REFRESH_TOKEN

pushWeekendOrders

PUSH_WEEKEND_ORDERS

billMigratedSubs

BILL_MIGRATED_SUBS

billingWindow

BILLING_WINDOW

useRechargeTags

USE_RECHARGE_TAGS

inviteLinkOverride

INVITE_LINK_OVERRIDE

hideChooseSubscription

HIDE_CHOOSE_SUBSCRIPTION

storefrontAccessToken

STOREFRONT_ACCESS_TOKEN

sitewidePortalPercentageOff

SITEWIDE_PORTAL_PERCENTAGE_OFF

hideOrderStatusWidget

HIDE_ORDER_STATUS_WIDGET

giftOnSkip

GIFT_ON_SKIP

multipassSecret

MULTIPASS_SECRET

lastRecurringBillingLock

LAST_RECURRING_BILLING_LOCK

cancelSubscriptionAfterAttempts

CANCEL_SUBSCRIPTION_AFTER_ATTEMPTS

subscriptionBillingRetryInterval

SUBSCRIPTION_BILLING_RETRY_INTERVAL

contactEmail

CONTACT_EMAIL

ianaTimezone

IANA_TIMEZONE

showShippingCalculationButton

SHOW_SHIPPING_CALCULATION_BUTTON

mergeSubscriptions

MERGE_SUBSCRIPTIONS

skioSmsModifyOptionsMapping

SKIO_SMS_MODIFY_OPTIONS_MAPPING

twilioMessagingServiceSid

TWILIO_MESSAGING_SERVICE_SID

lastRecurringBillingNotificationLock

LAST_RECURRING_BILLING_NOTIFICATION_LOCK

migrationId

MIGRATION_ID

impactKey

IMPACT_KEY

impactSid

IMPACT_SID

showNewCustomerPortal

SHOW_NEW_CUSTOMER_PORTAL

zendeskToken

ZENDESK_TOKEN

syncAddressesToShopify

SYNC_ADDRESSES_TO_SHOPIFY

allowCustomerDiscountCodeStacking

ALLOW_CUSTOMER_DISCOUNT_CODE_STACKING

settings

SETTINGS

syncingRules

SYNCING_RULES

showPauseInDashboard

SHOW_PAUSE_IN_DASHBOARD

showPauseInCustomerPortal

SHOW_PAUSE_IN_CUSTOMER_PORTAL

termsOfService

TERMS_OF_SERVICE

runningKlaviyoBackfill

RUNNING_KLAVIYO_BACKFILL

autoMergeBilling

AUTO_MERGE_BILLING

productDiscountFunctionId

PRODUCT_DISCOUNT_FUNCTION_ID

gorgiasDashboardActionToken

GORGIAS_DASHBOARD_ACTION_TOKEN

installedApps

INSTALLED_APPS

smartCarouselSettings

SMART_CAROUSEL_SETTINGS

dunningSettings

DUNNING_SETTINGS

useFlycoDeDunning

USE_FLYCODE_DUNNING

lastMigrationTime

LAST_MIGRATION_TIME

skioUninstalled

SKIO_UNINSTALLED

defaultCopyTranslationId

DEFAULT_COPY_TRANSLATION_ID

stripeSaasFee

STRIPE_SAAS_FEE

previewSettings

PREVIEW_SETTINGS

skioSmsSettings

SKIO_SMS_SETTINGS

showPauseInCutomerPortal

SHOW_PAUSE_IN_CUTOMER_PORTAL

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

Storefront User

  • Update Method: UPSERT

  • Table Name: [skio.storefront_user]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

cognitoUsername

COGNITO_USERNAME

email

EMAIL

phoneNumber

PHONE_NUMBER

siteId

SITE_ID

platformId

PLATFORM_ID

firstName

FIRST_NAME

lastName

LAST_NAME

userId

USER_ID

storefrontUserGroupId

STOREFRONT_USER_GROUP_ID

cognitoUserId

COGNITO_USER_ID

storefrontUserGroupStatus

STOREFRONT_USER_GROUP_STATUS

groupDiscountCode

GROUP_DISCOUNT_CODE

redactedAt

REDACTED_AT

shopifyTags

SHOPIFY_TAGS

qaToken

QA_TOKEN

qaTokenUpdatedAt

QA_TOKEN_UPDATED_AT

removedAt

REMOVED_AT

backupPaymentMethodId

BACKUP_PAYMENT_METHOD_ID

platformCreatedAt

PLATFORM_CREATED_AT

amountSpent

AMOUNT_SPENT

numberOfOrders

NUMBER_OF_ORDERS

amountSpentCurrencyCode

AMOUNT_SPENT_CURRENCY_CODE

numberOrOrders

NUMBER_OR_ORDERS

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

Subscription

  • Update Method: UPSERT

  • Table Name: [skio.subscription]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

billingPolicyId

BILLING_POLICY_ID

deliveryPolicyId

DELIVERY_POLICY_ID

shippingAddressId

SHIPPING_ADDRESS_ID

paymentMethodId

PAYMENT_METHOD_ID

deliveryPrice

DELIVERY_PRICE

status

STATUS

currencyCode

CURRENCY_CODE

nextBillingDate

NEXT_BILLING_DATE

storefrontUserId

STOREFRONT_USER_ID

idempotencyKey

IDEMPOTENCY_KEY

platformId

PLATFORM_ID

cancelledAt

CANCELLED_AT

statusContext

STATUS_CONTEXT

lastBillingAttemptAt

LAST_BILLING_ATTEMPT_AT

migrationIndex

MIGRATION_INDEX

customAttributes

CUSTOM_ATTRIBUTES

prepaidDeliveryPolicyId

PREPAID_DELIVERY_POLICY_ID

prepaidProductPricesPerDelivery

PREPAID_PRODUCT_PRICES_PER_DELIVERY

cyclesCompleted

CYCLES_COMPLETED

deliveryPriceOverride

DELIVERY_PRICE_OVERRIDE

creditPerOrder

CREDIT_PER_ORDER

metadata

METADATA

pausedAt

PAUSED_AT

siteId

SITE_ID

prepaidGiftRecipientId

PREPAID_GIFT_RECIPIENT_ID

originOrderId

ORIGIN_ORDER_ID

dunningStoryId

DUNNING_STORY_ID

note

NOTE

isPickup

IS_PICKUP

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

Subscription Line

  • Update Method: UPSERT

  • Table Name: [skio.subscription_line]

Source column name
Column name

id

ID

createdAt

CREATED_AT

updatedAt

UPDATED_AT

subscriptionId

SUBSCRIPTION_ID

priceWithoutDiscount

PRICE_WITHOUT_DISCOUNT

quantity

QUANTITY

sellingPlanId

SELLING_PLAN_ID

productVariantId

PRODUCT_VARIANT_ID

platformId

PLATFORM_ID

taxable

TAXABLE

groupId

GROUP_ID

reChargeId

RE_CHARGE_ID

boldId

BOLD_ID

removedAt

REMOVED_AT

ordersRemaining

ORDERS_REMAINING

isPrepaid

IS_PREPAID

prepaidSubscriptionId

PREPAID_SUBSCRIPTION_ID

customAttributes

CUSTOM_ATTRIBUTES

titleOverride

TITLE_OVERRIDE

legacySubscriptionId

LEGACY_SUBSCRIPTION_ID

MD5(siteId + id)

__SYNC_KEY

Name of source table in SKIO BigQuery

__SOURCE_TABLE

Name of source dataset in SKIO BigQuery

__DATASET

Daasity app account id

_ACCOUNT_ID

siteId

__SOURCE_ID

UTC timestamp of the last data sync

__SYNCED_AT

🔌
Base Order
Order Line Item
Product
Product Variant
Site
Storefront User
Subscription
Subscription Line
Click here to view full screen