Transformation Configuration Setup

Transformation Configuration Setup

Overview

The Daasity transformation code maps data from the TikTok Shop schema into the Unified Order Schema (UOS) for sales data

Feature Dependencies

You must have enabled our Code Repository feature in order to both access the Daasity transformation code as well as modify a Script Manifest File enabling this code to execute.

We recommend you review the Transformation Configuration section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

Script Manifest File (YML)

Upstream Transformation Dependencies

This code is dependent on the following integration being installed:

• TikTok Shop

This code block is dependent on the following upstream code blocks being implemented:

• Initialization

Transformation Code Requirements

To enable the data transformation from the TikTok Shop schema into UOS, the following code must be run in a workflow:

  uos_tiktok_shop:
    integrations:
      - tiktok_shop
    scripts:
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0512_UOS_BAS_TIKTOK_customers.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0513_UOS_BAS_TIKTOK_products.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0514_UOS_BAS_TIKTOK_product_variants.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0515_UOS_BAS_TIKTOK_orders.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0516_UOS_BAS_TIKTOK_order_line_items.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0517_UOS_BAS_TIKTOK_order_discount_codes.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0522_UOS_BAS_TIKTOK_refund_line_items.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0523_UOS_BAS_TIKTOK_fulfillments.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0524_UOS_BAS_TIKTOK_order_item_fulfillments.sql"
      - "github://platform-sql-shared/scripts/base/0500_uos/tiktok_shop/0526_UOS_BAS_TIKTOK_sales_report.sql"

Unified Order Schema

Code to populate the UOS tables with sales data from TikTok Shop

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0512_UOS_BAS_TIKTOK_customers.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0513_UOS_BAS_TIKTOK_products.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0514_UOS_BAS_TIKTOK_product_variants.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0515_UOS_BAS_TIKTOK_orders.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0516_UOS_BAS_TIKTOK_order_line_items.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0517_UOS_BAS_TIKTOK_order_discount_codes.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0522_UOS_BAS_TIKTOK_refund_line_items.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0523_UOS_BAS_TIKTOK_fulfillments.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0524_UOS_BAS_TIKTOK_order_item_fulfillments.sql

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/0500_uos/tiktok_shop/0526_UOS_BAS_TIKTOK_sales_report.sql