Skip to content
+

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

MetricHow it is computed
Contribution margin by marketplaceNet 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 rateMarketplace fees ÷ net revenue, per marketplaceTaken from Shopee escrow and TikTok Shop settlement transactions.
Return rate by marketplaceReturned orders ÷ valid orders
Provisional fee rateProvisional 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.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Marketplace feesMarketplace commission and service 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
Return rateReturned orders divided by valid orders.= returned_orders / Valid 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 (%)

Compared on one definition

MetricShopee sourceTikTok Shop source
Net revenueOrders and order lines after vouchers and returnsOrders and order lines after discounts and returns
Marketplace and payment feesEscrow settlement per orderSettlement statements and transactions
ReturnsReturns streamReturns stream
ProductsProduct catalogProduct catalog

Steps

  1. 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. 2

    Connect Shopee

    Click Connect with Shopee, sign in to your seller account and grant read access; no password to paste.

  3. 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. 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 TikTok Shop and Shopee in minutes

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