Product Variant Sales Metrics Template

The Product Variant Sales Metrics template creates one row per Shopify variant, so sizes, colors, materials, and other options are compared individually instead of being averaged into a product total.

Why variant-level sales matter

Product totals are reassuring and slightly misleading. A shirt that looks healthy overall is often two sizes selling out repeatedly and three that have not moved since you bought them, and only a variant report shows you which is which.

That distinction drives real money:

• Reorder in the proportions customers actually buy, instead of an even spread across sizes
• Free up cash tied up in variants that never sell
• Catch one variant driving a whole product’s return rate, which usually points to something specific to that option
• Give your purchasing conversations SKU-level evidence rather than product-level averages

Create the Product Variant Sales Metrics spreadsheet

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

Columns included in the template

The template creates a Variant Sales worksheet with:

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

The analytics columns use an all-time timeframe. The Returns column is Refund Count, meaning the number of distinct refunded orders associated with each variant.

How to use the template

• Sort by Net Quantity Sold to compare real demand across sizes, colors, and other options
• Compare Gross Quantity Sold with Net Quantity Sold to spot the variants customers order and then send back
• Read Returns and Total Order Count together before concluding a variant has a refund problem
• Compare Discounts with Net Sales to find variants that only sell on promotion
• Keep SKU visible whenever the report will be used for purchasing or inventory decisions

Add price, cost, inventory, and margin

You can add Shopify fields such as price, Compare-at price, Cost Per Item, barcode, option values, and inventory quantity to the same worksheet. Sales beside inventory is the pairing that makes reorder decisions obvious at a glance.

To add an analytics metric, select an empty column, click the button, choose Analytics, then choose the metric, timeframe, and optional filters.

For a ready-made profitability view, add an Reporting worksheet and choose Variant margin & inventory. It combines price, current cost, and inventory with Amount of Cost of Goods Sold, Gross Profit, % Gross Margin, Net Sales, and Net Quantity Sold.

Note: Cost, profit, and margin metrics depend on the variant’s current Cost Per Item value

For a broader guide to variant reporting, see Shopify Product Variant Analytics.