Introduction of Merchant SKU Profit Report

Merchant SKU Profit Report helps sellers quickly assess the profitability of each SKU, providing a basis for cost optimization and profit improvement decisions. It displays the profit for Merchant SKUs across Shipped, Completed, and Canceled orders.

• BigSeller's order profit only displays orders released by the platform.
• Canceled orders may still incur adjustment fees, so orders with a canceled status (and non-zero settlement data) will also be included in the profit report.

1. Field Introduction

2) Total Cost (Total Shipping Cost of Merchant SKU) = Merchant SKU Cost × Sales Quantity

• Merchant SKU Cost
  • If the order is processed in BigSeller, the value is based on your settings in [Order Settings > Cost Settings > Merchant SKU Cost Settings]
  • If the order is not processed in BigSeller, the value is based on the Merchant SKU Reference Price.
• Sales Quantity
  • If no return/refund, it equals the total quantity sold.
  • If returned/refunded, the return quantity will be deducted from the sales quantity.

3) Profit

• Profit = Merchant SKU Revenue-Total Cost (The total profit of the SKU within the selected time period.)
• Profit Rate =  Profit / (Merchant SKU Sales + Platform Subsidy) x 100%
• Single Merchant SKU Profit = Profit/Sales Volume

• Determined by Store ID + Order Number + SKU Name. (Example: If the same order contains two or more of the same SKU, it counts as 1 order only.)

5) Sales Volume: Total sold quantity of the store SKU linked to the merchant SKU, based on order data within the selected filters.

6) Return SKUs: The quantity of merchant SKUs returned in orders. (Not supported for manual orders.)

 

7) Return Rate: For Shopee/Lazada/TikTok: Return Quantity ÷ Sales Quantity × 100%. (Not supported for manual orders.)

8) Merchant SKU Total Sales: Product sales after discounts and promotions

• Shopee/Lazada/TikTok: The Product Subtotal of the store product corresponding to the Merchant SKU
• Manual Orders: The sales amount entered when creating the manual order; if not provided, defaults to 0.

9) Subsidy for Discount & Promotion (Shopee, TikTok only)

• Platform subsidies to sellers after offering discounts and vouchers to buyers. The cost is allocated to each item based on discount price.

10) Shipping Fee
 

• First allocated by weight (using SKU outbound weight).
• If SKU weight = 0: allocated by discount price (manual orders use total product price).
• Gift Products are excluded.

• First allocated by weight (using SKU outbound weight).
• If SKU weight = 0: allocated by discount price (manual orders use total product price).
• Gift Products are excluded.

11) Platform Charges


a. Commission: Platform commission charged to the seller, allocated by discount price across items.

b. Transaction Fee: Transaction fee charged by the platform upon settlement, allocated by discount price across items.

c. Service Fee (Shopee only): Special service fees charged by the platform, allocated by discount price.

d. Marketing Fee (Lazada only): Includes Free Shipping Max Fee and Sponsored Affiliates, allocated by discount price.

e. Refund Amount: Amount refunded to buyers upon return/refund.

• Since product-level data is unavailable from the API, this amount is distributed across returned SKUs based on return quantity. Free gifts are excluded.
• Allocation formula: (Returned Qty of SKU ÷ Total Returned Qty) × Refund Amount.

f. Other Platform Fees: Includes platform adjustments, compensation, and other fees. Allocated by discount price across items.

12) Definition of Time Fields

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. Allocation Method– Definition & Explanation

 

3. Notes