ds@mcpanalytics.aiEmail your data and your question and get an answer about your own data, with the method shown.Email your data and question. Get an answer.

How to Use Product Variation Performance in Etsy: Step-by-Step Tutorial

Updated October 2026

Discover which product variations drive sales, identify underperformers, and make confident inventory decisions with data-backed insights.

Introduction to Product Variation Performance

If you're running an Etsy shop with multiple product variations (different colors, sizes, materials, or styles) you've likely wondered: which variations are actually selling? Should you keep offering that rarely-purchased option, or double down on your best performers?

Product variation performance analysis answers these critical questions by revealing exactly which options customers prefer. This data-driven approach helps you optimize inventory, reduce dead stock, and focus resources on variations that generate revenue.

In this comprehensive tutorial, you'll learn how to analyze your Etsy product variations systematically, interpret performance metrics correctly, and make strategic decisions that improve profitability. Whether you're managing dozens of variations or just a few key options, this guide will transform how you approach product management.

Prerequisites and Data Requirements

Before diving into variation analysis, ensure you have the following in place:

Required Access and Tools

Data Collection Steps

Follow these steps to gather the necessary data from your Etsy shop:

Step 1: Access Your Etsy Shop Manager

Log into your Etsy account and navigate to Shop Manager. Click on "Settings" in the left sidebar, then select "Options" followed by "Download Data."

Step 2: Export Order Data

Select the date range for your analysis. For variation performance, we recommend:

  • Minimum: Last 90 days for seasonal products
  • Recommended: Last 6-12 months for comprehensive insights
  • Consider: Full year data to account for seasonal variations

Download the order items CSV file and check that it contains variation details for each purchase.

Step 3: Verify Data Completeness

Open your downloaded CSV and confirm it includes these essential columns:

Order ID, Sale Date, Item Name, Variations, Quantity, Price, Item Total

The "Variations" column should contain structured data like:

"Size: Large | Color: Navy Blue"
"Material: Sterling Silver | Length: 18 inches"
"Style: Modern | Finish: Matte"

Understanding Variation Data Structure

This tutorial assumes each variation appears as "Property: Value" pairs separated by pipes (|). Etsy's export layout can differ or change, so open your own file and adjust the examples below to what it actually contains:

Example 1: Single Property
Variations: "Size: Medium"

Example 2: Multiple Properties
Variations: "Size: Large | Color: Forest Green | Material: Organic Cotton"

Example 3: No Variations
Variations: (empty field)

Pro Tip: Products without variations will have empty variation fields. These should be analyzed separately as standalone products rather than variation options.

Step-by-Step Variation Performance Analysis

Step 1: Count Orders by Variation Option

Split each order's variation text into its Property: Value pairs and count orders and revenue per option. The section "Run It on Your Own Etsy Export" below shows how to do this on your own export at MCP Analytics.

Step 2: Review Variation Performance Metrics

Once you have the counts, look at these metrics for each variation. All figures in the examples below come from a synthetic data set generated for this tutorial; they are not from a real shop.

Core Performance Metrics Explained

1. Order Volume

The total number of orders containing this specific variation option. This is observed sales volume. It reflects customer preference only if every option was available for the same time, at the same price and shown equally.

Example Output:
Color: Navy Blue - 847 orders
Color: Forest Green - 312 orders
Color: Burgundy - 156 orders
Color: Coral - 89 orders

Interpretation: Of the 1,404 color orders shown, Navy Blue accounts for 847 (60.3%) and Coral for 89 (6.3%). Navy Blue sells the most; whether Coral underperforms depends on how long and how prominently it was offered.

2. Revenue Contribution

Total revenue generated by each variation, accounting for both price and volume. Some variations may sell less frequently but at higher prices.

Example Output:
Size: Small - $12,450 (425 orders @ avg $29.29)
Size: Medium - $18,920 (680 orders @ avg $27.82)
Size: Large - $15,680 (534 orders @ avg $29.36)
Size: X-Large - $8,340 (220 orders @ avg $37.91)

Interpretation: While Medium has the highest order volume, X-Large has the highest average order value, suggesting premium pricing opportunities.

3. Percentage of Total Sales

Each variation's contribution to your overall sales volume, helping you understand relative importance.

Example Output:
Material: Sterling Silver - 62.3% of jewelry orders
Material: Gold Filled - 28.7% of jewelry orders
Material: Rose Gold - 9.0% of jewelry orders

Interpretation: Sterling Silver dominates, but Rose Gold's lower share doesn't necessarily mean poor performance: consider inventory costs and profit margins.

4. Trend Analysis

Month-over-month and quarter-over-quarter performance changes reveal seasonal patterns and emerging preferences.

Example Output:
Style: Minimalist - +23% growth (Q4 vs Q3)
Style: Bohemian - -8% decline (Q4 vs Q3)
Style: Vintage - +2% stable (Q4 vs Q3)

Interpretation: Minimalist style is gaining momentum while Bohemian may be losing appeal or facing increased competition.

Step 3: Identify Top and Bottom Performers

You can segment your variations into performance tiers like these. This classification helps prioritize your next actions.

Performance Tier Definitions

