Skip to main content

Products

Which products earn, which ones only move, and what each costs you to sell.

90 second readAppears on: /shopify/products

Read the generated insight panel at the top after the cards, not instead of them.

The cards

This is where you find out whether your catalogue earned more, or only moved more.

Each card carries a small trend line: Product RevenueProduct RevenueWhat products really earn after markdowns., Gross SalesGross SalesRevenue before discounts; compare with Product Revenue for markdown cost., Avg. Order PriceAvg. Order PriceYour effective price per unit sold., % Returning Quantity% Returning QuantityWhich products earn loyalty and reorders.30% or more is healthy, % New Quantity% New QuantityWhich products bring in new buyers.70% or more is healthy, % COGS of Product Revenue% COGS of Product RevenueHow much of product income goes to making it.Under 35% is healthy, % Product Discounts% Product DiscountsHow heavily a product is marked down.Under 8% is healthy, COGSCOGSKeep it synced from Shopify, or every profit number is guesswork., Product DiscountsProduct DiscountsSurfaces which products lean hardest on markdowns. and QuantityQuantityThe core volume measure across products..

Read them in three moves

  1. Did products earn more? Product Revenue, then Gross Sales.
  2. What did earning it cost? % COGS of Product Revenue, then % Product Discounts.
  3. Who bought? % New Quantity against % Returning Quantity.

Three pairs worth checking

Gross Sales + Product Revenue. The gap between the two is your markdown bill, and Product Discounts is that same gap written as money.

% COGS of Product Revenue + % Product Discounts. Both eat the same margin. Either one rising while Product Revenue sits still means you sold the same goods for less.

Quantity + Avg. Order Price. Quantity up with average price down is a discount-led period, not a demand-led one.

The tables

The cards give you the catalogue as one number. These tell you which products deserve more stock and more budget, and which ones are quietly eating your margin.

All three tabs carry % Product Revenue% Product RevenueQuickly see which products drive most of your sales. and % Quantity% QuantityShows how much this product contributes to total volume. alongside the card metrics.

Not every column carries a % △ against your comparison period. Product Discounts, Product Revenue, Quantity and Avg. Order Price do, on all three tabs; % Returning Quantity and % New Quantity do on Product and Price Range.

Gross Sales, the share columns and both COGS columns have no % △ anywhere.

Product

The product that sells the most and the product that earns the most are rarely the same one. This is where they separate.

One row = one product title. Variants are rolled up, so two colours of the same shirt share a row.

How to scan it

  1. It opens on Product Revenue, highest first. Note your top three, then re-sort.
  2. Sort by Quantity, highest first, and look across at % Product Revenue.
  3. The row that matters: high Quantity, small % Product Revenue. That is volume which is not paying for itself.

Price Range

This tells you whether your catalogue is priced where your customers actually buy.

One row = one price band, written as two numbers such as 20-30.

The bands are built from the unit prices you have actually sold across your whole history, rounded to tens. They are yours, and they do not move when you change the date range.

How to scan it

  1. Sort by Quantity, highest first.
  2. Look across at % Product Revenue and Avg. Order Price.
  3. The band that matters: most of your units sitting in a band that holds little of your revenue. Your catalogue is priced below where your money is.

Product COGS

This is the margin tab, and the one where a big seller often turns out to be a thin one.

The same rows as Product, with COGSCOGSKeep it synced from Shopify, or every profit number is guesswork. and % COGS of Product Revenue% COGS of Product RevenueHow much of product income goes to making it.Under 35% is healthy added and the two customer-mix columns dropped. The tab carries its own note: COGS gets updated only at the end of the day.

How to scan it

  1. Sort by % COGS of Product Revenue, highest first.
  2. Look across at Quantity and % Product Revenue.
  3. The row that matters: high % COGS on a product that also carries real Quantity. Your busiest product is your thinnest.

Filters

The date range and the comparison period decide the numbers. The rest of the controls only decide what you are looking at.

Date Range and Previous period feed every % △ column and the trend line on every card.

The Filters button opens Country, Customer Type and Order Source. The dialog notes that source and customer type apply only to Shopify orders.

Search sits on each tab and filters rows only.

The chart switch adds a Dimensions picker (up to 10 products), a Metrics picker (up to 3, starting on Product Revenue) and a Compare checkbox. Export downloads the current view.

Price Range only appears when a single store is selected. Pick an organisation and the tab is gone.

Watch out for

A product with no cost set in Shopify shows COGS 0.00 and % COGS of Product Revenue 0.00. That reads as perfect margin. Sort by COGS, lowest first, and clear the zeros before you trust any margin figure on this page.

COGS here is the cost of the units sold, not the cost of one unit. It is unit cost times quantity, added up across every variant of the product.

Product Revenue is Gross Sales minus product discounts, and nothing else. No shipping, no refunds — it will not match Total Sales anywhere else in the app. When your prices include tax, the tax sits inside it, and the column hover then reads "(Includes Taxes)".

% Product Revenue and % Quantity add to 100% inside the table, not against the store.

Rows are grouped by product title. Two genuinely different products sharing a title become one row.

Do this first

Open Product COGS and sort by % COGS of Product Revenue, highest first.

Anything above your target margin that also carries real Quantity is the first product to re-price or re-source. Any 0.00 in that column is a missing cost, not a win.

See yoursEvery product you sold in the date range, with its cost, its markdown and its share of revenue.

Open Products