[Resolved] sync products after multiple wpallimport imports
This thread is resolved. Here is a description of the problem and solution.
Problem: The client needed to synchronize products between Dutch and German versions on their website, using the same SKU for each product. They encountered issues where the German version of a page was not displaying correctly, even though it was published. Solution: We advised the client to use the WPML export and import tool to link translations together, which can be found here: WPML Export and Import documentation. Additionally, for the issue with the German page not displaying, it was discovered that the page was still in drafts, and we recommended publishing it through the language switcher on the admin bar. For the broader issue of synchronizing products, we suggested exporting all feeds and merging them into a single CSV file for each language. This approach allows for the use of the 'Automatic Record Matching to Translate' feature during the import process. We recommended testing this solution on a sandbox site to ensure the correct setup of the 'import template'.
If this solution does not resolve your issue, or if it seems outdated or irrelevant to your case, please check the related known issues at WPML Known Issues and confirm that you have installed the latest versions of themes and plugins. If further assistance is needed, we highly recommend opening a new support ticket at WPML Support Forum.
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.
Background of the issue:
I have Dutch and German products on my site hidden link. I imported them using wpallimport. I want to enable a feature where clicking on the German flag while viewing a Dutch product will display the German version. The products share the same SKU.
Symptoms:
I need to synchronize products between Dutch and German versions based on SKU.
Questions:
How do I synchronize products between Dutch and German versions using WPML?
Here is the ticket. I will need to closely examine your website. Therefore, I will require temporary access (WP-Admin and FTP) to a test site where the problem has been replicated, if possible. This will enable me to provide better assistance and determine if any configurations need to be modified.
Please note that it is important to have a backup for security purposes and to prevent any potential data loss. You can use the UpdraftPlus plugin (https://wordpress.org/plugins/updraftplus/) to fulfill your backup requirements.
Your upcoming reply will be treated with confidentiality and will only be visible to you and me.
✙ To resolve the issue, I may need your consent to deactivate and reactivate plugins and the theme, as well as make configuration changes on the site if necessary. This emphasizes the significance of having a backup.
If you still can't manage to solve this, create a staging site with minimal data and we'll do some test import with around 2 - 3 products with two languages for a test.
Oh! Yes, i saw that option, but since the dutch part of the shop was devided in about 14 different imports, i can't match it to one comparable import. The new German one is much bigger and contains almost 60K products. I was hoping that there was a way to connect the products with the same SKU's afterwards.
Feel free to have a look in my dashboard: hidden link
It looks like you might have to configure it correctly. Moving forward, could you create a staging site with minimal data so we can do some test import with around 2 - 3 products in two languages?
Well.. This IS the staging site for musicdeals.nl. I cannot make another staging site because I don't have enough recourses. I would first have to copy this site and then remove 120000 products. But.. My server won't let me.
So the only thing I can do is make a new website with a few products, but I guess that is not the same.
So, I won't mind if you try it on my current staging site, I do have backups!
Alright, I'll give it a try. However, when I reviewed the WP ALL Import Manage import list here: hidden link , I only noticed "Thomann DE FULL," which appears to be the German language products. Could you upload the English products so I can review them?
All the other imports you see, are Dutch, it's a Dutch website. Together they contain the same products as the 1 German import, I just devised them into more imports for speed.
So the Dutch products are the base ones, they should not be changed and the Thomann DE FULL should be connected to the existing Dutch ones via sku
i'm wondering.. what are you going to test? Is there another way to sync those products besides this option during the wpallimport import: Automatic Record Matching to Translate. (i guess by hand, but that's no option for me since the amount of products)
If not, how do you want to connect them / test that?
There are too many products on the site and I'm having difficulties trying to troubleshoot the issue.
I have prepared a sandbox site and could you please import around 50 products for Dutch language? Then, prepare 50 products in German and I will test the import directly for you.
Thank you for your response. I'd be happy to assist you further with this. Typically, if the "import template" is set up correctly, importing the translated product will automatically sync with the primary language.
Here's the plan: we'll configure a few products for testing in the sandbox site I've set up for you. Once we have the correct "import template" in place, we can apply it to your staging site, initiate the import, and it will sync the products with your primary language.
But i saw you tried importing the german feed and syncing it to the DRUM feed. But that won't work, because the drum feed only contains a few thousand products. while the german feed contains 60.000 products. How do you think they will match with all the other products that were imported with the other feeds?
Please remember that the dutch products were divided by niche and imported with the use of 14 different imports, and the new german import contains ALL these products. So you can't match all these new german products with only ONE dutch import. If it works as i think it works, then only a few thousand products will be matched/synced andf the rest will not??
That's why i'm asking for a way to sync them AFTER the import.
