SleekView for WooCommerce Gift Cards Pro: codes and balances as tables
Gift Cards Pro stores each card with original value, current balance, recipient, expiry, and a redemption ledger. SleekView reads the cards table and joins the redemption events so a row shows code, recipient, balance, expiry, and the last order that used the card.
♾️ Lifetime License available
Every gift card, with its history
WooCommerce Gift Cards Pro keeps each gift card in wp_wc_gift_cards with columns for code, original_amount, balance, recipient_email, expires_at, and status. Redemption events sit in wp_wc_gift_card_redemptions with a reference to the consuming order_id. The default admin lists cards but exposes redemption history one card at a time, which makes liability and recipient questions slow to answer.
SleekView joins the cards table with the latest redemption row per card and exposes recipient, original amount, current balance, expiry, status, and last-used order as first-class columns. Filter by status to see active versus depleted, sort by expiry ascending to find the cards about to lapse, or filter by recipient domain to spot internal-employee usage patterns.
Inline edits adjust balance or extend expiry through the plugin's wc_gift_cards_update_card hook so any plugin-driven recipient notifications still fire. Bulk operations cover the practical workflows: extend expiry for a cohort affected by a service outage, disable a batch of codes leaked in a breach, or issue replacement codes with the original amount carried forward.
Workflow
Gift card operations without the click-through
Connect the source
wp_wc_gift_cards joined to the latest row per card from wp_wc_gift_card_redemptions. The grid loads with code, recipient, balance, expiry, and status visible.
Add behavior columns
days_to_expiry column for the near-expiry filter.
Save segment views
Edit inline and audit
wc_gift_cards_update_card. Each change writes to the audit log with the operator and reason.
Sample columns
A typical Gift Cards Pro view
wp_wc_gift_cards + wp_wc_gift_card_redemptions
| Code | Recipient | Original | Balance | Expiry | Status |
|---|---|---|---|---|---|
| GC-7821 | alex@studio.co | €100 | €42 | Dec 31 | active |
| GC-7822 | ria@design.io | $50 | $0 | Jun 30 | depleted |
| GC-7823 | tom@hello.dev | £75 | £75 | May 30 | expiring |
| GC-7824 | mia@brew.coop | €25 | €25 | Aug 12 | active |
Comparison
Default WooCommerce Gift Cards Pro admin vs SleekView
Default WooCommerce Gift Cards Pro admin
- Card list lacks the last redemption order as a column
-
No combined filter on
statusandexpires_at - Bulk expiry extensions require editing each card individually
- Recipient grouping not available in the default UI
- No CSV export of outstanding-liability cards by currency
SleekView
-
Cards joined to the latest
wp_wc_gift_card_redemptionsrow - Sort by expires_at ascending to surface near-expiry cards
- Inline balance and expiry edits route through plugin hooks
- Bulk expiry extension and code disable for breach response
- Liability rollup grouped by currency for finance export
Features
What SleekView gives you for WooCommerce Gift Cards Pro
Card plus history
Each row shows the gift card alongside its most recent redemption order. Support answers "where did this balance go" without clicking into the card's redemption history screen.
Expiry surfacing
Sort and filter on expires_at to find cards expiring in the next 30 days. Build a saved view that the support team uses weekly to send out renewal nudges for high-value cards.
Bulk maintenance
Extend expiry, disable, or reissue a batch of cards in one action. Each edit routes through wc_gift_cards_update_card so recipient emails fire and the audit log captures the operator.
Audience
Who uses SleekView for WooCommerce Gift Cards Pro
Finance teams
Pull the outstanding-balance liability grouped by currency for the monthly close. The grid sums balance across active cards per currency and exports cleanly to the accounting tool.
Support agents
Look up a recipient and see all their cards with balance, expiry, and last redemption. Reissue a code with the original balance carried forward when a recipient lost the card.
Loss prevention
Spot suspicious patterns: a single email holding many cards, rapid redemptions across geographies, or rapid balance draws. Disable affected codes in bulk while investigation continues.
The bigger picture
Gift cards are a liability, not just an SKU
Gift cards behave more like financial instruments than products. Each issued card is an outstanding liability on the books until it is redeemed or written off, and the accounting team needs the liability total grouped by currency, with expiry windows visible, to close the month cleanly. Support needs the redemption history per card to answer recipient questions in one read.
Loss prevention needs the ability to spot abuse patterns and disable affected codes in bulk before more value drains away. WooCommerce Gift Cards Pro persists all the right data in wp_wc_gift_cards and wp_wc_gift_card_redemptions, but the default admin presents the card list and the redemption history one card at a time, which forces each team into a different workflow. SleekView joins the source tables and gives finance, support, and loss prevention each a view tuned to how they actually think, all reading the live data the plugin writes.
Questions
Common questions about SleekView for WooCommerce Gift Cards Pro
Yes. The grid joins the latest redemption row per card and exposes a drill-down view that lists every redemption with the originating order, amount, and timestamp from wp_wc_gift_card_redemptions.
Yes. Select rows and apply an expiry extension to many cards at once. The edit routes through wc_gift_cards_update_card so any recipient notification configured in the plugin fires correctly.
wp_wc_gift_cards stores the currency per card. SleekView exposes currency as a column and supports grouping rollups by currency, which is the correct way to display the liability total.
Yes. A saved view sums balance across active, non-expired cards grouped by currency. The result is the program liability in each currency, ready for accounting export.
Yes. Customer-facing redemption is handled by Gift Cards Pro on the storefront. SleekView reads what the plugin writes, so any redemption made through the checkout appears on the next grid load.
Yes. A breach-response saved view filters cards by suspicious recipient domain or redemption velocity. Bulk-disable the cohort in one action and the plugin's downstream notifications follow up appropriately.
Yes. recipient_email and purchaser_email are both available as columns. Group by purchaser to find corporate buyers, or filter by recipient domain for internal-team usage analysis.
Yes. Support gets the recipient view with code-reissue rights, finance gets the liability rollup, loss prevention gets the breach-response views. Each saved view checks role capability.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Yith Woocommerce Tab Manager
- Woocommerce Product Variations Swatches
- Woocommerce Extra Fees
- Woocommerce Worldpay
- Wpc Buy Now Button
- Edd Frontend Submissions
- Woocommerce Affirm
- Woocommerce Authorize Net Cim
- Woocommerce Product Feed Pro
- Woocommerce Purchase Orders
- Woocommerce Stock Manager
- Woocommerce Wholesale Gateway
- Woocommerce Blocks
- Yith Woocommerce Product Reviews
- Thirstyaffiliates