✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView Charts dashboard for Advanced Dynamic Pricing for WooCommerce

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

1

Connect the ADP data source

Add the adp_rules table and wc_orders_meta as SleekView data sources. The agent UI maps _adp_applied_rules, _adp_total_discount, and rule definitions automatically across HPOS and legacy stores.
2

Pivot rule IDs to rule names

The adp_rules table holds rule labels and discount types. SleekView resolves rule IDs from _adp_applied_rules to readable names at query time, so charts show rule labels, not numeric IDs.
3

Add chart cards

Pick rule hits (Bar), daily discount given (Area), rule-type mix (Pie), and total savings this period (Number). Aggregations run against indexed columns on the order tables.
4

Save dashboards per campaign

Save a separate chart layout per campaign or sale window, scope per role, and embed any view on a frontend page for stakeholders who should not need WordPress admin access.

Sample dashboard

Charts you can build from Advanced Dynamic Pricing data

Four cards that turn adp_rules and _adp order meta into a pricing-rule performance dashboard inside WordPress.
Number · Default

Total discount given this month

Single KPI summing _adp_total_discount across orders in the current month, with the previous month underneath for context. Refunded and cancelled orders excluded by status filter.
Sum(_adp_total_discount)
Bar · Horizontal

Top pricing rules by hits

Horizontal bar of the most-fired rules, joining _adp_applied_rules to adp_rules on rule_id so labels show the human-readable rule name. Identifies the rules that actually move volume.
Count group by _adp_applied_rules
Pie · Donut

Rule type mix

Donut across percentage, fixed, BOGO, and tiered rule types from the type column on adp_rules. Useful for spotting whether the catalogue leans too heavily on flat discounts.
Count group by rule_type
Area · Gradient

Daily discount given

Gradient area chart of total discount per day from _adp_total_discount summed across orders. Shows the impact of a sale window in real time and surfaces unintended discount stacking immediately.
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_rules back to adp_rules for readable labels
  • Daily discount-given area chart from _adp_total_discount sums
  • 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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