Magento – Possible to link to product that has multiple URL Keys for different store views? (multilingual)

I guess your question mostly relates to SEO value, not how to technically do it in Magento. So we are just talking about semantics here. The language prefix already makes the URL unique, plus it uniquely identifies the language for that page. So this already is a plus for SEO.

Having an additional "news-de" would not be necessary - the language is already specified and the "-de" suffix does not tell anything new about the "news" part either. Because it is unneeded, it is actually bad practice to add it in there.

A URL like "/de/nachrichten" would be making much more sense: The "news" is translated into German ("nachrichten") and this not only points out to searchbots which language is used: It also gives added value to German readers. However, it would only make sense if the actual page itself (so the German translation of some product) actually is German.

In short: Try to use an URL key that directly matches the product name that is used on that page.

If you wanted this as a feature you can write a module, and observe the save product event and loop through all the stores and either:

• condition based looking for "english" if they are named like that
• hardcode the id's
• provide a configuration option in the admin to select the english stores.
• add an attribute to the store object

Another way to do it as a one off:

<?php

require '../app/Mage.php';

$englishStore = 1; // English Store (the one you want to copy from)
$attribute = "short_description"; // Attribute to copy

foreach (Mage::app()->getWebsites() as $website) {
    foreach ($website->getGroups() as $group) {
        $stores = $group->getStores();
        foreach ($stores as $store) {
            //store object
            //print_r($store->getData());

            // if english found in name or change this so it's hardcoded store id's
            if (strstr($store->getData('name'),"english")) {

                $StoreToUpdateCollection = Mage::getModel('catalog/product')->getCollection()
                    ->addAttributeToSelect('*')
                    ->addAttributeToFilter('store_id', $store->getData('store_id'));

                foreach ($StoreToUpdateCollection as $product) {

                    // get the description from the base English store
                    $englishProduct = Mage::getModel('catalog/product')->setStoreId($englishStore)->loadByAttribute('sku', $product->getData('sku'));
                    $newValue = $englishProduct->getData($attribute);

                    // update the attributes for the current store for the product ID
                    Mage::getSingleton('catalog/product_action')->updateAttributes(
                        array($product->getData('id')),
                        array($attribute => $newValue),
                        $store->getData('store_id')
                    );
                }


            }


        }
    }
}

I have not tested the updating part, would suggest trying this on a dev version.