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
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
Read pv_commission
Aggregate per vendor
Save cycle views
Update status inline
Sample columns
A typical commissions view
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_commissiondirectly 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.
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 checkout