[Resolved] woocommerce multilingual and multi currency not showing all products in my categ

Hi Vic,

Thanks for your update. I would need to look closely at your site, so I would need to request temporary access (WP-Admin and FTP)
– preferably to a test site where the problem has been replicated if possible –
in order to be of better help and check if some configurations might need to be changed.

Your next answer will be private, which means only you and I can access it.

❌ Please backup your database and website ❌

✙ I would need your permission to de-activate and re-activate the Plugins and the Theme and change configurations on the site. This is also a reason the backup is critical.

✙ I also need your permission to take a local copy of your site to debug the issue without affecting your live site.

Best regards,
Osama

Hi,

Thanks for your patience. Our 2nd tier support team has found a workaround for the issue. Please check the following steps:

1- Edit wp-content\plugins\woocommerce-multilingual\inc\template-classes\class-wcml-products-ui.php
2- Go to line 454
3- Replace

if ( $category ) {
	$sql          .= ' AND tx.term_taxonomy_id = %d ';
	$prepare_arg[] = $category;
}

With

if ( $category ) {
	if (empty($slang)) {
		$cat_translations = apply_filters( 'wpml_get_element_translations', [], apply_filters( 'wpml_element_trid', false, $category, 'tax_product_cat'), 'tax_product_cat');
		$cat_ids = wpml_prepare_in(array_column($cat_translations, 'element_id'), '%s');
		$sql          .= ' AND tx.term_taxonomy_id IN (' . $cat_ids . ') ';
	} else {
		$sql          .= ' AND tx.term_taxonomy_id = %d ';
		$prepare_arg[] = $category;
	}
}

I've applied the above steps on the staging site. Please check it and let me know if it works correctly. (hidden link)

Best regards,
Osama

Hi Vic,

It's great to hear that the issue is fixed. I'm not sure if this fix will be added to the next release, but our Dev team is aware of the issue, and they will fix it in a future release.

Best regards,