Shopify
Shopify Product Performance Analytics: Which Products Are Making Money and Which Are Hiding It
Shopify Product Performance Analytics: Which Products Are Making Money and Which Are Hiding It
Not all Shopify products that sell are profitable. This guide breaks down how to use Shopify product performance analytics to find your true earners, cut hidden losers, and make smarter inventory decisions.
Not all Shopify products that sell are profitable. This guide breaks down how to use Shopify product performance analytics to find your true earners, cut hidden losers, and make smarter inventory decisions.
08 min read

Shopify product performance analytics is one of the most underused, yet high-leverage levers in the entire e-commerce ecosystem. Most brands are obsessively focused on their top-line revenue growth, celebrating large daily order counts without stopping to investigate the underlying financial health of their individual product catalog.
The reality is that very few brands actually know which of their SKUs are truly generating net profit—and which ones are quietly, consistently eroding their bottom line through hidden costs. If you are currently running a catalog of more than 20 distinct SKUs, the mathematical odds are incredibly high that a meaningful portion of your total monthly revenue is actually coming from products that cost significantly more to acquire, ship, and support than they ever return in profit.
The problem is rarely visible in your standard Shopify dashboard because it hides in plain sight within your return rates, inefficient ad spend allocation, fulfillment complexity, and the compounding inventory carrying costs that plague slow-moving items. This post provides you with a robust, data-driven framework for cutting through the vanity metrics, helping you isolate your winners from the silent profit killers that are holding your brand back from true scalability.
Why Shopify's Default Analytics Miss the Point
Shopify's native analytics are primarily built around tracking gross revenue and aggregate order volume, which serves as a helpful high-level starting point but remains dangerously incomplete for serious financial management.
Revenue and profit are fundamentally not the same thing, and a product can easily rank in your top five by gross revenue while sitting at a deeply negative contribution margin once you start peeling back the layers. A product might appear to be a massive success because it drives significant traffic, but it can be a net liability once you factor in the following hidden expenses:
Cost of Goods Sold (COGS): The total landed cost of the product, including manufacturing, freight, duties, and quality control.
Paid Acquisition Cost: The specific advertising spend required to convert a new customer for that SKU, which often varies wildly by product category.
Return and Refund Rates: The high costs associated with return shipping, restocking, inspection, and the inevitable write-off of damaged or used inventory.
Fulfillment and Packaging Costs: The variable expenses for pick-and-pack labor, specialized packaging materials, and shipping insurance for delicate items.
Warehouse Carrying Costs: The invisible cost of capital tied up in inventory that sits on shelves for months, occupying premium space while losing value.
Shopify's built-in reports do not automatically connect these complex financial dots, as what you see in the standard dashboard is limited to gross sales, units sold, and occasionally a basic conversion rate. What you actually need to survive at scale is a complete, fully-loaded picture of what each individual product costs your business to manufacture, market, and fulfill. This specific analytical gap is the primary reason why many D2C operators remain trapped in a cycle of "growing broke" until they are eventually forced by cash flow constraints to perform a deep-dive audit of their unit economics.
The Four Product Performance Dimensions That Matter
Before you begin pulling any complex reports, it is critical to reach an internal consensus on exactly what "performance" means for your specific brand. There are four distinct dimensions worth measuring at the granular product level to ensure your analysis is comprehensive and actionable:
1. Revenue Contribution: This measures the gross revenue generated by the SKU, serving as your essential baseline anchor for all subsequent calculations. While high revenue is attractive, it can dangerously mask poor margins, so treat this dimension as a starting point rather than a final indicator of product success.
2. Contribution Margin: This is your revenue minus all variable costs, including COGS, shipping, payment processing fees, and direct acquisition spend attributed to that specific SKU. This is the single most important number in your dashboard, as it tells you whether the product is structurally profitable at the unit level before any fixed overhead is even applied.
3. Operational Complexity Score: This captures the friction a product creates in your operations, such as high return rates, difficult-to-handle fulfillment, fragile packaging, or unreliable supplier lead times. These hidden costs do not appear cleanly on a standard P&L statement, yet they impose massive drags on your team’s time and your brand's overall profitability.
4. Strategic Value: Some products exist for reasons beyond their own direct margin—they act as bundle drivers, help reduce churn, introduce new customers to your catalog, or anchor your core brand positioning. Profitability analysis should never happen in total isolation; understand that a loss-making SKU might be acceptable if it serves a critical strategic purpose, provided that the loss is intentional and capped.
Introducing the Product Profit Clarity Matrix
The Product Profit Clarity Matrix is a simple yet powerful four-quadrant tool for categorizing every single SKU in your Shopify catalog based on two critical axes: contribution margin (low to high) and sales volume (low to high). This visual tool allows you to instantly diagnose your catalog health without getting lost in endless rows of spreadsheet data.
High Margin / High Volume — Core Products
These are the pillars of your entire business and should be treated with the highest level of protection, investment, and strategic focus. Ensure your ad spend is heavily weighted toward these items, and treat any operational issue—such as a stock-out or a shipping delay—that slows these products down as an urgent, company-wide priority that requires immediate intervention from the leadership team.
High Margin / Low Volume — Growth Candidates
These products are structurally sound and highly profitable, but they have not yet reached their full potential in terms of market penetration. The central question here is whether the volume ceiling is a genuine demand problem or simply an issue with visibility and acquisition strategy. Often, low volume with strong margin is a signal of an underfunded opportunity that is simply waiting for a more aggressive marketing budget or a more optimized product page to scale rapidly.
Low Margin / High Volume — Risk Products
This quadrant is where many D2C brands get into serious, long-term trouble, as high sales volume often feels like a sign of success despite thin or negative contribution margins at scale. These products are a massive cash flow problem disguised as a growth win; you must conduct an honest assessment to see if margins can be improved through supplier negotiation, price increases, or cost reduction, or if you are simply selling your way into a deeper financial hole.
Low Margin / Low Volume — Cut Candidates
These products are effectively consuming valuable catalog space, tying up your inventory capital, and stealing operational attention from your high-performers while returning very little value. Unless there is a highly compelling, documented strategic reason to keep these items in your rotation, this quadrant is precisely where you should start your product pruning process to reclaim resources for your core categories.
How to Build This in Practice Using Shopify Data
You will not find the Product Profit Clarity Matrix as a native, one-click view inside Shopify, but you can easily build the necessary inputs by aggregating your data systematically.
Pull the Base Data
Start by exporting your raw product data from Shopify Analytics or your preferred reporting tool, focusing on the last 90 days as a standard window. You need to pull gross revenue, total units sold, the volume of returns and refunds, and the conversion rate for each product page, especially if you are running paid traffic to those specific URLs.
Layer in Cost Data
Shopify does not hold your accurate COGS data unless you have manually entered it at the variant level, which is a high-priority task for any growth-stage operator. Ensure you have the landed cost per variant—inclusive of all freight and duties—entered correctly so that the system can calculate a baseline gross margin for every item in your catalog.
Add Acquisition Cost Attribution
If you are running paid advertising, pull the cost-per-purchase by individual product from platforms like Meta or Google to identify hidden losses. This step frequently surfaces the most shocking surprises, as a product that converts at a low ROAS while appearing "profitable" at the gross margin level is almost always a net loser when you include the true cost of acquisition.
Score Operational Complexity
Manually rate each product on a scale of 1 to 5 regarding its return rate, supplier reliability, fulfillment difficulty, and packaging cost. You do not need this to be mathematically precise, as the goal is to surface the SKUs that are creating disproportionate operational drag, which allows you to make informed decisions about whether the overhead of an item is truly justified by its sales performance.
What Good Shopify Product Performance Analytics Actually Tells You
The ultimate goal of this deep-dive analysis is not merely to identify the losers for removal, but to actively answer five critical questions that define your growth strategy. You must clearly identify which products should receive the majority of your ad budget, which products have untapped margin that better sourcing could unlock, and which products are actively stalling your growth and should be discontinued. Furthermore, you need to understand where your inventory capital is being locked up in slow-moving or low-return SKUs and which products are driving true customer lifetime value beyond the single transaction. Running through this structured analysis on a quarterly basis is the absolute minimum requirement for brands in the growth stage, though monthly is significantly better if your catalog changes frequently or your ad mix is inherently volatile.
Common Mistakes in Product Performance Analysis
Measuring Revenue Instead of Margin: This is the single most common error, as revenue rank looks clean in a dashboard and creates an artificial sense of success, while margin is the only metric that tells you whether that revenue is actually worth the effort of acquisition.
Ignoring Return Rates by SKU: A product with a 25% return rate is a fundamentally different business proposition than the same product with a 5% rate; use your Shopify return data at the product level rather than just store-wide, as it reveals the true cost of selling certain categories.
Applying Blended CAC to All Products: Store-level acquisition costs are too broad and often mask the reality that some products are significantly more expensive to sell than others. If you are running product-specific campaigns, you must attribute that spend at the product level to see the true profitability of those specific promotional efforts.
Letting Strategic Products Become Sacred: Even items that serve a strategic purpose—such as entry-point SKUs or bundle drivers—must have clear margin targets. Labeling a product as "strategic" is never a valid reason to avoid the analysis, but rather a reason to set specific performance expectations and revisit them regularly to ensure they are still earning their keep.
Over-Indexing on Conversion Rate: A high conversion rate on a low-margin product can be incredibly misleading, as it encourages you to pour resources into an item that isn't actually helping the business grow in a sustainable way. Always evaluate conversion rate alongside margin, never as a replacement for it.
Tools That Extend Shopify's Analytics Capability
While native Shopify reporting covers the essential basics, you will eventually require more granular tools to manage product-level profitability at scale.
Shopify Built-in Reports: Perfectly adequate for basic revenue and unit data, though limited when it comes to sophisticated cost attribution and margin visualization.
Triple Whale: A powerful option for D2C brands running heavy paid ads, as it specializes in connecting total ad spend to specific product-level performance metrics.
Glew: A solid choice for product profitability reporting that features seamless COGS integration, allowing you to see the real bottom line per SKU.
Northbeam: Highly useful for brands requiring multi-touch attribution at the product level to understand the customer journey before a specific purchase is made.
Google Sheets or Airtable: An excellent path for teams that prefer building custom views pulling from Shopify exports; this method is incredibly flexible and cost-effective but does require consistent manual maintenance.
Shopify product performance analytics is one of the most underused, yet high-leverage levers in the entire e-commerce ecosystem. Most brands are obsessively focused on their top-line revenue growth, celebrating large daily order counts without stopping to investigate the underlying financial health of their individual product catalog.
The reality is that very few brands actually know which of their SKUs are truly generating net profit—and which ones are quietly, consistently eroding their bottom line through hidden costs. If you are currently running a catalog of more than 20 distinct SKUs, the mathematical odds are incredibly high that a meaningful portion of your total monthly revenue is actually coming from products that cost significantly more to acquire, ship, and support than they ever return in profit.
The problem is rarely visible in your standard Shopify dashboard because it hides in plain sight within your return rates, inefficient ad spend allocation, fulfillment complexity, and the compounding inventory carrying costs that plague slow-moving items. This post provides you with a robust, data-driven framework for cutting through the vanity metrics, helping you isolate your winners from the silent profit killers that are holding your brand back from true scalability.
Why Shopify's Default Analytics Miss the Point
Shopify's native analytics are primarily built around tracking gross revenue and aggregate order volume, which serves as a helpful high-level starting point but remains dangerously incomplete for serious financial management.
Revenue and profit are fundamentally not the same thing, and a product can easily rank in your top five by gross revenue while sitting at a deeply negative contribution margin once you start peeling back the layers. A product might appear to be a massive success because it drives significant traffic, but it can be a net liability once you factor in the following hidden expenses:
Cost of Goods Sold (COGS): The total landed cost of the product, including manufacturing, freight, duties, and quality control.
Paid Acquisition Cost: The specific advertising spend required to convert a new customer for that SKU, which often varies wildly by product category.
Return and Refund Rates: The high costs associated with return shipping, restocking, inspection, and the inevitable write-off of damaged or used inventory.
Fulfillment and Packaging Costs: The variable expenses for pick-and-pack labor, specialized packaging materials, and shipping insurance for delicate items.
Warehouse Carrying Costs: The invisible cost of capital tied up in inventory that sits on shelves for months, occupying premium space while losing value.
Shopify's built-in reports do not automatically connect these complex financial dots, as what you see in the standard dashboard is limited to gross sales, units sold, and occasionally a basic conversion rate. What you actually need to survive at scale is a complete, fully-loaded picture of what each individual product costs your business to manufacture, market, and fulfill. This specific analytical gap is the primary reason why many D2C operators remain trapped in a cycle of "growing broke" until they are eventually forced by cash flow constraints to perform a deep-dive audit of their unit economics.
The Four Product Performance Dimensions That Matter
Before you begin pulling any complex reports, it is critical to reach an internal consensus on exactly what "performance" means for your specific brand. There are four distinct dimensions worth measuring at the granular product level to ensure your analysis is comprehensive and actionable:
1. Revenue Contribution: This measures the gross revenue generated by the SKU, serving as your essential baseline anchor for all subsequent calculations. While high revenue is attractive, it can dangerously mask poor margins, so treat this dimension as a starting point rather than a final indicator of product success.
2. Contribution Margin: This is your revenue minus all variable costs, including COGS, shipping, payment processing fees, and direct acquisition spend attributed to that specific SKU. This is the single most important number in your dashboard, as it tells you whether the product is structurally profitable at the unit level before any fixed overhead is even applied.
3. Operational Complexity Score: This captures the friction a product creates in your operations, such as high return rates, difficult-to-handle fulfillment, fragile packaging, or unreliable supplier lead times. These hidden costs do not appear cleanly on a standard P&L statement, yet they impose massive drags on your team’s time and your brand's overall profitability.
4. Strategic Value: Some products exist for reasons beyond their own direct margin—they act as bundle drivers, help reduce churn, introduce new customers to your catalog, or anchor your core brand positioning. Profitability analysis should never happen in total isolation; understand that a loss-making SKU might be acceptable if it serves a critical strategic purpose, provided that the loss is intentional and capped.
Introducing the Product Profit Clarity Matrix
The Product Profit Clarity Matrix is a simple yet powerful four-quadrant tool for categorizing every single SKU in your Shopify catalog based on two critical axes: contribution margin (low to high) and sales volume (low to high). This visual tool allows you to instantly diagnose your catalog health without getting lost in endless rows of spreadsheet data.
High Margin / High Volume — Core Products
These are the pillars of your entire business and should be treated with the highest level of protection, investment, and strategic focus. Ensure your ad spend is heavily weighted toward these items, and treat any operational issue—such as a stock-out or a shipping delay—that slows these products down as an urgent, company-wide priority that requires immediate intervention from the leadership team.
High Margin / Low Volume — Growth Candidates
These products are structurally sound and highly profitable, but they have not yet reached their full potential in terms of market penetration. The central question here is whether the volume ceiling is a genuine demand problem or simply an issue with visibility and acquisition strategy. Often, low volume with strong margin is a signal of an underfunded opportunity that is simply waiting for a more aggressive marketing budget or a more optimized product page to scale rapidly.
Low Margin / High Volume — Risk Products
This quadrant is where many D2C brands get into serious, long-term trouble, as high sales volume often feels like a sign of success despite thin or negative contribution margins at scale. These products are a massive cash flow problem disguised as a growth win; you must conduct an honest assessment to see if margins can be improved through supplier negotiation, price increases, or cost reduction, or if you are simply selling your way into a deeper financial hole.
Low Margin / Low Volume — Cut Candidates
These products are effectively consuming valuable catalog space, tying up your inventory capital, and stealing operational attention from your high-performers while returning very little value. Unless there is a highly compelling, documented strategic reason to keep these items in your rotation, this quadrant is precisely where you should start your product pruning process to reclaim resources for your core categories.
How to Build This in Practice Using Shopify Data
You will not find the Product Profit Clarity Matrix as a native, one-click view inside Shopify, but you can easily build the necessary inputs by aggregating your data systematically.
Pull the Base Data
Start by exporting your raw product data from Shopify Analytics or your preferred reporting tool, focusing on the last 90 days as a standard window. You need to pull gross revenue, total units sold, the volume of returns and refunds, and the conversion rate for each product page, especially if you are running paid traffic to those specific URLs.
Layer in Cost Data
Shopify does not hold your accurate COGS data unless you have manually entered it at the variant level, which is a high-priority task for any growth-stage operator. Ensure you have the landed cost per variant—inclusive of all freight and duties—entered correctly so that the system can calculate a baseline gross margin for every item in your catalog.
Add Acquisition Cost Attribution
If you are running paid advertising, pull the cost-per-purchase by individual product from platforms like Meta or Google to identify hidden losses. This step frequently surfaces the most shocking surprises, as a product that converts at a low ROAS while appearing "profitable" at the gross margin level is almost always a net loser when you include the true cost of acquisition.
Score Operational Complexity
Manually rate each product on a scale of 1 to 5 regarding its return rate, supplier reliability, fulfillment difficulty, and packaging cost. You do not need this to be mathematically precise, as the goal is to surface the SKUs that are creating disproportionate operational drag, which allows you to make informed decisions about whether the overhead of an item is truly justified by its sales performance.
What Good Shopify Product Performance Analytics Actually Tells You
The ultimate goal of this deep-dive analysis is not merely to identify the losers for removal, but to actively answer five critical questions that define your growth strategy. You must clearly identify which products should receive the majority of your ad budget, which products have untapped margin that better sourcing could unlock, and which products are actively stalling your growth and should be discontinued. Furthermore, you need to understand where your inventory capital is being locked up in slow-moving or low-return SKUs and which products are driving true customer lifetime value beyond the single transaction. Running through this structured analysis on a quarterly basis is the absolute minimum requirement for brands in the growth stage, though monthly is significantly better if your catalog changes frequently or your ad mix is inherently volatile.
Common Mistakes in Product Performance Analysis
Measuring Revenue Instead of Margin: This is the single most common error, as revenue rank looks clean in a dashboard and creates an artificial sense of success, while margin is the only metric that tells you whether that revenue is actually worth the effort of acquisition.
Ignoring Return Rates by SKU: A product with a 25% return rate is a fundamentally different business proposition than the same product with a 5% rate; use your Shopify return data at the product level rather than just store-wide, as it reveals the true cost of selling certain categories.
Applying Blended CAC to All Products: Store-level acquisition costs are too broad and often mask the reality that some products are significantly more expensive to sell than others. If you are running product-specific campaigns, you must attribute that spend at the product level to see the true profitability of those specific promotional efforts.
Letting Strategic Products Become Sacred: Even items that serve a strategic purpose—such as entry-point SKUs or bundle drivers—must have clear margin targets. Labeling a product as "strategic" is never a valid reason to avoid the analysis, but rather a reason to set specific performance expectations and revisit them regularly to ensure they are still earning their keep.
Over-Indexing on Conversion Rate: A high conversion rate on a low-margin product can be incredibly misleading, as it encourages you to pour resources into an item that isn't actually helping the business grow in a sustainable way. Always evaluate conversion rate alongside margin, never as a replacement for it.
Tools That Extend Shopify's Analytics Capability
While native Shopify reporting covers the essential basics, you will eventually require more granular tools to manage product-level profitability at scale.
Shopify Built-in Reports: Perfectly adequate for basic revenue and unit data, though limited when it comes to sophisticated cost attribution and margin visualization.
Triple Whale: A powerful option for D2C brands running heavy paid ads, as it specializes in connecting total ad spend to specific product-level performance metrics.
Glew: A solid choice for product profitability reporting that features seamless COGS integration, allowing you to see the real bottom line per SKU.
Northbeam: Highly useful for brands requiring multi-touch attribution at the product level to understand the customer journey before a specific purchase is made.
Google Sheets or Airtable: An excellent path for teams that prefer building custom views pulling from Shopify exports; this method is incredibly flexible and cost-effective but does require consistent manual maintenance.
FAQ
What is Shopify product performance analytics?
Shopify product performance analytics refers to the process of evaluating individual products within a Shopify store across metrics like revenue, margin, units sold, return rate, and acquisition cost. The goal is to understand which products are genuinely profitable — not just high-selling — and make smarter decisions about inventory, ad spend, and catalog management.
Why doesn't Shopify show product profitability by default?
Shopify's native analytics are focused on transactional data — revenue, orders, and conversion. Profitability requires cost data (COGS, fulfillment, acquisition spend) that Shopify doesn't automatically hold or connect. Most brands need to either manually enter COGS into Shopify or use a third-party analytics tool to build a complete picture.
How often should I run a product performance audit?
Quarterly is a practical minimum for most Shopify brands. If you're scaling ad spend, adding new products regularly, or experiencing margin pressure, monthly reviews are worth the time. Major catalog decisions — discontinuations, pricing changes, sourcing renegotiations — should always be backed by a fresh performance review.
How do I attribute ad spend to specific products in Shopify?
Shopify's native attribution is limited for product-level ad spend. For paid social (Meta, TikTok) and paid search (Google), pull cost-per-purchase data from your ad platforms filtered by product or campaign. Tools like Triple Whale or Northbeam can automate this connection and give you blended ROAS at the SKU level.
What should I do with products in the low margin, high volume quadrant?
Start with a root cause analysis before making any decision. Ask whether the margin issue comes from COGS, pricing, acquisition cost, or return rates. In some cases, supplier renegotiation or a modest price increase can shift a risk product into profitability. In others, the structural economics won't change, and the right move is to phase the product out or reposition it as a bundle component rather than a standalone SKU.
Can a product with low profit margin still be worth keeping?
Yes — but with clear conditions. Products that function as customer acquisition entry points, bundle anchors, or retention drivers can justify thinner margins if they demonstrably improve lifetime value or basket size. The key is to make the case explicitly and set a margin floor below which the product gets reviewed again. "We keep it because it converts" is not a sufficient answer.
How do I know if my analytics setup is giving me accurate product data?
Start by checking whether your COGS is entered at the variant level in Shopify. Then verify that returns are being tracked and attributed back to the original product. Cross-reference your Shopify revenue numbers against your ad platform purchase data to check for significant discrepancies. If the numbers don't roughly reconcile, your attribution or cost data has a gap worth closing before you trust the analysis.
insights
Explore more on AI, Design and Growth

