SleekView for WooCommerce Worldpay: gateway transactions as tables
Surface Worldpay transaction ids, auth codes, AVS results, and capture status from wc_orders_meta as real columns. Filter by gateway response, bulk-reconcile authorisations, and audit declines without per-order click-through.
♾️ Lifetime License available
Worldpay gateway data, finally as columns
The WooCommerce Worldpay extension writes transaction ids, auth codes, AVS and CVV results, and capture status into order meta on every checkout. On HPOS stores those land in wc_orders_meta under keys like _wc_worldpay_transaction_id, _wc_worldpay_auth_code, _wc_worldpay_avs_response, and _wc_worldpay_capture_status. None of those appear on the default Orders screen. Reconciling Worldpay's batch report against WordPress means opening every authorised order to confirm capture.
SleekView reads these keys as first-class columns alongside the order status, amount, and customer email. Authorised-but-uncaptured orders become a saved view sorted by date. Declined transactions filtered by AVS result become a fraud audit table. Refunds from shop_order_refund (legacy) or refund rows in wc_orders (HPOS) join in so a single row shows the original capture and any reversals.
Inline edits route through the WooCommerce CRUD layer, so woocommerce_order_status_changed fires and the plugin's own capture and refund actions can still be triggered from the order context. SleekView does not bypass the gateway; it gives ops a row-level view of the data the plugin already records.
Workflow
How SleekView reads the Worldpay plugin schema
Pick the base table
wc_orders for transaction views or woocommerce_payment_tokens for a token-rooted view. SleekView detects HPOS or legacy automatically.
Add Worldpay meta columns
_wc_worldpay_transaction_id, _wc_worldpay_auth_code, _wc_worldpay_capture_status, and AVS or CVV responses as needed.
Build the saved views
Bulk-update post settlement
Sample columns
A typical Worldpay transactions view
wc_orders with Worldpay meta keys (_wc_worldpay_transaction_id, _wc_worldpay_auth_code).
wp_wc_orders + wp_wc_orders_meta + wp_woocommerce_payment_tokens
| Order # | Worldpay ID | Amount | Auth | Capture | Date |
|---|---|---|---|---|---|
| #10612 | WP-829F4A | £128.00 | Approved | Authorised | Apr 24 |
| #10611 | WP-83B221 | £56.00 | Approved | Captured | Apr 24 |
| #10610 | WP-8401C8 | £210.00 | Declined | None | Apr 23 |
| #10609 | WP-85E710 | £74.00 | Approved | Refunded | Apr 22 |
Comparison
Default WooCommerce Worldpay admin vs SleekView
Default WooCommerce Worldpay admin
-
Worldpay transaction id and auth code live in
wc_orders_meta, never in the Orders list - No filter for authorised-but-uncaptured orders on the default screen
- AVS and CVV responses are visible only after opening each order
- Reconciling the Worldpay batch report requires opening each row individually
-
Tokens in
woocommerce_payment_tokensaren't joined to the order context
SleekView
-
_wc_worldpay_transaction_id,_wc_worldpay_auth_code, and capture status as columns - Saved view for authorised-not-captured orders, sorted by auth age
- Filter on AVS and CVV results to audit declines and risk patterns
-
Join refunds from
wc_orders(HPOS) orshop_order_refund(legacy) - Bulk-update status after a Worldpay batch settlement
Features
What SleekView gives you for WooCommerce Worldpay
Gateway response as columns
Add _wc_worldpay_avs_response, _wc_worldpay_cvv_response, and _wc_worldpay_capture_status from the meta picker. Build a fraud audit view distinct from the fulfilment view, each with its own column set.
Auth vs capture filters
Filter on auth status approved combined with capture status not equal to captured. Sort by auth age to catch authorisations approaching the Worldpay reversal window.
Batch reconciliation
Group orders by Worldpay batch id (when the plugin records it) or by date range. Match WP totals against the Worldpay merchant portal report without exporting CSVs.
Audience
Who uses SleekView for WooCommerce Worldpay
Finance reconciliation
Group by Worldpay batch and date for daily settlement reconciliation. Capture status and refund total visible in one row; export to CSV for the accountant.
Risk and fraud
Audit view filtered on declined orders with AVS mismatch. Sort by IP and customer email to spot patterns the default Worldpay risk rules missed.
Support and chargebacks
Customer-rooted history with transaction id, auth code, and capture state per order. Hand evidence packs to the dispute team without screen-recording the order page.
The bigger picture
Why card-gateway ops need row-level views
Worldpay is one of the older, more configurable card gateways still in heavy use across UK and European stores. It exposes auth, capture, settle, and refund as separate operations, and the WooCommerce extension records all of that into order meta. The default WooCommerce Orders screen does not know any of those fields exist.
A merchant looking at the Orders page sees Processing or Completed and a total, not whether the auth has been captured yet, not whether AVS matched, not whether the order is approaching the auth-expiry window. Finance teams reconcile Worldpay batches by hand, risk teams spot fraud patterns only retrospectively, and support teams answer chargeback questions by opening each order in turn. SleekView reads the meta the plugin already writes and exposes it as columns ops can sort, filter, and update.
Same database, same plugin handlers, same webhook flow. The capability gained is row-level visibility into a payment lifecycle the default admin treats as opaque.
Questions
Common questions about SleekView for WooCommerce Worldpay
The WooCommerce Worldpay extension covers both the legacy Business Gateway and the current Worldpay Online product. SleekView reads whichever meta keys the version installed on the store actually writes, scanned from wc_orders_meta live.
Yes. SleekView reads from wc_orders_meta on HPOS and from postmeta on legacy stores. The same column configuration works on both schemas; SleekView detects the active path automatically.
Status edits route through WooCommerce CRUD, so the plugin's capture and refund actions run as expected when an order changes status. Full capture and refund operations call Worldpay APIs through the plugin's own handlers, SleekView does not bypass those.
 
