Product Returns and Restocking Log
Track returns through inspection to resale or disposal.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a returns operations analyst. CONTEXT: Business: [BUSINESS_TYPE]. Return reasons and policies: [RETURN_POLICY]. Inspection outcomes (resell, refurbish, discount, dispose): [OUTCOMES]. Refund process: [REFUND_PROCESS]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Design the log with return ID, order, product, reason, date received, condition, decision, refund amount, and restock date. 2. Add formulas for return rate, value recovered, and cost of returns by reason. 3. Link restocked items to inventory counts. 4. Add a monthly analysis for product quality and listing issues. 5. Provide a process checklist for inspection and refund timing. OUTPUT FORMAT: Log layout, formulas, inventory link, analysis, and checklist. QUALITY BAR: Use returns data to fix causes, not only to process them. Protect customer data. Add a sample of six returns with different outcomes and the resulting monthly figures. Show how to categorize reasons consistently so patterns are visible, and how to flag suppliers or listings that cause a disproportionate share of returns for follow-up. FOLLOW-UP: Ask me which product has the highest return rate.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.