SEO
Google AI & Local SEO: Rank in Both (2026 Guide)
Learn how to optimize content for Google AI search and local SEO simultaneously to rank in AI Overviews, maps, and organic search results.

SEO
Semantic Content Clusters for SEO & AEO (Templates)
Learn how to build semantic content clusters for SEO and AEO. Includes practical templates, internal linking structures, and examples for ranking in AI search.

SEO
How Google AI Search Works: RankBrain to Gemini (2026)
Discover how Google’s AI search evolved from RankBrain to Gemini and what it means for SEO, AI search results, and ranking strategies in 2026.

SEO
Google AI & Local SEO: Rank in Both (2026 Guide)
Learn how to optimize content for Google AI search and local SEO simultaneously to rank in AI Overviews, maps, and organic search results.

SEO
Semantic Content Clusters for SEO & AEO (Templates)
Learn how to build semantic content clusters for SEO and AEO. Includes practical templates, internal linking structures, and examples for ranking in AI search.
get in touch
Go from online presence to real business impact
Strategy, execution, and digital experiences designed to move together. Fill out the form below and our team will contact you shortly.
get in touch
Go from online presence to real business impact
Strategy, execution, and digital experiences designed to move together. Fill out the form below and our team will contact you shortly.
get in touch
Go from online presence to real business impact
Strategy, execution, and digital experiences designed to move together. Fill out the form below and our team will contact you shortly.
projectsupply
Services
We'd love to hear from you.
Tell us what you're building and where you need support.
projectsupply
Services
We'd love to hear from you.
Tell us what you're building and where you need support.
projectsupply
Services
We'd love to hear from you.
Tell us what you're building and where you need support.
