shopify-admin-gift-card-balance-report

What problem does it solve?

It eliminates the manual accounting effort of finding all active gift cards, calculating their remaining (unredeemed) balances, and identifying balances that are expiring soon for liability tracking.

Core Features & Use Cases

• Reads-only gift card inventory: Queries all active and partially-redeemed gift cards and surfaces remaining balance, initial value, and key dates for deferred revenue reporting.
• Expiry and status filtering: Filters by enabled/disabled/all status and flags gift cards expiring within a configurable number of days.
• Exports a reconciliation-friendly CSV: Produces a CSV file that includes gift card identifiers, customer email, balance details, and an expiring-soon indicator for downstream accounting workflows.
• Use Case: Before monthly financial close, generate a gift card liability report to reconcile deferred revenue and forecast imminent liability reduction from expiring gift cards.

Quick Start

Ask the assistant to run shopify-admin-gift-card-balance-report for your store and output the results in human-readable format.