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
- 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 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 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

🔥 [New] How to Add a Custom Column to the Profit Report

Copy link & title

Update Time: 30 Sep 2025 03:33

[New Feature] BigSeller now supports adding custom columns in the Profit Report. This allows you to create your own KPIs based on what matters most without waiting for new built-in fields.

1. Where You Can Use This Feature

You can add custom columns on the following pages: Order Profit, Store Profit, and Merchant SKU Profit. Within these pages, you can create your own metrics by performing basic calculations (add, subtract, multiply, divide) using existing fields.

2. Step-by-Step Guide

Step 1: Go to the Profit Report Page. Open one of the following: Order Profit, Store Profit, or Merchant SKU Profit.

Step 2: Click Add Custom Column. This button allows you to create a new custom field.

Step 3: Fill in the Template Information. When adding a custom column, you can configure:

Calculation Result Format: keep two decimal places, keep whole numbers, or show as a percentage
Display Position:
- Show at the beginning of the list (After the BigSeller Store Nickname)
- Show at the end of the list (Before Order Status)
Define Your Calculation Rules. Enter a formula based on existing fields.

💡 Exemplary Use Cases for Custom Columns

1. Custom ROI Calculation

Scenario: You want to measure the true return on investment for an SKU or order, including platform promotion subsidies.
How to do it: Create a custom column “Custom ROI” with the formula:
(Product Sales + Subsidy for Discount & Promotion) / (Merchant SKU Cost + Commission Fee + Transaction Fee + ....)\

2. Net Profit Analysis

Scenario: You want to calculate the net profit of each order after accounting for product cost and manual handling costs.
How to do it: Create a custom column “Net Profit” with the formula:
Order Revenue – Merchant SKU Cost – Labor Cost Per Order

Step 4: After saving, your new column will appear in the list view with the calculated values. You can edit or delete a custom column any time if your metrics change.

💡 Notes

1. You can create up to 10 custom columns per BigSeller account.
2. The added custom column is visible to all account holders with permission to access the page; it is not restricted to the creator alone.

2. When exporting the Profit Report, data in custom columns is generated according to the latest calculation formula.

🔥 [New] How to Add a Custom Column to the Profit Report

1. Where You Can Use This Feature

2. Step-by-Step Guide

▶ Video Tutorial

Is this content helpful?