🌟 Top Performers (Top 20%)
- High order volume AND strong revenue contribution
- Growing or stable trend patterns
- Action: Maintain inventory, consider expansion

⭐ Solid Performers (20-60%)
- Consistent sales with moderate volume
- Stable performance without major declines
- Action: Maintain current approach, monitor trends

⚠️ Underperformers (60-90%)
- Below-average order volume
- Limited revenue contribution
- Action: Evaluate for improvement or discontinuation

🚫 Poor Performers (Bottom 10%)
- Minimal orders over analysis period
- Declining trends or stagnant sales
- Action: Strong candidate for discontinuation

These tiers are rank cutoffs on order volume and revenue. They do not adjust for seasonality, price or how long an option has been offered, so check those yourself before acting on a tier.

Step 4: Conduct Deeper Statistical Analysis

For variations near decision thresholds, apply statistical rigor to avoid premature conclusions, using a test similar to those in A/B testing.

When to Apply Statistical Testing

Example: Comparing Two Similar Variations

Suppose you're deciding between two colors with similar performance:

Color: Sage Green
- Orders: 124
- Revenue: $3,596
- Trend: +5% growth

Color: Dusty Rose
- Orders: 118
- Revenue: $3,422
- Trend: +3% growth

Rather than discontinuing Dusty Rose based on slightly lower numbers, run a simple test. For counts like these, an exact binomial test asks whether 124 versus 118 orders could plausibly come from an even split:

Orders: 124 vs 118 (51.2% and 48.8% of 242)
Exact binomial test against an even split: p = 0.75

This assumes both colors were offered for the same time and shown to the same buyers. The p-value is the probability of data at least this extreme if there were no real difference; a small p-value is evidence against no difference, not proof of an effect, and a large one is not proof of no effect. Here the data show no evidence of a difference in demand, which is not evidence that the two are equal, so decide on cost and context too.

Step 5: Consider Context Beyond Raw Numbers

Quantitative data tells most of the story, but contextual factors matter for final decisions:

Inventory and Supply Chain

  • Minimum order quantities from suppliers
  • Cost differences between variation materials
  • Storage and handling complexity
  • Lead times for restocking

Customer Experience

  • Offering variety as a competitive advantage
  • Meeting diverse customer preferences
  • Bundle and upsell opportunities
  • Customer feedback and reviews

Operational Efficiency

  • Production time differences between variations
  • Error rates and quality control challenges
  • Packaging and shipping complexity
  • Photography and listing maintenance burden

Interpreting Your Results

Making Discontinuation Decisions

Discontinuing a variation is a significant decision that requires careful consideration. Use this decision framework:

Definite Discontinuation Candidates

