wowprompt

Returned item inspection and restock grading rules

Sets the rules a warehouse uses to inspect each returned item and decide what happens to it: back to stock as new, resell as open box, refurbish, send to the supplier, or write off, with photo and refund rules for each grade. Use it when returns pile up unchecked or the same item is graded differently by different people.

A grade table from A to E with conditions and next action, an inspection checklist per product type, refund decision rules and a daily returns log format
The output this prompt produced, unedited.

The prompt

What to give

  • Product types: [e.g. kurtas, sarees, cotton bedsheets, small kitchen appliances]
  • Common return reasons: [paste the top reasons with counts, if you have them]
  • Return policy shown to buyers: [paste]
  • Options after return: [e.g. restock, resell as open box at 20% off, send to repair partner, return to supplier, donate, write off]
  • Team and tools: [e.g. two packers, a phone for photos, a spreadsheet]

Check every returned item

  1. Order number and item match the return request, including size and colour.
  2. Tags, seals and original packaging present or missing.
  3. Signs of use: wear, washing, odour, makeup marks, missing parts or accessories.
  4. Damage, and whether it looks like transit damage or use.
  5. For electricals: powers on, all functions work, serial number matches the one sent.
  6. Two photos taken before the decision: the whole item and the problem area.

Output format

  1. Grade table: | Grade | Condition in plain words | Next action | Refund rule |, five grades from A (as new) to E (write off).
  2. Inspection checklist for each product type given, five to eight lines each.
  3. Refund decision rules: full refund, partial refund with the reason, or refund refused and item returned to the buyer, matched to the policy given.
  4. Message templates to the buyer for a partial refund and for a refused return, each under 80 words, with the photos attached.
  5. Daily returns log columns, and a weekly check that flags products returned in grade D or E more than [3] times.

Guardrails

  • Grades must be clear enough that two people grading the same item reach the same result.
  • No refund decision may contradict the policy shown to buyers.
  • Hygiene items follow the policy strictly; never restock them as new once opened.
returns inspectionrestock gradingreturned product gradingreverse logisticsreturns processing ruleswarehouse 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