How to Use Product Mix in Etsy: Step-by-Step Tutorial

Discover which product categories sell best and optimize your Etsy shop for maximum profitability

Introduction to Product Mix Analysis

Understanding your product mix is one of the most powerful ways to optimize your Etsy shop's performance. Your product mix reveals which items drive revenue, which variations customers prefer, and where your highest profit margins lie. Without this insight, you're essentially running your business blindfolded—making inventory decisions based on gut feeling rather than data.

As an Etsy seller, you've probably asked yourself: "Should I focus on physical products or digital downloads?" "Which variation of my bestselling item should I promote?" "Am I pricing my products optimally?" Product mix analysis answers all these questions and more, giving you a clear roadmap for growing your shop strategically.

In this comprehensive tutorial, you'll learn how to perform a complete product mix analysis for your Etsy shop. We'll walk through analyzing your physical versus digital sales split, identifying your top-performing variations, mapping price tiers, and calculating profit margins. By the end, you'll have actionable insights to optimize your product catalog and maximize profitability.

Prerequisites and Data Requirements

Before diving into product mix analysis, you'll need to gather the right data and ensure you have the necessary access. Here's what you'll need:

Required Data

Access Requirements

Exporting Your Etsy Data

To export your order data from Etsy:

  1. Log into your Etsy Shop Manager
  2. Navigate to Settings → Options → Download Data
  3. Select "Orders" and choose your date range
  4. Click "Download CSV" and save the file

This CSV file contains all the order-level data you'll need for product mix analysis. Keep this file handy as we work through each analytical step.

What You'll Accomplish

By following this tutorial, you will:

This analysis typically takes 30-45 minutes to complete manually, or just a few minutes using automated tools like the MCP Analytics Product Mix Service.

Step 1: What's My Physical vs Digital Sales Split?

Understanding the balance between physical and digital product sales helps you allocate resources effectively and identify growth opportunities.

Why This Matters

Physical and digital products have vastly different economics. Physical products require inventory management, shipping, and materials, while digital products offer near-infinite scalability with minimal overhead. Knowing your split helps you:

Analysis Process

To calculate your physical vs digital split:

1. Open your Etsy order export CSV file
2. Add a new column called "Product_Type"
3. For each product, categorize as either "Physical" or "Digital"
4. Create a pivot table with:
   - Rows: Product_Type
   - Values: COUNT of Order_ID (for order volume)
   - Values: SUM of Item_Total (for revenue)

Example Result:
Product_Type | Orders | Revenue  | % of Orders | % of Revenue
Physical     | 342    | $8,450   | 68%         | 71%
Digital      | 161    | $3,450   | 32%         | 29%
Total        | 503    | $11,900  | 100%        | 100%

Interpreting the Results

In the example above, physical products represent 68% of orders but 71% of revenue, suggesting a slightly higher average order value for physical items. Here's how to interpret your results:

Expected Output

You should now have clear percentages showing your revenue and order distribution between physical and digital products, plus insights into average order values for each type.

Step 2: Which Product Variations Are Most Popular?

Product variations—such as size, color, material, or design—often make the difference between a bestseller and a slow mover. This step reveals which variations resonate most with your customers.

Understanding Variation Performance

Most Etsy sellers offer variations of their core products. For example, a print seller might offer the same design in multiple sizes, or a jewelry maker might offer the same necklace in silver, gold, and rose gold. Knowing which variations sell best allows you to:

Analysis Process

To identify your top-performing variations:

1. In your CSV, identify the "Variations" column
2. Parse variations into separate attributes (Size, Color, etc.)
3. Create a summary table for each variation type:

Example for Size Variations:
Size     | Orders | Revenue  | Avg Price | % of Total Orders
8x10"    | 145    | $2,175   | $15.00    | 28.8%
11x14"   | 122    | $2,440   | $20.00    | 24.3%
16x20"   | 98     | $2,940   | $30.00    | 19.5%
5x7"     | 87     | $1,044   | $12.00    | 17.3%
24x36"   | 51     | $2,040   | $40.00    | 10.1%

Example for Color Variations:
Color        | Orders | Revenue  | % of Total Revenue
Black/White  | 178    | $3,204   | 31.2%
Sepia        | 124    | $2,232   | 21.7%
Full Color   | 201    | $4,824   | 47.1%

