SleekView for WooCommerce Currency Converter: rates & order currency as tables
Read exchange rates from wp_options (or a custom rate-cache table) and per-order currency from wc_orders.currency. Audit display-vs-base conversions across thousands of orders without opening each one.
♾️ Lifetime License available
See conversion data as one joined view
WooCommerce Currency Converter plugins (frontend widgets like Aelia's Currency Switcher, FOX Currency Switcher, or simpler display-only converters) let visitors browse the store in their local currency while orders still settle in the store's base currency. The default admin shows current rates in a settings screen and nothing else. The orders screen still displays totals in the base currency, so a UK merchant seeing a Stripe payout that doesn't reconcile against the order list has to open each EUR-customer order to find the conversion.
SleekView reads rate config from wp_options (a key like wc_currency_converter_rates, or Aelia's wc_aelia_currency_switcher) and joins per-order currency from wc_orders.currency on HPOS or the _order_currency postmeta on legacy. A conversion-audit view shows order id, display currency, base-currency total, converted total, and the rate used, all sortable and filterable.
Inline edits to the rate cache update the plugin's option with conflict detection, and a manual-rate override is a one-row edit. If your converter writes a conversion-log custom table (some commercial variants do), SleekView reads that directly. Otherwise it derives the effective rate from each order's totals.
Workflow
How SleekView reads Currency Converter data
Pick the source
wp_options (or a plugin custom table) for the rate-management view, or wc_orders joined to its meta for the per-order conversion audit.
Compose columns
wc_orders.currency, display total, base total, captured rate, gateway, and country. The rate column comes from wc_orders_meta using the key your converter writes.
Save and scope per role
Edit inline and reconcile
Sample columns
Conversion audit view
wc_orders.currency) and total with the rate snapshot stored in wc_orders_meta at checkout time.
wp_options (rate cache) + wp_wc_orders.currency + wp_wc_orders_meta
| Order | Display currency | Display total | Base total | Rate | Date |
|---|---|---|---|---|---|
| #5012 | EUR | €184.00 | £158.24 | 0.86 | Apr 24 |
| #5011 | USD | $220.00 | £174.90 | 0.795 | Apr 24 |
| #5010 | EUR | €95.00 | £81.70 | 0.86 | Apr 23 |
| #5009 | GBP | £48.00 | £48.00 | 1.00 | Apr 23 |
Comparison
Default Currency Converter admin vs SleekView
Default Currency Converter admin
- Rate settings screen, with no per-order audit showing the rate applied at checkout
-
wc_orders.currencyisn't surfaced as a column or filter on the Orders screen - Display-vs-base totals require opening each order to compare
- Manual-rate overrides happen one rate at a time, with no list view to inline-edit them
- Refund logic for foreign-currency orders is invisible until you open the order
SleekView
-
Conversion-audit view joining
wc_orders.currency, total, and the captured rate fromwc_orders_meta - Filter orders by display currency, gateway, country, and date together
- Inline-edit rate overrides directly from the rate list
- Per-currency revenue aggregates (order count, sum, average) for finance
-
Detect stale rates by sorting the rate list by
last_updatedtimestamp
Features
What SleekView gives you for WooCommerce Currency Converter
Conversion-audit table
Read wc_orders.currency alongside the rate snapshot captured in wc_orders_meta at checkout. Each row shows display total, base total, and effective rate, so finance can reconcile foreign-currency orders against the bank deposit.
Filter by currency and date
Combine wc_orders.currency, gateway, country, and date range. Save a view per currency so finance reconciles EUR, USD, and GBP buckets separately without rebuilding filters.
Inline-edit rate overrides
Update a manual exchange rate from the rate list, with conflict detection on the rate cache. Writes go through the plugin's settings API where exposed, clearing the conversion cache as the plugin would on a normal save.
Audience
Who uses SleekView for WooCommerce Currency Converter
Finance ops
Per-currency revenue with the rate at checkout time, filtered by date and gateway. Reconcile the EUR Stripe deposit against EUR display totals without exporting orders.
International merchants
Sort the rate list by last_updated to find stale rates, sort currencies by order count to decide which to keep, all from a single sortable view.
Customer support
Customer queries why their EUR refund came back as a slightly different amount. Pull the order row with the captured rate, explain the FX swing, refund inline through WooCommerce CRUD.
The bigger picture
Why currency conversions need a real audit view
Selling internationally means living with FX risk. A EUR customer paying a UK store sees a EUR price at checkout, but the Stripe deposit lands in GBP at a slightly different rate. Across a few thousand orders the gap matters, both for finance reconciliation and for the merchandiser deciding whether to keep a manual margin on top of the live rate.
The default WooCommerce admin treats currency as an attribute on the order detail screen, not as a first-class filter or column. Per-currency revenue lives in wc_orders but never surfaces in the Orders list, the rate captured at checkout is stored in wc_orders_meta but invisible without opening each order. SleekView turns the conversion data into a saved view: per-currency order count, display-vs-base totals, captured rate, refund-adjusted figure, all sortable and filterable.
Same database, same hooks, dramatically less spreadsheet work for the finance lead reconciling each foreign deposit.
Questions
Common questions about SleekView for WooCommerce Currency Converter
Any plugin that stores per-order currency on wc_orders.currency (HPOS) or _order_currency postmeta (legacy) and the effective rate as order meta at checkout. That includes Aelia Currency Switcher, FOX Currency Switcher, WooCommerce Multi-Currency Switcher, and most smaller display converters.
Yes. Per-order currency lives on wc_orders.currency when HPOS is on and on postmeta._order_currency on legacy. The join key is the same so saved views keep working across an HPOS migration with no rewrite.
Yes. Add aggregate columns to a per-currency view: order count, sum of total in display currency, sum in base currency, average rate. SleekView groups by wc_orders.currency and runs the sum as a subquery filtered by your date range.
Most currency-switcher plugins snapshot the effective rate to wc_orders_meta at checkout under a key like _order_exchange_rate or _aelia_cs_exchange_rate. SleekView surfaces that key as a real column. If your plugin does not snapshot the rate, SleekView derives it from display total over base total.
Yes for manual-override rates. Live exchange-rate feeds are pulled from the plugin's API endpoint on a schedule, so SleekView shows the cache state but does not write to the upstream feed. Manual overrides update the rate option through the plugin's settings API where exposed.
Refunds preserve the order's display currency in WooCommerce, so the refund row shows the same EUR or USD as the parent order. SleekView surfaces refund amount in both display and base currency, useful when the FX rate at refund time differs from checkout time and customers query the difference.
Yes. The rate cache typically stores a last_updated timestamp per currency. SleekView surfaces this on the rate list so you can sort to find rates older than a configurable threshold, useful when an API outage left the cache stale for a few hours.
WooCommerce calculates tax in the base currency unless the plugin reconfigures the tax engine. SleekView shows both the display-currency tax (from the order line) and the base-currency tax (from wc_order_tax_lookup) so finance can audit whether the conversion path inflated the tax position by a noticeable amount.
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
- Wpc Buy Now Button
- Woocommerce Sendcloud
- Woocommerce Shipping Australia Post
- Aliexpress Dropshipping Woo
- Woocommerce Shipping Usps
- Woocommerce Shipping Royal Mail
- Woocommerce Payments Stripe
- Sliced Invoices
- Woocommerce Measurement Price
- Woocommerce Product Question
- Square For Woocommerce
- Woocommerce Product Recommendations
- Woocommerce Sage Accounting
- Woocommerce Cashfree
- Woocommerce Weight Based Shipping
- Buddypress Media
- Wishlist Member Stripe
- Restrict User Access Pro
- Memberpress Corporate
- Woocommerce Paid Courses
- Profilepress
- User Role Membership
- Memberpress Corporate Pro
- Wp Members
- Paid Membership Pro Pro
- Ultimatemember Bbpress
- Memberpress Buddypress
- Ultimatemember Social
- Joinup Membership
- Memberpress Coupons