Integration Specifications
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)
Click here to view full screen
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]
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]
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]
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]
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]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
domain
DOMAIN
url
URL
currencyCode
CURRENCY_CODE
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]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
cognitoUsername
COGNITO_USERNAME
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]
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]
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
Last updated
Was this helpful?