sales vs inventory explained
Portfolytics lets you compare how many different products you offer in a group – and how much they actually sell.
This is what we call “Sales vs Inventory.” It shows which product groups are overstocked and which ones might need expanding. A product group here refers to products that are in the same category or a collection, or that share the same tag.
This report looks at how many unique products exist in each group, and compares that to the total sales. No customization needed, as always.
Why this matters
Some categories or collections have dozens of products but very few sales. Others have just a few products but bring in a lot of revenue.
Here’s what that might look like:
- 3 products in “Scarves” → €2,800 in sales
- 22 products in “Socks” → €360 in sales
This tells you that scarves might be a growth opportunity. And socks… maybe you’ve got too many.
This kind of analysis is very hard to do in Shopify. Portfolytics makes it automatic.
How to see it in the app
You’ll see this comparison in all views:
- Collections
- Tags
- Hierarchy
Just look for:
- total number of products in that group
- total sales
- sales per product in that group
We show this information in an intuitive table by the group type in question. And again, if you want to see the products in that group simply click on the collection or the category, for instance, and the product level table updates. Very easy and intuitive.
What actions can you take?
When you spot a mismatch between inventory size and sales, here are a few things to try:
- High sales, few products → consider adding more variety to meet demand
- Many products, low sales → simplify the collection or test different positioning
- Zero sales → time to cut or review those items
This helps you stock smarter without spreadsheets, inventory reports, or manual sorting.
When is this useful?
- During seasonal planning
- After uploading a new product line
- Before running a promotion or ad campaign
- When reviewing underperforming collections
It’s a quick way to align your product catalog with what’s actually selling.