Quote from Alex Dovlatov on February 9, 2026, 13:07

Hello Ihor

According to this ticket https://wordpress.org/support/topic/price-range-displays-incorrect-values-for-variable-products/ you already did that what could be advised, so share please in the private area of this ticket wp-admin + ftp access to this or stage (better stage site) to make code tests

Stage site can bre creates on test subdomain on the same hosting using https://wordpress.org/plugins/duplicator/, you can create site without images if its weight a lot

https://share.pluginus.net/image/i20230222134241.png
https://share.pluginus.net/image/i20230222134615.png

Quote from Ihor on February 9, 2026, 13:23

Wrote in private message

Quote from Alex Dovlatov on February 10, 2026, 17:58

Hello Ihor

Just looked your site - its alive one. Can you please create stage site to avoid site breaking. I am going to disable all plugins and change wp theme there, also do some experiments with data base, it can broke the site. If you have back up and give us green light we will do our experiments on the site you provided

Clone of the site can be created by duplicator plugin https://wordpress.org/plugins/duplicator/ - you can exclude images there to make it more light, we not need medias

So tell us please your decision

 

Quote from Ihor on February 11, 2026, 10:52

https://test.hydrohub.com.ua/ — a website for testing. The access credentials are the same.

Quote from Alex Dovlatov on February 11, 2026, 13:34

Hello Ihor

I've identified and resolved the issue. The problem was not with FOX's rounding logic (which is working correctly), but with incorrect variation prices stored in the database.

What I Did

1. ✅ Disabled all plugins except essential ones - issue persisted
2. ✅ Switched to default Storefront theme - issue persisted
3. ✅ Disabled all caching plugins - issue persisted
4. ✅ Checked the product data at: https://test.hydrohub.com.ua/wp-admin/post.php?post=44685&action=edit
5. ✅ Simply clicked the "Update" button on the product page

Result: Everything is now synchronized correctly:

• https://c2n.me/4nFJS9c.png
• https://c2n.me/4nFJSq4.png
• Live product: https://test.hydrohub.com.ua/katalog/mastyla/motorni-olyvy/motorna-olyva-protec-headway-ms-5w30/

Technical Explanation

With decimals set to 0 in FOX options, the rounding logic works correctly:

// WOOCS code - rounds to nearest integer when decimals=0
$prices_array['price'][$variation_id] = wc_format_decimal($price, $decimals);
$prices_array['regular_price'][$variation_id] = wc_format_decimal($regular_price, $decimals);
$prices_array['sale_price'][$variation_id] = wc_format_decimal($sale_price, $decimals);

Original prices (with decimals): 5 349.76 грн and 53 999.92 грн
Correctly rounded (decimals=0): 5 350 грн and 54 000 грн ✅

Root Cause - Database Desynchronization

The variation prices in the database were somehow corrupted or outdated. When you click "Update" on a product, WooCommerce recalculates and resaves all variation prices, which fixed the desynchronization.

Possible Causes

Most likely culprits:

1. WooCommerce Variation Swatches plugin - I noticed you have a swatches plugin installed. These plugins often hook into variation price saving and may have modified the values incorrectly during a previous save.
2. Bulk editing plugins - Any plugin that does bulk price updates could have saved incorrect variation data.
3. Import/migration - If you imported products or migrated data, the variation meta could have been corrupted during transfer.
4. Another currency/pricing plugin conflict - If you had another pricing plugin active before FOX, it may have left incorrect data in variation meta.

Recommended Testing Steps

To prevent this in the future, when you install/uninstall plugins that might affect prices:

1. Before making changes: Note down some test product variation prices
2. Deactivate the suspected plugin
3. Click "Update" button on affected products (this forces WooCommerce to recalculate variation prices)
4. Check if variation prices are correct

Important: Just deactivating plugins is not enough - you must click "Update" on the products to trigger WooCommerce to resave the variation data with correct values.

---

I'll add some possible causes:
Most likely one of the following:

When bulk importing/exporting products via CSV, variation prices weren't recalculated.
Some bulk editor plugin saved prices with decimals=2, but then the FOX settings were changed to decimals=0.
An older version of WooCommerce Swatches or another variation plugin didn't save price metadata correctly.
Migration from another server with different currency/decimal settings.