Yes. woocommerce_payment_tokens filtered by gateway_id set to the Worldpay slug shows saved tokens. Join woocommerce_payment_tokenmeta for the Worldpay-side reference id.
Declined transactions record an order note plus a status in _wc_worldpay_auth_response. SleekView renders the response code as a column, and you can filter to declined-only views and sort by AVS or CVV mismatch for risk review.
If the store runs WooCommerce Subscriptions, the Worldpay extension stores renewal-related meta on each renewal order in shop_subscription and the related renewal shop_order. SleekView can build a view that joins both to see renewal capture status alongside the subscription record.
Queries hit indexed columns on wc_orders directly. Meta-key filters use the wc_orders_meta indexes. Aggregate columns (lifetime captured value per customer) are opt-in per view since they cost more than direct columns.
Yes. Build a view scoped to one order or one customer, columns including transaction id, auth code, AVS, CVV, and notes. Export to CSV or PDF and attach to the dispute response without rebuilding the data manually.
 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 Stock Sync
- Yith Woocommerce Bookings
- Woocommerce B2b Suite
- Woocommerce Referrals
- Charitable
- Woocommerce Braintree
- Wcfm Bookings
- Woocommerce Free Shipping Bar
- Woocommerce Advanced Bulk Edit
- Woocommerce Tiktok Pixel
- Woocommerce Cybersource
- Woocommerce Sendcloud
- Currency Switcher
- Wholesale Market
- Magento Bridge
- User Meta Manager
- Memberpress Coupons
- Ihc Membership
- Nextend Social Login
- Buddypress Docs
- Membergate Pro
- Memberpress Affiliate Royale
- Memberium For Activecampaign
- Wp Affiliate Manager
- Magic Members Pro
- Simple Membership
- Memberpress Buddypress
- Restrict Content Pro
- Membership Pro Paypal
- Memberpress Corporate