I want to import all the categories in magento using CSV file, I tried to do using extension http://www.magentoworks.net/importexport-magento-category-extension/ it works but i want to do it using Dataflow-Profiles. Is there any way to do using Dataflow-Profiles?


5 Answers 5


Not using any extensions is limiting you, but you could use Import/Export with products because missing categories will be created when you import products. Afterwards, delete the created products.

Depending on your number of products and categories, it might be easier to create a single dummy product, assign it to all categories and then export only this product.

Note: This will not export any settings of the categories, so it's a workaround, not a full solution.


If you want to import all categories and products to your website,
just follow the following instructions.

  1. Create all categories and create one product in your website,
  2. After this, export that data and keep that with you.
  3. Now arrange the data which you want to import, that total have to be arrange in the format of your exported data.
  4. After arranged you can easily import the data into your website which you want to import newly in usual manner.

  5. Then go to system-->import/Export-->Data flows-->Follow that rules...

  • How can export products with category name not category id using system-->import/Export-->Data flows
    – user51361
    Commented Apr 20, 2017 at 10:31

I had this very same issue when I started to convert/migrate and old Zencart to Magento. I wrote a little script that kept the originl id's and sorted them back into Magento.

You my want to have a look at this: https://stackoverflow.com/questions/34213371/csv-import-export-problems-in-magento/34267981#34267981

This script is for Magento only, it exports and imports categories while keeping their ID´s intact. Which is good when moving between Magento installations sometimes.


Long story short. No. You cannot use the default Dataflow profiles (or advanced profiles) to export/import any other data structures than 'customers' and 'products'.

In order to achieve this you need a custom module. AFAIK there isn't a module out there with a Dataflow Adapter for Categories (but I may be wrong).

You can build your own module if you like.

You need a good understanding of the Dataflow Parsers/Adapters/Mappers to build this module.


Hello Find this url you will get proper solution



unzip the file merge the your magento folder

then it will work No Need to do anything


function getCategories()
    $file = 'csv/categories.csv';
    $arrResult = array();
    $headers = false;

    $handle = fopen($file, "r");
    if (empty($handle) === false) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            if (!$headers) {
                $headers[] = $data;
            } else {
                $arrResult[] = $data;
    return $arrResult;

Not the answer you're looking for? Browse other questions tagged or ask your own question.