Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Importing Category Tree? 
 
DarkNova
Jr. Member
 
Total Posts:  25
Joined:  2008-06-10
 

Hello,

How do I import my tree of categories into Magento? Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
cooper
Sr. Member
 
Total Posts:  104
Joined:  2008-03-31
 

Hello,

There ‘s a way with sql (I prefer) :

http://www.magentocommerce.com/boards/viewthread/8454/

or via Magento API :

http://www.magentocommerce.com/wiki/adding_a_new_category

 
Magento Community Magento Community
Magento Community
Magento Community
 
MmaxX
Sr. Member
 
Avatar
Total Posts:  112
Joined:  2008-04-01
 

Ok, but is there someone who can explain me further the second method (in the wiki) ?

I don’t know at all how works the API, so I need your help smile !
Thanks in advance.

 
Magento Community Magento Community
Magento Community
Magento Community
 
DarkNova
Jr. Member
 
Total Posts:  25
Joined:  2008-06-10
 

I suggest you check out the new API for version 1.1 here: http://www.magentocommerce.com/wiki/doc/webservices-api/api/catalog_category

Magento changed how the API works to make it much better than before.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dmt123
Jr. Member
 
Total Posts:  4
Joined:  2008-08-08
 

The web service API is a bit slow… a category importer for dataflow would be much faster as far as I know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
brianpat
Member
 
Total Posts:  44
Joined:  2008-04-05
 

Hi,
I am very new to the implementation of API. Has anybody implemented this for importing large number of categories successfully without breaking any other link. Also has anybody successfully used sql to import categories without any bug.

Appreciate a prompt reply.

Thanks
Brian

 
Magento Community Magento Community
Magento Community
Magento Community
 
neuro
Sr. Member
 
Avatar
Total Posts:  104
Joined:  2008-09-29
France
 

We can’t add category description? :/

 
Magento Community Magento Community
Magento Community
Magento Community
 
neuro
Sr. Member
 
Avatar
Total Posts:  104
Joined:  2008-09-29
France
 

OK, thanks a lot.

 
Magento Community Magento Community
Magento Community
Magento Community
 
joyously
Guru
 
Total Posts:  447
Joined:  2008-08-21
 
VisualFrames - 27 October 2008 06:43 PM

We have created a little tool that should help anyone import a big list of categories from a csv file. Please note that you will need to create an API username and password as the script communicates to your store through the API.

Please keep in mind that this is still work in progress and we have opted for functionality over fully polishing the app. Use at your own risks but it should be good enough to import categories in bulk in your store.

Feel free to try it out:
http://categoryimporter.ecommerce-themes.com/

Interesting idea to get people’s API usernames and passwords. Not something I would give to you though.
Your descriptions of the csv file in the two places don’t match either. One says to put the category and then the child category. The other looks like it has category and then parent category.  It’s hard to tell what’s what…

 
Magento Community Magento Community
Magento Community
Magento Community
 
ShopGuy
Guru
 
Total Posts:  462
Joined:  2008-09-07
 

I would not recommend using that tool as requires giving a third party access to your system. IF you do, then make an API user who only has access to categories and ensure to delete the user as soon as the import is done.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kevin123
Jr. Member
 
Total Posts:  27
Joined:  2008-11-04
 

Hey,

Could anyone please provide a working example of the category.create SOAP API function?

I have tried the example from

http://www.magentocommerce.com/wiki/doc/webservices-api/api/catalog_category#example_1._working_with_categories

The function returns the newly created category id, but the category does not show up anywhere in the magento admin.

Anyone run into this problem?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Chris Nudd
Jr. Member
 
Total Posts:  28
Joined:  2008-05-17
 

I have run into the same problem. Please magento, help us with this crucial issue. Category import should be the top of the list in dataflow.

Thanks,

CN

 
Magento Community Magento Community
Magento Community
Magento Community
 
Unirgy
Guru
 
Avatar
Total Posts:  478
Joined:  2007-09-07
 

to import category structure and associate with products try this:
http://www.magentocommerce.com/wiki/how_to_import_category_structure_with_products_using_dataflow

 
Magento Community Magento Community
Magento Community
Magento Community
 
cbsteven
Member
 
Total Posts:  73
Joined:  2008-07-25
 

Maybe someone could edit that article to make it a little more step-by-step? Importing categories shouldn’t require more than basic computer literacy to do. I’m been dabbling in programming of various languages for 10+ years and am having trouble following that page.

Unirgy - 02 December 2008 11:25 AM

to import category structure and associate with products try this:
http://www.magentocommerce.com/wiki/how_to_import_category_structure_with_products_using_dataflow

 
Magento Community Magento Community
Magento Community
Magento Community
 
wokka
Member
 
Total Posts:  45
Joined:  2008-06-06
 

Yes, I can’t understand it either!

I really need to be able to import categories easily from a simple csv - but it seems impossible with Magento.

Magento is so full of features I can’t believe how hard it is to import a category structure with ease. I’m actually thinking of dumping my magento site because of this.... very disappointed :-(

Can anyone in the magento community help me with this?

Thanks,
John

 
Magento Community Magento Community
Magento Community
Magento Community
 
pdxwebhead
Jr. Member
 
Total Posts:  27
Joined:  2008-07-16
Portland Oregon
 

To VisualFrames.

Is your site: http://categoryimporter.ecommerce-themes.com/ down?

The instructions seem simple enough, but I repeatedly get a SOAP error - it seems to be hanging on authentication. I created a fresh Magento install on my web server, pointed your category import tool to the web url with the Admin User name and Password.

Is there something else I need to check?

smile

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2