Streamlining Multi-Language Content Management in Sitecore

Managing multi-language websites with Sitecore can be a challenge, especially when we need to replicate many field values across different language versions of items. We need to manually copy field values from one language to other language version, which is very time consuming.

We can achieve this with PowerShell script in three easy steps. 

- Fetch an item using item path or item ID

- Iterate through its fields

- Copy values from source language to target language

Below is the overview of the script and the complete script to do that. 

Script Overview:

  1. Set Item Path & Languages:
    • $itemPath specifies the path to the Sitecore item.
    • $sourceLanguage and $targetLanguage are the language codes for the source and target languages (in this case, English and French).
  2. Fetch Item:
    • $item = Get-Item -Path $itemPath retrieves the item from Sitecore using the specified path.
  3. Editing Block:
    • $item.Editing.BeginEdit() begins editing the item.
  4. Field Value Copy:
    • It loops through the fields of the item and checks if the field has a value in the source language ($field.HasValue($sourceLanguage)).
    • If it does, the value from the source language is copied to the target language using $field.SetValue($value, $targetLanguage).
  5. Save Changes:
    • After modifying the fields, $item.Editing.EndEdit() saves the changes.
  6. Error Handling:
    • If an error occurs, the editing process is cancelled ($item.Editing.CancelEdit()), and an error message is logged.
Complete Script:

$itemPath = "/sitecore/content/Home/MyItem"
$sourceLanguage = "en"  # English
$targetLanguage = "fr"  # French

# Get the item from Sitecore
$item = Get-Item -Path $itemPath

try {
    $item.Editing.BeginEdit()

    foreach ($field in $item.Fields) {
        # Check if the field has a value for the source language
        if ($field.HasValue($sourceLanguage)) {
            $value = $field.GetValue($sourceLanguage)

            # Optionally, print verbose output for debugging
            Write-Host "Copying field: $($field.Name) from $sourceLanguage to $targetLanguage"
            
            # Set the value for the target language field
            $field.SetValue($value, $targetLanguage)
        }
    }

    # Save the item after updating the field values
    $item.Editing.EndEdit()

    Write-Host "Fields successfully copied from $sourceLanguage to $targetLanguage"
}
catch {
    # In case of an error, cancel the edit and log the error
    $item.Editing.CancelEdit()
    Write-Error "Error migrating fields: $_"
}

I hope this will help and reduce some load for copying field value one by one!

Stay connected for more updates. We will see some more useful PowerShell scripts in the next blogs.

Thank you!

Comments

Post a Comment

Popular posts from this blog

Setting Up Sitecore Headless with Next.js in Disconnected Mode

Image
Sitecore Headless CMS offers a flexible way to integrate with different frontend technologies. For developers working with frameworks like Next.js, Sitecore provides various ways to set up the environment, including four distinct modes: Disconnected Mode , Connected Mode , Integrated Mode , and API Mode . Each mode offers unique features for different stages of development and production needs. What Is Disconnected Mode? Disconnected Mode is designed for local development and testing without requiring a direct connection to the Sitecore platform. In this mode, data is typically retrieved from static files (like YAML or JSON), and content updates are done manually. This mode is ideal for frontend developers who want to focus on building the user interface and the site’s functionality without waiting for backend integration. In Disconnected Mode , the data flow is not dependent on the Sitecore CMS. Instead, content is stored locally in static files, which are easier to manage and qu...
Read more

Translating Sitecore items’ field values into different language with PowerShell and Translate API

Image
Recently, we encountered a situation where we needed to translate multiple Sitecore field values across numerous items into different languages. Manually handling each item and field was both time-consuming and complex—especially since actual translation was required, not just copying values between language versions. We explored various approaches to streamline the process. While AI-based solutions seemed promising, but client side Compliances for AI usage ruled out that option. Another practical alternative was to use spreadsheets like Excel or CSV files containing translated content and then import those values into Sitecore using PowerShell scripts. During our exploration, we discovered a freely accessible translation API that doesn't require an API key. By leveraging this in our PowerShell script, we were able to automate the translation process and directly apply the translated content to the appropriate language versions of the Sitecore items—saving both time and effort. ...
Read more

Create Sitecore Ribbon Button using Sitecore PowerShell Extensions

Image
Creating a custom Ribbon button in Sitecore using Sitecore PowerShell Extensions (SPE) involves several steps, which I'll guide you through below. The general process includes Create PowerShell Script Module and Add Integration Point Setup the PowerShell script Library and Add PowerShell script Configuring the Ribbon button and Sync Verify the button in the Ribbon Here's how we can achieve that: Pre-Requisites: Running Sitecore Instance PowerShell ISE to run PowerShell script (Install compatible Sitecore.PowerShell.Extensions if it’s not there) Step-1: Create PowerShell Script Module and Add Integration Point Create PowerShell Script Module: Go to Content Editor . In the content tree, navigate to: System > Modules > PowerShell > Script Library . Right-click on Script Library and select Insert > PowerShell Script Module . Give it a name, su...
Read more