TikTok Shop (Releasing Soon)

TikTok Shop integration for order data, discounts, refunds, and returns — unified in Daasity.a

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.

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.

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.

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:

• 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.