WPML: copy / duplicate product url slugs from original language to other languages #woocommerce #wpml

wpml-set-product-url-slug-translations-to-original-slug.sql

UPDATE
	wp_posts posts
	INNER JOIN (
		SELECT
			original_id.id,
			p_original_slug.post_name
		FROM (
			SELECT
				p.id,
				tr.language_code,
				tra.element_id AS original_id
			FROM
				wp_posts p
				INNER JOIN wp_icl_translations tr ON tr.element_id = p.id
				LEFT JOIN wp_icl_translations tra ON (tra.trid = tr.trid AND tra.language_code = 'en')
			WHERE
				tr.element_type = 'post_product'
  ) original_id
  LEFT JOIN wp_posts p_original_slug ON original_id.original_id = p_original_slug.id
	WHERE (original_id.language_code = 'fr' OR original_id.language_code = 'de')
) lookup_table ON posts.id = lookup_table.id 
SET posts.post_name = lookup_table.post_name;

I used this to reset product urls that had already been translated by WPML from en to de and fr to the original product url slug from the source language en.