Key Insights to Extract

Look for these patterns in your variation data:

In the example above, 8x10" prints lead in volume, but 16x20" prints generate more total revenue despite fewer orders. This suggests an opportunity to promote larger sizes more prominently, similar to how A/B testing helps identify winning variations in digital marketing.

Expected Output

You should have detailed tables showing performance metrics for each product variation type, with clear identification of your top performers and underperformers.

Step 3: What Are My Price Tiers?

Price tier analysis helps you understand how your products are distributed across different price points and which tiers drive the most revenue. This is crucial for strategic pricing and product development.

Why Price Tiers Matter

Different price points attract different customer segments and serve different purposes in your product mix:

Creating Your Price Tier Map

To analyze your price tier distribution:

1. Define your price tiers based on your product range
2. Categorize each product into a tier
3. Calculate metrics for each tier:

Example Price Tier Analysis:
Price Tier    | Products | Orders | Revenue   | Avg Margin | % Revenue
$0-$25        | 12       | 298    | $4,470    | 45%        | 37.6%
$25-$75       | 8        | 156    | $5,850    | 52%        | 49.2%
$75-$150      | 4        | 38     | $1,330    | 58%        | 11.2%
$150+         | 2        | 11     | $240      | 48%        | 2.0%

Volume by Tier:
Entry ($0-$25):     ████████████████████████████ 59.2%
Mid ($25-$75):      ███████████████ 31.0%
Premium ($75-$150): ███ 7.6%
Luxury ($150+):     █ 2.2%

Strategic Insights

Use your price tier analysis to identify strategic opportunities:

In the example above, the shop generates nearly half its revenue from mid-tier products while maintaining strong entry-level volume. However, premium products show the highest margins, suggesting an opportunity to develop more offerings in that tier.

Expected Output

You should have a clear picture of how your revenue, orders, and margins distribute across price tiers, with identified opportunities for portfolio optimization.

Step 4: Which Products Have the Highest Margins?

Profit margin analysis is the most critical component of product mix optimization. High-revenue products aren't valuable if they don't generate profit. This step helps you identify your most profitable products.

Understanding Product Margins

Your profit margin is the percentage of revenue remaining after subtracting costs. For Etsy sellers, costs typically include:

Calculating Margins

To calculate profit margins for your products:

Margin Formula:
Profit Margin % = ((Revenue - Total Costs) / Revenue) × 100

Example Calculation for a $40 Print:
Revenue:              $40.00
Materials (COGS):     -$8.00
Etsy Transaction:     -$2.60  (6.5%)
Payment Processing:   -$1.45  (3% + $0.25)
Shipping (absorbed):  -$5.00
Labor (15 min @ $30/hr): -$7.50
------------------------
Net Profit:           $15.45
Margin:               38.6%

Product Margin Comparison:
Product           | Revenue | Net Profit | Margin % | Orders
Digital Template  | $2,480  | $2,110     | 85.1%    | 124
Custom Portrait   | $4,200  | $1,470     | 35.0%    | 42
Art Print 8x10    | $2,175  | $1,088     | 50.0%    | 145
Sticker Pack      | $1,044  | $627       | 60.1%    | 174
Framed Print      | $2,940  | $764       | 26.0%    | 98

Identifying Margin Optimization Opportunities

Once you've calculated margins for all products, look for these patterns:

In the example above, digital templates show excellent margins (85%) but modest revenue. This suggests an opportunity to increase marketing spend on digital products since the incremental cost is near zero. Conversely, framed prints show low margins (26%) despite solid revenue, indicating a need to either raise prices or reduce framing costs.

This type of margin optimization is similar to the analytical approach used in AI-first data analysis pipelines, where automated systems continuously identify optimization opportunities.

Expected Output

You should now have a comprehensive margin analysis showing which products drive the most profit, which need optimization, and where to focus your growth efforts.

Interpreting Your Results

Now that you've completed all four analytical steps, it's time to synthesize your findings into actionable strategies. Here's how to interpret your complete product mix analysis:

Creating Your Product Mix Matrix

Combine your insights into a strategic framework:

