Quick script to export Magento categories with IDs
If you are after a quick method to get all the category ID's for your categories for some Excel lookups (for new data imports), then this quick PHP script should help you out:
<?php
define('MAGENTO', realpath(dirname(__FILE__)));
require_once MAGENTO . '/app/Mage.php';
Mage::app();
$category = Mage::getModel('catalog/category');
$tree = $category->getTreeModel();
$tree->load();
$ids = $tree->getCollection()->getAllIds();
if ($ids) {
$file = "var/import/catwithid.csv";
file_put_contents($file, "catId, catNamen");
foreach($ids as $id) {
$string = $id . ', ' . $category->load($id)->getName() . "n";
file_put_contents($file, $string, FILE_APPEND);
}
}
Simply save the above code in a PHP file in the base Magento directory of your store, and visit the URL in your web browser, simples!