SleekView for WooCommerce Extra Fees: fee rules & applied fees as tables
Read fee rules from wp_options and per-order fee lines from wc_orders_meta (or _fee_lines postmeta on legacy). Audit which rule fired on which order without opening orders one at a time.
♾️ Lifetime License available
Audit which fee fired on which order
WooCommerce Extra Fees plugins (the umbrella term covers Plugin Republic's Extra Fees, Conditional Fees for WooCommerce, and similar tools) let a merchant attach surcharges to checkout based on cart contents, payment gateway, country, or coupon use. The default admin for these plugins is usually a list of fee rules in a single screen, plus the standard WooCommerce order details where the fee shows up as a line. There is no audit table that says "this rule fired on these 312 orders last week" without writing SQL against wc_orders_meta.
SleekView reads fee rules from the plugin's options row (typically wp_options with a key like wc_extra_fees_rules or a custom table when the plugin ships one), then joins each applied fee back to its order through wc_orders on HPOS or shop_order on legacy. A fee-audit view surfaces order id, customer, gateway, rule name, fee amount, and date, all sortable and filterable. Switch to a kanban grouped by rule and you see which rules are doing the heavy lifting at a glance.
Inline edits route through the plugin's own rule API where the plugin exposes one, or fall back to direct option updates with a conflict-detection check (last-write-wins with a warning). Turning a rule off, raising a flat fee from $2 to $3, or scoping a rule to a new country no longer means clicking through the rule-editor for each one.
Workflow
How SleekView reads Extra Fees data
Pick the source
wp_options or the plugin's custom table) or the fee-audit table (joining wc_orders_meta back to wc_orders). SleekView detects HPOS automatically.
Compose columns
wc_orders_meta keys present in your data. Rule name is exposed as a real joinable column, not just an attribute on the fee line.
Save and scope
Edit inline or bulk-toggle
Sample columns
A typical Extra Fees audit view
wc_orders_meta back to wc_orders, grouped by rule name from plugin options.
wp_options (rule config) + wp_wc_orders_meta (applied fees)
| Order | Rule | Fee | Gateway | Status | Date |
|---|---|---|---|---|---|
| #10428 | COD surcharge | $4.00 | Cash on delivery | Processing | Apr 24 |
| #10427 | Express shipping | $12.00 | Stripe | Completed | Apr 24 |
| #10426 | Gift wrap | $3.50 | PayPal | Completed | Apr 23 |
| #10425 | COD surcharge | $4.00 | Cash on delivery | Cancelled | Apr 23 |
Comparison
Default WooCommerce Extra Fees admin vs SleekView
Default Extra Fees admin
- Rule list is editor-first, with no audit table showing which rule fired on which order
-
Applied fees live in
wc_orders_metabut never surface in the WooCommerce Orders list - No per-rule revenue total without writing custom SQL or pivoting an export
- Disabling a rule requires opening the rule editor, even for a one-click toggle
- No filter combining gateway, country, and rule on the orders screen
SleekView
-
Fee-audit table joining
wc_orders_metatowc_orderswith rule name as a real column - Per-rule revenue totals via aggregate columns on the rule list
- Filter applied fees by gateway, country, status, and date range together
-
Inline-toggle rule
activefrom the rule list without opening the editor - Kanban view grouping orders by which fee rule fired
Features
What SleekView gives you for WooCommerce Extra Fees
Fee-audit table you can sort
Read applied fees from wc_orders_meta on HPOS or _fee_lines postmeta on legacy. Each row shows the order, the rule that triggered, gateway, and amount, so finance can reconcile per-rule revenue without writing SQL.
Compose precise rule filters
Combine rule name, gateway, country (from wc_order_addresses), and date range. Save the filter as a named view your team reuses every billing cycle, no rebuilding it monthly.
Inline-edit rule status
Toggle a rule on or off, change a flat-fee amount, or scope a country list inline in the rule list. Edits route through the plugin's rule API where exposed, with conflict detection on direct option writes.
Audience
Who uses SleekView for WooCommerce Extra Fees
Finance ops
Per-rule revenue totals via aggregate columns from wc_orders_meta. Reconcile the COD-surcharge bucket against gateway statements without exporting to a spreadsheet.
Customer support
When a customer disputes a fee, search by order id, see the rule name, fee amount, and gateway on one row. Refund logic through WooCommerce CRUD fires status hooks as expected.
Merchandising leads
Decide which fee rules to keep, raise, or kill based on per-rule order count and gateway mix. Kanban view groups orders by the rule that fired for quick visual triage.
The bigger picture
Why fee-rule audits need joined views
WooCommerce Extra Fees plugins solve a real merchandising problem: nudge customers toward cheaper gateways, recover express-shipping costs, charge for gift wrap, surcharge by country, or apply a small handling fee on cash on delivery. The plugins do that part well. What they consistently miss is the audit surface, which rules fired, how often, on which orders, generating how much revenue, and is the rule worth keeping.
The default admin treats each rule as a config row and each fee as an invisible line on an order. Finance teams end up exporting orders, joining to a spreadsheet of rule names, and pivoting by hand every month. SleekView reads wc_orders_meta directly, names the rule on each row, and aggregates per rule, so the audit becomes a saved view instead of a Friday-afternoon task.
Same database, same hooks, dramatically less spreadsheet plumbing for the team that has to defend the surcharges to the leadership team.
Questions
Common questions about SleekView for WooCommerce Extra Fees
SleekView is plugin-agnostic at the schema level. Whether the rule config lives in wp_options (Plugin Republic's Extra Fees, Conditional Fees for WooCommerce) or a custom table (some commercial variants), the applied fees consistently land in wc_orders_meta on HPOS or _fee_lines postmeta on legacy, so the audit view works the same.
Yes. Applied fees are read from wc_orders_meta when HPOS is enabled (default since WooCommerce 8.2) and from postmeta on legacy. Both paths join back to the order through the standard order id, so saved views don't need to be rewritten after the HPOS switch.
Yes. Add an aggregate column on the rule list that counts orders and sums fee amounts. SleekView runs this as a subquery against wc_orders_meta filtered by your selected date range, giving a per-rule revenue view that the default plugin admin does not provide.
Where the plugin exposes a rule API (Plugin Republic does, some smaller plugins do not), SleekView writes through it so any cache-invalidation and validation hooks fire. When no API exists it falls back to direct option writes with a last-write-wins warning, useful for emergency rule toggles.
Yes. Gateway lives on wc_orders.payment_method, country on wc_order_addresses.country. SleekView joins both into the same view so finance can see, for example, all COD-surcharge fees that fired on French orders in March in one table.
By default yes, with a status column so refunds are visible. Refunds are stored as child orders with shop_order_refund type on legacy and a parent-id link on HPOS, so SleekView optionally subtracts refunded fee amounts from the per-rule revenue aggregate.
If the rule disables itself when a specific coupon applies, the coupon code lives on the order's edd_order_adjustments-equivalent meta or on a WooCommerce-specific meta key. SleekView surfaces these as columns so the audit row tells the full story: rule, fee amount, plus the coupon that suppressed it on related orders.
The audit view queries wc_orders with a date-range filter on date_created_gmt (indexed), then joins wc_orders_meta on order_id (also indexed). Aggregate columns are opt-in per view since they are heavier. Keep them off triage views and on monthly-reconcile views for fast plans.
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 Pdf Invoices Packing Slips
- Woocommerce Payments Stripe
- Woocommerce Shipping Fedex
- Woocommerce Shipment Tracking Pro
- Yith Woocommerce Affiliates
- Woocommerce Name Your Deal
- Woocommerce Weight Based Shipping
- Woocommerce Aftership
- Etsy Shop Importer
- Woocommerce Stock Manager Pro
- Woocommerce Purchase Order Gateway
- Surecart Checkout
- Woocommerce Bulk Stock Management
- Woocommerce Xero
- Woocommerce Shipping Ups