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

Unexpected error with integration lucid: Integration is not installed on this space

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