The system will only grab the data of the past 7 days on the second day after the shop has been authorized.
For example, You authorized the store on November 9. Our system will start counting the data of the previous 7 days at 00:00 on November 10 (that is, the data on November 3, November 4, November 5, November 6, November 7, November 8, and November 9).
Please confirm whether you have ever modified the product price or set a promotional price. If not, please contact us.
Because the system doesn't run data in real-time but will only do this in the early morning, around 1:00 am. And due to the delay of the API interface feedback, orders on the previous day may have not been fully synchronized from the marketplace to Bigseller. If you encounter this situation, we suggest you check the data the next day.
For example: after the 11.11 big promotion, the number of orders on November 12th may be wrong. It is recommended that you check the data again on November 13th.
If does, the same order number will correspond to multiple tracking numbers. One tracking number will be counted as one package when the system calculates the Outbound Package Qty.
1.Function
In the dimension of Merchant sku, Bigseller calculates the profit of shipped orders in sequence of order time.
2.Notes
(1)Only Shopee, Lazada, Tiktok shop and manual orders supported at present.
(2)Statistic of return orders includes Before signing under Return Manage.
(3)For orders processed outside Bigseller, reference price of Merchant sku is necessary for profit report, otherwise the cost of orders will show as 0.
(4)Default display orders in latest 30 days, you can trace orders up to 366 days ago.
(5)Exported excel contains 3000 pieces of data at most, a compressed package will be exported if beyond. Merchant sku name and product title will be exported, pics will not.
3.Formula & Terms
Formula:
Profit= Revenue- cost
Gross profit margin= Profit/ Product sales* 100%
Return rate= Return quantity/ Sales volume* 100%
Terms:
Merchant sku: Information including title, sku and pics
Profit: Total profit of this Merchant sku within selected time range. Profit= Revenue- cost
Commodity cost: Cost of Merchant sku. If the stock-in cost> 0, Merchant sku cost will be calculated. If stock-in cost= 0, reference price of Merchant sku will be calculated. If both Merchant cost and reference price= 0, then the cost is 0.
Gross profit margin: Gross profit of Merchant sku. Gross profit= Profit/ Product sales* 100%. If the sales price is 0, gross profit shows “-”.
Sales quantity: The total sales quantity of this sku within selected time range
Average profit: Profit/ Sales quantity
Order quantity: Order quantity related to this sku within the selected time range. Judged by order number, if one single order contains 2 or more of this sku, this order quantity counts as 1.
Return quantity: - Shopee/ Lazada: includes Merchant sku stocked in before signing. Not suitable for manual orders.
Return rate: - Shopee/ Lazada: Return quantity/ Sales volume* 100%. Not suitable for manual orders.
Product sales: - Shopee/ Lazada: Sum of sales price of the corresponding product of the Merchant sku. For manual orders, the sales price you entered when created this manual order will be adopted, 0 if no.
Shipping fee paid by buyer: - Shopee/ manual orders: Allocate to every Merchant sku of the order in the proportion of the net weight of Merchant skus. No allocation required for a single SKU.
- Lazada: Data grabbed from Lazada.
Shipping fee of seller: - Shopee: Allocate to every Merchant sku of the order in the proportion of the net weight of Merchant skus. No allocation required for a single SKU.
- Lazada: Data grabbed from Lazada.
- Manual orders: No shipping fee calculated.
Service charge: - Shopee: Seller transaction fee+ commission+ Tax( allocate by discount price)
- Lazada: Data grabbed from Lazada.
- Manual orders: No service charge calculated.
Seller coupon: - Shopee: Coupons provided by seller.
- Lazada: Data grabbed from Lazada.
- Manual orders: No Seller coupon calculated.
Return amount: No return amount calculated for manual orders.
Other: - Shopee: Coins subsidy( allocate by discount price)
- Lazada: All income not belonged to any of the above expenses shall be counted as other
4.Initial statistic upon launch
By the first launch of this feature(1.22, 2022), if your shop had been authorized to Bigseller,
Shopee: Collect orders within 30 days and analyze the completed orders.
Lazada: Collect orders within 30 days and analyze delivered, return or refund, lost& damaged orders.
Shops authorized after launch of feature,
Shopee: Collect orders within 14 days and analyze the completed orders.
Lazada:Collect orders within 30 days and analyze delivered, return or refund, lost& damaged orders.
① Take the item's stock cost: system will take the cost price of the merchant SKU by default. If the cost price is 0, it is taken as 0.
② Take the item's reference price: system will take the reference price of the merchant SKU by default. If the reference price is 0, it is taken as 0.
③ Stock cost is optimized taken, if it's 0 then reference price will be taken: system will take the cost price of merchant SKU. If the cost price is 0, the reference price is taken; If the reference price is 0, it is taken as 0.
