SleekView for WooCommerce Tip Jar: tip captures as tables
Read directly from wc_order_items fee rows for the tip amount plus wc_orders_meta for the tip preset selected at checkout. Filter by tip range, aggregate totals by month, and inline-edit fulfillment without per-order clicking.
♾️ Lifetime License available
Tip captures, finally measurable as a list
WooCommerce Tip Jar plugins (and similar tipping/gratuity extensions) attach a customer-chosen tip to the order at checkout, typically as a fee row in wc_order_items with order_item_type = fee. The selected preset (10%, 15%, custom amount) is usually stored alongside in wc_orders_meta. The default Orders list shows the total but never separates the tip from the rest of the order, so a tip-aware merchant can't easily ask "what did we collect in tips this week".
SleekView reads wc_order_items filtered to the tip fee row, joins it to the order and customer tables, and surfaces the tip amount, tip preset, and tip percentage as real columns. Aggregate tip revenue by date, filter to orders with a tip over a threshold, or pivot by preset to see which tip option converts best. The data is already in the WooCommerce schema, it just needs the right view.
Inline edits route through WooCommerce CRUD for status changes, and through standard meta-update hooks for any tip-meta corrections. Saved views per role keep service teams (which staff member earned tips), finance (period totals for distribution), and management (uptake and average tip rate) looking at the same data through their own lens.
Workflow
How SleekView reads your Tip Jar data
Pick the source
wc_orders as the base table on HPOS or shop_order on legacy. SleekView detects the active path and exposes joinable order items, item meta, and orders meta.
Add the tip fee join
wc_order_items filtered to the tip fee identifier. Tip amount and tip preset (from wc_orders_meta) become columns alongside the standard order fields.
Save and scope the view
Edit inline and ship
Sample columns
A typical Tip Jar capture view
wc_order_items (fee row for tip) with wc_orders_meta for tip preset and wc_orders for status, customer, and total.
wp_wc_order_items (order_item_type=fee) + wp_wc_orders_meta + wp_wc_orders
| Order # | Status | Tip preset | Tip | Order total | Date |
|---|---|---|---|---|---|
| #5121 | Completed | 15% | $4.20 | $32.20 | May 14 |
| #5120 | Completed | 20% | $9.40 | $56.40 | May 14 |
| #5119 | Processing | Custom | $2.00 | $28.00 | May 13 |
| #5118 | Refunded | 10% | $3.80 | $41.80 | May 13 |
Comparison
Default WooCommerce admin (with Tip Jar) vs SleekView
Default WooCommerce admin
- Tip amount rolls into the total without a separate column in the Orders list
-
Tip preset (10%, 15%, custom) lives in
wc_orders_metaand isn't surfaced - No filter for "orders with a tip greater than $5"
- Period totals (tips collected this week) need custom SQL or analytics
- Refunded tips appear in the total but aren't separately filterable
SleekView
-
Tip amount and preset as real columns from
wc_order_itemsand meta - Aggregate tip totals per day, week, month inline
- Filter by tip range or by preset (10% vs 15% vs custom)
- Refunded-tip tracking via the standard refund schema
- Save views per role for service, finance, management
Features
What SleekView gives you for WooCommerce Tip Jar
Tip amount as a column
Surface the tip fee row from wc_order_items as a real column alongside the order total. Filter to orders with a tip over a threshold or sort by tip amount to see the highest tippers.
Tip aggregates inline
Sum the tip column over a date range to see daily, weekly, monthly tip revenue. Useful for tip-pool distribution and management dashboards without exporting to a spreadsheet.
Filter by preset
Pivot the table by tip preset (10%, 15%, 20%, custom) to see which option converts best. Decide whether to change the default preset based on real conversion data, not guesswork.
Audience
Who uses SleekView for Tip Jar
Service teams
Tips per shift or per period visible inline for tip-pool distribution. No spreadsheet stitching, the numbers come straight from wc_order_items.
Finance
Tip revenue separated from product revenue for tax and accounting. Refunded tips visible inline so reconciliation matches the gateway's settlement reports.
Management
Average tip rate, preset uptake, and tip revenue trend visible across months. Decide whether the default preset is doing its job or needs adjustment.
The bigger picture
Why tip-revenue visibility matters for service businesses
Tip Jar plugins exist because more WooCommerce stores now operate the way restaurants, salons, and service providers do, where a meaningful portion of order value comes from gratuity. The plugins handle the checkout interaction well, presenting tip presets and writing the chosen amount to the standard fee mechanism. What they don't handle is the operational reporting that comes after, because the default WooCommerce Orders screen rolls the tip into the order total without ever showing what portion of it came from gratuity.
A salon owner doing weekly tip distribution can't see per-period tip totals without exporting. A finance lead reconciling at month end can't separate tip revenue from product revenue for tax purposes without custom SQL. A manager testing whether the default tip preset converts better at 15% or 18% can't see uptake by preset without an analytics tool.
SleekView reads wc_order_items fee rows, joins them to the order meta, and surfaces tip amount, preset, and percentage as real columns. Same database, same hooks, dramatically less spreadsheet work for the people running the service.
Questions
Common questions about SleekView for WooCommerce Tip Jar
Most Tip Jar plugins use the standard WooCommerce fee mechanism, which writes to wc_order_items with order_item_type = fee. The preset choice is typically in wc_orders_meta (or postmeta on legacy). SleekView reads that standard schema, no custom integration required.
The Tip Jar fee row has an identifying name or item-meta key set by the plugin (often containing "tip" or "gratuity"). SleekView lists actual item names and meta keys in your store, so you pick the real identifier and filter on it.
 Yes. Sum the tip-fee column over any date range filter (today, this week, this month). The aggregate appears at the foot of the view for quick distribution math. Useful for daily tip-pool calculations without a separate report.
 Yes. Refunds in WooCommerce create child orders (refund objects) that include the refunded fee row. SleekView can either subtract refunded tips from the original total or show refunded tips as their own view scoped to a date range, depending on what reconciliation needs.
 Only if your setup associates orders with a staff member, typically via a custom meta key set at checkout. SleekView surfaces that meta as a column and groups by it for tip-pool calculations. If you don't track staff per order, the aggregate view still gives you period totals.
 
