SleekView for WooCommerce Multi-Currency Switcher: per-currency orders as tables
Read rate config from wp_options (e.g. wc_aelia_currency_switcher or woocommerce_multi_currency) and per-order currency from wc_orders.currency. Audit each currency bucket without per-order click-through.
♾️ Lifetime License available
Audit each currency bucket as a saved view
Multi-currency switchers like Aelia Currency Switcher and the various "WC Multi-Currency" plugins let shoppers switch the entire store into their preferred currency, with prices, taxes, gateways, and shipping all reconfigured. The plugins do that well. What they consistently lack is an operational view of the resulting data: how many orders settled in each currency, what the effective rate was, which gateways are favoured per currency, and whether the per-product overrides (a flat EUR price instead of a converted price) are actually being used.
SleekView reads rate config and per-currency settings from wp_options (Aelia uses wc_aelia_currency_switcher, WC Multi-Currency uses woocommerce_multi_currency_* keys) and joins per-order currency from wc_orders.currency. Per-product price overrides live in postmeta with currency-suffixed keys (e.g. _regular_price_USD, _regular_price_EUR); SleekView lists these as joined columns on the products view, so you can audit which products have manual overrides versus auto-conversion.
Inline edits to a per-product currency price route through WooCommerce CRUD so plugin hooks fire and price caches clear. Inline edits to the global rate cache update the plugin option with conflict detection. Both are far faster than the click-through-each-product or open-settings-each-time defaults.
Workflow
How SleekView reads Multi-Currency Switcher data
Pick the source
wp_options, per-currency orders from wc_orders, or per-product price overrides from postmeta with currency-suffixed keys.
Compose columns
wc_orders.currency, gateway, country, and the captured rate, or product slug plus each currency-suffixed price key for the override audit.
Save and scope per role
Edit inline or bulk-update
Sample columns
Per-currency orders view
wc_orders.currency, the captured rate from wc_orders_meta, and customer country from wc_order_addresses.
wp_options (rates) + wp_wc_orders.currency + wp_postmeta (per-product currency prices)
| Order | Currency | Total | Country | Gateway | Date |
|---|---|---|---|---|---|
| #8814 | EUR | €184.00 | DE | Stripe | Apr 24 |
| #8813 | USD | $220.00 | US | PayPal | Apr 24 |
| #8812 | GBP | £95.00 | GB | Stripe | Apr 23 |
| #8811 | EUR | €48.00 | FR | Stripe | Refunded Apr 23 |
Comparison
Default Multi-Currency Switcher admin vs SleekView
Default Switcher admin
- Per-currency revenue requires exporting orders and pivoting by currency in a spreadsheet
-
Per-product price overrides (
_regular_price_USD,_regular_price_EUR) only show on the individual product edit screen - Rate cache state isn't visible as a sortable list, so stale rates go unnoticed
- Country-vs-currency filtering doesn't exist in the default Orders screen
- Bulk-updating EUR product prices requires opening each product
SleekView
-
Per-currency revenue and order-count views, grouped by
wc_orders.currency -
Per-product override audit across all currency-suffixed
postmetakeys -
Filter orders by country (
wc_order_addresses.country) and currency together - Inline-edit per-product currency prices through WooCommerce CRUD
-
Sort the rate cache by
last_updatedto find stale rates
Features
What SleekView gives you for WooCommerce Multi-Currency Switcher
Per-currency orders view
Group orders by wc_orders.currency and aggregate count, total, and average rate. Finance sees EUR, USD, GBP buckets side by side without exporting to a CSV.
Per-product override audit
List all currency-suffixed price keys (_regular_price_USD, _sale_price_EUR) as columns on the products view. See at a glance which products run manual overrides versus auto-conversion.
Bulk-edit currency prices inline
Update a EUR price across a product list inline, write goes through WooCommerce CRUD so price caches clear and plugin hooks fire. Far faster than opening each product individually.
Audience
Who uses SleekView for Multi-Currency Switcher
Finance ops
Per-currency revenue with the rate at checkout time, filtered by date and country. Reconcile each currency bucket against the bank deposit without manual pivots.
International merchants
Spot which countries actually convert to which currencies. Sort the rate cache by last_updated to find stale rates after an API outage.
Merchandisers
Audit manual price overrides per currency. Bulk-edit EUR product prices inline when an upstream supplier changes its EUR list price.
The bigger picture
Why multi-currency stores need per-currency views
A WooCommerce store selling across the EU, the UK, and the US is effectively running three stores in one schema. The switcher plugin handles the customer-facing translation between currencies, but the operational view stays single-currency by default: one Orders screen, one rate-settings tab, per-product edits per product. Finance teams that reconcile in three currencies end up exporting orders and pivoting by hand.
Merchandisers that override list prices per currency click through products one at a time. Support handling refunds for foreign-currency customers opens each order to find the captured rate. SleekView reshapes the same database into the views these teams actually want: a per-currency orders table, a per-product overrides audit, a rate-cache list sortable by last update.
Same WooCommerce CRUD, same hooks, dramatically less context-switching across three operational realities.
Questions
Common questions about SleekView for WooCommerce Multi-Currency Switcher
Yes. Aelia stores config under wc_aelia_currency_switcher in wp_options, per-order currency on wc_orders.currency (HPOS) or _order_currency (legacy), and per-product overrides as currency-suffixed postmeta keys. SleekView reads all of these directly.
Yes. WC Multi-Currency stores rates under woocommerce_multi_currency_* option keys; WPML's WooCommerce Multilingual stores per-currency price ratios in its own meta keys. SleekView surfaces both as the column set differs slightly per plugin, configured per view.
Yes. Per-order currency lives on wc_orders.currency when HPOS is on and on postmeta._order_currency on legacy. Saved views keep working across the HPOS migration without column-set rewrites.
Yes. SleekView lists per-product price-override keys (_regular_price_USD, _sale_price_EUR, etc.) as inline-editable columns. Bulk operations iterate through WooCommerce CRUD so price caches clear and plugin hooks fire on each row.
Yes. wc_order_tax_lookup stores tax in the order's currency. SleekView joins it to the per-currency view so finance can see how much EUR VAT, US sales tax, or UK VAT was collected separately, useful at quarter-end.
Refund logic stays inside WooCommerce CRUD: refunds preserve the order's display currency and write a refund child order on legacy or a parent-linked refund on HPOS. SleekView surfaces the refund amount in display currency on the per-currency view so the refund-adjusted revenue figure stays honest.
Yes. Show the currency-suffixed price columns on the products view and filter by NULL on a specific column. The result is the list of products that fall back to auto-conversion for that currency, useful when an upstream supplier changes a EUR list price and you want to set explicit overrides.
Each per-currency column adds one postmeta lookup per product row, which gets heavier with many currencies and many products. Keep overrides views scoped to a category filter, or paginate aggressively. Per-currency order views are cheap because wc_orders.currency is indexed.
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
- Berocket Product Filter
- Woocommerce Gift Ultimate
- Woocommerce Razorpay Pro
- Woocommerce Pdf Invoice Pro
- Woocommerce Cybersource
- Woocommerce Variation Stock
- Woocommerce Quaderno
- Currency Switcher
- Woocommerce B2b Suite
- Woocommerce Purolator
- Woocommerce Authorize Net Cim
- Woocommerce Realex
- Woocommerce Extra Product Options
- Edd Active Campaign
- Woocommerce Dynamic Pricing
- Memberium Active Campaign
- Ultimatemember Paid Content
- Paid Member Subscriptions
- Members Only
- Subscriber Only
- Memberpress Developer
- Memberpress Corporate
- Register Plus Redux
- Cimy User Extra Fields
- Wp Community
- Restrict User Access Pro
- Wishlist Member
- Magic Members Pro
- Wishlist Member X
- Profile Builder