If you sell apparel, footwear, or accessories on Shopify, you have probably wanted to answer a simple question: how much revenue did each color make last month?
Shopify's analytics give you a lot. What they do not give you is a total by color across your whole catalog. Here is what your options actually are, and what each one costs in time and accuracy.
What Shopify can and cannot report
Shopify reports sales at the product level and the variant level. You can see how many units of "Linen Blazer / Red / Medium" sold in a given period. What you cannot see natively is how much Red made across every product in your store that comes in a red colorway.
This is a structural limitation, not a gap in your setup. Shopify's Sales reports are built around products and orders. There is no native dimension for option value (like color or size) totaled across multiple product records.
The Shopify community thread "How can I view sales by product variant in my reports?" covers this gap well: the answer is the "Total sales by product variant" report, which gives you a per-variant breakdown. But a per-variant breakdown and a per-color breakdown are different things. "Red / Large" and "Red / Small" sold separately do not automatically sum into a single Red revenue figure.
If you want the data-model reason behind this, we cover it in Why Shopify cannot total sales by option value across products.
Option 1: Native Shopify reports
What you can do: Navigate to Analytics, then Reports, then "Total sales by product variant". This gives you a row for every variant sold in your date range, with units and revenue.
What you cannot do: Group those rows by color without leaving Shopify. If you have five red variants across three products, you will see five separate rows. You add them up manually.
When this works: For a small catalog (under 50 products, one or two colorways per product), manual addition is feasible. It is slow, but not impossible.
Where it breaks down: As catalog size grows, the variant list grows faster, because products multiply and colorways per product multiply. At 200 or 300 products, adding variant rows manually is an afternoon. At 500, it is not a realistic regular practice.
There is also a naming problem. Shopify reports the variant name as it was entered: "Red," "Scarlet," "Merlot," and "Brick" are all separate rows. You have to decide which names belong to the same color family, and apply that decision consistently, every time.
Option 2: CSV export and pivot table
What you do: Export your variant sales to CSV from Shopify admin. Open the file in Excel or Google Sheets. Add a column to classify each variant by color family. Build a pivot table that sums revenue by that color family column.
What you get: A color-level revenue ranking for the period, using your own order data.
When this works: This is the most common workaround, and it works. A merchant who is comfortable with spreadsheets can get a usable color report in an hour or two, assuming the catalog is reasonably well-named.
Where it breaks down:
First, the naming normalization problem. "Scarlet," "Merlot," "Sangria," "Brick," "Wine," and "Rust" are all, in practice, variations of the same color family. Mapping each to a family requires judgment and consistency. In a catalog built over several seasons by different buyers or suppliers, that mapping is a project of its own.
Second, some products have no color name. The color information lives only in the product image. A CSV column for those products is empty, and you have to handle them by looking up each product manually.
Third, this report does not update. The moment you run it, it is a snapshot. Running it monthly means repeating the whole process monthly.
Fourth, watch the columns. The export includes both gross and net sales; use net sales so returns and discounts are accounted for. Note that Shopify records a sales reversal on the date of the return, not the date of the original sale, so a color's month-over-month numbers can shift after the fact.
For stores that run this process regularly, the time cost is real. Say you run a 400-product womenswear store. Maintaining an accurate monthly color report through the CSV method is a recurring commitment, not a one-time project.
Option 3: Purpose-built color analytics
A third approach is to use a tool built specifically for this problem.
HueMetrics reads your Shopify catalog and order history and maps every product variant to one of 14 standard color families: Blacks, Whites, Grays, Reds, Oranges, Yellows, Greens, Teals, Blues, Navy, Purples, Pinks, Browns, and Beiges. It does this using automatic color detection: variant names and tags first, then product images for anything the name does not resolve, using color science in the LAB color space with a confidence score attached.
Anything low-confidence goes into a review queue. You correct it with one click. Corrections reattribute historical revenue, so the numbers update backward, not just forward.
The result is a live revenue ranking across all 14 color families, updated as new orders come in, net of returns and cancellations, and discount-aware. You do not export a CSV. You do not build a pivot table. You look at a report.
The full color ranking and 12-month trend lines for every family are free, with no card required and no time limit. The free plan is the evaluation.
If your store is at a scale where the CSV method takes meaningful time each month, or where the naming normalization problem has become hard to manage, that is the practical threshold where purpose-built tooling earns its place.
Which approach fits your store?
Use native Shopify reports if: Your catalog is small (under 50 products), colorways are limited, and you only need color data occasionally.
Use the CSV pivot method if: Your catalog is mid-size, you are comfortable with spreadsheets, and you can afford the time it takes each month. It is the honest workaround, and it works.
Use purpose-built color analytics if: Your catalog is large enough that manual normalization is no longer practical, you need the data updated continuously rather than as a monthly snapshot, or color-level decisions (reorders, markdowns and dead stock, assortment planning) happen often enough that the time cost of the spreadsheet method is significant.
HueMetrics is color analytics for fashion stores on Shopify. It attributes revenue to 14 color families from your own orders, free and in full, then turns winners and laggards into Shopify collections and markdowns you approve before launch. Start free on the Shopify App Store.