Home›Support›English Support›[Escalated to WPML Developers team] Multilingual & Multicurrency duplicates Bookings in WooCommerce Bookings
[Escalated to WPML Developers team] Multilingual & Multicurrency duplicates Bookings in WooCommerce Bookings
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.
Background of the issue:
Even though all related post types are set to "Not translatable", WPML M&M makes duplicates for WC Bookings.
We already followed "the solution" in https://wpml.org/forums/topic/multilingual-multicurrency-duplicates-orders-in-woocommerce-booking/ but it does not help. We did split and made separate products for each language.
Fortunately there's no duplicate for untranslated English product, but when we do the same with untranslated product in other language, WPML M&M does an empty "translation" which breaks Woocommerce stats and logic for further Calendar and Payment replications.
Thank you for contacting WPML support. While you are waiting for one of my colleagues to take this ticket and work on it, let me provide you with first debugging steps or if I can perhaps help with the issue quickly.
Hi Lucas, thanks. I've checked possible solutions in the support forum, including this one mentioned, but none of them seem related to the issue.
"What you are describing is the normal behavior we are having. As you show us, the order is 1, but we are duplicating the booings between languages in order to maintain the availability sync between languages."
This should not be a normal behavior, there should be another way to maintain availability.
Virtual bookable product may have translations in different languages, but WC Booking should not be duplicated, as it consequently makes duplicates in Google Calendar and dummy records in bookings' stats.
I'd like to provide admin access to the staging site I've made for this issue for the support person to check.
Please advise how can I safely provide access credentials.
Hello!
Please excuse us for the slow response times in our support during the weekends.
As for what you report in relation to Google Calendar synchronization, at present we have a registered bug for duplicated bookings and our developers are working on fixing the problem.
However, at this time, we don't have a patch for that issue.
About the issue with the duplicated booking stats, it would be nice if you can share more information with us and provide for example a screenshot of the issue.
Please do note to obfuscate any private information in that image.
Though WC Booking is set to Not Translatable, it is actually translated and duplicated in all languages. Resulting in broken dashboard numbers, double bookings in Google Calendar, double Zoom links. On the bookings.png image names are hidden and it's hard to understand, but all those bookings are RUS+ENG versions for no reason.
We also tried to split product translations and do completely separate language versions, one per language, without translations, but WC Bookings are still duplicated.
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
Hello,
I do have a few questions:
- Do you see any config issues at WooCommerce > WooCommerce Multilingual & Multi-Currency > Status? If so, please send us a screenshot from this screen.
- Does the issue disappear if you disable the plugin "WPML Synchronize Post Status"?
- Could it be that the issue only occurs once another plugin is enabled, like for example "WooCommerce Order Status Control"?
Further, would you be able to install the latest version of "WooCommerce Bookings" on a test site which I would like to provide, so that we can confirm if this is a general bug and take further steps?
Let me know if this would be possible and I will send a link to a test site with WPML and WooCommerce installed.
I want to make things clear. The issue you reported about duplicate entries in Google Calendar is known to us and escalated to our developers. As Goerge, my colleague, mentioned, we currently don't have a workaround for it. So, what we are trying to investigate now is the dummy records in bookings' stats.
We need to replicate this issue on a fresh WordPress installation. Then, I'll be able to escalate it to our compatibility team. For this, I created a test website with a clean WordPress install. You can access it through this link:
hidden link
With this link, you'll be directly logged in.
Could you please install the WooCommerce Bookings plugin and see if the issue is replicable on a clean WordPress installation?
I already configured WPML and WooCommerce on the test site. WPML is set to have Russian as the default language and English as the second language.
Please also ensure you install the latest version of the plugin.
Please let us know when everything is finished, and you can replicate the problem.
Important! Do not import your site to the test site. We must replicate the problem on a fresh, clean WordPress installation.
Do you see any config issues at WooCommerce > WooCommerce Multilingual & Multi-Currency > Status?
NO
- Does the issue disappear if you disable the plugin "WPML Synchronize Post Status"?
NO
- Could it be that the issue only occurs once another plugin is enabled, like for example "WooCommerce Order Status Control"?
NO, unrelated.
Further, would you be able to install the latest version of "WooCommerce Bookings" on a test site which I would like to provide, so that we can confirm if this is a general bug and take further steps?
Done. It's even worse here: made a single bookable consultation product, placed an order and somehow after the order was completed there are 4 (four) bookings!
Though, ideally, I would like to make wc_booking post type "Not translatable" and for one order I should have one booking in the system.
Please check backend and let me know what else I can do to help debug the issue.
Updste
This issue has been escalated to our developers. Our second-tier supporter suggests the following workaround. Please add the following code to the functions.php file of your theme.
add_filter( 'query', 'testfix' );
function testfix( $var ) {
if ( strpos( $var, "SELECT COUNT(DISTINCT wcbookings.ID) AS count" ) !== false ) {
$pattern = "/(FROM wp_posts AS wcbookings\s+INNER JOIN wp_wc_orders AS wcorder\s+ON wcbookings\.post_parent = wcorder\.id)/";
$replacement = "$1
INNER JOIN wp_icl_translations AS translations
ON wcbookings.ID = translations.element_id";
$var = preg_replace( $pattern, $replacement, $var );
$var .= " AND translations.source_language_code IS NULL";
}
return $var;
}
We'll keep you updated when we have news about this issue.
Hi, thanks. Looks good at your Sandbox site (added the code with Code Snippets).
But I wonder if would be possible to have single Booking while making wc_bookings post type as Not Translatable, as currently it is set to Translatable by default.
