Magento 1: Export Catalog Categories by 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/`