Consider removing variations that meet multiple criteria:

  • Fewer than 10 orders in the past 6 months
  • Represents less than 2% of category sales
  • Declining trend over multiple quarters
  • High production complexity or cost
  • No strategic value (e.g., doesn't complete a collection)

Investigate Before Discontinuing

Variations requiring deeper analysis before removal:

  • Recently launched (less than 6 months available)
  • Seasonal products outside peak season
  • Part of a coordinated product collection
  • Receives positive customer feedback despite lower sales
  • Fills a specific niche or customer segment

Retain and Monitor

Variations worth keeping despite moderate performance:

  • Enables bundle purchases with top performers
  • Low incremental cost to maintain
  • Differentiates your shop from competitors
  • Shows stable (not declining) performance
  • Represents your brand identity or aesthetic

Identifying Expansion Opportunities

Top-performing variations often reveal untapped potential. Look for these expansion signals:

1. Capacity Constrained Winners

Indicator: Variation frequently sells out
Example: "Size: Large" shows 15 stockout periods
Action: Raise inventory levels, sized to your supplier lead times

2. Adjacent Variation Opportunities

Indicator: Strong performance in related options
Example: "Color: Navy" and "Color: Forest Green" both top performers
Action: Test additional dark, muted tones like "Charcoal" or "Burgundy"

3. Price Point Optimization

Indicator: Premium variations outperform expectations
Example: "Material: Gold Filled" at +$15 shows strong conversion
Action: Test additional premium options or higher base pricing

4. Trend Acceleration

Indicator: Rapid growth in specific variation
Example: "Style: Minimalist" shows +45% quarterly growth
Action: Expand minimalist variations across other product lines

Advanced Analysis: Variation Combinations

The most powerful insights come from analyzing how variations perform together. Counting orders by combination of options shows which combinations sell most:

Top Combination Analysis:
1. Size: Medium + Color: Navy + Material: Organic Cotton - 156 orders
2. Size: Large + Color: Black + Material: Bamboo - 142 orders
3. Size: Small + Color: White + Material: Linen - 98 orders

Underperforming Combinations:
1. Size: X-Large + Color: Yellow + Material: Polyester - 3 orders
2. Size: Small + Color: Neon Green + Material: Synthetic - 5 orders

In this synthetic example, Medium + Navy + Organic Cotton is the top-selling combination. Order counts alone do not show whether buyers seek that combination out or whether it simply combines popular options; to test that, compare each combination's count with the count expected from the individual options' popularity.

Implementing Your Insights

Creating an Action Plan

Transform your analysis into a structured implementation plan with clear priorities and timelines.

Phase 1: Quick Wins (Week 1-2)

  1. Discontinue clear underperformers: Remove variations with fewer than 5 orders in 6 months and no strategic value
  2. Update inventory levels: Increase stock for top performers showing stockout patterns
  3. Adjust listing prominence: Move top variations to first position in listing photos and descriptions

Phase 2: Strategic Adjustments (Week 3-6)

  1. Test new variations: Launch 1-2 new options based on top performer patterns
  2. Price optimization: Adjust pricing for premium variations showing strong demand
  3. Bundle creation: Develop product bundles featuring top-performing combinations

Phase 3: Continuous Monitoring (Ongoing)

  1. Monthly reviews: Track variation performance metrics monthly
  2. Quarterly deep dives: Comprehensive analysis every quarter
  3. A/B testing: Systematically test new variation hypotheses

Tracking Implementation Success

Establish clear metrics to measure the impact of your variation optimization:

Key Performance Indicators:
- Overall Revenue: set your own target
- Inventory Turnover: reduce slow-moving stock
- Average Order Value: Increase through better variation mix
- Customer Satisfaction: Monitor reviews for discontinued items
- Operational Efficiency: Reduce SKU complexity overhead

Re-run the analysis on a fresh export each month to track progress against your own targets.

Run It on Your Own Etsy Export

Export your orders from Etsy as a CSV and upload it at MCP Analytics. The analysis counts orders and revenue for each variation option on your file and shows the result with the method used. You choose the columns; nothing connects to your Etsy account.

Try it on your data

Common Issues and Solutions

Problem 1: Insufficient Data for Analysis

Symptom: Analysis shows "insufficient data" warnings for most variations.

Cause: Fewer than 30-50 orders per variation, making statistical patterns unreliable.

Solution:

  1. Extend your analysis period to 12+ months
  2. Combine data across similar product listings
  3. Focus on property-level analysis (all "Size" variations together) rather than specific combinations
  4. Wait until you accumulate more sales data before making major decisions

Problem 2: Variations Not Parsing Correctly

Symptom: Variation data appears as raw text instead of separated properties.

Cause: Non-standard formatting in your Etsy variation setup or CSV export issues.

Solution:

  1. Verify your CSV uses UTF-8 encoding (re-export if necessary)
  2. Check that variation data follows Etsy's standard format: "Property: Value | Property: Value"
  3. Contact support if custom variation formats require special parsing
  4. Manually standardize variation naming in your Etsy listings for future consistency

Problem 3: Seasonal Products Show Misleading Trends

Symptom: Variations show strong negative trends but are actually seasonal.

Cause: Analysis period doesn't account for natural seasonal fluctuations.

Solution:

  1. Analyze full 12-month periods to capture complete seasonal cycles
  2. Compare year-over-year (YoY) rather than quarter-over-quarter
  3. Segment analysis by season: compare this summer to last summer
  4. Note seasonal context in your decision-making process

Problem 4: Recently Added Variations Appear as Underperformers

Symptom: New variations rank in bottom tier despite positive early signals.

Cause: Insufficient time in market compared to established variations.

Solution:

  1. Filter analysis to include only variations available for the full analysis period
  2. Create separate "new variation" tracking with appropriate benchmarks
  3. Use daily or weekly performance rates instead of absolute totals
  4. Wait at least 90 days before making discontinuation decisions on new options

Problem 5: Multiple Properties Create Analysis Complexity

Symptom: Products with 3+ variation properties (Size, Color, Material, Style) create hundreds of combinations.

Cause: Combinatorial explosion makes it difficult to identify clear patterns.

Solution:

  1. Analyze each property dimension independently first
  2. Focus on two-way combinations for the most important properties
  3. Consider simplifying your variation structure by reducing property count
  4. Use the tool's aggregation features to group similar combinations

Problem 6: Conflicting Signals Between Metrics

Symptom: A variation shows high order volume but low revenue, or vice versa.

Cause: Price differences, discounting patterns, or bundling affects metrics inconsistently.

Solution:

  1. Calculate and compare profit margins, not just revenue
  2. Consider strategic value: volume drivers vs. profit maximizers both have roles
  3. Review your pricing strategy for the conflicting variation
  4. Examine whether the variation is frequently purchased with others (bundle effect)

Next Steps with Etsy Analytics

Product variation performance is just one dimension of Etsy shop optimization. Expand your data-driven approach with these related analyses:

Advanced Analytics Techniques

Complementary Etsy Analyses

Continuous Improvement Process

Establish a regular cadence for variation analysis and optimization:

Monthly: Quick review of top and bottom performers
Quarterly: Comprehensive analysis with discontinuation decisions
Biannually: Strategic planning for new variation launches
Annually: Complete product line review and restructuring

This systematic approach ensures your product offerings continuously evolve based on real customer preferences rather than assumptions or guesswork.

Your turn

Bring your own data and the question you actually need answered.

MCP AnalyticsData science by email Send us your data and your question, and we will reply. ds@mcpanalytics.ai

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