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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions