Magento

Hello,

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

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

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 !
Thanks in advance.

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.

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

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

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/

We welcome donations if you want to see this tool enhanced and more robust…

Thanks.

We can’t add category description? :/

Good question. Not at this time.
There are a lot of things that we could do to enhance this import tool. If you guys want to speed things up you are welcome to make a donation to support the project.

OK, thanks a lot.

VisualFrames - 27 October 2008 07: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…

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.

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?

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

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

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 12:25 PM

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