Export Magento Product Categories to custom table

27 Oct

ini_set('max_execution_time', 1500);
ini_set('display_errors', 1);

require_once 'app/Mage.php';
$userModel = Mage::getModel('admin/user');

$categories = Mage::getModel('catalog/category')->getCollection()

foreach ($categories as $category) {

    $entity_id = $category->getId();
    $name = mysql_real_escape_string($category->getName());
    $url_key = $category->getUrlKey();
    $url_path = $category->getUrl();
    $is_active = $category->getIsActive();
    $now = time();

    $catids = array();
    foreach ($category->getParentCategories() as $parent) {
        $catids[] = $parent->getId();
    unset($catids[count($catids) - 1]);

    $parent = NULL;
    if (empty($catids)) {
        $parent = NULL;
    } else {
        $parent = array_pop($catids);

$con = mysql_connect("HOST", "USER", "PASSWORD");
mysql_select_db("DB", $con) or die("");

mysql_query("INSERT INTO `categories`(`id`, `name`, `slug`, `parent_id`, `enabled`, `modified_at`, `modified_by`) VALUES ('$entity_id', '$name', '$url_key', '$parent' ,'$is_active', '$now', 1)")  or die(mysql_error());

Leave a comment

Posted by on October 27, 2015 in ECommerce, Magento


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: