Sql – Is it possible to export/import product categories in Magento

exportimportmagentosql

I saw one other question on how to do a mass import of products, categories, and all that, but all I want to be able to do is import my categories from one store to another.

When you export products I see that there is still a category ID attribute that it gives the products, but I don't see any options for exporting product categories.

I assume the simplest way would be to just copy over the tables with SQL, but when I export/import through phpMyAdmin it never works….

Any ideas?

Thanks,

Chris

Best Answer

Unfortunately, there isn't an easy way to import/export categories. I'm shocked that the functionality still doesn't exist for that (and for dropdown/multiselect attributes).

If you are versed enough with using APIs and something like SOAP, you can certainly interact with Magento's API and quickly add categories from a CSV or something like that. But, you do have to develop it yourself. That is pretty much your only option at this point though..

http://www.magentocommerce.com/wiki/doc/webservices-api/api#category_api

Related Topic