Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics orders

Report High-Value Order Watchlist

List every order above a set dollar threshold for a period, so large orders get a manual look before or after fulfillment.

📋 Prompt
Run in Sidekick
List every order over [$500] placed in [LAST 30 DAYS], for manual review.

Per order:

  Order number, date, total value
  Customer name and whether they’re a first-time or returning buyer
  Number of items and shipping destination
  Current fulfillment/payment status
  Whether the order has already been flagged by Shopify’s fraud analysis


Summary:

  Total number of orders over the threshold and their combined revenue as a % of total store revenue for the period
  How many of these large orders are from first-time customers (generally worth extra scrutiny) vs established repeat customers
  Average time to fulfillment for this group compared to the store average — large orders sometimes get delayed if they need extra packing


Output format:

  Table: order #, date, value, customer, new/returning, items, destination, status, fraud flag


Deliverables:

  The table
  Total revenue represented by this watchlist as a % of the period’s total revenue
  Flag any first-time-customer large order that also carries a fraud-analysis warning, so it gets a manual look before shipping

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