Shopify Admin Fulfillment Status Digest

Workflow Steps

1. OPERATION: orders — query Inputs: first: <limit>, query: "fulfillment_status:unfulfilled OR fulfillment_status:partial", sort by CREATED_AT ascending (oldest first), paginate until complete Expected output: All open orders with createdAt, name, displayFulfillmentStatus; compute age = now − createdAt in days; bucket into aging_thresholds_days segments

2. OPERATION: fulfillmentOrders — query (via nested order.fulfillmentOrders) Inputs: For each order from Step 1: fulfillmentOrders(first: 5) to check status and requestStatus; flag any with status: ON_HOLD Expected output: Hold status per order, holdUntil if set; contribute to the Holds section of the digest

GraphQL Operations

# orders:query — validated against api_version 2025-01
query FulfillmentStatusDigest($first: Int!, $after: String, $query: String) {
  orders(first: $first, after: $after, query: $query, sortKey: CREATED_AT) {
    edges {
      node {
        id
        name
        createdAt
        displayFulfillmentStatus
        displayFinancialStatus
        totalPriceSet {
          shopMoney { amount currencyCode }
        }
        customer {
          id
          firstName
          lastName
        }
        fulfillmentOrders(first: 5) {
          edges {
            node {
              id
              status
              requestStatus
              fulfillAt
            }
          }
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

Note: fulfillmentOrders is a nested field on the Order type — the fulfillmentOrders:query frontmatter entry documents that this operation accesses fulfillment order data.

Session Tracking

Claude MUST emit the following output at each stage. This is mandatory.

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: fulfillment-status-digest            ║
║  Store: <store domain>                       ║
║  Started: <YYYY-MM-DD HH:MM UTC>             ║
╚══════════════════════════════════════════════╝

After each step, emit:

[N/TOTAL] <QUERY|MUTATION>  <OperationName>
          → Params: <brief summary of key inputs>
          → Result: <count or outcome>

On completion, emit:

For format: human (default):

══════════════════════════════════════════════
OUTCOME SUMMARY
  Total open orders:          <n>
  By age bucket (0-1d):       <n>
  By age bucket (1-3d):       <n>
  By age bucket (3-7d):       <n>
  By age bucket (7d+):        <n>
  Orders on hold:             <n>
  Errors:                     0
  Output:                     none
══════════════════════════════════════════════

For format: json, emit:

{
  "skill": "fulfillment-status-digest",
  "store": "<domain>",
  "started_at": "<ISO8601>",
  "completed_at": "<ISO8601>",
  "dry_run": false,
  "steps": [
    { "step": 1, "operation": "FulfillmentStatusDigest", "type": "query", "params_summary": "limit: <n>, query: fulfillment_status:unfulfilled OR partial", "result_summary": "<n> orders fetched", "skipped": false },
    { "step": 2, "operation": "fulfillmentOrders", "type": "query", "params_summary": "nested per order, first: 5", "result_summary": "<n> orders on hold", "skipped": false }
  ],
  "outcome": {
    "total_open_orders": 0,
    "buckets": [
      { "label": "0-1d", "count": 0 },
      { "label": "1-3d", "count": 0 },
      { "label": "3-7d", "count": 0 },
      { "label": "7d+", "count": 0 }
    ],
    "orders_on_hold": 0,
    "errors": 0,
    "output_file": null
  }
}

Output Format

Fulfillment Age Digest — <store> — <date>

Orders On Hold (if include_holds: true and holds exist):

Error Handling

Best Practices

1. Run this digest first thing each morning before processing any orders — it gives you the exception queue in one view.
2. Orders in the 7d+ bucket are your highest priority; investigate and either fulfill or place an explicit hold with a reason.
3. Use format: json to pipe the digest into a Slack notification or dashboard script.
4. Combine with order-hold-and-release to act on exceptions identified in this digest without leaving the CLI.
5. For stores with 500+ open orders, set limit: 100 and expect pagination — the digest will still aggregate correctly across all pages.