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
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
- 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