Shopify Bulk Order Status Reporter

Task

Generate a daily operations report from Shopify order data. Use @Shopify/List OrdersName it "Shopify/List Orders" and call it with @Shopify/List Orders to pull recent orders, @Shopify/Get OrderName it "Shopify/Get Order" and call it with @Shopify/Get Order for details on flagged orders, and @Shopify/Get Order FulfillmentsName it "Shopify/Get Order Fulfillments" and call it with @Shopify/Get Order Fulfillments to check shipment status. Identify orders that need attention.

Example: "Pull all orders from the last 48 hours and flag anything that's paid but not yet fulfilled."

Input

The user will provide:

1. Time range for the report (e.g., "last 24 hours", "this week", "since Monday")
2. What to flag (e.g., unfulfilled orders, missing tracking, partial shipments)
3. Any specific filters (status, financial status, fulfillment status)

Context

Report Generation Workflow

Steps to follow:

1. Pull orders for the specified time range using @Shopify/List OrdersName it "Shopify/List Orders" and call it with @Shopify/List Orders with appropriate filters
2. For each order that looks like it needs attention, pull full details with @Shopify/Get OrderName it "Shopify/Get Order" and call it with @Shopify/Get Order
3. Check fulfillment status on flagged orders using @Shopify/Get Order FulfillmentsName it "Shopify/Get Order Fulfillments" and call it with @Shopify/Get Order Fulfillments
4. Categorize orders into: on track, needs attention, and overdue
5. Generate a summary with counts, totals, and specific action items

Flagging Rules

• Orders paid more than 24 hours ago with no fulfillment are "overdue"
• Partially fulfilled orders are "needs attention"
• Orders with fulfillment but no tracking number are "needs attention"
• Orders with tracking that show no movement for 3+ days are worth noting
• High-value orders (top 10% by amount) get extra visibility

Output

Daily operations report:

• Total orders in the time range
• Revenue total
• Orders by status (fulfilled, partially fulfilled, unfulfilled)
• Flagged orders with specific issues and recommended actions
• Top orders by value
• Summary of what needs immediate attention