New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Shopify Admin Gift Card Liability Report

by 40RTY-ai in 40RTY-ai/shopify-admin-skills

Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band.

MITAuto-check passedBusiness, Finance & HR

Install Shopify Admin Gift Card Liability Report

skills CLI
$ npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-gift-card-liability-report -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install 40RTY-ai/shopify-admin-skills shopify-admin-gift-card-liability-report --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/40RTY-ai/shopify-admin-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/finance/shopify-admin-gift-card-liability-report .claude/skills/shopify-admin-gift-card-liability-report && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
shopify-admin-gift-card-liability-report
GitHub stars
194
Token cost
~1.8k tokens
SKILL.md length
579 words
Files
1
Skills in repo
116
Repo updated
First seen
Licence
MIT

At a glance

Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band.

  • Works in 4 steps: Outstanding balance = sum of… → Issue cohort = year-month of createdAt → Balance band = first band edge ≥… → …
  • Business, Finance & HR work in your project
  • SKILL.md covers Purpose, Prerequisites, Parameters and Safety, plus 7 more sections
  • Calls shopify

What it does

Shopify Admin Gift Card Liability Report is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band.

Its SKILL.md is about 1.8k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts. Compatibility notes: Claude Code, Cursor, Codex, Gemini CLI

It sits in Business, Finance & HR. It works with Shopify. The repository describes itself as: Community-maintained AI agent skills for operating Shopify stores — workflows, optimization, reports and more. The licence is MIT.

When your agent uses it

  • Business, Finance & HR work in your project

Example prompts

  • “/shopify-admin-gift-card-liability-report”

Requirements

  • Compatibility (from SKILL.md): Claude Code, Cursor, Codex, Gemini CLI

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Outstanding balance = sum of balance.amount (the liability)
  2. Issue cohort = year-month of createdAt
  3. Balance band = first band edge ≥ remaining balance, or >max for cards above the largest edge
  4. Breakage candidate = card with balance > 0 and (updatedAt older than stale_days ago OR expiresOn within next 30 days)

What it can do on your machine

Read from SKILL.md and the folder at commit 6765cb4. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • shopify

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

  • Compatibility

    Claude Code, Cursor, Codex, Gemini CLI

    From compatibility in the SKILL.md frontmatter.

Context cost

Shopify Admin Gift Card Liability Report loads about 1.8k tokens when it runs. Until then it costs about 45 tokens; SKILL.md has 579 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~45
When it runs · the whole SKILL.md, loaded when a task matches
~1.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from 40RTY-ai/shopify-admin-skills at commit 6765cb4, republished under its MIT licence (© 40RTY-ai). 579 words, ~1,812 tokens.

