shopify-admin-wismo-bulk-status-report

Name: shopify-admin-wismo-bulk-status-report
Author: 40RTY-ai

168stars17forks

How to install shopify-admin-wismo-bulk-status-report?

40rty-ai/shopify-admin-skills/shopify-admin-wismo-bulk-status-report

$npx -y skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-wismo-bulk-status-report

Installs into the current project.

Summary

Identify orders at risk of generating WISMO support tickets: shipped orders with stale tracking, and unfulfilled orders past their SLA window.

Files · 1

View on GitHub

SKILL.md

1	## Purpose
2	Generates a bulk report of orders most likely to generate "Where Is My Order?" (WISMO) support tickets — shipped orders whose tracking hasn't updated in N days, and unfulfilled orders sitting past a configurable SLA. According to industry research, WISMO accounts for ~18% of all incoming support requests, making proactive identification a direct ops capacity investment. Read-only. Replaces manual order-by-order admin scanning or helpdesk searches. The CSV output can be used to proactively contact customers before they contact you.
3
4	## Prerequisites
5	- `shopify auth login --store <domain>`
6	- API scopes: `read_orders`
7
8	## Parameters
9
10	\| Parameter \| Type \| Required \| Default \| Description \|
11	\|-----------\|------\|----------\|---------\|-------------\|
12	\| store \| string \| yes \| — \| Store domain (e.g., mystore.myshopify.com) \|
13	\| format \| string \| no \| human \| Output format: `human` or `json` \|
14	\| dry_run \| bool \| no \| false \| Preview operations without executing mutations \|
15	\| unfulfilled_sla_days \| integer \| no \| 3 \| Flag unfulfilled orders older than this many days \|
16	\| stale_tracking_days \| integer \| no \| 5 \| Flag shipped orders where the last fulfillment was created more than this many days ago (proxy for stale tracking) \|
17	\| limit \| integer \| no \| 250 \| Max orders per page \|
18
19	## Workflow Steps
20
21	1. OPERATION: `orders` — query (unfulfilled at-risk)
22	Inputs: `first: <limit>`, `query: "fulfillment_status:unfulfilled created_at:<='<NOW minus unfulfilled_sla_days>'"`, sort by `CREATED_AT` ascending
23	Expected output: Orders unfulfilled past SLA window with `name`, `createdAt`, `customer`, `displayFulfillmentStatus`; label as `UNFULFILLED_OVERDUE`
24
25	2. OPERATION: `orders` — query (shipped but potentially stale)
26	Inputs: `first: <limit>`, `query: "fulfillment_status:shipped updated_at:<='<NOW minus stale_tracking_days>'"`, sort by `UPDATED_AT` ascending
27	Expected output: Shipped orders not updated recently with `name`, `createdAt`, `fulfillments.createdAt`, `fulfillments.trackingInfo`; label as `SHIPPED_STALE_TRACKING`
28
29	## GraphQL Operations
30
31	```graphql
32	# orders:query — validated against api_version 2025-01
33	query WismoOrders($first: Int!, $after: String, $query: String) {
34	orders(first: $first, after: $after, query: $query, sortKey: CREATED_AT) {
35	edges {
36	node {
37	id
38	name
39	createdAt
40	updatedAt
41	displayFulfillmentStatus
42	displayFinancialStatus
43	customer {
44	id
45	firstName
46	lastName
47	defaultEmailAddress {
48	emailAddress
49	}
50	}
51	shippingAddress {
52	city
53	province
54	country
55	}
56	fulfillments {
57	createdAt
58	status
59	trackingInfo {
60	number
61	url
62	company
63	}
64	}
65	totalPriceSet {
66	shopMoney { amount currencyCode }
67	}
68	}
69	}
70	pageInfo {
71	hasNextPage
72	endCursor
73	}
74	}
75	}
76	```
77
78	## Session Tracking
79
80	Claude MUST emit the following output at each stage. This is mandatory.
81
82	On start, emit:
83	```
84	╔══════════════════════════════════════════════╗
85	║ SKILL: wismo-bulk-status-report ║
86	║ Store: <store domain> ║
87	║ Started: <YYYY-MM-DD HH:MM UTC> ║
88	╚══════════════════════════════════════════════╝
89	```
90
91	After each step, emit:
92	```
93	[N/TOTAL] <QUERY\|MUTATION> <OperationName>
94	→ Params: <brief summary of key inputs>
95	→ Result: <count or outcome>
96	```
97
98	On completion, emit:
99
100	For `format: human` (default):
101	```
102	══════════════════════════════════════════════
103	OUTCOME SUMMARY
104	Unfulfilled overdue orders: <n>
105	Shipped stale-tracking orders: <n>
106	Total at-risk orders: <n>
107	Errors: 0
108	Output: wismo-report-<YYYY-MM-DD>.csv
109	══════════════════════════════════════════════
110	```
111
112	For `format: json`, emit:
113	```json
114	{
115	"skill": "wismo-bulk-status-report",
116	"store": "<domain>",
117	"started_at": "<ISO8601>",
118	"completed_at": "<ISO8601>",
119	"dry_run": false,
120	"steps": [
121	{ "step": 1, "operation": "WismoOrders", "type": "query", "params_summary": "fulfillment_status:unfulfilled, sla_days: <n>, limit: <n>", "result_summary": "<n> orders", "skipped": false },
122	{ "step": 2, "operation": "WismoOrders", "type": "query", "params_summary": "fulfillment_status:shipped, stale_days: <n>, limit: <n>", "result_summary": "<n> orders", "skipped": false }
123	],
124	"outcome": {
125	"unfulfilled_overdue_count": 0,
126	"sh

People who liked this also viewed

6 picks

Type

shopify-admin-wismo-bulk-status-report

168stars17forks

View on GitHub

How to install shopify-admin-wismo-bulk-status-report?

40rty-ai/shopify-admin-skills/shopify-admin-wismo-bulk-status-report

$npx -y skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-wismo-bulk-status-report

Installs into the current project.

Summary

Identify orders at risk of generating WISMO support tickets: shipped orders with stale tracking, and unfulfilled orders past their SLA window.

Files · 1

View on GitHub

SKILL.md

1	## Purpose
2	Generates a bulk report of orders most likely to generate "Where Is My Order?" (WISMO) support tickets — shipped orders whose tracking hasn't updated in N days, and unfulfilled orders sitting past a configurable SLA. According to industry research, WISMO accounts for ~18% of all incoming support requests, making proactive identification a direct ops capacity investment. Read-only. Replaces manual order-by-order admin scanning or helpdesk searches. The CSV output can be used to proactively contact customers before they contact you.
3
4	## Prerequisites
5	- `shopify auth login --store <domain>`
6	- API scopes: `read_orders`
7
8	## Parameters
9
10	\| Parameter \| Type \| Required \| Default \| Description \|
11	\|-----------\|------\|----------\|---------\|-------------\|
12	\| store \| string \| yes \| — \| Store domain (e.g., mystore.myshopify.com) \|
13	\| format \| string \| no \| human \| Output format: `human` or `json` \|
14	\| dry_run \| bool \| no \| false \| Preview operations without executing mutations \|
15	\| unfulfilled_sla_days \| integer \| no \| 3 \| Flag unfulfilled orders older than this many days \|
16	\| stale_tracking_days \| integer \| no \| 5 \| Flag shipped orders where the last fulfillment was created more than this many days ago (proxy for stale tracking) \|
17	\| limit \| integer \| no \| 250 \| Max orders per page \|
18
19	## Workflow Steps
20
21	1. OPERATION: `orders` — query (unfulfilled at-risk)
22	Inputs: `first: <limit>`, `query: "fulfillment_status:unfulfilled created_at:<='<NOW minus unfulfilled_sla_days>'"`, sort by `CREATED_AT` ascending
23	Expected output: Orders unfulfilled past SLA window with `name`, `createdAt`, `customer`, `displayFulfillmentStatus`; label as `UNFULFILLED_OVERDUE`
24
25	2. OPERATION: `orders` — query (shipped but potentially stale)
26	Inputs: `first: <limit>`, `query: "fulfillment_status:shipped updated_at:<='<NOW minus stale_tracking_days>'"`, sort by `UPDATED_AT` ascending
27	Expected output: Shipped orders not updated recently with `name`, `createdAt`, `fulfillments.createdAt`, `fulfillments.trackingInfo`; label as `SHIPPED_STALE_TRACKING`
28
29	## GraphQL Operations
30
31	```graphql
32	# orders:query — validated against api_version 2025-01
33	query WismoOrders($first: Int!, $after: String, $query: String) {
34	orders(first: $first, after: $after, query: $query, sortKey: CREATED_AT) {
35	edges {
36	node {
37	id
38	name
39	createdAt
40	updatedAt
41	displayFulfillmentStatus
42	displayFinancialStatus
43	customer {
44	id
45	firstName
46	lastName
47	defaultEmailAddress {
48	emailAddress
49	}
50	}
51	shippingAddress {
52	city
53	province
54	country
55	}
56	fulfillments {
57	createdAt
58	status
59	trackingInfo {
60	number
61	url
62	company
63	}
64	}
65	totalPriceSet {
66	shopMoney { amount currencyCode }
67	}
68	}
69	}
70	pageInfo {
71	hasNextPage
72	endCursor
73	}
74	}
75	}
76	```
77
78	## Session Tracking
79
80	Claude MUST emit the following output at each stage. This is mandatory.
81
82	On start, emit:
83	```
84	╔══════════════════════════════════════════════╗
85	║ SKILL: wismo-bulk-status-report ║
86	║ Store: <store domain> ║
87	║ Started: <YYYY-MM-DD HH:MM UTC> ║
88	╚══════════════════════════════════════════════╝
89	```
90
91	After each step, emit:
92	```
93	[N/TOTAL] <QUERY\|MUTATION> <OperationName>
94	→ Params: <brief summary of key inputs>
95	→ Result: <count or outcome>
96	```
97
98	On completion, emit:
99
100	For `format: human` (default):
101	```
102	══════════════════════════════════════════════
103	OUTCOME SUMMARY
104	Unfulfilled overdue orders: <n>
105	Shipped stale-tracking orders: <n>
106	Total at-risk orders: <n>
107	Errors: 0
108	Output: wismo-report-<YYYY-MM-DD>.csv
109	══════════════════════════════════════════════
110	```
111
112	For `format: json`, emit:
113	```json
114	{
115	"skill": "wismo-bulk-status-report",
116	"store": "<domain>",
117	"started_at": "<ISO8601>",
118	"completed_at": "<ISO8601>",
119	"dry_run": false,
120	"steps": [
121	{ "step": 1, "operation": "WismoOrders", "type": "query", "params_summary": "fulfillment_status:unfulfilled, sla_days: <n>, limit: <n>", "result_summary": "<n> orders", "skipped": false },
122	{ "step": 2, "operation": "WismoOrders", "type": "query", "params_summary": "fulfillment_status:shipped, stale_days: <n>, limit: <n>", "result_summary": "<n> orders", "skipped": false }
123	],
124	"outcome": {
125	"unfulfilled_overdue_count": 0,
126	"sh

People who liked this also viewed

6 picks

Type