How to change URL key for category from Global into Storeview

3 July 2009 No Comment

When you use multi-languages, You want category url for each language is difference.
Example:
For category is Electronics
you want in the English it will is www.yourmagentosite.com/electronics
However in the other language( French example) it will be www.yourmagentosite.com/frenchname.
However in magento: the url key for category is always is Global. So when you change it for a storeview, it will be changed for all storeviews.
The url_key in manager attribute only apply for products, so change it will don’t work for category.
So we need to change in the database:
Please goto the eav_attribute and you will see the url_key.
example in magento 1.3. I saw url_key for category is 33, so I run this SQL:
UPDATE eav_attribute SET is_global = ‘0′ WHERE eav_attribute.attribute_id =33
and it work fine.