✨ 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 Wholesale Payments: invoices & payments as tables

Wholesale Payments adds invoice / net-terms gateways to WooCommerce; payment method, due dates, and partial-payment history live as meta on wc_orders rows. SleekView pivots them into a collections workspace built around outstanding balances.

♾️ Lifetime License available

SleekView table view for WooCommerce Wholesale Payments

Net-terms invoices on one collections table

Wholesale Payments (the Wholesale Suite invoice / net-terms gateway add-on) lets B2B customers check out with invoice or net-30 / net-60 payment methods instead of paying at checkout. The order is created in wc_orders with payment method wholesale_invoice (or a similar configurable identifier) and a due-date meta key like _wp_due_date. As partial payments arrive, the order's paid amount is updated and remaining balance recalculated, with payment history typically stored as serialised order meta or as order notes.

The default WooCommerce orders screen sorts by date and status. It doesn't show due date as a column, doesn't compute days-past-due, and doesn't show paid-versus-outstanding amount per order. Collections teams chasing net-30 invoices have no admin view that says "orders with status processing, payment method invoice, due before today". They build reports manually or rely on the gateway's basic admin screen.

SleekView reads wc_orders filtered to the invoice payment method, surfaces due date, days-past-due, paid amount, and outstanding balance as columns, and supports inline status updates that route through WooCommerce CRUD so customer reminder emails still fire. Collections becomes one workspace.

Workflow

Collections in one workspace

1

Filter to invoice payments

Source wc_orders filtered to payment_method equals the Wholesale Payments identifier. The view scopes to net-terms invoices only.
2

Pivot due-date and paid meta

Add the due-date meta key (e.g. _wp_due_date) and paid-amount meta as columns. Compute days-past-due as a virtual column from today minus due date.
3

Save the collections views

Build views for past-due-30, past-due-60+, partially-paid, due-this-week. Aggregate per customer for total outstanding balance.
4

Remind, escalate, write off

Trigger reminder emails, escalate to collections, or write off bad debt inline. Writes go through Wholesale Payments / WooCommerce hooks so customer-facing notifications and accounting integrations stay consistent.

Sample columns

A typical wholesale invoices view

Filters wc_orders to invoice payment method with due-date and outstanding-balance columns.
Source: wp_wc_orders + wp_wc_orders_meta (payment method, due date, partial-payment history)
Invoice Customer Status Total Paid Due date Days past due
#I-3318 Atlas Brewhouse Awaiting payment €1,420 €0 May 31 n/a
#I-3317 Northside Cafe Group Partially paid €3,840 €2,000 May 12 4
#I-3316 Field Studio Supply Paid €5,210 €5,210 May 09 n/a
#I-3315 Coastline Goods Past due €960 €0 Apr 28 18

Comparison

Default Wholesale Payments admin vs SleekView

Default WooCommerce orders + Wholesale Payments

  • Due date isn't shown as a column on the WooCommerce orders screen
  • Days-past-due requires custom code to compute from _wp_due_date
  • Paid-amount vs total isn't visible without opening each order
  • Collections workflow requires filtering by payment method then exporting to CSV
  • Bulk-sending payment reminders goes through one order at a time

SleekView

  • Due-date column with days-past-due computed inline
  • Outstanding balance = total minus paid as a sortable column
  • Filter to invoice payment method across the whole store
  • Saved views: due-this-week, past-due-30+, partially-paid
  • Inline trigger of reminder emails via order CRUD

Features

What SleekView gives you for WooCommerce Wholesale Payments

Due-date triage

Sort orders by _wp_due_date, filter to payment_method='wholesale_invoice', and compute days-past-due as a virtual column. Past-due-30 and past-due-60 buckets become saved views collections runs daily.

Outstanding balance

Compute outstanding balance from order total minus paid-amount meta. Sort by outstanding amount descending to chase the biggest exposures first; aggregate per customer for total outstanding.

Reminder workflow

Trigger payment-reminder emails inline (Wholesale Payments exposes a hook for this). Bulk-send a Friday reminder batch to every past-due invoice in one action with audit logging.

Audience

Who uses SleekView for Wholesale Payments

Collections

Past-due-30 invoices sorted by outstanding balance with customer contact pre-joined. Reminder, escalate, or write-off inline; status changes route through Wholesale Payments hooks.

Account management

Per-customer aggregated balance: total open invoices, total outstanding, largest past-due. Pre-call context for the account-management team.

Finance

Aged-receivables view: 0-30, 31-60, 61-90, 90+ buckets computed inline. Export quarterly snapshots without leaving the table.

The bigger picture

Why net-terms B2B needs a real collections table

B2B stores that offer net-30 or net-60 terms operate under different rules than retail. Cash flow depends on collections discipline, and collections discipline depends on knowing which invoices are overdue and by how much, with customer context pre-joined for outreach. The default WooCommerce orders screen doesn't know that an order placed three weeks ago with payment method wholesale_invoice is now five days past due.

The data is all there: wc_orders carries the payment method, _wp_due_date meta carries the due date, and partial-payment meta tracks what's been collected so far. Operators just need a screen that joins them, computes days-past-due as a virtual column, and surfaces outstanding balance descending. SleekView is that screen.

Collections runs a daily past-due-30 saved view, finance runs a monthly aged-receivables snapshot, and account managers pull per-customer balances in seconds. Reminder emails fire through Wholesale Payments hooks so the customer experience matches single-order workflows. The cash-flow signal becomes operational; days late stops being a number you compute when something goes wrong.

Questions

Common questions about SleekView for WooCommerce Wholesale Payments

Yes. SleekView reads from wc_orders + wc_orders_meta under HPOS and shop_order + postmeta otherwise. Wholesale Payments stores the same fields in whichever store is active.

 

Wholesale Payments writes the due date to order meta (typically a key like _wp_due_date; the exact key is configurable). SleekView pivots that key into a column with date filtering, so saved views by due-week or due-month work out of the box.

 

Wholesale Payments updates a paid-amount meta key as partial payments come in. SleekView surfaces both the running paid amount and the computed outstanding balance (total minus paid) as columns.

 

Yes, where Wholesale Payments exposes a reminder hook. SleekView's bulk action iterates per order through the same code path the plugin uses internally, so reminders use the configured template and are logged consistently.

 

Yes. Write-offs are typically a status change plus an order note. SleekView's inline edit can flip status and add a note in one action; the note is searchable in later audits.

 

Currency is stored on the order. Multi-currency stores can group or filter by currency so collections doesn't compare apples to apples by mistake. Aged-receivables views can split by currency or convert via a configured fx column.

 

If Wholesale Payments (or a companion plugin) stores PDF URLs as order meta or attachments, SleekView surfaces them as a link column. Collections opens the PDF in one click from the same row as the past-due flag.

 

Order tables (HPOS or otherwise) are indexed on date and status. SleekView queries respect those indexes and stream results, so a store running thousands of net-terms invoices a month keeps the collections table responsive.

 

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