Tiktok Shop (Seller) Connector

TikTok Ads is an advertising platform that allows brands to connect with a younger, highly-engaged audience through short-form video content.

4.8 on G2

Weld · Data Sources

Tiktok Shop (Seller)

Tiktok Shop (Seller)Your warehouseLive

order98 columnsSynced

product12 columnsSynced

statement13 columnsSynced

statement_transaction_report116 columnsSyncing

statement_transaction63 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Tiktok Shop (Seller)

Tiktok Shop (Seller)

Data source

Authenticating...

Ready to connect

Overview

Tiktok Shop (Seller) in your warehouse.
Ready for your agents.

TikTok Ads is an advertising platform that allows brands to connect with a younger, highly-engaged audience through short-form video content. Weld's Tiktok Shop (Seller) connector is fully managed: it extracts data from Tiktok Shop (Seller), loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Tiktok Shop (Seller) data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Tiktok Shop (Seller) is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 40
fields: 801
relationships: 25

Loading diagram…

order_statement_transaction

product_performance

seller_affiliate_order

shop_performance

goods_reference_code

fbt_warehouse_id

in_transit_quantity

on_hand_detail_total_quantity

on_hand_detail_available_quantity

on_hand_detail_reserved_quantity

on_hand_detail_unfulfillable_quantity

fbt_inventory_goods_sku

fbt_warehouse_id

on_hand_detail_total_quantity

on_hand_detail_available_quantity

on_hand_detail_reserved_quantity

cancellation_initiator

shipping_provider_id

shipping_provider

payment_currency

payment_sub_total

order_line_items

order_line_items_combined_listing_skus

order_line_items_item_tax

order_recipient_address_district_info

address_level_name

order_statement_transaction

settlement_amount

sales_tax_payment_amount

after_seller_discounts_subtotal_amount

order_sku_statement_transaction

order_statement_transaction_id

settlement_amount

audit_pre_approved_reasons

is_not_for_sale

recommended_categories

listing_quality_tier

price_tax_exclusive_price

external_list_prices

product_skus_inventory

product_sales_regions

product_performance

avg_page_visitors

click_through_rate

product_performance_gmv_breakdowns

product_performance_unit_sold_breakdowns

product_performance_impression_breakdowns

product_performance_page_view_breakdowns

product_performance_avg_page_visitor_breakdowns

product_performance_click_through_rate_breakdowns

product_performance_list

click_through_rate

arbitration_status

return_reason_text

return_order_seller_next_action_response

return_order_line_items

return_line_item_id

order_line_item_id

return_order_sub_line_items

return_sub_line_item_id

return_line_item_id

sub_order_line_item_id

order_line_item_id

return_order_discount_amount

product_seller_discount

shipping_fee_platform_discount

shipping_fee_seller_discount

product_platform_discount

return_order_shipping_fee_amount

seller_paid_return_shipping_fee

platform_paid_return_shipping_fee

buyer_paid_return_shipping_fee

seller_affiliate_order

seller_affiliate_order_skus

settlement_status

open_collaboration_id

target_collaboration_id

creator_username

shop_performance

avg_order_value_amount

shop_performance_gmv_breakdowns

shop_performance_buyer_breakdowns

shop_performance_product_impression_breakdowns

shop_performance_product_page_view_breakdowns

shop_performance_avg_product_page_visitor_breakdowns

sku_performance

adjustment_amount

net_sales_amount

settlement_amount

shipping_cost_amount

statement_transaction

actual_return_shipping_fee_amount

actual_shipping_fee_amount

adjustment_amount

affiliate_ads_commission_amount

affiliate_commission_amount

affiliate_commission_before_pit

affiliate_partner_commission_amount

statement_transaction_report

adjustment_order_id

associated_order_id

estimated_release_time

Open the schema explorer Open the full schema explorer

Models

Tiktok Shop (Seller) models.
What the numbers mean.

Open-source SQL that turns the raw Tiktok Shop (Seller) tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.

Open the models

Weld MCP server

Ask your agent.
It already knows Tiktok Shop (Seller).

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Tiktok Shop (Seller) context, finds the tables it needs and queries your warehouse.

Agent contextTiktok Shop (Seller) tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextTiktok Shop (Seller)tables40fields801joins25

>

How many order_statement_transaction rows do we have per order? Use our Tiktok Shop (Seller) data.

Reading the Tiktok Shop (Seller) context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.tiktok_shop.order_statement_transaction

raw.tiktok_shop.order

+ 38 more Tiktok Shop (Seller) tables

●weld·get_reference_schema

⎿order_statement_transaction · 61 columns

joins order on order_id

●weld·run_query

⎿select j.id, count(*) from {{raw.tiktok_shop.order_statement_transaction}} o

join {{raw.tiktok_shop.order}} j on o.order_id = j.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Tiktok Shop (Seller) data in your warehouse

>Ask about your Tiktok Shop (Seller) dataMCP

Destinations

Load Tiktok Shop (Seller) into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Tiktok Shop (Seller) connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Tiktok Shop (Seller) ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "tiktok-shop",
    "destination_schema_name": "tiktok-shop_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Tiktok Shop (Seller) data to work.

Connect Tiktok Shop (Seller), pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Tiktok Shop (Seller)

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors