> 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/tiktok-shop/transformation-configuration-setup.md).

# 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](/technical-docs/transform-code/code-repository.md) 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](https://help.daasity.com/~/revisions/FzI2OkS45ZmOz4UDlJk9/core-concepts/data-integrations/setup-guides/digital-integrations/tiktok-shop/workflow-configuration-setup) section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

### Script Manifest File (YML)

#### Upstream Transformation Dependencies

{% hint style="danger" %}
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
  {% endhint %}

#### 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>