SleekView Charts for Advanced Dynamic Pricing for WooCommerce
Advanced Dynamic Pricing writes applied rules and discount totals to _adp_applied_rules and _adp_total_discount on every order, plus rule definitions to the adp_rules table. SleekView Charts reads them and renders rule hits, savings, and top rules as real chart cards.
♾️ Lifetime License available
Pricing-rule usage as a real chart dashboard
Advanced Dynamic Pricing for WooCommerce stores each rule definition in the adp_rules custom table with priority, conditions, and discount type. On every order, the plugin writes _adp_applied_rules (the rule IDs that fired) and _adp_total_discount (the absolute amount saved) to order meta. Rule details, including labels and discount type, also land in _adp_order_data for full reconstruction at refund time.
The plugin is precise about capturing this, but the admin only shows rule definitions and a single per-order view. There is no built-in dashboard for rule hits over time, top rules by revenue impact, or cumulative discount given. SleekView Charts reads adp_rules, _adp_applied_rules, and _adp_total_discount from wc_orders_meta (HPOS) or postmeta (legacy) and pivots them into chart cards: top rules by hits, daily discount given, rule type mix, and total savings this month.
Each card is a saved query, not a snapshot. A merchandiser can pin the rule-hits Bar to the dashboard before a sale weekend, watch the Area chart climb during the campaign, and switch to the SleekView table view to see the exact orders behind any bar. Refund reconciliation reads from the same dataset, so the dashboard and the audit trail never disagree.
Workflow
From adp_rules to a pricing dashboard in four steps
Connect the ADP data source
Pivot rule IDs to rule names
Add chart cards
Save dashboards per campaign
Sample dashboard
Charts you can build from Advanced Dynamic Pricing data
Total discount given this month
Sum(_adp_total_discount)
Top pricing rules by hits
Count
group by _adp_applied_rules
Rule type mix
Count
group by rule_type
Daily discount given
Sum(_adp_total_discount)
group by date_created_gmt
Comparison
Default Advanced Dynamic Pricing admin vs SleekView Charts
Default ADP admin
- Rule definitions show, but rule hits over time are not aggregated anywhere
- Total discount given per day or per week requires custom SQL or CSV exports
- Top rules by revenue impact are invisible without an external report
- Rule-type mix (percentage vs fixed vs BOGO) is not surfaced as a chart
- No frontend embed for merchandisers without WordPress admin access
SleekView Charts
-
Top-rules bar joining
_adp_applied_rulesback toadp_rulesfor readable labels -
Daily discount-given area chart from
_adp_total_discountsums -
Rule-type donut from the discount-type column on
adp_rules - Total savings KPI scoped to the current campaign window
- Same dataset feeds the SleekView audit table for refund reconciliation
Features
What SleekView Charts gives you for Advanced Dynamic Pricing for WooCommerce
Rule hits as a real chart
Horizontal Bar resolving _adp_applied_rules to rule names from adp_rules. Merchandisers see exactly which rules carry the sale and which are dead weight.
Daily savings as a live trend
Gradient Area card summing _adp_total_discount per day so a sale window shows its actual lift in real time, not a week after the campaign ends.
Rule-type mix as a donut
Donut split across percentage, fixed, BOGO, and tiered rule types from adp_rules. Flags catalogues that lean too heavily on a single discount mechanic.
Audience
Who builds Advanced Dynamic Pricing dashboards with SleekView
Merchandisers
Watch top-rules and daily-discount cards during a sale weekend. Promotions that overshoot or under-perform are visible inside an hour instead of after the post-mortem.
Finance and owners
Track total discount given KPI against revenue to keep margin on target. Refund-aware filters exclude cancelled orders automatically.
Pricing analysts
Use rule-type mix and top-rules bars to retire dead rules and consolidate the catalogue. Drill-through to the SleekView table view shows the exact orders behind any bar.
The bigger picture
Why dynamic pricing needs a real chart layer
Advanced Dynamic Pricing for WooCommerce captures rule hits and discount totals on every order in clean, queryable meta keys. The plugin is precise about it. What the admin does not provide is a chart layer to read that data back as aggregates.
Without a dashboard, the only way to know which rules carry a sale, how much discount the store gave on a Saturday, or whether the catalogue leans too heavily on flat discounts is a CSV export and a spreadsheet, repeated every week. SleekView Charts removes that loop. Top-rules bar, daily-discount 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 rather than gut.
Charts and tables share one query layer, so refund reconciliation reads the same numbers as the dashboard.
Questions
Common questions about SleekView Charts for Advanced Dynamic Pricing for WooCommerce
Yes. SleekView Charts reads adp_rules and the _adp_applied_rules and _adp_total_discount 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. Rule definitions in adp_rules are unaffected by HPOS, so the chart layer is identical in both modes.
 Yes. SleekView joins _adp_applied_rules back to adp_rules on rule_id and resolves the name automatically, so bar charts show readable labels (Free Shipping over $100, Buy 2 Get 1, etc.) instead of numeric IDs.
 Yes. Every chart card respects a global date filter on the view. Save one layout per campaign and switch with a click. Side-by-side compare cards can include the previous-period column.
 Yes. The default order-status filter excludes refunded and cancelled rows so the discount KPI matches what finance expects. Filters are exposed per card if you want to include cancelled for analysis.
 Yes. The discount-type column on adp_rules distinguishes percentage, fixed, BOGO, and tiered. The rule-type donut splits them automatically, and any other card can filter 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 WordPress admin.
 No. SleekView Charts only reads from the ADP and WooCommerce tables on dashboard load. Pricing rules continue to fire at 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 Eu Vat Number
- Woocommerce Subscriptions
- Wpc Frequently Bought Together
- Wc Vendors
- Payu Money Woocommerce
- Authorize Net
- Paystack Woocommerce
- Woocommerce Product Vendors Pro
- Yith Woocommerce Pdf Invoice
- Woocommerce Pdf Invoices Packing Slips
- Funnelkit Stripe Gateway
- Woocommerce Blocks
- Metorik Helper
- Woo Paytm Payment Gateway
- Woocommerce Amazon Pay
- Paid Memberships Pro Discount Codes
- Subscriptio
- Magic Members
- Wp Private Content Plus
- Ultimatemember Bbpress
- Woocommerce Paid Courses
- Restrict User Access
- Paid Memberships Pro Elementor
- Memberium Infusionsoft
- Wp Affiliate Manager
- Paid Memberships Pro
- User Meta Pro
- Easy Affiliate
- Ultimatemember Real Time Notifications
- Cimy User Extra Fields