Magento – How to load category using url_key and parent catgory_id

catalogcategory

How to get category using url_key and parent category_id?
If category structure is as follows

-Root
  --Mobile
    ---Android
    ---Windows
    ---iOs
  --Tablet
    ---Android
    ---Windows
    ---iOs

Then using following code if try to load iOs category using url_key it load always load root->Mobile->iOS

$category = Mage::getModel('catalog/category')
    ->setStoreId(Mage::app()->getStore()->getId())
    ->loadByAttribute('url_key', 'cat_urlkey');

How I can modify code so that, sub category load by url_key and respective parent category_id?

Best Answer

You can load the attributes collection and get it's first element:

$categories = Mage::getResourceModel('catalog/category_collection');
$categories->addAttributeToSelect('*');

$categories->addAttributeToFilter('url_key', 'cat_urlkey');
$categories->addAttributeToFilter('path', array('like' => '1/15/%');

The second condition tells to take subcategories of the category with id 15.

Related Solutions

Parent Category Showing Products from Subcategories in Magento

This is actually a feature. If you want to avoid this you should set the flag 'Is anchor' to 'No' on the parent category. In your example 'Clothing'. This way, in the parent category you will see only products directly assigned to it.
After you do the changes you should re-index everything.

Magento – Category with ‘categorgyurl’ URL Key Attribute Already Exists

Try this code.

$category = Mage::getModel('catalog/category');
$category->setName('categorgyurl');
$category->setUrlKey('categorgyurl');
$category->setIsActive(1);
$category->setDisplayMode('PRODUCTS');
$category->setIsAnchor(0);

$parentCategory = Mage::getModel('catalog/category')->load($root_catid);
$category->setPath($parentCategory->getPath()); 

$categoryWasCreated = false;
$currentUrlKey = $category->getUrlKey();
while (!$categoryWasCreated) {
    $categoryId = Mage::getModel('catalog/category')->load($category->getUrlKey(), 'url_key')->getId();
    if ($categoryId) {
        //if category with this url key exist add some unique part to the name
        //I used here time function but you can use something else
        $uniquePart = time();
        $category->setUrlKey($category->getUrlKey() . $uniquePart);
    } else {
        $category->save();
        $categoryWasCreated = true;
    }
}

Hope that is what you need.

Best Answer

Related Solutions

Parent Category Showing Products from Subcategories in Magento

Magento – Category with ‘categorgyurl’ URL Key Attribute Already Exists

Related Topic