Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
- 8:00 – 13:00 9:00 – 13:00 9:00 – 13:00 8:00 – 12:00 8:00 – 12:00 -
- 14:00 – 17:00 14:00 – 18:00 14:00 – 18:00 13:00 – 17:00 13:00 – 17:00 -

Supporter timezone: Europe/Zagreb (GMT+02:00)

This topic contains 8 replies, has 2 voices.

Last updated by Bruno Kos 8 months, 4 weeks ago.

Assisted by: Bruno Kos.

Author Posts
October 3, 2024 at 4:49 am #16247847

zia001

Background of the issue:
I am using the export and import functionality of WPML to import products directly in multiple languages on my site hidden link.

Symptoms:
No specific issue or error message mentioned.

Questions:
Does _wpml_import_translation_group need to be numeric, or can it be something else like A100?
Can I directly set the slug for the 2nd language URL using export and import functionality (i.e., with the Excel file feed in the 2nd language)?

October 3, 2024 at 7:12 am #16248111

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

Thank you for contacting WPML support!

I believe that the `_wpml_import_translation_group` field does not necessarily need to be numeric; it can be a string like "A100." However, since WPML internally uses the `trid` field, which is a `BIGINT` (a numeric data type), it is generally safer and more reliable to stick with numeric values for the `_wpml_import_translation_group`.

While WPML may handle non-numeric values for the import group, using numeric values helps avoid potential issues or conflicts in how WPML processes and stores the `trid`. To ensure smoother operation and compatibility with WPML's internal mechanisms, it's recommended to use numbers for the `_wpml_import_translation_group`.

This will reduce the risk of unexpected behavior during imports and make it easier for WPML to manage translation groups effectively.

Regards,
Bruno Kos

trid.jpg
October 3, 2024 at 2:41 pm #16250803

zia001

Thank you Bruno. Very clear and helpful answer.

related to this: the export and import functionality works great for us, except for 1 issue. one of the taxonomies (model) for the 2nd language import is never imported initially (100% sure it is mapped correctly).

we found a workaround. after completing import, go to settings > taxonomies translation > toggle "Model" taxonomy between translatable and non-translatable. this fixes issue and model is not populated.

have you seen this before? why is is taxonomy not imported properly?

thanks,

October 4, 2024 at 6:55 am #16252609

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

So this happens for only one taxonomy - all the other taxonomies of the same type are imported properly?

If so I cannot tell, we would need to test this in sandbox (so both imports) to see why this one in particular fails.

Let me know and I will create a sandbox where we can try these imports and see if this happens in such setup.

October 4, 2024 at 2:16 pm #16254694

zia001

yes mostly 1 taxonomy (most important one). not sure how to set sandbox, please let me know what you need from me to test this. i can provide you with the import files i am using (in both langauges)

October 7, 2024 at 7:49 am #16259295

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

I set up a sandbox here:
hidden link

To confirm, you are doing this through WPML All Import?

I installed these plugins, if something else is needed by all means. Since All Import issues are specific, if possible can you record this using tool such as hidden link?

So the import process and show us where it fails.

October 10, 2024 at 3:33 am #16272788

zia001

Here is a loom video: hidden link

I am using WP ALL IMPORT.

looking forward to your feedback.

thanks,

October 10, 2024 at 3:34 am #16272789

zia001

I am also happy to give you access to website if helpful.

October 10, 2024 at 6:55 am #16273027

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

These Models, are these imported through this import file as well or did you set them before?

Can you install Motors theme on hidden link and do the import?

And then check if the issue is still there. If yes, don't use the workaround so I could create a Duplicator package and escalate to our compatibility team.

On another note, what if you have Models set as "Translatable - only show translated items" in the first place so before the import, does it work without needing to change translation preferences back and forth for this taxonomy?

The topic ‘[Closed] export import functionality questions’ is closed to new replies.