Magento

Hello,

Where can I find the catergory ID’s for my sites catergories.

Thanks

Hi, look in your admin in the category, there you will find the id number in the url.
cheers

OK Thanks,

Is there no where i can get a list off all the catergory ID’s without going into every catagory? I keep thinking I saw something about a Catergory Tree but cant find it now?

Thanks

If you take a look at your ‘catalog_category_entity_varchar’ table in the database and look at all the entries with an attribute_id of 31 (at least that’s what it’s like in my store) I think you’ll find what you want.

harry12bar - 01 September 2008 09:30 AM

Hi, look in your admin in the category, there you will find the id number in the url.
cheers

Since version 1.1.5 or 1.1.6 it’s no longer in the URL. Now I have to look in the DB. Cumbersome…

Hi all

I found a simpler way: Install and activate the “Tamper Data” Firefox extension.
Now click on a category. In Tamper Data you will see the URL containing the category ID (as seen in the browser address bar in earlier versions of Magento).

Hope this helps someone…

Regards

Concept - 04 September 2008 03:08 AM

OK Thanks,

Is there no where i can get a list off all the catergory ID’s without going into every catagory? I keep thinking I saw something about a Catergory Tree but cant find it now?

Thanks

Here is a code that displays all the categories ids:

Also take a look at this thread: http://www.magentocommerce.com/boards/viewthread/17998/

It seems you can now just go to Admin -> Catalog -> URL Rewrite.  If you have many categories (like I do), you can just type in name of your category in the “Request Path” to filter the list and you can see it in the “Target Path”.

the URL Rewrite didnt display the root category id.  (why not?) So had to use the ‘dirty fix’.  Why does noone display the address of the code they publish???  app/design/adminhtml/default/default/template/catalog/category/edit/form.phtml i think

If you’re looking to import categories using dataflow, try this solution:

http://www.magentocommerce.com/wiki/how_to_import_category_structure_with_products_using_dataflow

Here is a code that displays all the categories ids:

<?php
    require_once 'app/Mage.php';
        Mage::app('default');
        
        
        $categories = Mage::getModel('catalog/category')->getCollection();
        $categ_ids=$categories->getAllIds();
        var_dump($categ_ids);
?>

This is a great piece of code!
How do I get the name of each category to be displayed next to each category ID and insert a line break <br /> after each one.

Example:

Cat. Name1: ID#1
Cat. Name2: ID#2
Cat. Name3: ID#3
....

THANKS!!

davidgrun - 03 December 2008 05:49 AM

Here is a code that displays all the categories ids:

<?php
    require_once 'app/Mage.php';
        Mage::app('default');
        
        
        $categories = Mage::getModel('catalog/category')->getCollection();
        $categ_ids=$categories->getAllIds();
        var_dump($categ_ids);
?>

This is a great piece of code!
How do I get the name of each category to be displayed next to each category ID and insert a line break <br /> after each one.

Example:

Cat. Name1: ID#1
Cat. Name2: ID#2
Cat. Name3: ID#3
....

THANKS!!

Here is the code:

@ab.wdev

Thanks for your help!
I’m getting this error with your new code.

Fatal error: Class ‘Mage’ not found in /home/kehothhh/public_html/category_id_list.php on line 9

This is my code.

davidgrun - 21 December 2008 07:02 PM

@ab.wdev

Thanks for your help!
I’m getting this error with your new code.

Fatal error: Class ‘Mage’ not found in /home/kehothhh/public_html/category_id_list.php on line 9

This is my code.

<?php 
/*
DISPLAY CATEGORY IDs with names
*/

$categories_collection = Mage::getModel('catalog/category')->getCollection();
        $categories_collection->addAttributeToSelect('name')->setStoreId(Mage::app()->getStore()->getId())->load();    
    if($categories_collection->getSize()){
        foreach($categories_collection as $category){
            echo $category->getName().' '.$category->getId().'<br />';
        }
    } 
?>

Try this:

THANKS that works!

Here is my final code with a tad of styling just to make it easier to the eye

I also attached the file for whoever wants to download it. (just place it in your root folder).

Enjoy!

category_id_list.php  (File Size: 2KB - Downloads: 8)