[Resolved] Min and max price on variable products not copied to secondary Languages.

Hello,

Thank you for providing access to the environment. I tried creating a backup, but it’s over 30GB, which makes creating and restoring it very difficult. Let’s try to solve the issue using the sandbox you prepared.

I noticed that in the test environment you managed to update WooCommerce to nearly the latest version. Observing the problem for this product and its translation:

- hidden link
- hidden link

It currently seems that the only visible issue is that for the translated product, WooCommerce converted the MIN/MAX price by adding its own VAT calculation, while in the original language the MIN/MAX price was displayed without VAT - I'm attaching a screenshot.

Am I understanding the problem correctly?

Regards,
Pawel

Hello,
I understand that this issue is urgent and affects your business operations. I will focus on the handling of prices in the database. It’s possible that a plugin is creating an additional copy, which might be causing the problem. I will treat this as a priority and aim to provide at least a temporary workaround by tomorrow to prevent any blockers.

Best regards,
Pawel

Hello,

I’ve made extensive attempts to reproduce the scenario you described, both on a clean WooCommerce setup and on larger, test-ready environments, but without much success. It seems likely that multiple factors are contributing to this behavior.

I can see that your site is quite large, and I fully understand the need to resolve this issue. Unfortunately, I wasn’t able to generate a usable backup. It might be possible for you to prepare one using tools available on your infrastructure side - mainly the database would be sufficient. This would allow me to debug the full flow and identify a reliable solution.

At this point, the only thing I can suggest is to test the following:

* Run the command `wp cache flush` and check whether the issue stops occurring (variation prices should recalculate correctly)

If that helps, you could try the following workaround:

<?php

// /wp-content/mu-plugins/wpmlvip-348.php
add_action('woocommerce_after_product_object_save', function($product) {
	if ($product->is_type('variable')) {
		wc_delete_product_transients($product->get_id());
		WC_Product_Variable::sync($product->get_id());
	}
});

This is not an ideal solution, but it should help. If either of these approaches works, I will try to prepare a more optimized solution specifically tied to the import process. At the moment, I’m unable to fully validate it since I cannot reproduce the issue on my end.

Kind regards,
Pawel