Skip to content

E-commerce

Connect TikTok Shop to DataxLand

DataxLand's own TikTok Shop connector reads your shop's orders, order lines, payment statements and every transaction in them, returns and products through the TikTok Shop Open API. You click "Connect with TikTok Shop" and sign in to your seller account; no key to paste. DataxLand puts revenue from lives and videos next to the real platform fees, payment fees and refunds in the statements, so TikTok Shop net revenue and profit after fees use the same definitions as Shopee, Lazada and your other channels.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with TikTok Shop

  • See how much a TikTok Shop order is really worth after platform fees, payment fees and returns.
  • Compare net revenue, cancellation and return rates of TikTok Shop with Shopee and Lazada each week.
  • Combine with TikTok Ads to put ad spend next to the revenue you actually receive.
  • Get a weekly Telegram report of profit after fees by channel.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
ordersOrders, status, created and updated times, seller and platform discounts.
order_itemsOrder lines by SKU, quantity and discounted price.
statementsPayment statements per period - revenue, fees and payout.
statement_transactionsEach transaction in a statement, tied to an order, with fee types and adjustments.
returnsReturn requests, refunds and refunded amounts.
productsProducts and SKUs, to join with your cost table.

Connection details

Sign-in methodSign in with your account (OAuth), no password to paste
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Data readorders, order_items, statements, statement_transactions, returns, products
DeveloperDataxLand
LicenseMIT
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Provisional fee rateShare of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost)Ratio (%)

Connect TikTok Shop in 3 steps

  1. 1

    Connect with TikTok Shop

    In the workspace choose Add source → TikTok Shop, click Connect with TikTok Shop, sign in to your seller account and grant read access.

  2. 2

    Choose streams and start date

    Keep the six default streams and pick a start date. Buyer columns are marked for hashing on load.

  3. 3

    Review Si's proposal

    Si maps orders, statements and returns to the standard retail model; you check the highlighted parts, approve and build.

Limits and caveats

  • TikTok Shop data has no product cost; add a cost table from Excel or Google Sheets for contribution margin.
  • TikTok ads (TikTok Ads Manager) are a separate connector; add TikTok Ads for true ROAS.
  • Fees of orders not yet in a statement are flagged as provisional until the statement arrives.
  • The connection goes through DataxLand's app on TikTok Shop Partner Center; if the button is not open for your account yet, start with a Seller Center Excel export.

Frequently asked questions

Does DataxLand change anything in my shop?

No. The connector only reads; DataxLand never edits orders, prices or products.

Is buyer information stored?

Personal-data columns are hashed on load and masked before they reach Si; no API, dashboard or MCP tool returns them.

How often is data refreshed?

On the workspace schedule; orders, returns and products load incrementally by update time, so later runs are faster than the first.

Dashboard templates that use this source

Ask Si about your TikTok Shop data →TikTok Shop + Google Sheets →TikTok Shop + Facebook Marketing →TikTok Shop + Shopee →TikTok Shop + TikTok Marketing →All data sources →

Connect TikTok Shop and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes