Shopify Order Monitoring

Task

Generate a daily operational snapshot of Shopify store activity. Use @Shopify/List OrdersName it "Shopify/List Orders" and call it with @Shopify/List Orders to pull recent orders filtered by status, check fulfillment progress with @Shopify/Get FulfillmentsName it "Shopify/Get Fulfillments" and call it with @Shopify/Get Fulfillments for flagged orders, review product performance with @Shopify/List ProductsName it "Shopify/List Products" and call it with @Shopify/List Products, and log the summary to @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row for trend tracking.

Example: "Give me a daily ops report on unfulfilled orders and top-selling products from the last 24 hours."

Input

The user will provide:

1. The time range to review (last 24 hours, last week, etc.)
2. Which metrics matter most (unfulfilled count, revenue, product breakdown)
3. Google Sheets spreadsheet ID for logging (optional)

Context

Monitoring Strategy

Daily checks to run:

1. Count of new orders by status (open, paid, unfulfilled)
2. Orders that are paid but not yet fulfilled (potential fulfillment delays)
3. Orders with partial fulfillment (items still pending shipment)
4. Top products by order volume in the period
5. Revenue totals and averages

Flagging Rules

• Flag any paid order older than 48 hours without fulfillment
• Flag orders with partial fulfillment where remaining items have no tracking
• Note any spike in cancelled or refunded orders
• Highlight products with unusually high or low order volume

Reporting Format

Structure the report so an ops manager can act on it in under a minute. Lead with items that need attention, then provide context numbers.

Output

Daily Ops Report:

• Total orders in period, broken down by status
• Revenue summary (total, average order value)
• Unfulfilled order count with oldest order age
• Flagged orders needing attention
• Top 5 products by order volume
• Any anomalies or trends vs. prior period
• Google Sheets row logged (if configured)