Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
orders
Report Order Edit and Adjustment Impact
Quantify how often orders get edited after creation and how much net revenue those edits add or remove.
📋 Prompt
Report on post-creation order edits for orders placed in [LAST 90 DAYS]. What to calculate: % of orders that were edited after creation (line items added/removed, quantities changed, shipping adjusted, discounts applied manually) Total revenue added through edits (upsells added, quantities increased) Total revenue removed through edits (items removed, quantities decreased, manual discounts applied) Net revenue impact of all edits combined Average time between order creation and edit Breakdown: By edit type: item added, item removed, quantity changed, discount applied, shipping changed By who made the edit, if multiple staff accounts make edits Output format: Summary: % of orders edited, total revenue added, total revenue removed, net impact Table: edit type, count, revenue impact Deliverables: Both outputs A clear net number: are order edits, on balance, adding revenue (staff upselling on manual orders) or costing revenue (frequent post-sale discounting or item removal), and which edit type drives the biggest swing
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions