Loading...
Loading...
Sell and accept gift cards with secure code generation, real-time balance tracking, partial redemption support, and expiration enforcement
npx skill4agent add finsilabs/awesome-ecommerce-skills gift-cards| Platform | Recommendation | Notes |
|---|---|---|
| Shopify | Use Shopify's built-in gift cards (available on all plans except Basic) | Native integration with checkout, balance tracking, and email delivery — no app needed |
| WooCommerce | WooCommerce Gift Cards plugin (official, | Core WooCommerce does not include gift cards; these plugins are well-maintained and widely used |
| BigCommerce | BigCommerce Gift Certificates (built in, all plans) | Native support — create, sell, and redeem gift certificates from the admin panel |
| Custom / Headless | Build with ledger-based balance tracking | See Custom section below |
POST /admin/api/2024-04/gift_cards.json[woo_gift_card_balance_check]CREATE TABLE gift_cards (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
code VARCHAR(32) NOT NULL UNIQUE,
initial_value_cents INTEGER NOT NULL,
currency VARCHAR(3) NOT NULL DEFAULT 'USD',
issued_to VARCHAR(255),
expires_at TIMESTAMPTZ,
is_active BOOLEAN NOT NULL DEFAULT true,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE TABLE gift_card_ledger (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
card_id UUID NOT NULL REFERENCES gift_cards(id),
amount_cents INTEGER NOT NULL, -- positive = credit, negative = debit
type VARCHAR(16) NOT NULL CHECK (type IN ('issue', 'redeem', 'refund', 'void')),
order_id UUID,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);async function getBalance(cardCode: string): Promise<number> {
const card = await db.giftCards.findByCode(cardCode.toUpperCase());
if (!card || !card.is_active) throw new Error('CARD_NOT_FOUND');
if (card.expires_at && card.expires_at < new Date()) throw new Error('CARD_EXPIRED');
const result = await db.raw(
'SELECT COALESCE(SUM(amount_cents), 0) AS balance FROM gift_card_ledger WHERE card_id = ?',
[card.id]
);
return Math.max(0, parseInt(result.rows[0].balance, 10));
}async function redeemGiftCard(code: string, orderId: string, orderTotalCents: number) {
return db.transaction(async tx => {
// Lock the card row to prevent concurrent redemptions
const card = await tx.raw(
'SELECT * FROM gift_cards WHERE UPPER(code) = ? FOR UPDATE',
[code.toUpperCase()]
).then(r => r.rows[0]);
if (!card || !card.is_active) throw new Error('CARD_NOT_FOUND');
const balance = await getBalance(code);
const appliedCents = Math.min(balance, orderTotalCents);
if (appliedCents === 0) throw new Error('ZERO_BALANCE');
await tx.giftCardLedger.insert({
card_id: card.id,
amount_cents: -appliedCents,
type: 'redeem',
order_id: orderId,
});
return { appliedCents, remainingBalance: balance - appliedCents };
});
}0O1IABCD-xxxx-xxxx-MNOP| Problem | Solution |
|---|---|
| Two simultaneous checkouts both succeed using the same card | Use a row-level lock ( |
| Balance goes negative due to rounding in split payment | Use |
| Customer cannot find their card after a refund re-credits it | After refunding to a gift card, ensure the card is reactivated if it was previously depleted and deactivated |
| Gift card codes appear in server access logs | Never include the code as a URL path parameter; use a POST body or a hashed lookup token |
| Gift card purchased but code not delivered | Platform-native gift cards send automatically; for custom implementations, use transactional email with delivery tracking and a resend option in your customer service panel |