The last couple months I’ve been very focused on adding the most requested feature, CSV Export, and I’m happy to announce that last week an update to Connections was released, version 8.5.6, which includes the last of the CSV Export tools-the CSV Category export tool. Just like the other CSV export tools added in the previous versions, it is as easy to use as clicking a single button. My test database of categories consists of nearly 2,000 categories and this tool is able to export them in mere seconds. The fields included in the export are the category ID, name, slug, description and parent. The parent field will even show you the ancestor categories if you have a nested category configuration.
As promised, this update also includes a CSV Category Import tool. A lot of work went into creating and testing this new tool and I believe it to be a very solid and robust tool that supports bulk importing of nested categories. One of my test CSV files was the US zipcodes, of which there are over 43,000. This import tool was able to easily import all of them and, more importantly, it was able to import all of them properly nested under their respective state!
Now, I do have to add a disclaimer. Just because you can import that many categories does not mean you should. If your site is not highly optimized and running on a robust server your site could suffer slower page load times on pages where all categories are needed to be displayed in the browser. This is not a Connections issue or bug. When dealing with that many post categories in WordPress there will be similar page loading issues if you are running your site on an inexpensive shared host. Now, a few hundred or a couple thousand should be plenty doable.
Disclaimer aside, if you would like to learn more about how to use the CSV Category Import tool, please check out the documentation. The documentation includes many examples, including example CSV files. I think you’ll find that this tool is not only robust but very flexible!