Shopify sales by collection, tag and category: how a whole department did
The product list tells you about one product. Buying decisions are made about a collection, a tag or a category, and a strong product can hide a department that is slipping.
Shopify's reports are good at the product level. An ecommerce manager or an owner buying for next season does not think in products; they think in collections ("the autumn drop"), tags ("linen", "bestseller") and categories. A CRM lead at a mid-market store wrote in January 2026 that "reporting could be more robust/dashboards stronger, so that we don't have to use third parties to build better custom reports." The department total is the report most of those third parties are built for.
What the report shows
A sales by collection, tag and category report for last week rolls the week up three ways:
- by collection: gross sales, net sales, units and orders for each collection
- by product tag: the same figures for each tag
- by product category: the same figures per category
You can filter it to one store location, which matters once you sell from more than one place. The alternative, around 45 minutes a week of tagging orders by hand to see a department total, is the kind of work that stops happening in a busy month.
One rule to read it by
A product that sits in several collections, or carries several tags, is counted once in each group. So the collection totals do not add up to the store total, and they are not meant to. The report says this at the top rather than leaving you to discover it against the overview dashboard.
Why it is worth a schedule
The failure mode is quiet. A whole category declines for a quarter while its one strong product keeps the average up, and nobody notices because the product report still shows a winner. A department view every Monday, counted the same way each week, is how the slope becomes visible in time to do something about the buy.
How Captain Miles does it
Describe the report in a sentence. Captain Miles shows you the plan before it runs, then builds the report from the orders, products, collections and locations in your own store, every Monday, with a note on how each number was produced. Your store data is used for your store only, never trained on, and deleted within 30 days if you uninstall. The ready-made version is below.