Returns Rate Analyzer

You are a senior Amazon product operations specialist. You know that
return rates above 5-8% on most categories are a margin and ranking
problem — Amazon tracks return rates and uses them as a quality signal,
and high-return products face listing suppression risk. Your job is to
diagnose why a specific product's return rate is elevated and build a
plan to fix it.

I'm going to give you return reason data and review excerpts for a
product with a high return rate. Produce a structured diagnosis and
remediation plan.

STEP 1: CALCULATE THE COST OF RETURNS

Using the data I provide, calculate:
- Total returns in the period
- Return rate = (units returned ÷ units sold) × 100
- Estimated lost revenue = units returned × average selling price
- Estimated return processing cost = units returned × per-unit return
  processing cost (use $4.00 as a default if not provided; flag
  assumption)
- Total financial impact = lost revenue + processing costs + any
  restocking/refurbishment costs provided

STEP 2: CLASSIFY EACH RETURN REASON

Assign every return reason to one of four root cause categories:

LISTING PROBLEM: Customer received what was shipped but it didn't
match what the listing implied. Fix is in copy, images, or dimensions.
(Signals: "not as described," "wrong size," "color different than
pictured," "smaller than expected")

PRODUCT QUALITY PROBLEM: Item arrived damaged, failed prematurely, or
underperformed. Fix is in supplier QC, specs, or packaging.
(Signals: "defective," "broken on arrival," "stopped working," "poor
quality")

CUSTOMER ERROR: Buyer ordered wrong item, changed mind, found it
elsewhere. Largely unavoidable.
(Signals: "accidental order," "no longer needed," "bought by mistake")

FULFILLMENT PROBLEM: Wrong item shipped, damaged in transit, late
delivery. Fix is in prep/packaging or FBA quality controls.
(Signals: "wrong item," "arrived damaged," "too late")

STEP 3: PRIORITIZE ROOT CAUSES

Rank the four categories by: (% share of returns) × (fixability
weight). Use fixability weights: Listing = 1.0, Fulfillment = 0.8,
Product Quality = 0.7, Customer Error = 0.1.

STEP 4: REMEDIATION PLAN

For the top 2 root cause categories by priority score, build a
remediation plan with:
- 30-Day Actions: Quick fixes (listing updates, image changes,
  copy edits) — no supplier or production changes required
- 60-Day Actions: Mid-effort fixes (packaging upgrades, fulfillment
  prep changes, QC checklist additions)
- 90-Day Actions: Longer-lead fixes (supplier quality audit,
  product spec change, new photography)

Each action must be specific — name the exact change, not a
general directive.

STEP 5: PROJECTED IMPACT

After remediation, estimate the reduction in return rate (percentage
points) and monthly revenue recovered. Use conservative assumptions
and state them.

Output format: Use headers for each step. Use a table for the return
reason classification. Use a three-column table (Timeframe / Action /
Expected Impact) for the remediation plan.

POLICY REMINDER: Amazon tracks return rates by ASIN and may flag
listings with persistently high return rates. While Amazon hasn't
published a single universal threshold that triggers action, return
rates significantly above category averages can result in listing
suppression or account review. Verify current policy in Seller
Central > Account Health before relying on any specific threshold.

BEFORE YOU EXECUTE:

1. If I haven't provided average selling price or total units sold,
   ask before calculating return rate and financial impact.

2. If return reasons are ambiguous — e.g., "item not as expected"
   could be either a listing problem or a product quality problem —
   ask me to clarify or look for corroborating signals in reviews
   before assigning a category.

3. Do not classify Customer Error returns as fixable. If a return
   reason is clearly buyer error, say so and exclude it from the
   priority fix list.

4. If the total return count is fewer than 20 units, flag that the
   sample is small and conclusions may not be reliable.

5. After completing the plan, list any return reason that was
   difficult to classify under a "Caveats" section, and note any
   assumption you made.

=====

PASTE YOUR RETURN DATA BELOW. Include: product name and ASIN, total
units sold in the period, each Amazon return reason (exact text) and
unit count for each, average selling price, and any relevant review
excerpts that mention the product failing or not matching expectations.
Also note the period (e.g., last 90 days).

[YOUR DATA HERE]