Magento – Mass change product URL keys to match product names

ce-1.7.0.2url

Shopkeeper created configurable products by duplicating existing products and did not change the product URLs to match the product names. The shop is also a multilingual shop and different languages are made as store views.

This all lead to situation where the duplicated products had wrong url keys.

I found this code that could be added to a new .php file and run on the server and that was a solution for ONE store view:

<?php
require 'app/Mage.php';
Mage::app();
$amount = 0;
$model = Mage::getModel('catalog/product');
$products = $model->getCollection();
foreach ($products as $product) {
    $model->load($product->getId());
    $product->setUrlKey($model->getName())->save();
    set_time_limit();
    $amount++;
}

That code changed the product url keys to match the product names, but it only worked for one store view.

My question is: how do I change the product url keys for the other store views in other languages?

UPDATE!
The solution was easy: in the frontend just change to the next store view and run the new .php file in that view also.

Best Answer

The reason why that worked, is because Magento internals will use the current store id on Mage::getModel('catalog/product').

You could have used Mage::getModel('catalog/product')->setStoreId('STORE_ID');

Related Solutions

Magento – Catalog URL Rewrite after daily import/update of Product

Catalog URL Rewrite is a heavy index to run if you have thousands of skus. I'd recommend setting it to update manually not on save. You can do this programatically in your import script. Then have your import script run the index once when it's done importing all the products. You can also have your import script set the index mode back to "update on save" after it has run the index manually.

As for the "-1" on the end of urls. I've seen this happen in different configurations, particularly if you have a flat product catalog without unique category names in the urls. There have been some bugs with this behavior in different versions of Magento. The worst we found is that those number would increment with each index run. So one day the page is shoes-1.html, the next it's shoes-2.html, etc. Definitely do some testing on that if the pages are public. If everything stays a private sale this may not be critical for now. But do resolve this because as the url keys change, the records for the old url keys remain. This will also contribute to bad performance as you can easily get millions of unneeded core_url_rewrite rows over time.

Magento – Set Configurable Attributes and Custom Options via URL

There is not a way to select a custom option based off a URL parameter. The custom options are not rendered the same as configurable attributes.

This is the code that defaults the attribute values

var separatorIndex = window.location.href.indexOf('#');
    if (separatorIndex != -1) {
        var paramsStr = window.location.href.substr(separatorIndex+1);
        var urlValues = paramsStr.toQueryParams();
        if (!this.values) {
            this.values = {};
        }
        for (var i in urlValues) {
            this.values[i] = urlValues[i];
        }
    }

    this.configureForValues();

You could write something custom to do exactly what you are looking for using jQuery.param().

http://api.jquery.com/jquery.param/

Related Topic