Understand Your Product Reports
Your Product Reports give you detailed product-level insights that Etsy’s built-in dashboards don’t provide. Etsy reports at the listing level, but ProfitTree breaks your catalog down into unique products and variations, giving you a clearer view of what’s truly selling and how profitable each item is.
Here’s how to understand everything on the Product Reports page.
How Product Reports Work
1. Only products with at least one sale appear
Product Reports show sold items only. If a product hasn’t sold during the selected date range, it will not display.
2. You’re viewing one row per unique product or variation
Etsy sends variation-level data, so each variation (size, color, material, etc.) appears as its own row.
3. SKUs drive grouping
If you use SKUs, ProfitTree groups identical products across all listings.
If multiple Etsy listings share the same SKU, ProfitTree displays one combined product row.
If you do not use SKUs, ProfitTree cannot consolidate identical products across listings.
4. Clicking a product shows detailed history
You can open any product to see its total performance across all listings where it appears.
Sorting Options
ProfitTree offers multiple ways to sort your products:
Most Recent
Sorts products by the most recent sale date.
Tap once → newest sales
Tap twice → oldest sales
Best Sellers
Sorts products by the total number of units sold during the selected period.
Tap once → bestselling
Tap twice → lowest-selling
Most Profitable
Sorts products by estimated operating profit.
Tap once → highest estimated profit
Tap twice → lowest estimated profit
Note: Operating Expenses, Operating Profit, % Profit, and ROI are based on weighted averages because Etsy does not provide order-specific fee breakdowns.
Trend Setters
Sorts products by sales momentum — products increasing the most compared to the previous time period.
Tap once → rising performers (“trend setters”)
Tap twice → declining performers (“falling stars”)
Understanding Each Column in Product Reports
Below are definitions for each metric you’ll see in your report.
SKU
The unique identifier for a product or variant.
If no SKU exists in Etsy, this column will be blank.
Listing Title
Displays the listing title and variation name.
If a SKU appears in multiple listings, the title shown will be from the most recent sale.
Units Sold
The total quantity sold for that unique product or variant in the selected date range.
Trend indicator:
Up arrow = more units sold vs last period
Down arrow = fewer units sold vs last period
Net Sales
Revenue collected after accounting for:
Discounts
Partial or full refunds
Shipping/handling collected
Important:
Due to Etsy API limitations, shipping and refunds are shown as weighted averages if multiple units were sold in the same order.
COGS
Total cost of goods sold for that product during the selected period.
If COGS are missing, an error icon appears.
How to fix missing COGS
Go to COGS Management, open the product, and enter the correct cost.
Operating Expenses
Weighted averages of:
Listing fees
Processing fees
Transaction fees
Weighted shipping deductions
These are averages because Etsy does not provide per-item fee data.
Operating Profit
Estimated profit before advertising or indirect expenses.
Formula:
Operating Profit = Net Sales – COGS – Operating Expenses
% Profit (Profit Margin)
Estimated profit percentage before marketing costs.
ROI (Return on Investment)
Formula:
ROI = Operating Profit / (COGS + Operating Expenses)
Summary
Your Product Reports are one of the most powerful tools in ProfitTree. They help you:
Understand product-level profitability
See how each variation performs
Identify trend setters and under-performers
Group listings by SKU for cleaner reporting
Track costs, fees, and margins accurately
With views that Etsy does not provide, Product Reports give you clarity on exactly what’s driving your shop’s success.