Download SKILL.mdSave it as .claude/skills/shopify-admin-gift-card-liability-report/SKILL.md (or your agent's skills folder).
name
shopify-admin-gift-card-liability-report
description
Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band.
compatibility
Claude Code, Cursor, Codex, Gemini CLI
role
finance
toolkit
shopify-admin, shopify-admin-execution
api_version
2025-01
graphql_operations
giftCards:query
status
stable

Purpose

Calculates the store's total outstanding gift card liability — the sum of unredeemed gift card balances that represent a future obligation to deliver goods. Breaks the liability down by issue-month cohort and remaining-balance band so finance can size the obligation, age it, and forecast breakage. This is the bookkeeping companion to gift-card-balance-report (which lists individual cards). Read-only — no mutations.

Prerequisites

  • Authenticated Shopify CLI session: shopify store auth --store <domain> --scopes read_gift_cards
  • API scopes: read_gift_cards

Parameters

ParameterTypeRequiredDefaultDescription
storestringyes—Store domain (e.g., mystore.myshopify.com)
statusstringnoenabledFilter by status: enabled, disabled, or all
balance_bandsarrayno[10, 50, 100, 250, 500]Upper edges of balance bands (in store currency) for distribution table
stale_daysintegerno365Cards untouched longer than this are flagged as breakage candidates
as_ofstringnotoday (UTC)ISO date for the "as of" snapshot label on the report
formatstringnohumanOutput format: human or json

Safety

ℹ️ Read-only skill — no mutations are executed. The dollar figure produced is the deferred-revenue liability for accounting purposes; review with your accountant before booking journal entries.

Liability Model

For every enabled gift card with balance > 0:

  1. Outstanding balance = sum of balance.amount (the liability)
  2. Issue cohort = year-month of createdAt
  3. Balance band = first band edge ≥ remaining balance, or >max for cards above the largest edge
  4. Breakage candidate = card with balance > 0 and (updatedAt older than stale_days ago OR expiresOn within next 30 days)

Aggregations:

  • Total outstanding (overall + per cohort + per band)
  • Card counts per cohort and per band
  • Weighted-average days since issue
  • Breakage candidate total — useful for revenue recognition under ASC 606 / IFRS 15 for stores in jurisdictions where breakage can be recognized

Workflow Steps

  1. OPERATION: giftCards — query Inputs: query: "status:<status> balance:>0", first: 250, select id, balance, initialValue, createdAt, updatedAt, expiresOn, enabled, lastCharacters, pagination cursor Expected output: All gift cards with positive balance; paginate until hasNextPage: false

  2. For each card, compute issue cohort, balance band, and breakage flag

  3. Aggregate totals: overall liability, per-cohort table, per-band table, breakage candidate subtotal

  4. Compute redeemed-to-date as Σ(initialValue - balance) for context

Show full SKILL.md (230 more words)Show less

GraphQL Operations

graphql
# giftCards:query — validated against api_version 2025-01
query GiftCardLiability($query: String, $after: String) {
  giftCards(first: 250, after: $after, query: $query) {
    edges {
      node {
        id
        balance {
          amount
          currencyCode
        }
        initialValue {
          amount
          currencyCode
        }
        enabled
        createdAt
        updatedAt
        expiresOn
        lastCharacters
        customer {
          id
          displayName
          defaultEmailAddress {
            emailAddress
          }
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

Session Tracking

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

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: Gift Card Liability Report           ║
║  Store: <store domain>                       ║
║  As of: <YYYY-MM-DD>                         ║
║  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 LIABILITY  (as of <date>)
  Active cards w/ balance:   <n>
  Total outstanding:         $<amount>
  Initial value issued:      $<amount>
  Redeemed to date:          $<amount>  (<pct>%)
  Breakage candidates:       <n>  ($<amount>)

  By issue cohort (YYYY-MM):
    2024-12  Cards: <n>  Liability: $<n>
    2025-01  Cards: <n>  Liability: $<n>

  By balance band:
    ≤ $10     Cards: <n>  Liability: $<n>
    ≤ $50     Cards: <n>  Liability: $<n>
    ≤ $100    Cards: <n>  Liability: $<n>
    > $500    Cards: <n>  Liability: $<n>

  Output: gift_card_liability_<date>.csv
══════════════════════════════════════════════

For format: json, emit:

json
{
  "skill": "gift-card-liability-report",
  "store": "<domain>",
  "as_of": "<YYYY-MM-DD>",
  "active_with_balance": 0,
  "total_outstanding": 0,
  "initial_value_issued": 0,
  "redeemed_to_date": 0,
  "redemption_rate_pct": 0,
  "breakage_candidates_count": 0,
  "breakage_candidates_value": 0,
  "currency": "USD",
  "by_cohort": [],
  "by_band": [],
  "output_file": "gift_card_liability_<date>.csv"
}

Output Format

CSV file gift_card_liability_<YYYY-MM-DD>.csv with columns: gift_card_id, last_characters, initial_value, balance, redeemed, currency, created_at, issue_cohort, balance_band, updated_at, expires_on, breakage_candidate, customer_email

Error Handling

ErrorCauseRecovery
THROTTLEDAPI rate limit exceededWait 2 seconds, retry up to 3 times
No gift cards with positive balanceStore hasn't issued any, or all redeemedExit with $0 liability
Multi-currency cardsCards issued in different presentment currenciesGroup totals by currency code; do not sum across currencies
Card with null expiresOnNo expiry policyTreat as non-expiring; do not include in expiry-based breakage

Best Practices

  • Run on the last day of every accounting period so the figure aligns with your balance-sheet close.
  • The total outstanding amount is the deferred-revenue liability — book it in your accounting system, do not treat issued gift cards as revenue.
  • Breakage policy varies by jurisdiction; consult your accountant before recognizing breakage candidates as revenue. The stale_days and expiresOn flags here are inputs to that policy, not a substitute for it.
  • Track the redemption-rate trend month over month — declining redemption can indicate a customer-experience issue (recipients can't find / remember their cards).
  • Pair with gift-card-issuance to monitor flow: liability should increase by issuance and decrease by redemption + breakage.

© 40RTY-ai, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/finance/shopify-admin-gift-card-liability-report of 40RTY-ai/shopify-admin-skills.

Open the folder on GitHubat commit 6765cb4

Compare with similar skills

Shopify Admin Gift Card Liability Report next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Shopify Admin Gift Card Liability Report compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Shopify Admin Gift Card Liability Report this skill40RTY-ai/shopify-admin-skills194—~1.8kAutomated safety check: PassMIT
Price Optimization Toolnexscope-ai/eCommerce-Skills1.1k—~3.3kAutomated safety check: PassMIT
Shopify Tax Compliancenexscope-ai/eCommerce-Skills1.1k—~463Automated safety check: PassMIT
Ecommerce Advisorborghei/Claude-Skills891—~1.2kAutomated safety check: PassMIT
Apify Ecommerceapify/awesome-skills266—~4.6kAutomated safety check: NotesApache-2.0
Checkout Purchasekeypo-us/keypo-cli182—~880Automated safety check: NotesNone

Similar skills

  • Price Optimization Tool

    nexscope-ai/eCommerce-Skills

    Evaluate ecommerce price candidates using unit economics, historical observations, elasticity analysis, scenario modeling, and controlled experiments.

    1.1k GitHub stars~3.3k tokensUpdated 1 mo ago
    Business, Finance & HRAuto-check passed

  • Shopify Tax Compliance

    nexscope-ai/eCommerce-Skills

    Tax setup and compliance — sales tax, VAT, duty collection, tax-exempt customers, reporting

    1.1k GitHub stars~463 tokensUpdated 1 mo ago
    Business, Finance & HRAuto-check passed

  • Ecommerce Advisor

    borghei/Claude-Skills

    Strategic advisory for e-commerce founders on unit economics, fulfillment models, payments, and channel strategy.

    891 GitHub stars~1.2k tokensUpdated 4 days ago
    Sales & SupportAuto-check passed

  • Apify Ecommerce

    apify/awesome-skills

    Official

    Scrape e-commerce data for pricing, reviews, bestsellers, and seller discovery across 30+ platforms including Amazon, Walmart, eBay, Shopify, WooCommerce, and more.

    266 GitHub stars~4.6k tokensUpdated 18 days ago
    Sales & SupportAuto-check: notes

  • Checkout Purchase

    keypo-us/keypo-cli

    A skill your agent uses when the user asks to buy a product from the Shopify store.

    182 GitHub stars~880 tokensUpdated 6 mo ago
    Sales & SupportAuto-check: notes

  • Shopify Automation

    davepoon/buildwithclaude

    Automate Shopify tasks via Rube MCP (Composio): products, orders, customers, inventory, collections.

    3.6k GitHub starsUsed in 7 repos~1.5k tokens
    Productivity & AutomationAuto-check passed

More from 40RTY-ai/shopify-admin-skills

All 116 skills in this repo

  • Shopify Admin Abandoned Cart Recovery

    40RTY-ai/shopify-admin-skills

    Query checkouts abandoned in the last N days, generate unique discount codes per customer, and tag them for re-engagement.

    194 GitHub stars~1.9k tokensUpdated 1 mo ago
    Auto-check passed

  • Shopify Admin Address Correction

    40RTY-ai/shopify-admin-skills

    Update the shipping address on an unfulfilled order before it ships.

    194 GitHub stars~1.5k tokensUpdated 1 mo ago
    Auto-check passed

  • Shopify Admin Agentic Crawler Access

    40RTY-ai/shopify-admin-skills

    Edit the theme's robots.txt.liquid to explicitly allow AI crawlers (GPTBot, ClaudeBot, PerplexityBot, Google-Extended, OAI-SearchBot, Amazonbot) so AI assistants are permitted to read the catalog.

    194 GitHub stars~1.8k tokensUpdated 1 mo ago
    Auto-check passed

  • Shopify Admin Agentic Description Enrichment

    40RTY-ai/shopify-admin-skills

    Rewrite thin product descriptions into structured, fact-rich copy (materials, fit, use-cases, the words shoppers actually type) so AI agents have something concrete to quote and match.

    194 GitHub stars~1.6k tokensUpdated 1 mo ago
    Auto-check passed

  • Shopify Admin Agentic Image Alt Text

    40RTY-ai/shopify-admin-skills

    Generate and set descriptive alt text on product images so AI agents (which can't 'see' pixels) can understand and recommend what each product looks like.

    194 GitHub stars~1.6k tokensUpdated 1 mo ago
    Auto-check passed

  • Shopify Admin Agentic LLMs Txt

    40RTY-ai/shopify-admin-skills

    Generate and publish an /llms.txt guide (brand summary, flagship products, key policies, contact) via a theme template so AI assistants get a curated, machine-readable map of the store.

    194 GitHub stars~1.8k tokensUpdated 1 mo ago
    Auto-check passed

Works with

Categories

Questions about Shopify Admin Gift Card Liability Report

What does Shopify Admin Gift Card Liability Report do?

Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band. Shopify Admin Gift Card Liability Report is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band.

When should I use Shopify Admin Gift Card Liability Report?

Shopify Admin Gift Card Liability Report fits situations like: business, Finance & HR work in your project.

How do I install Shopify Admin Gift Card Liability Report in Claude Code?

Run `npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-gift-card-liability-report -a claude-code`. Or copy the skill folder (skills/finance/shopify-admin-gift-card-liability-report in 40RTY-ai/shopify-admin-skills) into .claude/skills/shopify-admin-gift-card-liability-report in your project. Claude Code loads it when a task matches its description.

How do I install Shopify Admin Gift Card Liability Report in Codex?

Run `npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-gift-card-liability-report -a codex`. Or copy the skill folder (skills/finance/shopify-admin-gift-card-liability-report in 40RTY-ai/shopify-admin-skills) into .agents/skills/shopify-admin-gift-card-liability-report in your project. Codex loads it when a task matches its description.

Can I use Shopify Admin Gift Card Liability Report in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-gift-card-liability-report -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/shopify-admin-gift-card-liability-report, .gemini/skills/shopify-admin-gift-card-liability-report, .github/skills/shopify-admin-gift-card-liability-report and .opencode/skills/shopify-admin-gift-card-liability-report in your project.

What does Shopify Admin Gift Card Liability Report need to run?

Going by SKILL.md and its folder, Shopify Admin Gift Card Liability Report needs the command-line tools its instructions call (shopify). Compatibility (from SKILL.md): Claude Code, Cursor, Codex, Gemini CLI.

Does Shopify Admin Gift Card Liability Report access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Shopify Admin Gift Card Liability Report safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Shopify Admin Gift Card Liability Report use?

Shopify Admin Gift Card Liability Report is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Shopify Admin Gift Card Liability Report use?

About 1.8k tokens (SKILL.md is roughly 7.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Shopify Admin Gift Card Liability Report?

Skills that share tags, products or a category with Shopify Admin Gift Card Liability Report: Price Optimization Tool (nexscope-ai/eCommerce-Skills, 1.1k stars), Shopify Tax Compliance (nexscope-ai/eCommerce-Skills, 1.1k stars), Ecommerce Advisor (borghei/Claude-Skills, 891 stars) and Apify Ecommerce (apify/awesome-skills, 266 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Shopify Admin Gift Card Liability Report?

40RTY-ai (a GitHub organization) maintains it in 40RTY-ai/shopify-admin-skills, which has 194 GitHub stars. The repository holds 116 skills in this directory. The repository was last updated on August 14, 2026.

Source: 40RTY-ai/shopify-admin-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.