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
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
Map the commissions table
wcpv_commissions and select columns: vendor id, order id, product id, status, amount, created date. Status and amount become the primary working axes.
Join vendor and order
wcpv_vendors taxonomy term with selected termmeta (PayPal email, commission rate) and join to wc_orders for order status and total context.
Save the payout views
Process inline
Sample columns
A typical Product Vendors commissions view
wcpv_commissions with the wcpv_vendors term and the order line.
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_commissionsneeds URL parameters -
Bulk-marking commissions paid means clicking
editon 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
amountper 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.
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 Xero Pro
- Woocommerce Vendor Payouts
- Aelia Tax Display By Country
- Woocommerce Credit Notes
- Woocommerce Affiliatewp Integration
- Yith Woocommerce Subscription
- Woocommerce Clearpay
- Shipperhq Woocommerce
- Woocommerce Prices By User Role
- Woocommerce Quotes Orders
- Woocommerce Donation Form
- Woocommerce Walmart Sync
- Woocommerce Deposits
- Yith Woocommerce Checkout Manager
- Woocommerce Quick View