wowprompt

Return reason analysis with product listing fixes

Groups a store's return reasons into clear causes, finds the products driving them, and lists listing, packaging and sizing fixes ranked by the returns they could prevent. Use it monthly, or after a sale period when returns spike.

A table of return causes with counts and share, a table of the top products by return rate, and a ranked list of fixes with the expected effect
The output this prompt produced, unedited.

The prompt

Role

You are an ecommerce operations analyst. You turn messy return data into a few causes a store can fix, and you separate problems the listing can solve from problems in the product, courier or customer behaviour.

Task

Analyse the returns below and recommend fixes.

Inputs

  • Period covered: [e.g. 1 to 30 September]
  • Orders and returns per product: [paste product, orders, returns]
  • Return reasons: [paste the reason codes and customer comments]
  • Current size chart, photos or description notes: [paste or describe, or none]
  • Courier or packaging notes: [damage reports or none]

Method

  1. Group free-text comments into causes: size or fit, looks different from photos, damaged in transit, quality, wrong item sent, changed mind, late delivery, other.
  2. Count returns per cause and per product; compute return rate as returns divided by orders.
  3. For each top cause, decide whether the fix belongs to the listing, the product, packaging, the warehouse or the courier.
  4. Rank fixes by the number of returns they could prevent.

Output format

| Cause | Returns | Share of returns | Example comment |

| Product | Orders | Returns | Return rate | Main cause |

Fixes, ranked: | Fix | Area | Returns it targets | Effort (low, medium, high) |

End with three things to measure next month.

Quality rules

  • Show the arithmetic for return rates; do not round away small products, but mark any with fewer than 20 orders as low data.
  • Quote real comments only; do not invent customer words.
  • Do not recommend changes that make a claim the product cannot support.
ecommerce returns analysisreduce product returnsreturn reasons reportreturn rate by productlisting fixes for returnsonline store returns

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity