Product Sales Metrics Template

The Product Sales Metrics template creates one row per Shopify product with lifetime sales metrics beside the product title. It is the quickest way to rank your catalog without building every analytics column yourself.

What this template answers

Shopify tells you what sold. This template tells you how each product performed on the measures that drive decisions, all in one sortable sheet:

• Which products carry your revenue, and which ones you keep stocking out of habit
• Which sell in volume but contribute little once discounts are counted
• Which get returned often enough to be worth investigating
• Which are candidates for more ad spend, and which for clearance

Because it is a spreadsheet, you can sort it, filter it, add your own formulas, and export it to Excel or CSV for a buying meeting.

Create the Product Sales Metrics spreadsheet

1. Install Mixtable Analytics Spreadsheet
2. In Mixtable, click Create Spreadsheet
3. Search for or select Product Sales Metrics under Analytics & Reporting
4. Create the spreadsheet

Columns included in the template

The template creates a Product Sales worksheet with:

• Product Title
• Total Order Count
• Gross Quantity Sold
• Net Quantity Sold
• Returns
• Discounts
• Net Sales

The Returns column uses Refund Count, which counts distinct orders with refund activity. It is not a count of returned units.

What you can learn from the template

• Sort by Net Sales or Net Quantity Sold to identify your leading products
• Compare Gross Quantity Sold with Net Quantity Sold to see how much returns are eating; a wide gap is worth investigating, with sizing, quality, and product descriptions the usual places to start
• Read Returns beside Total Order Count, since a big return number on a big seller is normal and the same number on a small seller is not
• Compare Discounts with Net Sales to find products that only move when they are marked down, which is a pricing decision rather than a merchandising win
• Add price, cost, inventory, vendor, category, tags, or product status for the context that turns a ranking into an action

Add more Shopify fields or analytics

To add a Shopify field, insert a column, click the button, and choose the Shopify data field you want.

To add another performance metric:

1. Open your Product Sales worksheet, then select an empty column or insert a new one. Empty columns have a non-green header; a green header means the column is already linked to Shopify data

2. Click the button in the column header

3. Choose Analytics

   

4. Under Which metric?, select the metric you want

5. Under Over what time period?, choose All time, Fixed dates, Rolling period, Calendar year, or Calendar month

6. Under Limit which orders count, add any optional filters supported by the metric

7. Click Save Column

The template’s metrics cover all time. Adding the same metric again over a shorter window, such as the last 90 days, is what turns the sheet into a trend view: a product high on lifetime sales but low on recent sales is fading, and you would never see that from one column. Name the new column clearly, for example Net Sales · Last 90 days, so it is never confused with the lifetime figure.

Build a more focused product report

Within an existing spreadsheet, add an Reporting worksheet and choose Product sales & return rate under Shopify data worksheet with analytics columns. That report combines Shopify product fields with Net Sales, Net Quantity Sold, Orders Count, Return Request Rate, and Total Refund Amount, which is the better starting point when returns are the thing you are investigating.

For a variant-level view of the same catalog, see Product Variant Sales Metrics Template.