The system will summarize profit data by order, and you can view the profit of each order.
 
💡 Notes
1. Profit report only counts shipped, completed and canceled orders.

 2. Orders not processed in BigSeller are also available in profit report, but you need to maintain the reference price first. If you neither process orders in BigSeller nor maintain reference price, the cost of merchant SKUs in orders will be 0.
3. Return Order: After orders are moved to the After Sales Orders list and the returns stock-in is completed, their order cost in the profit report will be set to 0.
4. How to update costs of merchant SKU in profit report?




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

1. Field Introduction

1. Order No: the order number of your order. Same with the one in the Seller Center

2. Order Revenue: The settlement amount of orders. For Shopee it corresponds to "Final Amount" in the bill, for TikTok it corresponds to "Total settlement amount" in the bill (including adjustment fees), and for Lazada it corresponds to "Amount released" in the bill.

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

💡 Notes

1) The Value of  [Stock Out/In Price]:

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




3) If you need to update the Merchant SKU Cost, you can manually update it directly on the Order Profit Report page or import a spreadsheet for the update. 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)

7. Platform Subsidy 8. Platform Charges:

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 Creation Date." Manual orders also use this as the order time.

Confirm Time:

Release Time:

Platform Completion Time in BigSeller:



💡 Tips: In order profit report, you can select the display fields, drag to adjust the column order, and freeze certain columns on the left.

2. FAQs

Q1: How to search for orders?
A1: You can search orders by platform, store, order mark, order time(order time, release time and completed time), order number.

1) Order Mark: the mark you added when processing orders. 👉 Learn More

2) Order Time: Prepaid order is the payment time of the order, COD order is the creation time of the order.

3)  Release Time:

4) Completed Time:



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



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

Initialize data statistics when the feature is launched (your store has authorized BigSeller)
Shopee: BigSeller will sync orders from previous 30 days and count the profit for completed orders;
Lazada: BigSeller will sync orders from previous 30  days and count the profit for Delivered, Return Or Refund, Lost & Damaged orders;

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;