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
This skill systematically audits your Amazon product listings using data-driven insights aligned with A9 algorithm mechanics, keyword relevance, and conversion psychology. You'll receive actionable recommendations to improve search ranking, increase click-through rates, and optimize conversion rates while ensuring full compliance with Amazon's content guidelines and category-specific requirements.
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
You can conduct rapid, structured UX audits of e-commerce experiences without needing design expertise. By applying Nielsen's proven heuristics framework adapted for conversion-critical flows, you'll identify specific usability violations, quantify their conversion impact, and receive prioritized recommendations that your product or design team can action immediately. This transforms subjective design critique into standardized, defensible analysis.
by composiohq
You can systematically audit product catalogs across 3+ marketplace channels, detect sync discrepancies in real time, validate data against channel-specific requirements, and automate compliance checks before publishing. This skill prevents overselling, catches formatting errors, identifies missing attributes, and ensures your listings meet platform policies—transforming catalog management from reactive firefighting to proactive, error-free operations.
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
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
Process high-volume review batches (10-500+ monthly) to extract actionable intelligence instead of scattered feedback. You'll categorize reviews by sentiment, root cause, and urgency; identify systemic product or service issues masked by individual complaints; and generate psychology-informed, platform-compliant responses designed to recover ratings and improve seller performance metrics.
by composiohq