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.
Mixtable's analytical worksheets load your collections as rows with sales metrics as columns. Start from the Collection Sales template and shape it from there.
Net sales, gross sales, order count, and quantity sold for every collection in your store, over any date range.
The Collection Sales template loads order count, quantity sold, returns, discounts, and net sales per collection in one step.
Refund amounts, refund counts, refunded quantity, and percent of orders refunded, so problem categories are visible too.
Discount amounts per collection show which categories only sell when they are on sale.
Fixed date ranges compare launches and seasons, rolling windows keep a living view of what is selling now.
Rank collections, compute share of sales, or divide revenue by product count, like any spreadsheet.
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.
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.
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.
The point of collection analytics is changing your collections. In Mixtable, 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.
Analytical worksheets cover supported metric and filter combinations. These are the core metrics for collection analysis.
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.
No exports, no pipelines. Rank first, then dig into the outliers.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
The template loads order count, quantity, returns, discounts, and net sales per collection.
Pick a season or launch window, or a rolling range like last 30 days for a living view.
Sort by net sales, then check refunds and discounts on the leaders and laggards.
Reorganize collections in the same spreadsheet, or export the numbers to Excel or CSV.
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.
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.
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.
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.
Through the products in it. Mixtable tracks which products belong to which collections and aggregates product-level sales up to each 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.
Yes. 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.
Yes. Any worksheet exports to Excel or CSV, so the ranking can go into a deck or to a teammate in one click.
Open Mixtable for your store and let the numbers pick your homepage slots.
