✨ 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 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

SleekView table view for WooCommerce Currency Per Product

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

1

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.
2

Compose columns

Add the assigned currency (_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.
3

Save and scope per role

Merchandisers see the full override audit, finance sees revenue-relevant currencies, support sees a leaner row with one or two currencies highlighted per region.
4

Edit inline or bulk-update

Inline-edit per-currency prices, bulk-flip the assigned currency across a category, or reset to auto-conversion by clearing the override meta. Writes go through WooCommerce CRUD.

Sample columns

Per-product currency override audit

Joins postmeta._product_currency and currency-suffixed price keys (_regular_price_USD, _regular_price_EUR) per product.
Source: 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 postmeta keys (_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 postmeta query

SleekView

  • Currency-suffixed postmeta keys 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.

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