What is this page?
The Sales & Profit page breaks down your financial performance at the product level. While the Dashboard gives you a shop-wide overview and the Profit & Loss shows a full financial statement, this page lets you see exactly how much revenue, profit, and margin each individual product generates -- helping you identify your winners and underperformers.
Key Metrics on This Page
This page shows both a Shop Summary (aggregate metrics across all products) and a per-product table with the same metrics broken down by product.
Gross Sales
- What it shows: Total revenue from product sales before any discounts, for each product.
- Formula: Sum of (Original Price x Quantity) for each item sold
- Example: You sold 50 units of Product A at $30 each. Gross Sales for Product A is $1,500, regardless of any discounts you offered.
- Important: Uses the full original price, not the discounted amount. See Revenue Metrics.
Net Sales
- What it shows: Revenue after subtracting seller discounts, per product.
- Formula: Product Sales - Discounts
- Example: Product A has $1,500 in Product Sales and $200 in Discounts. Net Sales = $1,300. Shipping revenue is tracked separately.
- Important: Discounts here are seller-initiated discounts only. TikTok platform discounts (co-funded promotions) are tracked separately.
Cost of Goods Sold (COGS)
- What it shows: The total cost of products you sold during the selected period, per product.
- Formula: Unit Cost x Units Sold (per product/SKU)
- Example: Product A has a unit cost of $8 and you sold 50 units. COGS = $400.
- Important: You must set your unit cost in the Inventory page. If COGS is not set, it will show as $0 and Gross Profit will equal Net Sales. If you use FIFO Cost Tracking, the cost per unit is based on your purchase history rather than a single fixed cost.
Gross Profit
- What it shows: Revenue remaining after subtracting the cost of goods, per product.
- Formula: Net Sales - COGS
- Example: Product A has $1,375 Net Sales and $400 COGS. Gross Profit = $975.
- Important: This does not include fees, shipping costs, or commissions. For a complete profit picture per product, look at Operating Profit.
Operating Profit
- What it shows: Your actual profit per product after all operational expenses are deducted.
- Formula: Gross Profit + Manual Income - Shipping Costs - FBT Fees - Platform Fees - Affiliate Commissions - Sample Costs - Refunds & Returns - Manual Expenses
- Example: Product A has $975 Gross Profit, but $50 in platform fees, $30 in shipping costs, $25 in affiliate commissions, and $15 in refunds are allocated to it. Operating Profit = $975 - $50 - $30 - $25 - $15 = $855.
- Important: This is the most comprehensive per-product profitability metric. Shop-level expenses (like platform fees and shipping costs) are distributed proportionally across products based on their share of revenue.
Product Profit
- What it shows: Your final per-product bottom-line profit after all product-specific expenses, platform subsidy, and ad spend. This is the most complete profitability metric at the product level.
- Formula: Operating Profit + Platform Subsidy - Ad Spend
- Example: Product A has $855 Operating Profit, received $40 in Platform Subsidy from TikTok co-funding, and had $60 in ad spend allocated to it. Product Profit = $855 + $40 - $60 = $835.
- Important: Product Profit excludes shop-level manual adjustments that are not bound to a specific product. If you need to see the full picture including all adjustments, check the shop-wide Net Profit on the Dashboard or Profit & Loss page.
Margin
- What it shows: What percentage of revenue you keep as gross profit, per product.
- Formula: (Gross Profit / Net Sales) x 100
- Example: Product A has $975 Gross Profit and $1,375 Net Sales. Margin = 70.9%. That means you keep about $0.71 of every dollar of net sales for Product A.
- Important: Products with no sales will not show a margin value. A product with 0% Margin means your product cost equals your revenue -- you are breaking even before any other expenses.
ROI (Return on Investment)
- What it shows: How much operating profit you earn per dollar of inventory cost, per product.
- Formula: (Operating Profit / COGS) x 100
- Example: Product A has $855 Operating Profit and $400 COGS. ROI = 213.8%. That means you earn $2.14 in operating profit for every $1 spent on Product A.
- Important: Requires COGS to be set. Helps you compare the return on your investment across different products, even if they have different price points.
Units Sold
- What it shows: Total number of individual items sold for each product.
- Important: Counts individual items, not orders. A single order with 3 units of Product A counts as 3 units for Product A.
Refunds & Returns
- What it shows: Dollar value of refunds issued for each product.
- Important: Includes product refunds and the financial impact of cancelled orders. Shown as a negative value because it reduces your profit. Refunds are attributed to the date they were processed (completion date), not the original order date.
Features
Shop Summary Cards
A row of configurable metric cards at the top showing aggregated metrics across all products. These show the same total values you would see on the Dashboard for the same date range. Click "Configure Metrics" to choose which metrics to display. Available metrics include:
- Revenue: Gross Sales, Net Sales, GMV, GMV (with TikTok Co-funding)
- Profit: Net Profit, Margin
- Costs: Ad Spend, Gross Ad Spend, Ad Credits, Shipping Fees, Net Shipping, Platform Subsidy
- Affiliates: Affiliate Ads, Affiliate Expenses, Affiliate Sales Commission
Table View and Card View
Switch between two display modes using the toggle in the top right:
- Table View (default) -- a detailed spreadsheet with all metrics, sortable columns, and search. Best for in-depth analysis.
- Card View -- products displayed as visual cards with key metrics (Gross Sales, Product Profit, Margin, ROI, Orders, Units). Best for a quick visual scan of your product lineup.
Click any product in either view to open its detail page.
Include Sample Costs
A toggle above the table lets you include or exclude sample order costs. When enabled, five additional columns appear: Sample COGS, Sample Shipping, Sample Fees, Sample Orders, and Sample Units. This helps you see the full cost of your influencer sampling program per product. Your preference is saved across sessions.
Time Period Selector
Quick tabs let you switch between Today, Yesterday, Last Week, or a custom date range. The custom date range supports selecting any start and end date.
Preliminary Data Warning
When viewing today's data or very recent orders, a warning banner may appear indicating the data is preliminary. This means some orders in the period have estimated fees (Tier 3 data). Complete financial data (exact fees and settlement amounts) becomes available after TikTok processes the orders, typically within 7-14 days. Revenue figures are accurate from the start -- only fees refine over time.
Summary By Product
The main section below Shop Summary lists every product with its metrics. Features include:
- Search -- find products by name or SKU
- Sorting -- click any column header to sort ascending or descending
- Product drill-down -- click a product row to open the full product detail page with time-series charts and SKU-level breakdown
- Export -- download the table as CSV for external analysis
The table columns are grouped by category:
- Revenue: Gross Sales, Net Sales, Discounts
- Cost & Profit: COGS, Gross Profit, Operating Profit, Product Profit
- Ratios: Margin, ROI
- Volume: Orders, Units
- Fees: FBT Fees, Ad Spend
- Manual Adjustments: Manual Income, Manual Expenses, FBS Manual Shipping, Net Manual Adjustment
- Affiliates: Affiliate Ads, Affiliate Ads Orders/Units, Affiliate Sales Orders/Units
- Refunds: Gross Sales Refund, Other Refund Costs, Returned Refunds, Refund Orders/Units
Some columns (Platform Subsidy, Affiliate Sales Commission, Cancelled Orders) are hidden by default -- expand column groups to reveal them.
Product Detail Page
When you click on a product, you see:
- Time-series charts showing how the product's metrics changed over the selected period
- SKU-level breakdown for products with multiple variants (sizes, colors, etc.)
- All the same metrics (Gross Sales, Net Sales, COGS, Gross Profit, etc.) broken down by each SKU
Configure Metrics
The "Configure Metrics" button lets you choose which metric cards appear in the Shop Summary section. Your selections are saved and persist across sessions.
Export
You can export the product table data for external analysis. This is useful for creating custom reports or sharing product performance data with your team.
How Per-Product Expenses Work
Some expenses in Dashboardly are tracked at the shop level (not per-product), such as platform fees, shipping costs, and affiliate commissions. To show a meaningful Operating Profit per product, these shop-level expenses are distributed proportionally across products based on each product's share of total revenue.
Example: If Product A makes up 30% of your total revenue and the total platform fees are $1,000, then $300 in platform fees is allocated to Product A.
This proportional distribution means:
- The sum of all per-product Operating Profits equals the shop-wide Operating Profit
- Very small rounding differences (less than $0.01) can occasionally occur due to mathematical rounding
- Products with higher revenue absorb a larger share of shop-level expenses
Common Questions
Why does a product show $0 for COGS and Gross Profit equals Net Sales?
You have not set the Cost of Goods for that product. Go to the Inventory page, find the product, and enter your unit cost. Once set, COGS and Gross Profit will calculate automatically. See Setting Up Cost of Goods (COGS) for step-by-step instructions.
Why do per-product numbers not add up to the shop total exactly?
Shop-level fees (like platform fees and shipping costs) are distributed proportionally across products based on their revenue share. Mathematical rounding can cause tiny differences (typically less than $0.01). Additionally, some expenses like manual adjustments may be applied at the shop level and distributed proportionally.
Why is today's data labeled "preliminary"?
When an order first comes in, Dashboardly uses estimated fee values based on your shop's historical average fee rate. As TikTok processes settlements (usually within 7-14 days), the exact fee amounts replace the estimates. Revenue figures (Gross Sales, Net Sales) are accurate from the start -- only fees and cost allocations refine over time.
Why is my Operating Profit lower than expected for a product?
Operating Profit includes many deductions that are not visible in simpler metrics: TikTok platform fees, affiliate commissions, shipping costs, FBT fulfillment fees, refund costs, and sample order expenses. These are distributed proportionally by revenue share. A product with high revenue will absorb a larger share of shop-level expenses. Check the Profit & Loss page for a detailed breakdown of every expense category.
How does COGS work for products with multiple SKUs?
Each SKU can have its own unit cost. When you set costs at the SKU level, COGS is calculated per-SKU and then summed for the product. If a product has variants (sizes, colors, etc.) with different sourcing costs, setting per-SKU costs gives you the most accurate profit picture.
Why do refund numbers differ between this page and the P&L?
Both pages use the same data. However, if you are comparing a specific product's refunds on this page to the total refunds on the P&L page, remember that the P&L shows all products combined. The refund values on this page are attributed to individual products based on the actual items that were refunded.