SleekView Charts for WooCommerce Multi Currency: sales by currency in WP
WooCommerce stores the order currency on every wc_orders row, and Multi Currency adds the chosen-currency total and the FX rate at checkout to wc_orders_meta. SleekView Charts reads those columns and meta keys and builds a dashboard of revenue per currency, currency mix, FX rate history, and daily trends.
♾️ Lifetime License available
Read multi-currency sales as charts, not a currency filter
WooCommerce Multi Currency layers on top of the standard wc_orders table. Every order already has currency (EUR, USD, GBP, AUD, etc.) and total_amount in that currency. Multi Currency writes the FX rate used at checkout to _multi_currency_rate on wc_orders_meta, plus the base-currency equivalent to _multi_currency_base_total. The default WooCommerce admin shows currency as a filter, not as a chart.
SleekView Charts reads those columns and meta keys and turns them into chart cards. A Donut splits orders by currency so EUR, USD, GBP, and AUD shares show together. A Bar ranks revenue per currency using total_amount grouped by currency. A Number card sums the base-currency equivalent using _multi_currency_base_total so reporting reads in one number regardless of how customers paid. An Area chart plots daily base-currency revenue from date_paid_gmt.
This is a reading layer, not a replacement for the FX engine. Multi Currency still owns the currency switcher UI and the FX rate sync. SleekView Charts adds the dashboard the plugin does not lay out: currency mix against revenue per currency against base-equivalent total on one saved screen, scoped per role, embeddable so finance reads multi-currency totals without admin access.
Workflow
From currency meta to a multi-currency dashboard in four steps
Point SleekView at WooCommerce orders
Switch the view to Charts
Add currency chart cards
Save and scope the dashboard
Sample dashboard
Charts you can build from WooCommerce Multi Currency data
Base-currency revenue this month
Sum(_multi_currency_base_total)
Orders by currency
Count
group by currency
Revenue per currency
Sum(total_amount)
group by currency
Daily base-currency revenue
Sum(_multi_currency_base_total)
group by date_paid_gmt
Comparison
Default WC Multi Currency admin vs SleekView Charts
Default WC Multi Currency admin
- Currency is a filter on the orders list, not a chart of revenue per currency
- Base-currency total across all orders is never surfaced as a single KPI
- FX rate history meta sits on each order but is never plotted over time
- Currency mix as a donut requires exporting wc_orders and pivoting in Excel
- No saved per-role dashboard for finance that reads base-currency only
SleekView Charts
-
Chart cards built directly on
currencyand_multi_currency_base_totalwith no aggregation precompute - Mix Number, Pie, Bar, Line, and Area cards on a single multi-currency dashboard
- Read base-currency totals as one number, regardless of how customers paid
- Saved chart views scoped per role for finance, ops, and growth
- Embed a multi-currency dashboard on a frontend page for finance without WC admin
Features
What SleekView Charts gives you for WooCommerce Multi Currency
Real charts on currency data
Number, Pie, Bar, Line, Area, Radar, and Radial cards built from the standard currency column on wc_orders plus the FX-rate and base-total meta Multi Currency writes on every order.
Complements the FX engine
Multi Currency still owns the currency switcher UI and the FX rate sync from the upstream provider. SleekView Charts adds the dashboard that turns those rates and currency labels into a side-by-side view.
Base-currency reporting
Sum _multi_currency_base_total across all orders to get one consolidated total for finance, with the currency mix donut next to it for context on how that total was earned.
Audience
Who builds Multi Currency dashboards with SleekView
Finance teams
Track the base-currency KPI and the daily base-currency area chart so monthly revenue reads in one number, regardless of how many currencies the store accepts.
Growth and international teams
Watch the currency mix donut to see which markets are pulling weight and which need more localisation work in the next quarter.
Owners and managers
Use the revenue-per-currency bar to spot when a currency's revenue moves disproportionately because of FX shifts rather than real demand.
The bigger picture
One revenue number across currencies should not need a spreadsheet
WooCommerce stores the order currency on every wc_orders row already. Multi Currency layers FX rate and base-currency total on top via wc_orders_meta. The data needed to read sales across EUR, USD, GBP, AUD, and CAD as one consolidated total is right there, written on every order.
WooCommerce admin treats currency as a filter on the orders list, and the consolidated base-currency total lives nowhere in admin at all. Finance still exports the orders, pivots them in Excel, and rebuilds the same number every month. SleekView Charts reads currency, total_amount, and _multi_currency_base_total directly and turns them into chart cards on one saved dashboard.
Finance sees the base-currency KPI and the daily area chart in the store base currency. Growth teams see the currency mix donut and the per-currency revenue bar to track which markets pull weight. Multi Currency keeps owning the switcher and the FX rate sync; SleekView adds the in-WordPress reading layer that turns currency labels into a real dashboard.
Questions
Common questions about SleekView Charts for WooCommerce Multi Currency
No. Multi Currency still owns the currency switcher UI and the FX rate sync from the upstream provider. SleekView Charts is a reading layer on the currency column on wc_orders and the FX-rate meta the plugin writes to wc_orders_meta, so you can chart multi-currency revenue on one screen.
 Yes. SleekView reads wc_orders and wc_orders_meta directly when HPOS is enabled, including _multi_currency_rate and _multi_currency_base_total. Legacy stores fall back to shop_order postmeta with the same key names.
 Yes. _multi_currency_base_total on wc_orders_meta carries the base-currency equivalent of each order. A Number KPI summing that column gives one total for the month, regardless of how customers paid.
 Yes. currency on wc_orders is exposed as a chartable dimension. A Donut on that field shows the order-count share per ISO currency, and a Bar on Sum of total_amount grouped by currency shows revenue in each native value.
 Yes. _multi_currency_rate on wc_orders_meta carries the rate used at checkout. A Line chart of average rate per day grouped by currency, sourced from that meta key, shows how rates moved across the date range.
 Yes. If older orders predate Multi Currency, _multi_currency_base_total is missing on those rows. SleekView treats missing values as zero in the KPI and surfaces a count of affected orders so the team knows historical FX backfill is needed.
 No. Chart queries run on demand when a user loads the dashboard, hit indexed columns on wc_orders, and use the same MySQL connection as WordPress. Checkout, FX sync, and currency switching are untouched.
 Yes. Save the chart view, scope it to a finance role, or embed the dashboard on a frontend page gated by that role. Base-currency totals are readable without WordPress admin access.
 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
- Wt Woocommerce Customer History
- Square For Woocommerce
- Berocket Product Filter
- Woocommerce Min Max Quantities
- Funnelkit Cart
- Yith Woocommerce Bookings
- Woocommerce Zip Checkout
- Shipstation Woocommerce
- Woocommerce Eu Vat Number
- Aelia Eu Vat Assistant
- Paypal Payments
- Cartflows
- Woocommerce Multistep Checkout
- Yith Woocommerce Bulk Product Editing
- Woocommerce Show Single Variations