From shopify-admin-skills
Lists all active Shopify gift cards with remaining balance, expiry, and last-used date for liability tracking and deferred revenue reporting.
How this skill is triggered — by the user, by Claude, or both
Slash command
/shopify-admin-skills:shopify-admin-gift-card-balance-reportThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Queries all active and partially-redeemed gift cards and reports the total outstanding gift card liability (unredeemed balances). Used for balance sheet reporting, accounting for deferred revenue, and auditing unused gift cards before they expire. Read-only — no mutations.
Queries all active and partially-redeemed gift cards and reports the total outstanding gift card liability (unredeemed balances). Used for balance sheet reporting, accounting for deferred revenue, and auditing unused gift cards before they expire. Read-only — no mutations.
shopify store auth --store <domain> --scopes read_gift_cardsread_gift_cards| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| store | string | yes | — | Store domain (e.g., mystore.myshopify.com) |
| status | string | no | enabled | Filter by status: enabled, disabled, or all |
| expiring_within_days | integer | no | 30 | Flag gift cards expiring within this many days |
| format | string | no | human | Output format: human or json |
ℹ️ Read-only skill — no mutations are executed. Safe to run at any time.
OPERATION: giftCards — query
Inputs: query: "status:<status>", first: 250, pagination cursor
Expected output: All matching gift cards with balance, initialValue, expiresOn, lastCharacter, usedOn; paginate until hasNextPage: false
Flag cards expiring within expiring_within_days
Aggregate: total outstanding balance (liability), count by status, total initial value issued
# giftCards:query — validated against api_version 2025-01
query GiftCardBalances($query: String, $after: String) {
giftCards(first: 250, after: $after, query: $query) {
edges {
node {
id
balance {
amount
currencyCode
}
initialValue {
amount
currencyCode
}
enabled
expiresOn
createdAt
lastCharacters
customer {
id
displayName
defaultEmailAddress {
emailAddress
}
}
}
}
pageInfo {
hasNextPage
endCursor
}
}
}
Claude MUST emit the following output at each stage. This is mandatory.
On start, emit:
╔══════════════════════════════════════════════╗
║ SKILL: Gift Card Balance Report ║
║ 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):
══════════════════════════════════════════════
GIFT CARD BALANCE REPORT
Active gift cards: <n>
Total outstanding balance: $<amount> (liability)
Total initial value issued: $<amount>
Redeemed to date: $<amount>
Expiring in <n> days: <n> cards ($<amount>)
Output: gift_card_balances_<date>.csv
══════════════════════════════════════════════
For format: json, emit:
{
"skill": "gift-card-balance-report",
"store": "<domain>",
"active_count": 0,
"total_outstanding_balance": 0,
"total_initial_value": 0,
"currency": "USD",
"expiring_soon_count": 0,
"expiring_soon_value": 0,
"output_file": "gift_card_balances_<date>.csv"
}
CSV file gift_card_balances_<YYYY-MM-DD>.csv with columns:
gift_card_id, last_characters, status, initial_value, balance, currency, created_at, expires_on, customer_email, expiring_soon
| Error | Cause | Recovery |
|---|---|---|
THROTTLED | API rate limit exceeded | Wait 2 seconds, retry up to 3 times |
| No gift cards | Store hasn't issued any | Exit with 0 total liability |
| Gift card with no customer | Issued without customer account | Show as "Anonymous" |
expiring_within_days represent imminent liability reduction — no action needed, but useful for forecasting.customer-spend-tier-tagger to target high-balance card holders with reminder campaigns.gift-card-issuance (conversion-optimization skill) to track cards issued vs. redeemed over time.npx claudepluginhub 40rty-ai/shopify-admin-skills --plugin shopify-admin-skillsCalculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band. Useful for deferred-revenue accounting and breakage estimation under ASC 606 / IFRS 15.
Manages Wix coupons and discounts via REST API: query active/expired/usage-based lists, create fixed-amount/percent-off types, detect conflicts, calculate margins.
Creates, edits, and optimizes skills for Claude Code, including drafting, evaluating with test prompts, iterating on performance, and improving skill descriptions for better triggering accuracy.