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
• Order Line Item
• Product
• Product Variant
• Site
• Storefront User
• Subscription
• Subscription Line

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