# TikTok Shop (Releasing Soon)

## Overview

Daasity's TikTok Shop integration connects directly to the TikTok Shop API to ingest transactional order data — including orders, line items, pricing, discounts, returns, and refunds. This gives merchants full visibility into their TikTok Shop performance alongside the rest of their commerce data in Daasity.

{% hint style="warning" %}
TikTok Shop is a separate integration from TikTok (Ads). The TikTok Ads integration covers ad spend and GMV Max campaign data. TikTok Shop covers order and transaction data. Both can be active simultaneously.
{% endhint %}

The integration was built to address a common gap: many merchants connect TikTok Shop to Shopify via third-party middleware (such as Mirakl), but those connectors typically don't expose detailed discount and refund data. Daasity's direct API connection fills that gap.

## What's Included

The TikTok Shop integration pulls the following data into Daasity:

* **Orders** — Full order records including status, fulfillment type, delivery details, and payment information.
* **Line Items & Pricing** — Order line items with granular price detail: sale price, original price, platform fees, shipping fees, and discount breakdowns at the SKU level.
* **Returns & Refunds** — Return records and return line items including refund amounts, return reasons, and return status.
* **Products & SKUs** — Product catalog and SKU-level data including pricing, availability, and platform status.
* **External Order References** — Links TikTok Shop orders to their corresponding orders in external systems (e.g., Shopify), enabling cross-platform order matching and unified reporting.

## Data Model

All TikTok Shop data is stored in the tiktok\_shop schema in your data warehouse. The schema is structured as follows:

| Table                                         | Description                                                             |
| --------------------------------------------- | ----------------------------------------------------------------------- |
| tiktok\_shop.shops                            | Authorized TikTok Shop(s) connected to your account                     |
| tiktok\_shop.orders                           | Order-level records including status, fulfillment, and delivery details |
| tiktok\_shop.order\_line\_items               | Individual line items within each order                                 |
| tiktok\_shop.order\_line\_item\_price\_detail | Granular pricing for each line item: sale price, discounts, fees        |
| tiktok\_shop.products                         | TikTok Shop product catalog                                             |
| tiktok\_shop.product\_skus                    | SKU-level product data including pricing and availability               |
| tiktok\_shop.external\_orders                 | Mapping of TikTok orders to external system order IDs (e.g., Shopify)   |
| tiktok\_shop.external\_order\_line\_items     | Line item-level external order mappings                                 |
| tiktok\_shop.returns                          | Return records including return reason and status                       |
| tiktok\_shop.return\_line\_items              | Line item-level return and refund detail                                |

These tables join together as follows: orders → order\_line\_items → order\_line\_item\_price\_detail (for pricing and discounts), and orders → returns → return\_line\_items (for refund data). External order references link TikTok order IDs to Shopify order IDs.<br>

## How It Appears in Daasity

Once connected, TikTok Shop data is available in Looker via the Order and Order Line Revenue explores. You can view and filter on:<br>

* Daily sales performance by order, line item, or SKU
* Discount and fee breakdowns at the line item level
* Return and refund amounts by order or product
* Order linkage to Shopify (via External Order References)

All integer and decimal fields are available as metrics. All dimension fields are selectable for filtering and grouping.

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/tiktok/tiktok-shop-releasing-soon.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.