SleekView for WooCommerce Currency Per Product: per-product currency overrides as tables
Read per-product currency from postmeta._product_currency and per-currency price overrides (_regular_price_USD, _regular_price_EUR) as joined columns. Audit and bulk-edit overrides without per-product click-through.
♾️ Lifetime License available
Audit per-product currency overrides at a glance
WooCommerce Currency Per Product plugins (WP Wham's plugin of the same name is the canonical example) let a store assign a different display currency or a manual price override to specific products. A B2B importer might list European-source products in EUR and US-source products in USD inside the same store, with a switcher converting at checkout. The data lives in postmeta with currency-suffixed keys: _product_currency for the assigned currency and _regular_price_USD, _regular_price_EUR, etc. for per-currency overrides.
The default admin shows these as a tab on each product edit screen. There is no list view that says "these 47 products run EUR overrides, these 12 changed prices last week, these 8 have no override and fall back to auto-conversion." SleekView reads the currency-suffixed postmeta keys as joined columns on the products view, so the override audit is one saved view away.
Inline edits route through WooCommerce CRUD so price caches clear, search indexes update, and plugin hooks fire. Bulk-flip 40 products from EUR override to USD override across a category in seconds, with the same side effects as 40 manual edits.
Workflow
How SleekView reads per-product currency data
Pick the source
wp_posts (post_type=product) for the override audit, or product_variation for variation-level pricing, joined to currency-suffixed postmeta keys.
Compose columns
_product_currency) plus each currency-suffixed price key. The column picker lists keys actually present in your installation, so you do not have to guess.
Save and scope per role
Edit inline or bulk-update
Sample columns
Per-product currency override audit
postmeta._product_currency and currency-suffixed price keys (_regular_price_USD, _regular_price_EUR) per product.
wp_posts (post_type=product) + wp_postmeta (currency-suffixed keys)
| Product | Assigned currency | EUR price | USD price | GBP price | Updated |
|---|---|---|---|---|---|
| Studio Lamp | EUR | €184.00 | $210.00 | £158.00 | Apr 24 |
| Drafting Table | USD | €240.00 | $280.00 | £210.00 | Apr 23 |
| Aluminium Tripod | EUR | €95.00 | auto | £82.00 | Apr 21 |
| Walnut Shelf | GBP | auto | auto | £320.00 | Apr 19 |
Comparison
Default Currency Per Product admin vs SleekView
Default per-product admin
- Per-product currency overrides live on each product's edit screen, with no list-level audit
-
Currency-suffixed
postmetakeys (_regular_price_USD) never surface as columns in the Products list - Bulk-updating EUR prices means opening each product
- No way to find products that fall back to auto-conversion versus those with manual overrides
-
Recently-updated overrides are invisible without a custom
postmetaquery
SleekView
-
Currency-suffixed
postmetakeys as inline-editable columns in the Products list - Filter products by assigned currency, category, and override presence
- Bulk-flip currency assignments and per-currency prices across a category
- Sort by last-updated to find recently-changed overrides
- Detect coverage gaps by filtering NULL on a specific currency column
Features
What SleekView gives you for WooCommerce Currency Per Product
Override audit columns
List every currency-suffixed price key (_regular_price_USD, _sale_price_EUR) plus the assigned currency (_product_currency) as columns on the products view. Audit coverage and pricing at a glance.
Inline-edit per-currency prices
Update EUR, USD, or GBP prices directly in the list. Writes go through WooCommerce CRUD so price caches clear, search indexes update, and plugin hooks fire as expected.
Find auto-conversion fallbacks
Filter products with NULL on a specific currency column to find products without a manual override. Useful when an upstream supplier changes EUR list pricing and you want to set explicit prices instead of relying on the live rate.
Audience
Who uses SleekView for Currency Per Product
Merchandisers
Audit per-currency coverage across categories. Bulk-update EUR prices inline when an upstream supplier's EUR list shifts, far faster than opening each product.
Finance ops
Reconcile per-currency revenue with the actual override prices. Combine with per-order currency from wc_orders.currency to verify customers were charged the intended override.
Customer support
Customer queries why a EUR price differs from a converted USD price. Pull the product row with both currencies on the same line, explain the override, and check the assigned currency.
The bigger picture
Why per-product currency overrides need a list view
Selling a product catalogue that mixes EUR-sourced and USD-sourced inventory inside one WooCommerce store creates a perfectly reasonable operational problem: which products run manual overrides, which fall back to auto-conversion, and where is the coverage incomplete. The data exists, the WordPress postmeta table happily stores currency-suffixed keys per product. What does not exist in the default admin is a list view that surfaces the overrides as columns.
Merchandisers click through products one at a time, finance reconciles per-currency revenue against guesses about override coverage, and bulk updates after a supplier price change become an evening-long task. SleekView turns the same postmeta keys into inline-editable columns, with category and currency filters that make the override coverage obvious at a glance. Same database, same WooCommerce CRUD, dramatically less click-through for the team running a multi-currency catalogue.
Questions
Common questions about SleekView for WooCommerce Currency Per Product
Any plugin that writes per-currency prices to postmeta with currency-suffixed keys. The canonical case is WP Wham's WooCommerce Currency Per Product, but Aelia Currency Switcher, WPML's WooCommerce Multilingual, and WC Multi-Currency all use similar patterns, so the same SleekView view configuration works across them.
Yes. The convention is established across the multi-currency plugin ecosystem: a product has a base price plus zero or more currency-specific overrides keyed by ISO code. SleekView's column picker scans your installation for keys actually present, so you only see currencies you actually run.
 Yes. Inline-edit a single price or select multiple rows for a bulk update. Each write goes through WooCommerce CRUD so price caches clear, search indexes update, and plugin-side hooks (e.g. for affiliate-feed regeneration) fire as expected on every product.
 
Yes. Filter by NULL on a specific currency column (e.g. _regular_price_USD is NULL). The result is the list of products that fall back to auto-conversion for that currency, useful when you want to set explicit prices to avoid live-rate noise.
Yes. Variation-level currency overrides live on variation posts (product_variation post type) with the same postmeta key pattern. SleekView can target either the parent product view or a variation-level view, depending on how granular your pricing model is.
Yes. WooCommerce caches product prices keyed off a transient version that bumps on any price-meta save. SleekView edits route through wc_delete_product_transients (called by core on price updates), so the storefront sees the new price on the next request without a manual cache clear.
Yes. Add a post_modified column to the products view (or a custom "last currency edit" timestamp if your plugin writes one). Sort descending and filter to the current week, useful for verifying that a planned bulk update actually applied to the expected set.
Per-currency columns each add a postmeta lookup per row, so wide views with many currencies get heavier. Scope the view with a category filter or pagination, or use a base columns view plus a click-through detail row for full currency coverage.
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 Paystack
- Printify Integration
- Woocommerce Tnt Shipping
- Atum Inventory Management
- Woocommerce Google Analytics Pro
- Woocommerce Pagseguro
- Woocommerce Eu Vat Number
- Woopayments
- Edd Aweber
- Woocommerce Additional Variation Images
- Woocommerce Instamojo
- Paypal Payments
- Shipment Tracking
- Woocommerce Clearpay Afterpay
- Edd Paypal Pro