Big Tre ภาษาไทย

Real profit per SKU and per channel

Updated

Real profit per SKU is the price the customer paid, minus the platform's fees, the seller-paid share of vouchers, free gifts, returns, shipping the seller covered and the product's cost. Most Thai online brands see sales per SKU but not this figure, because the fees sit in settlement reports, the cost sits in a spreadsheet or ERP, and the product codes differ between them. Big Tre builds this view as part of its data foundation.

What goes into it

Item Where it comes from
Price paid Order lines from the OMS or marketplace
Commission, service, transaction and payment fees Each platform's settlement report, per order
Seller-funded vouchers and discounts Order and settlement data, split from platform-funded vouchers
Free gifts Order lines at zero price, valued at cost
Returns and failed deliveries Order status and return reports
Shipping paid by the seller Settlement report or carrier invoice
Product cost The brand's cost sheet, purchase orders or ERP
Ad spend (for profit after ads) Ad accounts, when connected

A worked example

Illustrative figures for one unit of one SKU sold on one marketplace, not any platform's actual rates.

Line Baht
Price after the seller voucher 450
Commission, service, transaction and payment fees -60
Seller-paid shipping subsidy -15
Free gift, at cost -20
Product cost -180
Share of returns (5 percent of units returned, cost not recovered) -9
Profit before ads 166
Margin before ads 37 percent of 450

The same SKU on another channel with higher fees and a bigger seller voucher can land at half that margin. The table makes that visible per SKU and per channel.

Where it goes wrong

  • Fees as a flat percentage. Fees vary by platform, category and campaign, and platforms change them. A flat rate hides which products lose money.
  • Platform vouchers counted as discounts. Platform-funded vouchers come back in the payout. Counting them as a cost understates margin.
  • Sets counted as one product. A set must be split into its items, both for cost and for stock.
  • Different product codes. Without one mapping, the same product's sales on Shopee and TikTok cannot be added up.
  • Cost of goods from last year. Margin is only as good as the cost behind it.

What the result looks like

A table of every SKU by channel with units, sales, fees, discounts, cost and margin, refreshed daily. The same product's margin on Shopee, Lazada, TikTok Shop and the web store side by side shows where to spend and where to raise prices. Profit after ad spend is shown only once ad accounts are connected, and shown as blocked until then.

Questions the team can then ask

Through the AI data analyst: "which SKUs lost money last month after vouchers", "what did the 11.11 campaign earn after discounts", "if the seller voucher drops from 10 to 5 percent, where is break-even".

Start with the free Health Check or write to hello@bigtre.business.