How can we help?

Help & FAQs
- Role - Finance
- BigSeller Report -- To realize full data monitoring of goods, stores and shipment
- Introduction to Live Sales Monitor
- Introduction to WMS Monitor
- Introduction to Store Report
- 🔥 [New Update] Introduction to Order Report
- Introduction to Sales Report
- Introduction to Profit Report
- 🔥 [New] How to Add a Custom Column to the Profit Report
- Introduction to Shopee Order Profit Report
- Introduction of Store Profit Report
- Introduction of Order Profit Report - General Template
- Introduction of Merchant SKU Profit Report
- Introduction to Invoicing Report
- Introduction to Merchant SKU Report
- Introduction to Task Report
- How to use Platform Payment Reconciliation (Shopee and TikTok Shop)?
- Profit Analysis for Shopee
- Profit Analysis for Lazada
- Profit Analysis for TikTok
- How to update cost of merchant SKU in profit report list?
- How to use Platform Payment Reconciliation (Lazada)?
- How to edit other fees for store profit report?
- Introduction to Shopee Store Health (Account Health)
- Introduction to Lazada Store Health (Account Health)
- Introduction to Multi-Currency Exchange Rate Settings

Introduction to Sales Report

Copy link & title

Update Time: 21 Nov 2025 02:04

In Sales Report, sales data can be summarized by Store SKU or Merchant SKU. A Reporting Dimension option is available, allowing you to:

Count combination SKUs as a whole, or
Break down combination SKUs by their sub-SKUs.

This makes it easier to view sales data for individual SKUs directly in the system, reducing manual calculation effort. You can also switch currencies when viewing the data, and export the report in the selected currency.

💡 Notes

1. Statistics principle: the order data of the day can only be viewed the next day;
2. Statistics based on:

COD orders are based on order creation time, Pre Paid orders are based on order payment time

3. Supporting platforms: Lazada, Shopee,Tokopedia, Blibli, Tiki,, Shopify, TikTok, Woocommerce, Akulaku, Thisshop, PGmall, Zalora, Facebook, Lineshopping, manual orders, POS retail orders, messenger orders.
4. Order statistics in sales Report do not include unpaid non-COD orders. Orders exported from the Order Processing page (Orders > Order Processing > All Orders) will include unpaid orders. When comparing report data and viewing order details, unpaid orders need to be excluded.

1. Summary by Store SKU

1) Summary Information

You can review summarized sales data according to the specified criteria. Enable Display Chart to display the data in a chart.

Product Quantity: Total Store SKU quantity
Valid Orders: Total Orders - Cancelled Orders - Refunded Orders
Refund Product Amount: the total amount of the refunded orders
Refund Product Quantity: the total number of refunded products
Product Sales: Only the price after deducting product discounts is calculated, excluding shipping fees and other fees
Valid Product Sales: Total Product Sales - Canceled Order Amount
Product Sales Quantity: The total number of products sold
Valid Product Sales Quantity: Sales Quantity - Canceled Quantity

2) Item Sales Information

In Item Sales Information, you can choose to view sales details by SPU or by SKU.

SPU represents the marketplace product-level dimension, where all variants of the same product are aggregated.
SKU represents the marketplace variant-level dimension, showing sales data for each individual variant.

When you choose to aggregate by the SPU dimension, you can click the Detail button to view the sales information of the SKU variants under that product.

You can also export data using Export by Store SPU, Export by SPU, or Export by SKU + Date.
If you select Export by SKU + Date, the system will export the daily store-level SKU sales performance, with each row organized by the specific date.

2. Summary by Merchant SKU

1) Summary Information

You can review summarized sales data according to the specified criteria.

SKU Qty: Total Merchant SKU Quantity
Merchant SKU Sales: Only the discount price is calculated, excluding shipping fee and other fees.
Valid Merchant SKU Sales: Total Merchant SKU Sales - Cancelled Merchant SKU Amount
Merchant SKU Sales Quantity: Total Sales of Merchant SKU
Valid Merchant SKU Sales Quantity: Sales Quantity - Canceled Quantity
Valid Orders: Total Orders - Cancelled Orders, The quantity of valid orders doesn't mean total quantity of valid orders for all Merchant SKUs. For example, if there are two Merchant SKUs A and B in one order, the quantity of valid orders for both Merchant SKU A and B is 1.
Refund Merchant SKU Amount: Merchant SKU Refund Amount
Refund Merchant SKU Quantity: Merchant SKU Refund Quantity

2) Item Sales Information

In Item Sales Information, you can choose to view sales details by SPU or by SKU.

SPU represents the BigSeller SPU-level dimension, where all variants of the same SPU are aggregated.
SKU represents the BigSeller merchant SKU-level dimension, showing sales data for each individual SKU.

💡 Notes
1) If you choose to display data aggregated by SPU, you must manage and maintain Multiple Variations in the Bigseller Inventory Module > Merchant SKU page. An SPU is used to group Merchant SKUs that belong to the same series.
For more details about Multiple Variations, please refer to How to Add Multiple Variations (SPU)
2) if you choose to dispaly data by SPU, you can click drill down to to view or compare the sales performance of individual merchant SKUs under the SPU.

3) BigSeller also supports expanding by platform, store, and warehouse, helping sellers to better compare data and conduct multi-dimensional analysis.

4) Export Data: You can export aggregated data based on SPU or SKU, categorized by platform, store, and warehouse.

Introduction to Sales Report

1. Summary by Store SKU

2. Summary by Merchant SKU

Is this content helpful?