Thank you for contacting WPML support. I’d be happy to assist you with this issue.
Access to the environment where the issue occurs would be very helpful in investigating the reported problem.
Would it be possible to provide us with access to an environment where the issue can be reproduced (preferably a non-production environment with the smallest possible amount of data)? This would allow us to create a copy where we can replicate the issue and look for a solution.
It would also be very helpful to know when the problem first appeared. I can see that your plugins have been updated:
- Did the issue occur before, and the update was an attempt to fix it?
- Or did the problem appear after the update?
I look forward to your reply. Thank you and best regards.
Thank you for your quick and detailed response, as well as for providing access. I have installed the Duplicator plugin to create a backup so that we can properly diagnose the source of the issue.
The backup process is taking unusually long. Normally, it takes about 5 minutes, but in this case it may take significantly longer due to the size of the environment. As soon as the backup is completed, it will be forwarded to our technical team for further investigation - I will keep you updated on the progress.
Additionally, I noticed that multiple copies of this support thread have been created. To keep everything organized, I will redirect the remaining ones to this thread so that all information is available in one place and easy to track.
has the backup process been done please?
Sorry that i created multiple copies of the support thread as im was looking for a livechat support hope to have the issue fixed fast.
You can check the backup progress by logging into the admin panel and navigating to:
- Duplicator / Backups
- the progress is displayed there (for example: "Building Backup 60.0%")
At the moment the status shows "Building Backup 60.0%". Even for larger websites, the process usually takes around 15 minutes. In this case, the server might be under heavier load, which could explain why it is taking longer than usual.
I will check the status again in a few hours. If the backup is still not completed, I will stop the Duplicator process and try generating the backup using the `All-in-One WP Migration and Backup` plugin.
Hi Pawel, thanks for the update. since it has been stuck at 60% for a long time. please go ahead and stop the duplicator process now. i am fine with trying the all in one WP migration plugin as you suggested. lets try that to save time.
I confirm that the backup has been successfully downloaded. It will now be analyzed by our technical team to reproduce the case and prepare a solution.
Duplicator was not able to complete the backup (it estimated about ~5GB), so I stopped the process and deactivated the plugin. I then installed and activated the `All-in-One WP Migration and Backup` plugin, which successfully generated the backup, although the final size was significantly larger than what Duplicator had estimated.
As soon as we have any updates, I will keep you informed.
- `shop/product/part-accessories-for-harley/seat-seat-belt-components/car-seat-belt-shoulder-pads-soft-and-breathable-protective-covers/`
id: 115975, lang: eng (also has German and French versions)
- `shop/product/uncategorized/schouderbeschermers-voor-autogordels-zachte-en-ademende-beschermhoezen/`
id: 116021, lang: eng (however the content is in German; it also has German and French versions)
Both products:
- have the same SKU: `XJ663` and `662698481266`
- have the same `Published on date: Jan 26, 2026 at 16:37`
When switching the language on the frontend to German for both products, the images appear to be similar, however the content is different (both the product name and the description).
It looks like this may be the result of some import or update process, where there might have been an issue detecting the existing product by SKU, which resulted in creating a new product.
To continue investigating the issue and determine the root cause, I would need to know which process created these products (for example: import, synchronization from an external system, manual creation in the admin panel, etc.). This will help us identify where the issue may have originated.
I’d be happy to help. I suggest the following approach:
1. Our development team will try to reproduce the issue in the current configuration
- to verify whether this may have occurred on an older version of one of the plugins and was only identified later.
2. If we are able to reproduce the issue, we will check whether updating the plugins to the latest versions resolves it.
3. If the update does not resolve the issue, we will try to prepare a workaround.
If we are unable to detect anything following this approach (or if the issue does not occur again), we may consider that it was a temporary problem:
- unfortunately, we do not have access to logs from that period,
- it is possible that one of the plugins was on an older version and the issue was resolved by an update.
I will share an update in the next message with the results of our investigation.
We have analyzed the contents of the database - everything "works/looks OK".
Additionally, we attempted to reproduce the duplication. On the current build (with updated plugins), we were unable to duplicate an object in a way that keeps the same SKU (while translating/editing content). Standard mechanisms, when creating duplicates, add a suffix to the SKU in the format "sku_number-N" (where N is the next available number).
The only scenario that leads to duplication like the one observed here is using `UAE Duplicator` from the `Ultimate Addons for Elementor` plugin - but this is intended behavior, as it bypasses the usual restrictions.
While reviewing the database, it appears that most duplicates were created around `January 20, 2025 9:19 am`, although there are also some much older ones. The question is whether any work was being carried out around that time.
It seems that the most reasonable approach would be to clean this up manually in the products, so that no order-related data is lost.
Additionally, I am sharing the SQL I prepared for searching duplicates for testing/verification purposes:
SELECT
tr.language_code,
GROUP_CONCAT(p.id),
pm.meta_value AS SKU
FROM
`wp_posts` AS p
LEFT JOIN wp_icl_translations AS tr
ON
(p.ID = tr.element_id)
LEFT JOIN wp_postmeta AS pm
ON
(p.ID = pm.post_id)
WHERE
p.post_type IN('product', 'product_variation') AND p.post_status = 'publish' AND pm.meta_key = '_sku' AND tr.language_code = 'en'
GROUP BY
pm.meta_value;
---
To summarize:
- Were any changes or work carried out around `January 20, 2025 9:19 am` (plus/minus 1-2 days)?
- Have you perhaps found any other method to reproduce this state besides `UAE Duplicator`?
Best regards, and I look forward to your feedback.
