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
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
Filter to invoice payments
wc_orders filtered to payment_method equals the Wholesale Payments identifier. The view scopes to net-terms invoices only.
Pivot due-date and paid meta
_wp_due_date) and paid-amount meta as columns. Compute days-past-due as a virtual column from today minus due date.
Save the collections views
Remind, escalate, write off
Sample columns
A typical wholesale invoices view
wc_orders to invoice payment method with due-date and outstanding-balance columns.
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.
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 Affiliatewp Integration
- Charitable
- Woocommerce Wholesale Prices
- Thrivecart Funnels
- Product Vendors Marketplace
- Product Csv Import Export
- Woocommerce Shipping Multiple Addresses
- Woocommerce Pdf Invoice Pro
- Veeqo Wp
- Skubana Wp
- Woocommerce Distance Rate
- Funnelkit Cart
- Woocommerce Extra Options
- Aelia Currencyswitcher
- Woocommerce Follow Up Emails