✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for WooCommerce GoCardless

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

1

Pick the base table

Choose wc_orders for order workflows or woocommerce_payment_tokens for a mandate-rooted view. SleekView detects HPOS or legacy automatically.
2

Add gateway meta columns

Pull _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.
3

Save the view per role

Name the views ("Awaiting submission", "Failed last cycle", "Active mandates") and gate by WordPress capability so finance, support, and risk each see the right rows.
4

Bulk-update after webhooks

Once GoCardless webhooks fire, bulk-update affected orders through SleekView. CRUD writes keep woocommerce_order_status_changed hooks firing as expected.

Sample columns

A typical GoCardless Direct Debit view

Joins wc_orders with the gateway meta keys (_gocardless_mandate_id, _gocardless_payment_id) and payment-token records.
Source: 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_meta but 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_tokens aren't browseable from the order context
  • Failed Direct Debits surface only as a generic order note, not a queryable column

SleekView

  • Surface _gocardless_mandate_id and _gocardless_payment_id as first-class columns
  • Filter by mandate status (submitted, active, cancelled) in one click
  • Join woocommerce_payment_tokens to 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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