✨ 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 WC Vendors: vendors and commissions as tables

WC Vendors stores per-vendor commissions in pv_commission linked to WooCommerce orders. SleekView pivots commissions, payouts, and per-vendor sales into a single screen with inline reconciliation edits.

♾️ Lifetime License available

SleekView table view for WC Vendors

Vendor commissions on a single screen

WC Vendors keeps commissions in pv_commission and joins them to WooCommerce orders (which on modern stores live in wc_orders under HPOS, or wp_posts as shop_order on the legacy schema). The default WC Vendors commission list works for browsing, but per-vendor totals across date ranges require running reports, status changes (pending → paid) go one row at a time, and reversed commissions don't have a triage view that helps finance reconcile against refunds or chargebacks.

SleekView queries pv_commission directly with order and vendor joins, then gives you per-vendor totals, payout status, and order-level breakdowns in one table. A typical payout cycle view filters by date range with status=approved and pending payout > 0 — that's the batch payout queue, ready for inline status updates from pending to paid. A reversal triage view scopes to status=reversed, sorted by date, with the parent order visible for reconciliation against the original sale and the refund that triggered the reversal.

Per-vendor totals aggregate commission per vendor for any date range, useful for quarterly vendor statements or annual 1099 reporting in the US. Order joins surface the order total, payment status, and refund context inline, so a finance team reconciling commission against payouts doesn't need to open each order separately. The schema works for both WC Vendors Free and Pro (Pro adds shipping commission and more fields), and for both legacy and HPOS order storage — the joins adapt to whichever WooCommerce is configured for.

Workflow

From pv_commission rows to a payout-ready view

1

Read pv_commission

SleekView queries the commission table directly with joins to wp_users for vendor identity and to wc_orders or wp_posts for order context, depending on whether HPOS is enabled.
2

Aggregate per vendor

Build per-vendor rows summing commission for any date range, with pending payout total, count of approved rows, and count of reversed rows visible alongside.
3

Save cycle views

Finance gets the payout queue scoped to the cycle date range; vendor managers get per-vendor history for support context; growth gets top-earner views with rolling-window comparisons.
4

Update status inline

Mark commissions as paid from the row in bulk. SleekView writes through the standard WC Vendors hooks so any payout integration runs as it would from the default admin.

Sample columns

A typical commissions view

One row per commission record with vendor, order, status, and payout.
Source: wp_pv_commission + wp_wc_orders (or wp_posts shop_order) + wp_users
Vendor Order Total Commission Status Paid
Maker Guild #10421 €140 €98 Approved Apr 18
Studio Goods #10420 €80 €56 Approved Apr 18
New Trader #10419 €42 €29 Pending
Refund Demo #10418 €60 €42 Reversed

Comparison

Default WC Vendors admin vs SleekView

Default WC Vendors admin

  • Commission list has limited filtering and bulk actions
  • Per-vendor totals across date ranges require reports
  • Status changes (pending → paid) go one at a time
  • Reversed commissions aren't surfaced as a triage view
  • No saved view per payout cycle

SleekView

  • Read pv_commission directly with order and vendor joins
  • Aggregate commission per vendor for any date range
  • Inline-approve or mark-as-paid commission rows
  • Filter for reversed commissions and reconcile in place
  • Save views per payout cycle or vendor

Features

What SleekView gives you for WC Vendors

Per-vendor totals

Group commissions by vendor for the current cycle with sum, count, and pending payout in one row, useful for cycle-level reconciliation against payment processor records.

Order joins

Each commission row joins to its parent order so you can see totals, payment status, and refund context inline for reconciliation without opening each order separately.

Payout cycle views

Save a view scoped to a date range with status=approved and pending payout > 0 — your batch payout queue, loaded with one click each cycle.

Audience

Who uses SleekView for WC Vendors

Marketplace finance

Payout cycles and reconciliation without report exports, with cycle-scoped views that load instantly and CSV export for the accounting record.

Vendor managers

Per-vendor commission history at a glance for support questions, with order-level context visible alongside so questions like 'why was this commission lower' resolve quickly.

Growth

Spot top earners and at-risk vendors over rolling windows, useful for identifying churn risk early and prioritising relationship investment with high-value vendors.

The bigger picture

Why marketplace commission needs cycle-level views

Marketplace finance lives in cycles. Every two weeks, every month, every quarter — pick a cadence and that's when commissions get reviewed, payouts get approved, and disputes get reconciled. The default WC Vendors admin treats commissions as a flat list, which works for spot-checks but breaks the cycle-level workflow.

A finance lead running a monthly payout cycle wants every approved commission since the last cycle, grouped by vendor, with pending payout totals and refund context visible. The default list gives them a chronological commission feed and asks them to do the grouping in their head or in a spreadsheet. Multiply that across forty vendors and the manual reconciliation eats half a day.

SleekView turns the cycle into a saved view. Open the view, see every vendor with their cycle totals, mark the batch as paid in bulk, export to CSV for the accounting record. The reconciliation context — orders, refunds, reversals — is in the same screen.

The cycle goes from a half-day chore to a thirty-minute review, and the finance lead spends the saved time on actual finance work instead of data wrangling.

Questions

Common questions about SleekView for WC Vendors

Yes. Free has the core pv_commission table; Pro adds more commission fields (shipping commission, tax handling, more granular status types) and additional metadata. SleekView surfaces whichever columns your install has — when Pro is active, the additional fields appear automatically without configuration. Build a view once and it adapts to the schema you actually have.

 

Yes. Select rows and update status inline — the standard WC Vendors hooks fire so any payout integrations (Stripe Connect, PayPal Mass Pay, custom processors) run normally. The bulk update is the same operation as a one-by-one status change, just batched. Useful for monthly cycles where you process dozens or hundreds of approvals at once and want a verifiable record of what got paid when.

 

Same data layer. WC Vendors Marketplace is the rebrand of the Pro version — the schema is unchanged, the table names are unchanged, and SleekView reads the same pv_commission table on either branding. If you migrated from one name to the other, no reconfiguration is needed; existing views keep working with no changes.

 

Yes. Shipping is stored alongside item commission in the same table on Pro/Marketplace setups. Surface both as separate columns or as a sum. Useful for marketplaces where vendors handle their own shipping and the commission split needs to reflect that — finance can review item commission and shipping commission separately, or roll them up for the vendor statement.

 

Yes. HPOS (High-Performance Order Storage) moves orders from wp_posts to wc_orders, but commission records still live in pv_commission with order ID references. SleekView's joins use whichever order storage WooCommerce is configured for — legacy or HPOS — and the result is the same. No migration step needed when you flip the HPOS toggle.

 

Yes. Any view exports to CSV with the columns you've defined — vendor, order, commission amount, status, paid date, etc. Useful for monthly bookkeeping, quarterly reviews, or year-end 1099 preparation where you need a clean record of payouts per vendor. The CSV is one click from the table header and includes the same data visible in the view.

 

Build a per-vendor commission history view filtered by vendor — each row shows the commission, the parent order, the date, and the status. When a vendor questions a commission amount, the view answers their question in seconds with order-level context. For deeper investigation, the order join lets you see refunds, partial refunds, and reversed commissions tied to the same order.

 

Yes. Add a calculated column dividing commission by order total — surfaces effective commission rate per order. Useful for spotting orders where a flat-fee structure resulted in unusually high or low effective rates, or where a vendor's commission rule isn't producing the expected percentage. Filtering by effective rate range catches edge cases your commission rules might be missing.

 

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