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 |
|---|---|
| orders | Orders, status, created and updated times, seller and platform discounts. |
| order_items | Order lines by SKU, quantity and discounted price. |
| statements | Payment statements per period - revenue, fees and payout. |
| statement_transactions | Each transaction in a statement, tied to an order, with fee types and adjustments. |
| returns | Return requests, refunds and refunded amounts. |
| products | Products and SKUs, to join with your cost table. |
Connection details
| Sign-in method | Sign in with your account (OAuth), no password to paste |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Data read | orders, order_items, statements, statement_transactions, returns, products |
| Developer | DataxLand |
| License | MIT |
| Technical docs | Connector 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.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line 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 orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Marketplace fees | Marketplace commission and service fees, allocated to lines by line revenue. | Currency |
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
| Contribution margin | Net 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 cost | Currency |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Cancellation rate | Cancelled orders divided by total orders.= cancelled_orders / all_orders | Ratio (%) |
| Provisional fee rate | Share 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
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
Choose streams and start date
Keep the six default streams and pick a start date. Buyer columns are marked for hashing on load.
- 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
Connect TikTok Shop and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes