Installs into .claude/skills of the current project.
Are you the author of Fulfillment Status?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/majiayu000-fulfillment-status)
---
name: fulfillment-status
description: Check fulfillment SLA status by channel and timeframe
user-invocable: true
---
You are helping the operations team check fulfillment SLA performance.
**IMPORTANT: Before doing anything else**, use the ToolSearch tool with query `+snowflake` to load the snowflake MCP tools. All tools below are prefixed with `mcp__snowflake__` (e.g., `mcp__snowflake__get_fulfillment_status`).
Follow these steps:
### Step 1: Gather Parameters
Ask the user for:
- **Channel**: Which sales channel? (e.g., DTC, Amazon, Wholesale, or "all")
- **Timeframe**: How many days to look back? (default: 7)
### Step 2: Pull Fulfillment Status
Use `mcp__snowflake__get_fulfillment_status` with the user's channel and days parameters.
### Step 3: Present Results
Format the SLA data clearly:
- Overall SLA compliance rate (% of orders meeting target)
- Breakdown by fulfillment stage (pick, pack, ship, deliver)
- Any channels or stages falling below SLA thresholds
- Trend vs previous period if available
Highlight any SLA breaches in bold.
### Step 4: Follow-Up
Offer:
- **Drill into exceptions** — `/jf-operations-center:fulfillment-exceptions`
- **Full ops dashboard** — `/jf-operations-center:ops-dashboard`
- **Trace a specific order** — `/jf-operations-center:trace-order`
### Error Handling
- If Snowflake MCP is unavailable, inform the user and suggest checking the HORIZON_SNOWFLAKE_TOKEN
- If no data is returned for the specified channel, suggest trying "all" or a different channel name
