Dropship Returns Escalation Analyzer
Analyze return patterns and build data-driven supplier escalation cases
What You Can Do
You can systematically analyze your dropship return data to uncover supplier-specific patterns, calculate the true cost of returns (refunds, shipping, labor, lost margin), and build compelling escalation cases with hard evidence. This skill helps you differentiate between legitimate supplier quality issues and customer abuse patterns, then generates negotiation strategies for chargebacks or return credits backed by quantified financial impact.
Features
Identify clustered returns by SKU, supplier, or return reason to spot systemic quality or fulfillment issues
Calculate total cost of returns including refunds, return shipping, processing labor, and lost profit margins
Generate structured escalation cases with timeline, evidence, and financial justification suppliers can't dismiss
Compare return rates, patterns, and costs across suppliers to prioritize escalation efforts
Distinguish between one-off complaints and statistically significant patterns requiring escalation
Extract customer feedback, review excerpts, and data points to support your chargeback or credit demand
Separate legitimate seasonal fluctuations from actionable quality issues worth escalating
Organize return data with timestamps and reasons to build defensible escalation records
Example Output
Input: 12 returns in 4 weeks for a supplier's t-shirt SKU (2,400 units sold), with reasons: "arrived damaged" (7), "wrong color" (3), "size too small" (2)
Output:
- Pattern Identified: 58% of returns claim damage, 3x higher than category average (15%)
- Financial Impact: $840 in refunds + $180 return shipping + $120 processing labor + $600 lost margin = $1,740 loss over 4 weeks
- Annualized Risk: If pattern continues, $22,620 annual loss from this SKU alone
- Root Cause Likelihood: Supplier's packaging inadequate for shipping method (high confidence based on photo evidence from 5 customers)
- Escalation Recommendation: Demand $2,100 return credit (120% of documented loss) or require upgraded packaging; threaten chargeback if unresolved in 10 days
- Negotiation Script: "Your t-shirt SKU shows 58% damage rate vs. our 15% average. We've documented $1,740 in losses over 4 weeks. We need either a $2,100 credit for this batch or guaranteed packaging upgrades with next order."
Second Example:
- Non-Issue Detected: Size complaint returns on "one size fits all" item tracked to customers outside your typical demographic—classifies as customer fit expectations, not supplier quality issue. Recommendation: Do not escalate.
What's Included
- SKILL.md: Complete skill configuration and usage instructions
- Return Data Analysis Template: Spreadsheet structure for organizing return data by supplier, SKU, date, and reason
- Root Cause Classification Checklist: Distinguish between supplier quality, shipping damage, customer misuse, and policy violations
- Financial Impact Calculation Worksheet: Step-by-step cost breakdown template including refunds, return shipping, labor, and margin loss
- Escalation Case Builder Framework: Structured template for documenting evidence, timeline, financial impact, and negotiation demands
- Supplier Scorecard: Compare return rates, costs, and patterns across multiple suppliers for prioritization
Who It's For
- Dropship store managers — Handle supplier quality issues and negotiate return credits or chargebacks
- E-commerce operations managers — Systematize returns analysis across multiple suppliers and product lines
- Supplier relationship managers — Build data-driven cases for supplier performance reviews and escalations
- Dropship business owners — Monitor and reduce return-related losses impacting bottom-line profitability
- Marketplace sellers — Identify problematic suppliers before quality issues tank your ratings
Best For
- Investigating why a single SKU or supplier has excess returns (5%+ return rate)
- Building chargeback or credit demand cases with financial evidence
- Quarterly supplier performance reviews and quality assessments
- Responding to supplier disputes about return rates or claims
- Calculating ROI of switching suppliers or requiring packaging upgrades
- Prioritizing which escalation issues to address first across multiple suppliers
You might also like
You can design and implement automated inventory synchronization workflows that keep stock levels consistent across 3+ sales channels simultaneously. This skill helps you establish a single source of truth for inventory, reduce overselling incidents from manual errors, and cut daily administrative work by automating stock level updates triggered by purchases on any channel. You'll gain visibility into channel-specific demand patterns and create prioritized update protocols that minimize data conflicts.
by composiohq
You can input your DTC conversion funnel data—including traffic, conversion rates by stage, user feedback, and session recordings—and Claude will identify where conversions statistically leak, synthesize root causes from multiple data sources, and generate a prioritized roadmap of A/B tests with confidence intervals and resource estimates. The skill produces investment-grade optimization recommendations that justify budget allocation to your team and stakeholders.
by composiohq
This skill reads invoice PDFs, scanned receipts, and financial documents to extract vendor name, invoice number, date, and amount. It then renames files using a consistent format (YYYY-MM-DD Vendor - Invoice - Description.pdf) and sorts them into logical folders by vendor, expense category, time period, or tax classification. You can transform hours of manual bookkeeping into minutes of automated organization, turning messy downloads and email attachments into a clean, audit-ready filing system.
by composiohq
You can systematically reconcile inventory levels across your website, marketplaces, physical stores, and social commerce channels to identify conflicts caused by processing delays and real-time transaction mismatches. Claude generates prioritized conflict reports, root cause analyses, and step-by-step reconciliation workflows that address channel-specific sync issues and implement buffer strategies to prevent overselling and stockouts during peak demand periods.
by composiohq
You can analyze your product listings against competitor benchmarks, generate platform-optimized titles and descriptions tailored to each marketplace's algorithm, identify high-impact keywords that drive traffic and conversions, and create data-driven A/B testing variations. This skill helps you manage multi-channel selling efficiently by providing actionable optimization recommendations that account for platform-specific ranking factors, customer intent, and conversion psychology across Amazon, eBay, Shopify, Etsy, and niche marketplaces.
by composiohq
You'll systematically analyze your e-commerce funnel to pinpoint friction points—form abandonment, checkout delays, unclear CTAs, confusing navigation—and connect each to measurable conversion loss. Claude generates a defensible improvement roadmap ranked by ROI potential, backed by behavioral psychology and conversion science principles, so you can present stakeholders with data-driven priorities that justify budget allocation.
by composiohq
Process hundreds of reviews monthly to identify sentiment trends, recurring complaint patterns, and business impact without manual analysis. Generate contextual, platform-compliant responses to negative reviews that address specific complaints while protecting your seller rating. Create standardized playbooks for recurring issues and track response effectiveness through structured metrics to turn review management into a competitive advantage.
by composiohq
This skill helps you systematically identify high-value customer segments, diagnose friction points specific to each group, and design segment-specific conversion interventions. You'll map personalization opportunities across your funnel, prioritize initiatives by ROI impact, and build business cases for personalization programs with measurable conversion uplift potential.
by composiohq