Incorrect currency symbol in Subscription table causing Proration calculation errors
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hello,
I am using FOX – Currency Switcher Professional along with WooCommerce Subscriptions and I've encountered a critical issue regarding the subscription switch (upgrade) process.
The issue: In the"Subscriptions" admin table, the total amounts are displayed using the customer's paid currency value (e.g., 524 PLN which includes VAT), but the currency symbol is forced to the store's base currency (e.g., 524 €).
Impact on Proration: Because the symbol is EUR but the value is actually PLN, the WooCommerce Subscriptions proration engine calculates the difference incorrectly. It tries to subtract the PLN value (thinking it's EUR) from the new plan's EUR price. This results in completely broken"Due Today" amounts in the cart during a subscription switch.
Example:
Store Base: EUR
Customer Paid: 426 PLN + VAT = 524 PLN
Subscriptions Table displays: 524 € (Wrong symbol!)
New Plan: 1000 €
Calculation: System thinks the customer already paid 524 € instead of 100 €, so it charges the wrong difference.
It seems FOX is overriding the currency symbol in the admin table filters without converting the numeric value back to the base currency, which"pollutes" the metadata used by the Subscriptions proration engine.
Is there a snippet or a setting to ensure that the Subscriptions table and background proration logic always use the correct Base Currency values?
Environment:
- WordPress Version: 6.9.4
- WooCommerce Version: 10.6.1
- WooCommerce Subscriptions Version: 8.5.0
- FOX – Currency Switcher Version: 1.4.6
Thank you!
Hello
You can try adding this snippet to your functions.php as a first step:
add_filter( 'woocommerce_is_rest_api_request', function( $is_rest ) {
if ( is_admin() AND ! wp_doing_ajax() ) {
remove_all_filters( 'woocommerce_currency' );
}
return $is_rest;
} );However I want to be honest with you — this is an experimental fix and may not fully resolve the issue, as the conflict likely goes deeper into how FOX hooks into the subscription metadata at the time of order creation.
To properly investigate and fix this without risk to your live store, I would need you to create a staging site using Duplicator: https://wordpress.org/plugins/duplicator/
Once the staging site is ready, please share the following in the private data section of this ticket:
For the staging site: FTP credentials and WordPress admin access.
If your production site is still in development and not yet live, you can also share production credentials. If it is a live store with real customers, please share staging only — I do not want to risk breaking anything on a live environment.
https://share.pluginus.net/image/i20230222134241.png
https://share.pluginus.net/image/i20230222134615.png
Hello
I've looked into this issue and here are a couple of hooks:
add_filter( 'woocommerce_currency_symbol', function( $symbol, $currency ) {
if ( empty( $currency ) ) {
return $symbol;
}
global $WOOCS;
if ( ! isset( $WOOCS ) ) {
return $symbol;
}
$currencies = $WOOCS->get_currencies();
// If the requested currency differs from what FOX currently has set,
// return the correct symbol for the explicitly requested currency.
if ( $currency !== $WOOCS->current_currency && isset( $currencies[ $currency ]['symbol'] ) ) {
return $currencies[ $currency ]['symbol'];
}
return $symbol;
}, 10000, 2 ); // Priority 10000 > FOX's 9999 — runs after FOX and corrects it
/**
* Fix: Ensure the subscription's total paid for the current period
* is always returned in the store base currency for proration math.
* FOX may have set current_currency to something else during cart processing.
*/
add_filter( 'wcs_switch_total_paid_for_current_period', function( $total_paid, $subscription ) {
global $WOOCS;
if ( ! isset( $WOOCS ) || ! $WOOCS->is_multiple_allowed ) {
return $total_paid;
}
$order_currency = $subscription->get_currency(); // e.g. 'PLN'
$default_currency = $WOOCS->default_currency; // e.g. 'EUR'
if ( $order_currency === $default_currency ) {
return $total_paid;
}
$currencies = $WOOCS->get_currencies();
if ( ! isset( $currencies[ $order_currency ]['rate'] ) || $currencies[ $order_currency ]['rate'] == 0 ) {
return $total_paid;
}
// Convert from order currency (PLN) to base currency (EUR) for proration math
return $total_paid / $currencies[ $order_currency ]['rate'];
}, 10, 2 );
I placed them into file functions.php of the current wp theme and now its looks good:
Test it please
Wow, that was fast. Looks like working fine now :) Thank you!
Will a theme update wipe out that functions.php code? Should I migrate it to a child theme or Code Snippets to keep it safe?