How is order profit calculated?
Profit = order income − product cost: order income is what the platform settles to the store (commission, service fees, etc. already deducted), and product cost is the units not cancelled × unit cost, 0 when no cost is set. Margin = profit ÷ (product sales + platform subsidy).
In short
Profit = order income − product cost
Margin = profit ÷ (product sales + platform subsidy) × 100%; shows -- when the denominator is 0
Order income
What the platform settles to the store: product sales + platform subsidy + platform fees + other fees. Platform fees (commission, transaction fee, service fee, seller-paid shipping, refunds) are negative, so order income already has them deducted.
Product cost
- Units not cancelled × unit cost. Costs are in CNY and converted to the selected currency at the order day's rate.
- Shipped units use the cost fixed at shipping; units not yet shipped are estimated by the "product cost source" setting.
- Products without a cost count as 0, which makes profit look higher, so set costs first.
Which day does an order count on?
It follows the time type in the filters, always in each store's local date:
- Order time (default): the day the order was placed.
- Confirmed at: the payment day for prepaid orders, the order day for cash on delivery; prepaid orders not yet paid do not appear.
- Settled at: the day of each platform settlement, one row per settlement (an order settled twice has two rows, each with that settlement's amounts).
- Payout time: the day that settlement's money reached the store, also one row per settlement; settlements not paid out yet do not appear.
With one row per settlement, the order's product cost and units sit on its earliest settlement, so the rows add up to the order total; unsettled orders have no settlement time and do not appear. Either way, amounts are converted at the order day's exchange rate. The default runs from 30 days ago to today; the change on cards compares with the period of the same length right before.