✨ 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 Product Vendors: vendor commissions & products as tables

Product Vendors stores vendors as wcpv_vendors taxonomy terms and logs commissions in wcpv_commissions linked to shop_order or wc_orders rows. SleekView pivots vendors, orders, and commissions into one filterable workspace.

♾️ Lifetime License available

SleekView table view for Product Vendors (Marketplace)

Vendor commissions, finally on one screen

The Product Vendors extension by WooCommerce models each vendor as a term of the wcpv_vendors taxonomy. Vendor settings (PayPal email, commission rate, vendor admin user ids) live in termmeta. Every order line that belongs to a vendor creates a row in the wcpv_commissions table with order id, product id, vendor id, vendor admin id, status (unpaid, paid, void), amount, and timestamps. Orders themselves still live in WooCommerce's order store (wc_orders under HPOS, shop_order posts otherwise).

The default admin lists commissions per vendor with a fixed column set and forces clicks to each commission to mark it paid or void. Filtering unpaid commissions across all vendors, grouping them into payout batches, or building leaderboards by gross sales versus net commission all require custom queries. Product Vendors offers no joined view of orders, commissions, and vendors in the standard admin.

SleekView reads wcpv_commissions, joins the wcpv_vendors taxonomy terms with their termmeta, and surfaces order context from the active WooCommerce order store. Inline status changes route through the plugin's CRUD so payout-notification emails still fire. Marketplace ops, finance, and vendor management all share one source.

Workflow

Marketplace finance in one workspace

1

Map the commissions table

Point SleekView at wcpv_commissions and select columns: vendor id, order id, product id, status, amount, created date. Status and amount become the primary working axes.
2

Join vendor and order

Add the wcpv_vendors taxonomy term with selected termmeta (PayPal email, commission rate) and join to wc_orders for order status and total context.
3

Save the payout views

Build views for unpaid balances grouped by vendor, paid this month, voided refunds, and quarterly leaderboards. Scope vendor self-service views by vendor admin id.
4

Process inline

Mark commissions paid or void from the table. CRUD writes fire payout hooks; bulk actions iterate row by row so notification behaviour matches single-row edits.

Sample columns

A typical Product Vendors commissions view

Joins wcpv_commissions with the wcpv_vendors term and the order line.
Source: wp_wcpv_commissions + wp_term_taxonomy (wcpv_vendors) + wp_termmeta + wp_wc_orders
Commission Vendor Order Product Status Amount Date
#WC-3318 Coastline Goods #9102 Beach towel Unpaid $11.20 May 15
#WC-3317 Field Studio #9101 Print A3 Paid $8.40 May 14
#WC-3316 Brewline Roasters #9100 House blend 500g Unpaid $5.60 May 14
#WC-3315 Coastline Goods #9095 Linen tote Void $0.00 May 13

Comparison

Default Product Vendors admin vs SleekView

Default Product Vendors admin

  • Commissions are listed per vendor with no cross-vendor view in the standard admin
  • Vendor termmeta (payout method, commission rate) isn't shown on commission rows
  • Filtering by date range across wcpv_commissions needs URL parameters
  • Bulk-marking commissions paid means clicking edit on each row
  • No leaderboard view by gross sales or net commission

SleekView

  • Cross-vendor commission table sortable by amount, status, or vendor
  • Vendor termmeta surfaced as columns next to each commission
  • Aggregate amount per vendor for payout-batch totals
  • Inline-edit commission status with hook-aware writes
  • Saved views: unpaid balances, paid this month, voided refunds

Features

What SleekView gives you for Product Vendors (Marketplace)

Cross-vendor commission table

All rows of wcpv_commissions in one table, sortable by vendor id, status, or amount. The per-vendor screen still exists; SleekView adds the cross-vendor angle finance needs at month-end.

Date and status faceting

Filter on status, created_at, and the joined order's date_completed. A view of "unpaid commissions accrued before May 1" becomes a saved filter rather than a custom query.

Vendor metadata on every row

Pivot termmeta keys (PayPal email, default commission rate, store URL, vendor admin user id) into columns. Payout outreach and rate-overrides become one-click context inline.

Audience

Who uses SleekView for Product Vendors

Marketplace finance

Month-end payout view: unpaid commissions grouped by vendor, summed and sortable. Mark a batch paid in one bulk action that still triggers payout-notification emails.

Vendor management

Leaderboard sorted by net commission per quarter. Filter to newly approved vendors to see ramp; filter to dormant vendors (no commissions in 30 days) for outreach.

Support

Per-order commission split visible during a support ticket. When a customer requests a refund, support sees which vendor commission will reverse before approving.

The bigger picture

Why Product Vendors stores need cross-vendor tables

Marketplaces grow by adding vendors, and every new vendor multiplies the operational load on the same admin screens. Product Vendors stores commission lines in wcpv_commissions with one row per vendor per order line, vendor metadata in wcpv_vendors termmeta, and orders in the active WooCommerce order store. The data model is clean; the default admin's per-vendor pagination is what slows operators down.

A finance team closing the month wants every unpaid commission in one filtered view, summed per vendor, ready for a PayPal MassPay export. A vendor manager wants a quarterly leaderboard sorted by net commission. Support needs per-vendor history without opening five tabs.

The default admin doesn't ship those screens because most stores don't need them until vendor count crosses fifty. SleekView pivots wcpv_commissions into a cross-vendor workspace with termmeta as columns, status filters as facets, and inline edits routed through the plugin's CRUD. The same source feeds vendor-scoped views for self-service.

The schema has been carrying this weight all along; SleekView just exposes it.

Questions

Common questions about SleekView for Product Vendors (Marketplace)

Yes. SleekView reads from wc_orders when HPOS is enabled and from shop_order posts otherwise. wcpv_commissions stores the order id either way, so the join key is the same.

 

Yes. When a refund triggers Product Vendors to void a commission, the status column on wcpv_commissions updates to void. Filter to voided rows in a saved view for refund-impact auditing.

 

By default, yes. SleekView writes through the plugin's commission CRUD so the woocommerce_product_vendors_commission_status_updated hook fires and downstream emails or webhooks still trigger. Direct table writes are an option when intentionally skipping notifications.

 

Yes. Scope a saved view by current user's vendor admin id from termmeta. Vendors get a self-service commissions table while site admins keep the full cross-vendor view.

 

Product Vendors lets each product carry its own commission rate as postmeta. SleekView surfaces that key as a column alongside the vendor's default rate so overrides are visible at a glance.

 

When one order has line items from multiple vendors, wcpv_commissions writes one row per line. SleekView's join to wc_orders preserves the multi-row relationship and the order total is visible on each commission row for context.

 

Yes. Any saved view exports to CSV with the joined termmeta (PayPal email, payout method) included so the export is upload-ready for PayPal MassPay or a similar disbursement tool.

 

wcpv_commissions is a flat custom table with indexed columns on order id and vendor id. SleekView queries respect those indexes and stream rows page by page, so views over hundreds of thousands of commissions stay 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