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]
| 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 |
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 |
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 |
Last updated