SleekView for WooCommerce GoCardless: mandates & Direct Debit orders as tables
Read GoCardless mandate ids, payment ids, and payout references straight out of wc_orders_meta and woocommerce_payment_tokens. Filter by mandate status, sort by next collection date, and reconcile payouts without opening each order.
♾️ Lifetime License available
Direct Debit ops without per-order clicks
WooCommerce GoCardless saves the mandate id, payment id, and customer reference into order meta on every Direct Debit checkout. On HPOS stores these live in wc_orders_meta under keys like _gocardless_mandate_id, _gocardless_payment_id, and _gocardless_customer_id. The default Orders screen never shows them, so checking whether a mandate is active or pending submission means opening each order one at a time.
SleekView reads those keys as real columns alongside the order total, status, and customer email. Mandate tokens stored in woocommerce_payment_tokens and woocommerce_payment_tokenmeta join in too, so a single view can show every active customer with their mandate status, last collection date, and outstanding balance. Payout reconciliation becomes a sort on payout id rather than a CSV export from the GoCardless dashboard cross-referenced against WordPress.
Inline status edits route through WooCommerce CRUD, so woocommerce_order_status_changed still fires when you bulk-flip a batch of submitted Direct Debit orders to processing after the GoCardless webhook confirms them. The plugin's own webhook handlers continue to run; SleekView just gives ops a row-level view of the same data the plugin already writes.
Workflow
How SleekView reads the GoCardless plugin schema
Pick the base table
wc_orders for order workflows or woocommerce_payment_tokens for a mandate-rooted view. SleekView detects HPOS or legacy automatically.
Add gateway meta columns
_gocardless_mandate_id, _gocardless_payment_id, _gocardless_customer_id, and any status keys from the meta picker. The picker lists keys present in your data.
Save the view per role
Bulk-update after webhooks
woocommerce_order_status_changed hooks firing as expected.
Sample columns
A typical GoCardless Direct Debit view
wc_orders with the gateway meta keys (_gocardless_mandate_id, _gocardless_payment_id) and payment-token records.
wp_wc_orders + wp_wc_orders_meta + wp_woocommerce_payment_tokens
| Order # | Mandate | Customer | Total | Status | Date |
|---|---|---|---|---|---|
| #10812 | MD0000ABCD | alex@studio.co | £42.00 | Submitted | Apr 24 |
| #10811 | MD0000EFGH | ria@design.io | £18.00 | Confirmed | Apr 24 |
| #10810 | MD0000IJKL | tom@hello.dev | £120.00 | Pending submission | Apr 23 |
| #10809 | MD0000MNOP | mia@brew.coop | £24.00 | Failed | Apr 22 |
Comparison
Default WooCommerce GoCardless admin vs SleekView
Default WooCommerce GoCardless admin
-
Mandate ids and payment ids live in
wc_orders_metabut never show on the Orders list - Reconciling a payout means cross-referencing the GoCardless dashboard against WP one order at a time
- No filter for mandate status exists on the default Orders screen
-
Tokens in
woocommerce_payment_tokensaren't browseable from the order context - Failed Direct Debits surface only as a generic order note, not a queryable column
SleekView
-
Surface
_gocardless_mandate_idand_gocardless_payment_idas first-class columns - Filter by mandate status (submitted, active, cancelled) in one click
-
Join
woocommerce_payment_tokensto see active mandates per customer - Bulk-flip status after a confirmed payout, hooks still fire through CRUD
- Save "Pending submission" and "Failed DD" views per role
Features
What SleekView gives you for WooCommerce GoCardless
Gateway meta as columns
Add _gocardless_mandate_id, _gocardless_payment_id, and _gocardless_customer_id from the meta-key picker. The picker scans your wc_orders_meta for keys actually in use, no guessing.
Direct Debit lifecycle filters
Filter on mandate status, payment status, or both. Build a saved "awaiting confirmation" view for the queue between checkout and webhook confirmation, and a "failed last cycle" view for retries.
Bulk-update after payout
Flip a filtered set of submitted orders to processing or completed after the GoCardless payout settles. CRUD writes mean woocommerce_order_status_changed and email triggers run as if a human clicked each one.
Audience
Who uses SleekView for WooCommerce GoCardless
Finance ops
Reconciliation view: orders grouped by GoCardless payout id, filtered by date range. Match WP totals against the GoCardless dashboard without exporting CSVs.
Customer support
Customer-rooted view showing every order with mandate id, last-collection date, and any failed attempts. Answer "why was I charged" or "is my DD set up" without a second tab.
Risk and compliance
Failed-mandate audit table: filter on _gocardless_payment_status equals failed, sort by amount, view notes inline. Spot patterns before they become chargeback disputes.
The bigger picture
Why Direct Debit ops need row-level views
Direct Debit settles slowly. Unlike a card charge that confirms in two seconds, a GoCardless payment moves through submitted, confirmed, paid out, and (sometimes) failed over a window of business days. The default WooCommerce Orders screen does not model that timeline.
It shows order status and total, not mandate status, not payout id, not the gap between submission and confirmation. Finance teams reconcile by exporting from GoCardless and grep-ing through WordPress, support teams handle "is my Direct Debit set up" calls by opening each order one at a time, and risk teams spot failed-DD patterns only after the chargeback. SleekView reads the data the plugin already writes (_gocardless_mandate_id, _gocardless_payment_id, mandate state, payout reference) and turns it into the workspace each team needs.
Same database, same hooks, the same webhook handlers running unchanged. The change is just that the meta keys finally show up as columns ops can sort, filter, and update.
Questions
Common questions about SleekView for WooCommerce GoCardless
Yes. SleekView reads GoCardless keys from wc_orders_meta on HPOS and from postmeta on legacy stores. The same column config works on both schemas because SleekView detects the active path automatically.
Yes. The plugin saves the mandate state into _gocardless_mandate_status when webhooks update it. Add that key as a column and SleekView renders it; pair it with a value-to-colour mapping so active reads green and cancelled reads red.
Status edits route through WooCommerce CRUD, so woocommerce_order_status_changed fires and downstream listeners (email, stock, webhook delivery) run normally. Mandate creation and Direct Debit submission still go through the GoCardless API on checkout, SleekView does not bypass that.
Yes. Build a view on woocommerce_payment_tokens filtered by gateway_id = gocardless. Join woocommerce_payment_tokenmeta for the GoCardless mandate id and any flags the plugin stores.
Failed payments add an order note and update _gocardless_payment_status. SleekView can render the status column with a red span and add a saved view that pre-filters to failed attempts in the last seven days.
No. The GoCardless dashboard remains the source of truth for mandates, payouts, and chargebacks. SleekView gives WooCommerce ops a row-level view of the data the plugin already syncs into WordPress so reconciliation does not require constant tab-switching.
 
Queries hit indexed columns on wc_orders (id, status, date_created_gmt). Meta-key filters use the standard wc_orders_meta indexes. Heavy aggregate columns like lifetime DD value are opt-in per view since they're slower than direct columns.
Yes. Any SleekView table exports to CSV with the same columns and filters applied. Useful for finance handing data to accountants or for compliance evidence packs without giving them WP admin access.
 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 Paytm Gateway
- Product Csv Import Export
- Woocommerce Shipping Multiple Addresses
- Woocommerce Quantity Discounts
- Aelia Currencyswitcher
- Bigcommerce
- Woocommerce Sendcloud
- Solid Affiliate
- Woocommerce Shipping Rates
- Woocommerce Stock Sync
- Woocommerce Cybersource
- Woocommerce Stock Manager Pro
- Magento Bridge
- Woocommerce Donation Form
- Cart66 Cloud