> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/skio/integration-specifications.md).

# 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](https://lucid.app/lucidchart/521ba785-9d3d-4adb-a510-a2b760eb3c30/view)

{% @lucid/lucid-component url="<https://lucid.app/lucidchart/521ba785-9d3d-4adb-a510-a2b760eb3c30/view>" fullWidth="true" %}

## SKIO Schema

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

* [Base Order](#base-order)
* [Order Line Item](#order-line-item)
* [Product](#product)
* [Product Variant](#product-variant)
* [Site](#site)
* [Storefront User](#storefront-user)
* [Subscription](#subscription)
* [Subscription Line](#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            |