SleekView for WooCommerce Realex: Global Payments transactions as tables
Surface Realex / Global Payments order id, auth code, 3D Secure status, and capture state from wc_orders_meta as real columns. Filter authorisations vs captures and audit declines without opening each order.
♾️ Lifetime License available
Realex gateway data as a workspace
Realex Payments, now part of Global Payments, runs the gateway behind a lot of European online retail. Its WooCommerce extension records the Realex order id, pasref, auth code, AVS and CVV results, and 3D Secure status into order meta on every checkout. On HPOS stores these land in wc_orders_meta as keys like _wc_realex_order_id, _wc_realex_pasref, _wc_realex_authcode, and _wc_realex_3dsecure_status. The default WooCommerce admin doesn't surface them.
SleekView reads those keys as columns alongside the order total, status, and customer. Authorised-but-uncaptured orders become a saved view sorted by auth age, declines filter by AVS or CVV mismatch, and 3DS abandons get their own audit table. Tokens in woocommerce_payment_tokens joined to woocommerce_payment_tokenmeta show saved Realex card references per customer for token-management workflows.
Inline status edits route through WooCommerce CRUD, so woocommerce_order_status_changed fires and the Realex extension's own capture, void, and refund actions continue to run from the order context. The plugin still owns the API calls; SleekView gives ops a row-level workspace on the data the plugin already writes.
Workflow
How SleekView reads the Realex plugin schema
Pick the base table
wc_orders for the transaction workspace or woocommerce_payment_tokens for a token-rooted view. HPOS or legacy is detected automatically.
Add Realex meta columns
_wc_realex_order_id, _wc_realex_pasref, _wc_realex_authcode, and 3DS or AVS keys from the meta picker.
Save the workflow views
Bulk-update post settlement
Sample columns
A typical Realex transactions view
wc_orders with Realex meta keys (_wc_realex_order_id, _wc_realex_pasref, _wc_realex_3dsecure_status).
wp_wc_orders + wp_wc_orders_meta + wp_woocommerce_payment_tokens
| Order # | Pasref | Amount | Auth | 3DS | Date |
|---|---|---|---|---|---|
| #7621 | PR4421AB | €162.00 | Approved | Authenticated | Apr 24 |
| #7620 | PR4420CD | €54.00 | Approved | Attempt | Apr 24 |
| #7619 | PR4419EF | €348.00 | Declined | Not enrolled | Apr 23 |
| #7618 | PR4418GH | €96.00 | Approved | Authenticated | Apr 22 |
Comparison
Default WooCommerce Realex admin vs SleekView
Default WooCommerce Realex admin
-
Realex order id, pasref, and auth code live in
wc_orders_metaonly - No filter for declines or 3DS abandons on the default Orders screen
- AVS and CVV results need a click into each order to see
- Reconciling against Realex Hub reports is manual and per-order
-
Tokens in
woocommerce_payment_tokensaren't joined to the order context
SleekView
-
_wc_realex_order_id,_wc_realex_pasref, and_wc_realex_authcodeas columns - Saved decline-audit views filtered on AVS or CVV mismatch
- 3D Secure status (Authenticated, Attempt, Not enrolled) as a filterable column
- Bulk-update post settlement with hooks firing through CRUD
-
Customer-rooted token view from
woocommerce_payment_tokens
Features
What SleekView gives you for WooCommerce Realex Payments
Realex meta as columns
Pull _wc_realex_order_id, _wc_realex_pasref, _wc_realex_authcode, and 3DS or AVS keys from the meta picker. Each view picks its own subset for fulfilment, finance, or risk.
Auth-vs-capture filters
Filter on auth status approved combined with capture state not equal to captured. Sort by auth age to surface auths nearing the Realex reversal window before they expire.
3DS abandon audit
Filter on _wc_realex_3dsecure_status equals Attempt or Abandoned. Useful for tuning fraud rules and following up recoverable carts that fell off at the challenge step.
Audience
Who uses SleekView for WooCommerce Realex
Finance reconciliation
Filter by capture date and currency for Realex Hub reconciliation. Total captured and refunded inline; export filtered set to CSV for the accountant.
Risk teams
Decline-audit view filtered on AVS or CVV mismatch, sorted by amount. 3DS abandons in a separate saved view for cart-recovery follow-up.
Support
Customer-rooted history with pasref, auth code, and 3DS state per order. Evidence for disputes ready to export without screen-recording each order page.
The bigger picture
Why merchant-gateway ops need row-level views
Realex Payments runs the gateway behind a lot of European stores, especially in Ireland and the UK where Global Payments has deep merchant relationships. The lifecycle of a card payment through Realex has more states than the default WooCommerce Orders screen models: auth, capture, settle, void, refund, and the 3D Secure flow around all of them. The extension writes every state into order meta.
The default admin reads almost none of it. Finance teams reconcile by exporting Realex Hub reports and grep-ing through WordPress, risk teams spot AVS or CVV problems only after the chargeback, and support teams answer dispute questions by opening each order in turn. SleekView reads the meta the plugin already writes and exposes it as columns ops can filter, sort, and bulk-update.
The plugin's API integrations continue unchanged. The gain is visibility, the data was always there, the admin just never showed it.
Questions
Common questions about SleekView for WooCommerce Realex Payments
Yes. Realex is the older brand name for what is now Global Payments e-commerce. The WooCommerce extension keys are unchanged. SleekView reads whichever meta keys the installed version writes, scanned from wc_orders_meta at config time.
Yes. Keys read from wc_orders_meta on HPOS and from postmeta on legacy stores. The same column configuration works on both schemas because the active path is detected automatically.
Yes. _wc_realex_3dsecure_status records values like Authenticated, Attempt, Not enrolled, or Failed. Filter on Attempt or Failed to build a 3DS friction audit view distinct from the fulfilment workspace.
Yes. Status edits route through WooCommerce CRUD, so woocommerce_order_status_changed fires and the Realex extension's own capture, void, and refund handlers run as expected from the order context.
Yes. Build a view on woocommerce_payment_tokens filtered by gateway slug. Join woocommerce_payment_tokenmeta for the Realex card reference and any flags.
Yes. Build a view scoped to one order with pasref, auth code, 3DS status, AVS or CVV, and order notes. Export to CSV or PDF and attach to the dispute response.
 
Queries hit indexed columns on wc_orders directly. Meta filters use the standard wc_orders_meta indexes. Aggregate columns are opt-in per view since they're slower than direct columns.
No. The Realex Hub remains the source of truth for batches, payouts, and dispute handling. SleekView gives WooCommerce-side ops a row-level view of the data the plugin syncs into WordPress, reducing context-switching between admin and portal.
 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
- Woocommerce Tnt Shipping
- Woocommerce Zip Checkout
- Woocommerce Vendor Payouts
- Woocommerce Product Variations Swatches
- Woocommerce Vertex Tax
- Variation Swatches
- Woocommerce Distance Rate
- Gumroad Wp
- Woocommerce Product Feed Pro
- Woocommerce Weight Based Shipping
- Wpc Buy Now Button
- Woocommerce Eu Vat Assistant
- Woocommerce Product Table
- Edd Conditional Emails
- Woocommerce Prices By User Role
- Memberium
- Memberium Infusionsoft Pro
- Profile Builder
- Ultimatemember Real Time Notifications
- Memberpress Pro
- Memberium Infusionsoft
- Ultimate Membership Pro Indeed
- Profile Magic
- Indeed Ultimate Member
- Memberpress Bundle
- Restrict User Access Pro
- Ultimatemember Paid Content
- Wp Affiliate Manager
- Thrive Apprentice
- Memberium Keap