Handle "where is my order" and order status questions by looking up order details in Shopify and the Supabase operations database. Use this skill when a customer asks about order status, tracking, delivery timeline, or has concerns about a delayed shipment. This is the most common customer inquiry type (~40% of tickets).
Customers asking about their order status is the single most common inquiry. This skill looks up the order, determines the current status, and generates an accurate, helpful response.
Extract order identification from the customer's message:
Query the orders table in Supabase, or use the Shopify API directly if needed.
Map the order's fulfillment status to a customer-friendly explanation:
| Internal Status | Customer-Facing Status | Explanation |
|---|
unfulfilled | Being Prepared | Order received, being picked and packed |
partially_fulfilled | Partially Shipped | Some items shipped, others being prepared |
fulfilled + no tracking | Shipped | Label created, awaiting carrier scan |
fulfilled + tracking active | On Its Way | In transit with carrier |
fulfilled + delivered | Delivered | Carrier confirms delivery |
cancelled | Cancelled | Order was cancelled (check reason) |
refunded | Refunded | Refund processed |
Nepal-sourced items (longer lead times):
Some products ship directly from our Nepal workshop. These have 2-4 week lead times. Check the fulfillment_route field — if it's "nepal", set appropriate expectations and explain the artisan sourcing context positively.
FBA orders:
Orders fulfilled by Amazon have separate tracking. Check fulfillment_route = 'fba' and direct customer to Amazon tracking.
Delayed orders (>7 business days domestic, >21 days international):
Order not found:
Use the response template from agents/customer-service/skills/ticket-triage/response-templates.md as a starting point, but personalize:
orders table — Primary lookup for order status, fulfillment route{
"order_found": true,
"order_number": "#1042",
"status": "on_its_way",
"tracking_number": "9400...",
"carrier": "USPS",
"estimated_delivery": "2026-03-25",
"response_draft": "...",
"needs_escalation": false,
"escalation_reason": null
}