Attached you will find a little archive which contains all mods and tricks described above to import categories as a CSV file.
I also had a little struggle putting the very helpful hints together.
Just put it into your app directory, create advanced import profile and should simply work.
This gets me the furthest but I am still getting this error:
Starting profile execution, please wait... Warning: Please dont close window during importing/exporting data Starting Mage_Dataflow_Model_Convert_Adapter_Io :: load Loaded successfully: "/stores/var/import/Categories.csv" Starting Mage_Dataflow_Model_Convert_Parser_Csv :: parse Found 1 rows Starting catalog/convert_adapter_category :: parse <br /> <b>Fatal error</b>: Call to undefined method ImpCat_Catalog_Model_Convert_Adapter_Category::getStoreById() in <b>/stores/app/code/local/ImpCat/Catalog/Model/Convert/Adapter/Category.php</b> on line <b>42</b><br /> Processed 0% 0/1 records Imported 0 records
I’m running 1.1.6 - is there a code difference that is causing this?
One thing I thought of is if I have the “store” column wrong in my CSV file. Should that column ALWAYS be “default”? Or does it depend on what your actual store name is? I’ve tried it both ways and it didn’t seem to make a different.
The CSV file I have it saved as a Unicode TXT file with a CSV extension. Is that correct?
Thanks - IR
Nevermind. I figured it out. The text file needs to be ANSI format. I was doing Unicode and UTF. Once I changed it, it worked. Plus I left the “store” column at “default” even though we have a different store name. It doesn’t matter. Thanks guys for all this help.
I wrote my own script based on direct sql queries. Importing the tree of over 200 categories from temporary table into magento and asociating products with them.
I’ts hardcoded for my own needs, but i think it’s enough easy to change .
If somebody interested, I can share.
Hi, could you share me the code please? I think it is safer just to do it via direct sql (that way I won’t need to back up an entire site and my installation would stay clean)