SleekView for WooCommerce Wholesale Order Form: bulk orders & line items as tables
Wholesale Order Form lets wholesale customers add many SKUs to cart at once; the orders land as standard WooCommerce orders with the wholesale customer role and tiered pricing applied. SleekView pivots those bulk orders into an ops table tuned for B2B fulfilment.
♾️ Lifetime License available
Bulk wholesale orders on one fulfilment table
WooCommerce Wholesale Order Form provides a one-page form for wholesale buyers to add many products to cart in a single submission. The resulting orders are normal WooCommerce orders, stored in wc_orders (HPOS) or as shop_order posts. Line items live in wc_order_items + wc_order_itemmeta as usual. The wholesale customer's user account carries a wholesale_customer or similar role (set by Wholesale Suite or compatible plugin) and the order's prices are calculated from the wholesale tier at checkout.
The standard WooCommerce orders screen treats a 200-SKU wholesale order and a one-item retail order identically. Sort and filter columns aren't B2B-aware: there's no easy way to filter to orders from wholesale customers only, no per-customer order count for the month, no average order size column. Bulk operations on wholesale orders (mark as shipped, generate pick lists, send order confirmations to procurement) go one row at a time through the standard admin.
SleekView reads wc_orders, joins user role from wp_usermeta to filter wholesale-only, surfaces line-item count and unique SKU count as columns, and aggregates per-customer monthly totals. Fulfilment opens one view; finance another; account managers a third.
Workflow
B2B order ops on one workspace
Filter to wholesale customers
wc_orders and add a join to wp_usermeta on the wholesale-customer role. The view scopes to wholesale orders only without changing how WooCommerce stores them.
Aggregate lines and tier
wc_order_items. Pivot the customer's wholesale tier from usermeta into a column so account managers see tier on every row.
Save B2B views
Update status inline
Sample columns
A typical wholesale orders view
wc_orders to wholesale-role customers and adds line-item aggregates as columns.
wp_wc_orders + wp_wc_order_items + wp_wc_order_itemmeta + wp_users + wp_usermeta
| Order | Wholesale customer | Status | Lines | Total | Date | Shipping |
|---|---|---|---|---|---|---|
| #W-5121 | Northside Cafe Group | Processing | 42 | €3,840 | May 16 | Flat-rate |
| #W-5120 | Atlas Brewhouse | Completed | 18 | €1,260 | May 15 | Pickup |
| #W-5119 | Field Studio Supply | On hold | 67 | €5,210 | May 14 | Courier |
| #W-5118 | Coastline Goods | Cancelled | 12 | €0 | May 13 | n/a |
Comparison
Default WooCommerce admin vs SleekView
Default WooCommerce orders admin
-
Standard orders screen has no wholesale-only filter (role lives in
wp_usermeta, not on the order) - Line count and unique-SKU count per order aren't shown as columns
- Per-customer monthly aggregate needs a separate reports tool
- Bulk-completing a wholesale order's 100+ items goes through the order edit screen
- Wholesale tier ("Tier 1", "Tier 2") isn't visible on the order row
SleekView
-
Wholesale-only orders view via role join to
wp_usermeta - Line count, unique SKU count, and average line price aggregated per order
-
Per-customer monthly totals from
wc_ordersaggregation - Wholesale tier surfaced from usermeta as a column
- Inline-edit order status with hook-aware writes (still fires fulfilment emails)
Features
What SleekView gives you for WooCommerce Wholesale Order Form
Pick-list-ready order view
Expand each order to its line items joined from wc_order_items. Sort by SKU and quantity for warehouse picking; export the expanded view as a CSV for the pick-list printer.
Customer order history
Aggregate wc_orders by customer id to get total orders, total spent, and last-order date per wholesale account. Sort by spend to identify top accounts.
Wholesale role facet
Filter to orders from users with the wholesale-customer role via a join to wp_usermeta. Combine with date range and status for monthly wholesale-only reports.
Audience
Who uses SleekView for Wholesale Order Form
Fulfilment / warehouse
Pick lists by order with line counts visible upfront. Sort large multi-SKU orders first for batching; mark as shipped inline once packed.
B2B account management
Top accounts by month: total spent, last order date, average order size. Account managers spot drop-off patterns and ramp accounts at risk.
Finance
Wholesale-only revenue per period, average order value, and net-30 outstanding (joined to the payment method column). Net-terms invoicing becomes auditable inline.
The bigger picture
Why wholesale order ops needs flat tables
Wholesale orders look nothing like retail orders. A retail order has one or two items; a wholesale order can have a hundred lines and a five-figure total. A retail customer orders once or twice; a wholesale customer orders weekly, on net-30 terms, with a tier-based price list that's invisible to the retail side of the store.
The default WooCommerce orders admin doesn't make that distinction and treats both flows in the same fixed-column screen. Wholesale Order Form solves the customer-facing side (bulk add-to-cart) but doesn't change the admin. Fulfilment teams scrolling through orders need line counts up front to batch large jobs first.
Finance needs wholesale-only revenue per period for monthly close. Account managers need per-customer order history sortable by spend to spot drop-off. The data is in wc_orders, wc_order_items, and the wholesale-customer role assignment in usermeta.
SleekView joins them, aggregates them, and presents the B2B-shaped table the workflow actually needs. Retail orders keep their own view; wholesale orders get the flat tier-aware workspace that matches how B2B teams actually run.
Questions
Common questions about SleekView for WooCommerce Wholesale Order Form
Yes. SleekView reads from wc_orders when HPOS is enabled and shop_order posts otherwise. Wholesale Order Form writes to whichever store WooCommerce is configured to use; the column layout in SleekView is identical.
Wholesale Order Form itself doesn't tag the order; the customer's role does. Filter wc_orders joined to wp_usermeta on the wholesale-customer role (varies by Wholesale Suite version). The role identifier is configurable per saved view.
Yes. Wholesale Suite stores tier assignment as usermeta (or as a sub-role); SleekView surfaces that key as a column. The actual tier price on the order is implicit in the line-item totals, which also surface.
Yes. The line items from wc_order_items + wc_order_itemmeta expand as a child table per order. Useful for fulfilment picking long wholesale carts without leaving the orders view.
Yes. Any saved view exports to CSV; expanding line items in the view writes them as rows in the export, so the resulting file is upload-ready for a WMS or printable as a pick-list.
Yes by default. SleekView writes through WooCommerce's order CRUD so status-change emails (processing, shipped, completed) and gateway webhooks fire as if a human clicked through the order screen. Direct DB writes are available for bulk cleanup.
Wholesale Order Form (and Wholesale Suite) enforces minimum order value at checkout. SleekView reads orders that have already passed the rule; for auditing rejected attempts, surface server logs separately. The historical orders table reflects what actually got placed.
Yes. Payment method or a custom usermeta flag (depending on the net-terms plugin in use) joins onto each order. A saved view of net-30 orders past due (status not completed, date older than 30 days) becomes a collections workspace.
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 Grouped Products Pro
- Sprout Invoices
- Woocommerce Purchase Order Gateway
- Woocommerce Order Status Control
- Woocommerce Gift Ultimate
- Woocommerce Easyship
- Woocommerce Currency Per Product
- Woocommerce Prices By User Role
- Woocommerce Dhl Express
- Tradegecko Wp
- Woocommerce Criteo
- Woocommerce Wholesale Prices
- Woocommerce Pdf Vouchers
- Woocommerce Realex
- Yith Woocommerce Points And Rewards