Introduction of Order Profit Report - General Template

The system will summarize profit data by order, and you can view the profit of each order.
 



Supported marketplaces(General Template): Shopee, Lazada, Tiktok Shop, Tokopedia, Facebook, manual orders, POS retail orders, messenger orders.

1. Field Introduction

3. Cost of Merchant SKU: Total cost price of merchant SKUs within the order. (Cost of merchant SKU = stock out qty * stock out cost)

1) If the order is packed in BigSeller, the value is taken based on the Merchant SKU Cost Settings;

• If the order is not packed in BigSeller, system will quote the Reference Price of the Merchant SKU as the cost;
• For Return Orders: Merchant SKU Cost = Total Stock-Out Price –  Stock-In Price of the returned SKUs.

2) You can check the Stock-Out/In Price in the Inventory > Stock Movement.




3) Since the order cost is based on the cost at the time of stock-out, you can manually update it if needed.
To update the Merchant SKU Cost, you can either adjust it directly on the Order Profit Report page or import a spreadsheet.
How to update cost of merchant SKU in profit report list?




4. Profit/Loss: the profit/loss of this order. (Order Profit = Order Revenue - Cost of Merchant SKU)



5. Profit Rate = Profit / (Product SKU Sales + Platform Subsidy) x 100%


6. Order Value: the amount actually paid by the buyer for this order; ( = Product Sales + Shipping Fee paid by buyer)

• Product Sales: Product sales after discounts and promotions, where Shopee corresponds to "Product Price" in platform statements and TikTok corresponds to "Subtotal after seller discounts" in platform statements.
• Shipping Fee Paid By Buyer: Actual shipping fee paid by buyer (Tokopedia shipping fee paid by buyer is paid to platform directly and is not calculated to the order value, so all are displayed as 0)

7. Platform Subsidy

• Subsidy for Discount & Promotion (Shopee Only): Discount and voucher amounts correspond to the “Voucher & Subsidy Shopee” (Seller Voucher + Shopee Discount) in the platform statement.

8. Platform Charges:

• Commission Fee: The commission charged by the platform to sellers based on a percentage. The main commission types for each platform are as follows.

  • Shopee: Platform Commission, Affiliate Marketing Commission

  • TikTok: Platform Commission, Fixed Order Commission, Marketing Commission, Influencer Commission

  • Lazada: Lazada Commission, YouPik Commission, etc.

• Transaction Fee: transaction fee for platform fund settlement;

• Service Charge: only support Shopee and TikTok, special service fees charged by the platform to sellers; for Shopee, this is the sum of the Service Fee and Overseas Return Service Fee shown on the corresponding bill.

• Shipping Fee Paid By Seller: actual shipping fee paid by seller, corresponding to the Shipping Subtotal in the Shopee bill.

• Merketing Fees: The marketing-related fee charged by the platform. This fee is distributed across all products.

  • Shopee: It corresponds to the Campaign Fee in the bill;

  • Lazada:. The sum of Sponsored Affiliates and Free Shipping Max Fee

  • TikTok: It corresponds to the Marketing Fee in the platform statement;

• Buyer Refund Amount: the fee refunded to the buyer when the order return or refund is completed.

9. Other Fee: including platform fee adjustments, compensation and all other fees;

10. Definition of Time Fields in Orders

Order Time: Based on order creation time; matches the platform's "Order Create Time". Manual orders also use this as the order time.

Confirm Time:

• Online orders: Prepaid uses payment time; COD uses order creation time.

• Offline orders: Manual orders use order time; POS/messenger orders use order creation time.

Release Time:

• Non-platform orders: Use shipped time.

• Shopee/TikTok: Use settlement time.

• Lazada: Use transaction time.

Platform Completion Time in BigSeller:

• Shopee/TikTok: When status changes to Completed.

• Lazada: When status changes to Delivered / Confirmed / Return or Refund / Lost & Damaged.

• Manual orders: When moved to [Shipped > Shipped].
  

2. FAQs

Q1: How can I check the order revenue in Seller Center?
A1: You can check the order revenue in Shopee/Lazada Seller Center as shown in the following images.

• Shopee Order Revenue

• Lazada Order Revenue

• TikTok Shop Order Revenue

Q2: How many days of historical order data will the profit report synchronize?

A2:
Initialize data statistics after the feature is launched (new authorized stores)
Shopee: BigSeller will sync orders from previous 14 days since the authorization day and count the profit for completed orders;
Lazada: BigSeller will sync orders from previous 30 days the authorization day and count the profit for Delivered, Return Or Refund, Lost & Damaged orders;