SleekView Charts for Discount Rules for WooCommerce
Discount Rules for WooCommerce stores each rule in the wdr_rules table and writes _wdr_discount_total and _advanced_woo_discount_save_amount to every order. SleekView Charts reads them and renders rule hits, savings, and top rules by revenue impact as live chart cards.
♾️ Lifetime License available
Bulk and tiered discount usage as a chart dashboard
Discount Rules for WooCommerce (Flycart) stores each rule in the wdr_rules custom table with conditions, filters, and discount mechanics. On every order it writes the applied savings to _wdr_discount_total and _advanced_woo_discount_save_amount, the matched rules to _wdr_applied_rules, and a structured snapshot to _advanced_woo_discount_data for audit and refund reconstruction.
The plugin captures this cleanly, but the admin shows rule definitions and a single per-order edit screen. There is no aggregate view of rule hits over time, total savings per period, or top rules by revenue impact. SleekView Charts pivots the meta into a dashboard of chart cards: total savings this month, top rules by hits, rule-type mix (percentage, fixed, BOGO, bulk), and daily discount given. Joins resolve rule IDs from _wdr_applied_rules back to wdr_rules.title so charts show readable labels.
Each card is a saved query against the live tables, not a screenshot. A merchandiser pins the rule-hits Bar before a Black Friday weekend, watches the Area chart climb in real time during the sale, and drills into the SleekView table view to see the exact orders behind any bar. Refund reconciliation reads the same dataset, so the dashboard and the audit trail never disagree.
Workflow
From wdr_rules to a discount dashboard in four steps
Connect the Flycart data source
Resolve rule IDs to labels
Add chart cards
Save dashboards per role
Sample dashboard
Charts you can build from Discount Rules data
Total savings this month
Sum(_wdr_discount_total)
Top discount rules by hits
Count
group by _wdr_applied_rules
Rule-type mix
Count
group by discount_type
Daily savings trend
Sum(_wdr_discount_total)
group by date_created_gmt
Comparison
Default Discount Rules admin vs SleekView Charts
Default Discount Rules admin
- Rule definitions show, but rule hits over time are not aggregated anywhere
- Total savings per period requires a CSV export and a spreadsheet
- Top rules by revenue impact are not surfaced in the admin
- Rule-type mix (percentage vs fixed vs BOGO) is invisible without custom SQL
- No frontend embed for merchandisers without WordPress admin access
SleekView Charts
-
Top-rules bar joining
_wdr_applied_rulestowdr_rules.titlefor readable labels -
Daily savings area chart from
_wdr_discount_totalsums -
Rule-type donut from the discount_type column on
wdr_rules - Total savings KPI scoped to the current period, refund-aware
- Same dataset feeds the SleekView audit table for refund reconciliation
Features
What SleekView Charts gives you for Discount Rules for WooCommerce
Rule performance as a real chart
Horizontal Bar resolving _wdr_applied_rules to titles from wdr_rules. Merchandisers see which rules actually carry the sale and which are catalogue clutter.
Daily savings as a live trend
Gradient Area card summing _wdr_discount_total per day so a sale window shows its lift in real time, not a week after the campaign closes.
Rule-type mix as a donut
Donut across percentage, fixed-cart, fixed-product, BOGO, and bulk rule types from wdr_rules.discount_type. Flags catalogues leaning too hard on a single discount mechanic.
Audience
Who builds Discount Rules dashboards with SleekView
Merchandisers
Watch top-rules and daily-savings during a sale weekend. Promotions that overshoot margin or under-perform on volume are visible inside an hour instead of after the post-mortem.
Finance teams
Track the total-savings KPI against revenue to keep margin on target. Refund-aware filters exclude cancelled orders automatically so the number matches expectations.
Pricing analysts
Use rule-type mix and top-rules bars to retire dead rules and consolidate the catalogue. Drill-through to the table view shows the exact orders behind any bar.
The bigger picture
Why bulk and tiered discounts need a chart layer
Discount Rules for WooCommerce captures rule hits and savings on every order in queryable meta keys. The plugin is reliable about it. What the admin does not provide is a chart layer to read that data back as aggregates.
Without a dashboard, knowing which rules carry a sale, how much discount the store gave on a given day, or whether the catalogue leans too heavily on flat discounts means a CSV export and a spreadsheet every week. SleekView Charts removes the loop. Top-rules bar, daily-savings Area chart, rule-type donut, and total-savings KPI sit on one saved dashboard ready before the next campaign.
Merchandisers see promotions land in real time. Finance keeps an eye on margin without spreadsheets. Pricing analysts retire dead rules with evidence.
Charts and tables share one query layer, so refund reconciliation reads the same numbers as the live dashboard.
Questions
Common questions about SleekView Charts for Discount Rules for WooCommerce
Yes. SleekView Charts reads wdr_rules and the _wdr_discount_total, _wdr_applied_rules, and _advanced_woo_discount_save_amount order meta. Without the plugin those keys do not exist, so the dashboard would have nothing to aggregate.
Yes. SleekView Charts reads from wc_orders_meta when HPOS is enabled and from postmeta on legacy stores. wdr_rules is a custom table and is unaffected by HPOS, so the chart layer is identical in both modes.
Yes. SleekView joins _wdr_applied_rules back to wdr_rules on rule_id and resolves the title automatically. Bar charts show labels like Bulk 10% off or BOGO Outerwear instead of numeric IDs.
Yes. Every card respects a global date filter on the view. Save one layout per campaign and switch with a click. Compare-card overlays add the previous-period column when you want context.
Yes. The default order-status filter excludes refunded and cancelled rows so the savings KPI matches finance reports. Per-card overrides allow including cancelled rows for analysis when needed.
Yes. The discount_type column on wdr_rules distinguishes percentage, fixed-cart, fixed-product, BOGO, and bulk. The rule-type donut splits them automatically, and any other card filters to a single type.
Yes. Any saved chart view embeds on a frontend page with role-based access, so merchandisers and finance read the dashboard without needing WordPress admin.
No. SleekView Charts only reads from the Flycart and WooCommerce tables on dashboard load. Discount rules continue to fire at cart and checkout exactly as before, untouched by the chart layer.
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 Multistore
- Yith Woocommerce Product Add Ons
- Woocommerce Mix And Match Products
- Instamojo
- Yith Woocommerce Wishlist
- Woocommerce Sequential Order Numbers Pro
- Product Csv Import Export
- Cartflows
- Aelia Eu Vat Assistant
- Winwar Aelia Currency Switcher
- Givewp
- Mollie Payments
- Woocommerce Tax Toggle
- Woocommerce Product Recommendations
- Woocommerce Extra Checkout Fields For Brazil