[Escalated to WPML Developers team] Bundled products don't translate from EN to DE and NL.

Hi there. I'm back.

Can you also please share a Duplicator package or a full website backup that I can share with my colleagues?

I will be waiting for your response.

Hi there.

I think that my colleagues might also be interested in testing this on a local environment.

So, if you can share a full backup or if you can share access and give us approval to install the "Duplicator" plugin and create a full backup, both would be good options.

Please let me know what would work best for you.

Hello,

I have received the same response from you before in this thread: https://wpml.org/forums/topic/bundled-products-dont-translate-from-en-to-de-and-nl/#post-15560299

I responded to that message here: https://wpml.org/forums/topic/bundled-products-dont-translate-from-en-to-de-and-nl/#post-15561065

I am not sure if you saw my latest reply.

If you have seen it and if by your repeated response you mean that all you can do is share site access (without being able to share a backup or give an approval for creating a backup from our side), even though this may not be sufficient for our development team during the debugging process (and I am also uncertain about how IP-based access will function, as most IPs are dynamic and change frequently nowadays), we can definitely proceed in that manner if that's what you prefer.

Please inform me of your decision.

Thank you!

Hi there.

You can share it in the private fields I am enabling below.

Thank you for the confirmation.

My colleagues are already investigating on this.

I will get back to you when I have updates.

Hi there.

There have been all kind of tests done on this internal escalated ticket and constant progress but I waited until the team got to a conclusion.

We were able to see that the product is a composite product and not a bundled product.

It is a very complicated issue. The composite product contains bundled products and they don't have price data and we load the invalid composite template for the translated products.

Our team tried various things, including duplicating the product 1:1 from the original and disabling all WPML plugins, yet the error still persists.

In the end, I think that we located the issue in the product with ID 12661.

The original - ID 12660 is a bundled product with some items. However the translated ID 12661 does not have any items in the bundle. Hence it is deemed as not purchaseable, hence breaks the composite/bundled product logic.

Our team could also see that the issue with the product that is missing its bundled product is because it is using a custom table - wp_woocommerce_bundled_items

We fixed that by running:

INSERT INTO `wp_woocommerce_bundled_items` (`product_id`, `bundle_id`, `menu_order`) VALUES
(	140,	12661,	0),
(	142,	12661,	1),
(	9601,	12661,	2),
(	12024,	12661,	3),
(	10776,	12661,	4);

which basically added to the product ID 12661 the appropriate bundled product.

However, we were still getting:

This item cannot be purchased at the moment.<span class="invalid_product_note">Please make sure that you have assigned a price to this product. WooCommerce does not allow products with a blank price to be purchased. This note cannot be viewed by customers.</span><br />
<b>Warning</b>:  Undefined variable $is_block_editor_request in <b>C:\laragon\www\bund\wp-content\plugins\woocommerce-composite-products\templates\composited-product\invalid-product.php</b> on line <b>36</b><br />

And there is discrepancy in the product values - mainly in the keys _wc_sw_max_regular_price and _wc_sw_max_price which gets updated to 0 and blank instead of 1185 and this essential makes the product not purchaseable.

The price was set correctly once the product price (Regular price) was different from not set and 0 -> in /wp-admin/post.php?post=12660&action=edit&lang=en (attaching screenshot).

Another thing that we had to fix:

INSERT INTO `wp_woocommerce_bundled_items` ( `product_id`, `bundle_id`, `menu_order`) VALUES
(	238,	12451,	0),
(	10797,	12451,	1),
(	10741,	12451,	2),
(	10730,	12451,	3),
(	11989,	12451,	4),
(	9604,	12451,	5),
(	9610,	12451,	6);

Probably not the best workaround for this - because the wp_woocommerce_bundled_items_meta is missing, but still better than not having it.

Additional fixes in wp-content/plugins/woocommerce-product-bundles/assets/js/frontend/add-to-cart-bundle.js
Replace:

this.price_data.suffix_exists              = wc_bundle_params.price_display_suffix !== '';

with:

if (this.price_data) {
    this.price_data.suffix_exists = wc_bundle_params.price_display_suffix !== '';
} else {
    console.warn("price_data is undefined. Initializing default.");
    this.price_data = { suffix_exists: false }; // Provide some default initialization
}

It is very odd because the new bundled product does not behave in the same way.
We can summarize that perhaps the bundled products were not translated properly to start with.

Perhaps the best workaround and fix is to re-create the product.

Also, maybe the product can be fixed if you re-translate the products and then the bundles and then the composite product.

If there is still the notice about suffix existing, we recommend to use the last workaround from above.

I hope that you will find all this information helpful.

Also, sorry for the long message but I thought it would be insightful 🙂

Mihai