[Resolved] Products gallery images do not appear in translation in the WP Admin.

yeah feel free to do it, all we want its site to work as fast as possible. we also have a copy in stage environemenr under dev123

i make some test in the stage environment. I will restore it. but you can directly use live website for make your local copy.

You just send us a photo of the pefraser.com website.

We never talked about an issue about how it's display on the website. We used a special way to make photo appear on website waiting for this issue to be solve. So you cannot check website to check if it's working. We are the one who handle the website, what we request you is about the back end. I'm talking about inside admin panel, when we go in product.

I repeat, we don't talk about the website but inside WordPress admin panel. Image gallery and category both did't get converted well by WPML.

- For Category, some are missing and not been created.
- For product, image gallery did't get transfered to English product, making amazon also did't work,

This problem is a emergency and need a serious attention to be solve. Look screenshot and make effort to understand it.

every single image in the backend as been uploaded manually using wordpress method. But still they conter part in english never get updated even if been created by WPML. We do not use any special plugin to upload photo. if we go in english product and then add photo manually we will see it of course. Our issue its that photo if french product gallery not been transfered in english product photo gallery. All step mentioned dont solve our issue. something go wrong with WPML and need investigation. You also did't anwserd for category that not been translated.

you told you download the website locally so we did make some test.
Special way is sql query to put data at right place .

The gallery do exist in english but have missing image.
We can't wait the long deley to get anwser so we have to make some test.
We are actually able to make them appear with a query.

UPDATE wp_postmeta AS pm_en
INNER JOIN wp_icl_translations AS t_en ON pm_en.post_id = t_en.element_id
INNER JOIN wp_icl_translations AS t_fr ON t_en.trid = t_fr.trid AND t_fr.language_code = 'fr'
INNER JOIN wp_postmeta AS pm_fr ON t_fr.element_id = pm_fr.post_id
SET pm_en.meta_value = pm_fr.meta_value
WHERE t_en.language_code = 'en'
AND t_en.element_type = 'post_product'
AND pm_en.meta_key = '_thumbnail_id'
AND pm_fr.meta_key = '_thumbnail_id';

UPDATE wp_postmeta pm_en
INNER JOIN (
SELECT
pm_fr.post_id AS french_product_id,
pm_fr.meta_value AS gallery_ids,
p_en.ID AS english_product_id
FROM wp_postmeta pm_fr
INNER JOIN wp_posts p_fr ON pm_fr.post_id = p_fr.ID
INNER JOIN wp_icl_translations t_fr ON p_fr.ID = t_fr.element_id
AND t_fr.element_type LIKE 'post_product%'
AND t_fr.language_code = 'fr'
INNER JOIN wp_icl_translations t_en ON t_fr.trid = t_en.trid
AND t_en.element_type LIKE 'post_product%'
AND t_en.language_code = 'en'
INNER JOIN wp_posts p_en ON t_en.element_id = p_en.ID
WHERE pm_fr.meta_key = '_product_image_gallery'
) AS mapping ON pm_en.post_id = mapping.english_product_id
SET pm_en.meta_value = mapping.gallery_ids
WHERE pm_en.meta_key = '_product_image_gallery';

There query are able to make appear product in english but still not perfect as it seem they end up disapearing eventualy.

Next try will be to create a script who delete and put back image using publish button. I dont understand you cant see missing image gallery inside wp-admin.

you already asked for a copy of the site on stage environment and we already provide it. It's dev123.pefraser.com You will not see issue on the site. Don't even go on the site, I keep and alway talked about wordpress product editor. For the custom query, they are made in some of our stage enviroment to see what working.

by the way i solved part of the issue using advenced sql qury and php script for find out where it blocking. seem that WPML dont handle very well when a image associate to a product dont actually really have a file on the server. So corruption litterally seem to block script from executing corectly.