WC Vendors Pro tracks commissions in pv_commission with foreign keys to the WooCommerce order and the vendor user. Each row stores the commission amount, status (paid, unpaid, due), the product (where commission rules vary per product), and the timestamp. The default WC Vendors admin gives a flat commission list with a fixed column set and a report screen for totals.

SleekView reads pv_commission directly and joins it with wc_orders (or legacy shop_order posts) and wp_users. A row can show vendor, order number, customer, product, commission amount, status, and date together. Sort by commission amount, filter by status and date range, scope to a single vendor, or surface unpaid commissions older than 30 days as a payout queue.

Inline status changes (marking a commission paid, applying a payout reference) write through WC Vendors' API where exposed. Bulk-mark a set of commissions as paid after a Stripe Connect transfer, and the vendor's audit log records each change. The reconciliation export from a filtered view replaces the manual CSV-from-report step that finance currently runs.

WC Vendors Pro got the commission data model right early. Commissions are real rows with foreign keys to orders and vendors, status transitions are tracked, and per-product commission rules resolve to per-row amounts at order time. That data layer scales to marketplaces with hundreds of vendors and tens of thousands of monthly commissions without breaking a sweat.

The bottleneck has always been the admin: a flat list with a fixed column set, a report screen that gives totals but not row-level context, and per-row actions that need a click and a confirm. Finance teams above a certain marketplace size end up exporting the list to a spreadsheet and managing payouts there because the spreadsheet has the columns and bulk operations the WC Vendors screens don't. SleekView removes the reason finance needs the spreadsheet.

The commission table becomes a real list with custom columns, saved filters, inline editing, and bulk operations, all writing through the WC Vendors API so audit logs and vendor totals stay correct. The shift from spreadsheet ops back to in-WordPress ops sounds small but it changes who owns the data, how fast payouts run, and whether reconciliation is a continuous task or a monthly emergency.