Product Mix Matrix:
                    High Volume          Low Volume
High Margin     | STARS               | HIDDEN GEMS
                | - Promote heavily   | - Increase visibility
                | - Protect pricing   | - Test price increases
                | - Expand variations | - Develop similar products
                |                     |
Low Margin      | WORKHORSES          | QUESTION MARKS
                | - Optimize costs    | - Discontinue or
                | - Test price increases| - Reposition as premium
                | - Cross-sell stars  | - Reduce complexity

Strategic Actions by Product Type

Stars (High Margin, High Volume)

These are your best performers. Actions to take:

Hidden Gems (High Margin, Low Volume)

These products are profitable but underselling. Actions to take:

Workhorses (Low Margin, High Volume)

These drive traffic but not profit. Actions to take:

Question Marks (Low Margin, Low Volume)

These products may not deserve space in your catalog. Actions to take:

Portfolio-Level Insights

Look at your entire product mix holistically:

Automate Your Product Mix Analysis

While the manual analysis process described in this tutorial is thorough, it's also time-consuming and needs to be repeated regularly to stay current. The MCP Analytics Product Mix Tool automates this entire workflow.

Why Use Automated Analysis?

Try the Product Mix Analyzer →

Next Steps with Etsy Analytics

Now that you understand your product mix, consider these advanced analytical techniques to further optimize your Etsy shop:

1. Time-Series Analysis

Track how your product mix evolves over time. Are certain products seasonal? Are margins improving or degrading? Time-series analysis reveals trends that snapshot analysis misses.

2. Customer Segmentation

Different customers prefer different products. Segment your buyers by purchase behavior to tailor marketing messages and product recommendations.

3. Cohort Analysis

Track groups of customers acquired in the same period to understand which products drive repeat purchases and customer lifetime value.

4. Attribution Modeling

Understand which marketing channels drive sales for different product categories. Your physical products might acquire customers differently than digital products.

5. Predictive Analytics

Use historical product mix data to forecast future demand, similar to how accelerated failure time models predict event timing in other contexts.

Recommended Reading

Continue Optimizing

Product mix analysis isn't a one-time exercise. Markets change, customer preferences evolve, and new products get added. Schedule regular product mix reviews:

Troubleshooting Common Issues

Here are solutions to common problems you might encounter during product mix analysis:

Issue: Inconsistent Product Names

Problem: Your Etsy data shows the same product with multiple names or spellings, making aggregation difficult.

Solution: Create a product mapping table that standardizes names. Use Excel's VLOOKUP or spreadsheet formulas to replace variations with canonical names before analysis.

Example Mapping:
"Botanical Print - Rose" → "Botanical Print"
"botanical print rose" → "Botanical Print"
"Rose Botanical" → "Botanical Print"

Issue: Missing Cost Data

Problem: You don't have accurate COGS for all products, making margin calculation impossible.

Solution: Start tracking costs immediately for new products. For historical products, estimate conservatively:

Issue: Variations Data is Messy

Problem: Etsy exports variations in a single cell like "Primary color: Blue; Size: Large", making it hard to analyze each attribute separately.

Solution: Use spreadsheet text functions to parse variations:

In Excel/Google Sheets:
1. Use Text to Columns to split on semicolons
2. Use FIND and MID functions to extract specific attributes
3. Or use the formula:
   =MID(A1, FIND("Size:", A1)+6, FIND(";", A1, FIND("Size:", A1))-FIND("Size:", A1)-6)

Issue: Seasonal Products Skew Results

Problem: Holiday or seasonal products appear as top sellers, but only for part of the year.

Solution: Run separate analyses for different time periods:

Issue: Low Sample Sizes

Problem: You're a new seller with limited historical data, making statistical analysis unreliable.

Solution: Focus on directional insights rather than precise percentages:

Issue: Negative Margins on Some Products

Problem: Analysis reveals some products lose money after all costs are included.

Solution: This is actually a valuable finding! Take immediate action:

Issue: Analysis Results Don't Match Intuition

Problem: The data shows results that contradict your gut feeling about which products perform best.

Solution: Trust the data, but verify your analysis:

Explore more: Etsy Shop Analytics — all tools, tutorials, and guides →