[Resolved] Import of translations from csv for products

I have created php code that updates product details from csv file, however it updates data from csv for all translations, but I would like to update 'en' only.

If possible please advise how to adjust code to update product data only for selected language?

php code below:

<?php
// Load WordPress and WPML
require_once('wp-load.php');

// Function to update product translation and provide debugging messages
function update_product_translation($sku, $title, $description, $content) {
// Get the product post ID by SKU
$product_id = wc_get_product_id_by_sku($sku);

if ($product_id) {
// Get the default language
$default_language = apply_filters('wpml_default_language', null);

// Set the language to English for translation
do_action('wpml_switch_language', 'en');

// Update the product title, description, and content
$update_args = array(
'ID' => $product_id,
'post_title' => $title,
'post_excerpt' => $description,
'post_content' => $content,
);

$result = wp_update_post($update_args);

if (is_wp_error($result)) {
echo "Error updating SKU $sku in English: " . $result->get_error_message() . "\n";
} else {
echo "Updated SKU $sku in English.\n";
}

// Reset the language to the default
do_action('wpml_switch_language', $default_language);
} else {
echo "Product with SKU $sku not found.\n";
}
}

// Read and process the CSV file
if (($handle = fopen('products.csv', 'r')) !== false) {
while (($data = fgetcsv($handle, 1000, ',')) !== false) {
$sku = $data[0];
$title = $data[1];
$description = $data[2];
$content = $data[3];

// Call the function to update the product translation for English
update_product_translation($sku, $title, $description, $content);
}
fclose($handle);
}
?>

Dear Waqas Bin Hasan,

Thanks for your response.

Already went through this but it doesn't work for me.
- Check these guides and see if these help:
--- https://wpml.org/documentation/plugins-compatibility/export-multilingual-websites-using-wp-all-export-wpml/
--- https://wpml.org/documentation/related-projects/wpml-all-import-plugin-website-import-with-wpml/

added debuting info.

Dear Shekhar Bhandari,

Thank you for your reply.

Sorry I didn't get what do you mean by:
1. "Export current page posts in a CSV"? - Please guide on steps of doing this process.
2. Where and how to set "a unique identifier" ? which identifier we are referring to?

Which are we using to do those steps?

Kind regards,
Max

Dear WPML team,

I have successfully exported all products using 1st step.

Now I am facing issue with 2nd step. I have 2 tables in default language(lv) and secondly language(eng).

https://wpml.org/documentation/related-projects/wpml-all-import-plugin-website-import-with-wpml/importing-multiple-languages-with-wp-all-import-and-wpml/#import-the-default-language-file
step 5. It says in your instructions: Map the unique identifier to the correct element in your CSV or XML file."

I have attached my test table for default language.

My question is how do I map product from file with woocommerce product if unique identifier is not set yet? Should I use SKU or Product ID number? And later map secondary language translations from other table to SKU or Product ID?

Kind regards,
Max

Dear Team,

I have just tried to do those steps, but it didn't work out.
1. I exported and re-imported 5 products and set unique identifier using product ID.

Eng translations didn't come up.

Please advise to fix it or/and debug the process.

Kind regards,
Max