How to Calculate Your Shopify Collection’s Product-to-Sales Ratio (Step-by-Step Guide)

Most Shopify store owners track total sales. But total sales alone don’t tell you if your collections are efficient. That’s where the sales-to-product ratio comes in. It shows how much revenue each product in a collection brings in – and it’s one of the fastest ways to spot bloated, underperforming categories.

Here’s how to calculate it step-by-step (or skip the mess with Portfolytics).

Understanding the Sales-to-Product Ratio Formula

Here’s the simple math:

Sales-to-Product Ratio = Total Sales from Collection / Number of Products in that Collection

This tells you the average sales per product. Higher = better.
If one collection makes €40,000 with 10 products, and another makes €40,000 with 50, the first one is 5x more efficient.

This is key to smart collection performance analysis and SKU efficiency.

Step 1: Export Your Shopify Collections Data

Start by getting a list of all collections and their product counts.

Inside Shopify:

• Go to “Products” → “Collections”
• Export or copy the list

But here’s the problem — Shopify doesn’t show product counts per collection in exports. You’ll have to count manually or use a tool like Portfolytics which tracks product counts by collection instantly.

If going manual, make sure you’re counting unique products, not variants or SKUs. A product with 10 size/color variations still counts as one product in this calculation.

Step 2: Export Your Sales Data by Collection

Shopify doesn’t natively show sales per collection. That’s where things get tricky.

Here are your options:

• Manual route: Export product-level sales, match products to collections, then total the sales per collection.
• Portfolytics: This step is automatic — sales per collection or per main and subcategory are built into the dashboards.

If you’re doing it manually:

• Match each product to its collection(s)
• Add up the sales by collection
• Watch out: a product in multiple collections may show up in several places

Step 3: Calculate Efficiency Scores for Each Collection

Now divide total sales by product count for each collection:

Sales ÷ Products = Sales-to-Product Ratio

Example:

• Collection A: €50,000 / 10 products = €5,000 per product
• Collection B: €50,000 / 50 products = €1,000 per product

Even though they make the same money, Collection A is far more efficient.

Portfolytics shows these ratios by default — no spreadsheets needed. Just click the collection, and you’ll see it.

Interpreting Your Results: What Strong vs Weak Ratios Look Like

Instead of using fixed euro or dollar benchmarks, compare each collection’s ratio to your store-wide average.

• Collections with a higher sales-to-product ratio than average are likely lean, focused, and performing well.
• Collections below the average may be bloated, confusing, or simply not resonating with your audience.
• Collections far below the average likely need to be trimmed, merged, or better merchandised.

You can also compare:

• Main categories vs subcategories
• Historical performance (month over month)
• Collections tied to specific vendors, campaigns, or tags

This approach helps you find silent overachievers – and underperformers – without relying on arbitrary monetary amounts. And if you have products with very different prices then you will have to trust your expertise when comparing the results.

Common Calculation Mistakes to Avoid

1. Double-counting shared products – A product in two collections could inflate both
2. Using total product variants instead of SKUs – Only count once per product
3. Mixing date ranges – Always use the same sales period across collections
4. Not filtering out unpublished or hidden products

Portfolytics uses a “first-match” method to avoid product duplication and keeps the comparison clean.

How Portfolytics Automates This Entire Process

All the work above? It’s handled in seconds inside Portfolytics. You get:

• Sales-to-product ratio for every collection
• Product counts by collection, category, and tag
• Easy navigation: click category → see efficiency
• Subcategory and product-level breakdowns
• No spreadsheets. No CSV exports.

So you can focus on insights – not data wrangling.

Setting Up Monthly Efficiency Tracking

This isn’t just a one-time check. Add it to your monthly routine:

• Review sales-to-product ratios each month
• Flag collections dropping below target (€500 per product, for example)
• Decide: cut, combine, or promote?

With Portfolytics, just adjust the date range and refresh. You’ll see trends immediately — no extra setup.

Final Thoughts

Revenue is only part of the picture. Two collections might sell the same… but if one needs 5x more products to do it, it’s dragging you down.

That’s the power of the Sales-to-Product Ratio. It turns your Shopify collection analytics into real, actionable insights. And whether you do it manually or use Portfolytics, it’s a metric every growing store should track.