Sales & Profit

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 product price, not the discounted amount. Gross Sales is merchandise-only and does not include customer-paid shipping; shipping is tracked separately. 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 real operational profit for each product after all operational expenses. At the shop level this figure is anchored to your TikTok settlement (the amount actually deposited once orders settle, net of TikTok’s fees); each product then receives its proportional share. Before orders settle, it is an estimate built from the fee components.
**What’s inside it (breakdown): **For each product, Operating Profit covers Gross Profit plus Manual Income, less Shipping Costs, FBT Fees, Platform Fees, Affiliate Commissions, Sample Costs, Refunds & Returns, and Manual Expenses. Shop-level costs are distributed proportionally by each product’s share of revenue.
**Example (illustrative breakdown): **Product A has $975 Gross Profit; $50 platform fees, $30 shipping, $25 affiliate commissions and $15 refunds are allocated to it, giving roughly $975 − $50 − $30 − $25 − $15 = $855. This shows how the components combine — the exact figure is reconciled against settlement, so a hand calculation may differ slightly.
**Important: **This is the most comprehensive per-product profitability metric. Because the shop-wide total is settlement-anchored and then allocated, manually subtracting the visible rows for one product will approximate — not exactly reproduce — its Operating Profit, unless every row shares the same settlement / data-readiness state and proportional allocation basis.

Product Profit

What it shows: Your final per-product bottom-line profit after all product-specific expenses and ad spend. Platform Subsidy is not added here -- it is already included in your sales revenue, so it is shown only as a separate reference column. This is the most complete profitability metric at the product level.
Formula: Operating Profit − Net Ad Spend
Example: Product A has $855 Operating Profit and $60 in ad spend allocated to it. Product Profit = $855 − $60 = $795.
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 tabs for products with multiple variants, including an All SKUs view
Manage Unit COG for dated cost history. If a specific SKU tab is selected, the button opens that SKU's periods. In All SKUs, a multi-SKU product opens a SKU chooser instead of silently editing a product default. A one-SKU product selects its only SKU automatically.
Profit Breakdown with merchandise sales, customer-paid shipping, shipping deductions, fees, COGS, adjustments, and ad spend shown as separate components. Gross Sales itself excludes shipping.
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 per-product Operating Profits add up to (and reconcile against) the shop-wide, settlement-anchored Operating Profit
Small differences can occur from rounding and from products being in different settlement / data-readiness states when you view them
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?

Set a dated product-level default in Inventory when variants share the same cost. Add a dated SKU override when one variant differs. For each sold unit, Dashboardly uses a priced FIFO lot first, then the SKU period active on the order date, then the product period active on that date. On the product detail page, select a SKU tab before clicking Manage Unit COG to edit that SKU directly; All SKUs opens a chooser for multi-SKU products.

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.