Magento 1: Export catalog categories for a specific store view

In this post you will learn how you can export Magento 1.9 categories for a specific store view as CSV.

For example, you have Arabic store view with ID 7, and you want to export all arabic category names in a CSV file, below will be the code you want.

Create a file on your Magento root and paste the below code, change the $storeId to your desired ID and run the script.

<?php

require_once 'app/Mage.php';
Mage::app("admin");

$storeId = 7;
$categories = Mage::getModel('catalog/category')
	->getCollection()
	->setStoreId($storeId)
	->addFieldToFilter('is_active', 1)
	->addAttributeToSelect('*');

$handle = fopen("var/export/categories_arabic.csv", "w");
$header = array('ID', 'Name');
fputcsv($handle, $header);

foreach($categories as $category){

	$row  = array($category->getId(), $category->getName());
    fputcsv($handle, $row);
}

fclose($handle);
?>

After running the above script, you will find the exported CSV file `categories_arabic.csv` in the directory `var/export/`

Author: Tahir Yasin

Tahir is a Passionate Web Developer from Lahore, Pakistan and a guy with NEVER-STOP-LEARNING attitude who keeps an eye on emerging technologies and customer trends.

Leave a Reply

Your email address will not be published. Required fields are marked *