Yes. wc_order_items on HPOS works the same way as on legacy for SleekView's purposes. The fee-row join plus wc_orders_meta lookup behaves identically. SleekView detects which path is active.
Yes. Any saved view exports to CSV with active columns and filters. Useful for monthly tip-revenue review, payroll-tip distribution, or sharing with the accountant. GDPR data-export tooling continues to work as before.
 
Status edits route through CRUD so woocommerce_order_status_changed fires and any Tip Jar listener on that hook runs. Direct tip-amount edits should be rare (tips are customer choices), but if needed they trigger the standard order-items update hooks.
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 Color Swatches
- Paypal Payments
- Woocommerce Checkout Addons
- Woocommerce Back In Stock
- Woocommerce Currency Converter
- Woocommerce Donation Form
- Affiliatewp
- Edd Frontend Submissions
- Edd Aweber
- Woocommerce Moneris
- Woocommerce Additional Variation Images
- Woocommerce Mercado Pago
- Woocommerce Quantity Discounts
- Woocommerce Subscriptions
- Woocommerce Criteo
- Memberium Active Campaign
- Buddypress Docs
- Buddypress Media
- Wishlist Quickfront
- Members Management Pro
- Memberpress Affiliate Royale
- Magazine Paywall
- Wp Affiliate Manager
- Woocommerce Paid Courses
- Content Locker Pro
- Memberpress Bundle
- Loginpress Pro
- Membership By Supsystic
- Profile Magic
- Wishlist Member Stripe