One row per collection
Net sales, gross sales, order count, and quantity sold for every collection in your store, over any date range.
Know what every collection is worth
Open Mixtable for your store and let the numbers pick your homepage slots.
Use case for Mixtable Analytics Spreadsheet
Analyze Shopify collections with a spreadsheet
Net sales, orders, quantity sold, discounts, refunds, and return rates for every collection, in a live spreadsheet fed by your Shopify store. See which collections carry the season and which ones just take up navigation space.
Collection Sales - Acme Apparel From Shopify A
B
C
D
1
Collection
Net sales
Orders
Qty sold
2
Summer Essentials
$48,210
402
612
3
Workwear
$31,480
268
331
4
New Arrivals
$24,890
241
298
5
Knitwear
$12,340
104
126
6
Accessories
$8,110
156
214
7
Last Chance
$3,940
61
97
By collectionQuantityReturnsThis season +
- Live from your store
Trusted by thousands of Shopify stores
What you can do
Everything you need to analyze Shopify collections
Mixtable's reporting worksheets load your collections as rows with sales metrics as columns. Start from the Collection Sales template and shape it from there.
A ready-made template
The Collection Sales template loads order count, quantity sold, returns, discounts, and net sales per collection in one step.
Returns per collection
Refund amounts, refund counts, refunded quantity, and percent of orders refunded, so problem categories are visible too.
Discount exposure
Discount amounts per collection show which categories only sell when they are on sale.
Season over season
Fixed date ranges compare launches and seasons, rolling windows keep a living view of what is selling now.
Stock and sell-through per collection
Add any of 14 inventory metrics, like Closing Value at Cost, Sell-Through Rate, Dead Stock Units, and Out-of-Stock Variants, to see how much stock each collection holds and how fast it moves.
The collection metrics you can put in a worksheet
Reporting worksheets cover supported metric and filter combinations. These are the core metrics for collection analysis.
- Net sales
- Gross sales
- Order count
- Net quantity sold
- Gross quantity sold
- Refunded quantity
- Refund amounts
- Refund count
- Percent of orders refunded
- Discount amounts
- Tax amounts
- Any date range
In the spreadsheet
See how it looks in the sheet.
Collection Ranking - Q2 From Shopify A
B
C
1
Collection
Net sales
Share
2
Summer Essentials
$48,210
37%
3
Workwear
$31,480
24%
4
New Arrivals
$24,890
19%
5
Knitwear
$12,340
10%
6
Accessories
$8,110
6%
- Share column is a formula
- Sortable like any sheet
See which collections earn their place
Collections are how customers shop and how you merchandise, but most reporting stops at products. The Collection Sales template ranks every collection by the same metrics, so navigation, homepage slots, and campaign features can follow the numbers.
Guide: Rank your collections- Net sales, orders, and quantity sold per collection
- Sort by any metric to rank collections
- Spot collections with traffic-worthy names and no revenue
- Share-of-sales is one formula away
Category Health - Q2 From Shopify A
B
C
1
Collection
Refunded
Discounts
2
Summer Essentials
$1,240
$2,890
3
Workwear
$680
$1,140
4
New Arrivals
$980
$310
5
Last Chance
$210
$1,860
- Discount-dependent category
- Quality beside revenue
Returns and discounts, by category
Two numbers tell you when a category has a problem: how much of it comes back, and how much of it only sells at a discount. Both are collection-level metrics in Mixtable, sitting right next to the revenue they erode.
Guide: Check category health- Refund amounts, refund counts, and refunded quantity per collection
- Percent of orders refunded as a category quality signal
- Discount amounts show which collections depend on promotions
- Gross versus net sales makes the gap visible
Summer Essentials - YoY From Shopify A
B
C
D
1
Metric
Summer 25
Summer 26
Last 30 days
2
Net sales
$39,180
$48,210
$7,840
3
Orders
334
402
68
4
Qty sold
489
612
104
5
Refunded qty
31
28
4
- Fixed + rolling ranges
- Growth with fewer returns
Compare seasons, launches, and campaigns
A collection's job changes through the year. Fixed date ranges let you compare this summer against last summer or measure a launch window precisely, while rolling windows keep a living view of what is selling right now.
Guide: Compare your seasons- Fixed ranges for launches, seasons, and campaign windows
- Rolling windows like last 30 days for a current view
- Put two periods side by side and diff them with a formula
- Collection metrics respect the same date ranges as everything else
Collections - Edit Side Sync 2 changesPreview A
B
C
1
Product
Net sales
Add to collection
2
Linen Shirt
$6,240
Summer Essentials
3
Canvas Tote
$3,180
Summer Essentials
4
Wool Scarf
$890
5
Corduroy Cap
$1,420
- Analytics beside actions
- Synced when you approve
Analyze collections, then reorganize them, same spreadsheet
The point of collection analytics is changing your collections. With Mixtable Spreadsheet Editor, the same spreadsheet that ranks them also edits them: add products to collections, remove them, and rework titles and SEO in bulk, with every change previewed before it syncs.
Guide: Reorganize collections- Add or remove products from collections with action columns
- Edit collection titles, descriptions, and SEO in bulk
- Changes preview first and sync only when you say so
- Metric columns stay read-only analysis views
Compare
Mixtable vs other ways to analyze Shopify collections
Shopify reports lean product-first. Here is how the options compare when the question is about categories.
| Analysis task | Mixtable | Shopify reports | Exporting to Excel | BI platforms |
|---|---|---|---|---|
| Sales metrics per collection | Yes, in a live sheet | Limited | Manual product mapping | Yes, after modeling |
| Returns and discounts per collection | Yes, same sheet | No | Manual joins | Yes, after modeling |
| Season-over-season comparisons | Yes, fixed ranges | Date pickers | Yes, manually | Yes |
| Rank and share-of-sales formulas | Yes, it is a spreadsheet | No | Yes, manually | Query languages |
| Edit collections where you analyze them | Yes, same spreadsheet | Separate screens | No | No |
| Stays current without re-exporting | Yes, dynamic ranges | Yes | No | Yes, via pipelines |
| Setup time | Minutes, from a template | None | Every single time | Days to weeks |
Comparison reflects typical collection analysis workflows. Mixtable analytics covers supported metric and filter combinations.
Getting started
From install to a collection report in minutes
No exports, no pipelines. Rank first, then dig into the outliers.
Connect your store
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
Open Collection Sales
The template loads order count, quantity, returns, discounts, and net sales per collection.
Set the date range
Pick a season or launch window, or a rolling range like last 30 days for a living view.
Rank and inspect
Sort by net sales, then check refunds and discounts on the leaders and laggards.
Act on it
Reorganize collections in the same spreadsheet with Mixtable Spreadsheet Editor, or export the numbers to Excel or CSV.
Questions
Shopify collection analytics questions
How do I see sales for each Shopify collection?
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open the Collection Sales template. Every collection loads as a row with order count, quantity sold, returns, discounts, and net sales, live from your store.
Which metrics are available per collection?
Net and gross sales, order count, net and gross quantity sold, refunded quantity, refund amounts and counts, percent of orders refunded, discount amounts, and tax amounts.
Can I compare collections across seasons?
Yes. Fixed date ranges let you compare this season against last season for the same collection, and rolling windows keep a current view that updates itself.
Can I see which collections get returned the most?
Yes. Refunded quantity, refund amounts, and percent of orders refunded work at collection level, so category-wide quality problems show up next to category revenue.
How does a sale get attributed to a collection?
Through the products in it. Mixtable tracks which products belong to which collections and aggregates product-level sales up to each collection.
Can a product count toward more than one collection?
Yes. A product in three collections contributes its sales to all three, which matches how collections work in Shopify. Keep that in mind before summing collection rows into a store total.
Can I reorganize collections based on what I find?
Yes. With Mixtable Spreadsheet Editor, the same spreadsheet edits collections: add or remove products with action columns and update titles or SEO in bulk, with every change previewed before it syncs to Shopify.
Can I export the collection report?
Yes. Any worksheet exports to Excel or CSV, so the ranking can go into a deck or to a teammate in one click.
Keep going
Keep going with analytics
Adjacent workflows and the help articles behind this page.