Combine TikTok Shop with Shopee to compare real profit across both marketplaces
When you sell on TikTok Shop and Shopee at the same time, each marketplace has its own reports, fee rules and settlement cycle: Shopee has an escrow settlement per order, TikTok Shop has settlement statements and transactions. Put the two reports side by side by hand and revenue, fees and returns do not share a definition. DataxLand maps both into one standard retail model, so net revenue, marketplace fees, payment fees, return rate and contribution margin use the same formula for each marketplace, each product and each day. You learn which marketplace really earns more, not just which one sells more.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Different fee levels and vouchers give the same product very different margins on each marketplace.
- Settlement cycles do not line up; DataxLand marks provisional fees so you never compare settled numbers with unsettled ones.
- One net revenue definition for every channel is the condition for a fair comparison and for Si to answer correctly.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Contribution margin by marketplace | Net revenue − cost of goods − marketplace fees − payment fees − seller-paid shippingNeeds product cost; where cost is missing, COGS coverage shows how much revenue has no cost yet. |
| Marketplace fee rate | Marketplace fees ÷ net revenue, per marketplaceTaken from Shopee escrow and TikTok Shop settlement transactions. |
| Return rate by marketplace | Returned orders ÷ valid orders |
| Provisional fee rate | Provisional fees ÷ total feesShows how much of the period's fees the marketplace has not settled yet. |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Marketplace fees | Marketplace commission and service 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 |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid 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 (%) |
Compared on one definition
| Metric | Shopee source | TikTok Shop source |
|---|---|---|
| Net revenue | Orders and order lines after vouchers and returns | Orders and order lines after discounts and returns |
| Marketplace and payment fees | Escrow settlement per order | Settlement statements and transactions |
| Returns | Returns stream | Returns stream |
| Products | Product catalog | Product catalog |
Steps
- 1
Connect TikTok Shop
Click Connect with TikTok Shop, sign in to your seller account and grant read access to orders, settlements, returns and products.
- 2
Connect Shopee
Click Connect with Shopee, sign in to your seller account and grant read access; no password to paste.
- 3
Review Si's mapping
Si maps orders, order lines, settlements and returns from both marketplaces into the standard model and asks about anything unclear; you approve.
- 4
Build and read the dashboards
The Sales channels and P&L overview dashboards compare both marketplaces side by side; ask Si which products make money on one but lose on the other.
Frequently asked questions
Is the same product listed on both marketplaces merged?
Yes, when both marketplaces use the same SKU code or you declare a code mapping table. Si proposes how codes match during review; codes that cannot be matched are kept separate and reported to you.
Are this week's fees accurate?
Fees on settled orders are the marketplace's real numbers. Unsettled orders use provisional fees and are marked, so the provisional fee rate shows which numbers can still change.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect TikTok Shop →Connect Shopee →Ask Si about your TikTok Shop data →Ask Si about your Shopee data →
Other combinations
- Combine Google Sheets with TikTok Shop: costs that update themselves
- Combine TikTok Shop with Facebook Ads when Meta ads send buyers to TikTok
- Combine TikTok Shop with TikTok Ads to know whether your ads make money
- Combine an Excel cost file with Shopee to see real profit per product
- Combine Freshdesk with Shopee to manage customer support by order
- Combine Shopee with Facebook Ads to see your blended ROAS
Combine TikTok Shop and Shopee in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes