SleekView for WooCommerce 2Checkout: gateway transactions as queryable tables
The 2Checkout (Verifone) gateway writes sale IDs, payment method data and fraud scores into wc_orders_meta. SleekView promotes those keys to typed columns finance and risk can filter, sort and export.
♾️ Lifetime License available
2Checkout writes everything to order meta. SleekView reads it.
The WooCommerce 2Checkout (now Verifone) gateway plugin does not add its own tables. It writes Verifone sale IDs, INS notification data, payment method types and fraud scores into wc_orders_meta on each order. The default WooCommerce orders screen cannot filter by any of these, so reconciling a 2Checkout payout against shop revenue means opening orders one at a time or dropping into raw SQL.
SleekView reads those meta keys against High-Performance Order Storage and promotes them to typed columns. _2checkout_order_number becomes a searchable reference. _2checkout_fraud_score becomes a filterable risk indicator. Payment method type splits card, PayPal, wire and SEPA flows in one click. Recurring billing flags expose subscription renewals as their own saved view.
Edits route through WooCommerce's CRUD layer to preserve hooks and audit trails. Verifone-side references stay read-only so they can never drift from the gateway's view of the transaction. Per-role masking hides PII columns from staff who do not need them.
Workflow
Promote 2Checkout meta to first-class columns
Pick the source
wc_orders joined with wc_orders_meta. The grid auto-detects every _2checkout_-prefixed key (sale number, payment method, fraud score, recurring flag).
Compose columns
Save and scope per role
Edit inline or bulk update
Sample columns
2Checkout (Verifone) order metadata
wc_orders_meta. The plugin adds no custom tables.
wp_wc_orders_meta (HPOS) or wp_postmeta
| Meta key | Description | Type | Filterable | Status |
|---|---|---|---|---|
| _2checkout_order_number | Verifone sale reference | string | Yes | Read |
| _2checkout_payment_method | Card, PayPal, SEPA, wire | string | Yes | Read |
| _2checkout_fraud_score | Verifone fraud signal | integer | Yes | Audit |
| _2checkout_recurring | Subscription renewal flag | boolean | Yes | Read |
Comparison
Default WooCommerce 2Checkout admin vs SleekView
Default WooCommerce 2Checkout admin
- Fraud score hidden inside per-order screens
- No way to filter card vs PayPal vs SEPA from the order list
-
_2checkout_order_numbernot searchable on the orders screen - Recurring renewals look identical to first-time charges
- INS notification history scattered across order notes
SleekView
-
Promote fraud score to a sortable column from
wc_orders_meta - Filter by payment method (card, PayPal, SEPA, wire) in one click
-
Search by
_2checkout_order_numberat the list level -
Renewals view via
_2checkout_recurringas a filter - Export 2Checkout-funded slices for finance reconciliation
Features
What SleekView gives you for WooCommerce 2Checkout (Verifone)
Fraud score column
Promote _2checkout_fraud_score to a sortable, filterable column. Set thresholds (above 50, above 70) as saved views so the risk team can scan elevated orders without opening them.
Method split
Card, PayPal, SEPA Direct Debit and wire orders all write the same gateway but different _2checkout_payment_method values. One filter splits them into distinct reporting views.
Recurring queue
Surface _2checkout_recurring as a column to isolate subscription renewals from first-time payments. Renewal failure investigations become a saved view instead of an export.
Audience
Who uses SleekView for WooCommerce 2Checkout
Risk review
Filter by fraud score above your threshold, sort by order total descending, and the daily risk queue becomes a one-click saved view. Bulk export feeds the dispute-prep workflow.
Finance reconciliation
Pair Verifone sale ID with capture date and payment method, then export by batch to reconcile against 2Checkout payout reports without manual pivots.
Subscription operations
Use the recurring flag plus order status to isolate failed renewals. Bulk-flag affected customers for retention outreach before churn occurs.
The bigger picture
2Checkout payouts cross currencies and methods
2Checkout's biggest pitch is cross-border: hundreds of currencies, multiple funding methods (card, PayPal, SEPA, wire) and built-in subscription billing on one gateway. That breadth becomes a problem on the default WooCommerce orders screen because every transaction looks the same. A SEPA renewal in EUR, a first-time Brazilian Boleto and a US card subscription all show up as "2Checkout" with no list-level way to separate them.
Finance reconciles by exporting and pivoting in Excel. Risk reviews each order one click at a time. Support cannot search by Verifone sale ID.
Promoting the gateway's meta keys to typed columns turns those bottlenecks into normal saved views. For cross-border stores running real 2Checkout volume, that change pays back in the first reconciliation cycle and keeps paying back every renewal batch after that.
Questions
Common questions about SleekView for WooCommerce 2Checkout (Verifone)
No. The 2Checkout (Verifone) gateway plugin writes everything (sale ID, payment method, fraud score, recurring flag, INS responses) into wc_orders_meta on HPOS or wp_postmeta on legacy storage. SleekView reads those meta keys as columns, with no extra schema to join.
Yes. Promote _2checkout_fraud_score to a numeric column and sort or filter by threshold. A saved view of "fraud score above 50 in the last 7 days" gives the risk team a daily review queue without per-order clicks.
Yes. SleekView reads from wc_orders and wc_orders_meta on High-Performance Order Storage. Sites still on legacy CPT order storage are supported too; the grid auto-detects the active layer. Saved views carry over across the HPOS migration.
Yes. _2checkout_recurring is written on renewal orders and exposed as a boolean filter. A saved view of "renewals only" separates subscription cycles from one-off purchases for reporting and retention work.
No. _2checkout_order_number is immutable on Verifone's side; editing it locally would silently desync the order from the gateway. SleekView marks it read-only. Notes and editable meta keys can still be inline-edited and route through WooCommerce's CRUD layer.
Currency is its own column with locale-aware formatting. 2Checkout supports cross-border payments in many currencies, so currency as a filter lets finance split EUR, GBP, USD and other flows for separate reconciliation against Verifone's per-currency payouts.
 Fraud score, payment method and recurring status together flag the riskiest cohorts. A saved view of "high fraud score on first-time card orders, shipped" surfaces the orders most likely to dispute. Pre-collecting shipping evidence for that view shortens dispute response time later.
 Yes. Filter to whatever finance or risk asked for, then export the visible slice as CSV. Column-level masking applies on export, so PII fields hide for users without the right capability. Common exports include daily fraud-flagged orders and monthly recurring-renewal failures.
 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
- Rehub Affiliate
- Woocommerce Gift Cards Pro
- Surecart Subscriptions
- Funnelkit Stripe Gateway
- Woocommerce Vendor Payouts
- Edd Recommendations
- Woocommerce Moneris
- Yith Woocommerce Subscription
- Woocommerce Customer Order Csv Export
- B2b For Woocommerce
- Woocommerce Aftership
- Wholesale Suite
- Printful Integration
- Woocommerce Advanced Product Labels
- Edd Conditional Emails