Ask your WordPress questions! Pay money and get answers fast! Comodo Trusted Site Seal
Official PayPal Seal

Bulk Import Categories + Category Description WordPress

  • SOLVED

I have a list of about 400 categories I'd like to import into Wordpress 3.3.1.

They each have a parent category, and a description.

Wordpress offers no native method to do this.

Can you recommend a plugin or solution? Thanks.

Answers (4)

2012-01-22

Fahad Murtaza answers:

http://wordpress.org/extend/plugins/category-import/


SRD comments:

Thanks. This does not import the category description, which is important in my scenario.


Fahad Murtaza comments:

OK try CSV importer. i,e

http://wordpress.org/extend/plugins/csv-importer/

Create fake posts in CSV with all categories i.e 1 post per one category.

Once the categories are imported, delete the fake posts in bulk using the bulk delete plugin

http://wordpress.org/extend/plugins/bulk-delete/


SRD comments:

Thanks. This plugin doesn't mention anything about category descriptions, nor do any of the example CSV files. Adding a test field for category description does not work either.


Fahad Murtaza comments:

OK then you need to get one developed. I can develop a solution for you.


SRD comments:

Thanks. Approximate cost?


Fahad Murtaza comments:

Please inbox me.

2012-01-22

John Cotton answers:

Can you show us a couple of sample records?


SRD comments:

It's simply a CSV with data corresponding to the following columns:
Region; City; Description

Where Region is the parent category, City is the sub-category, and Description is the category description of the City.

It is for a business directory.


John Cotton comments:

Are you prepared to bump up the prize? Make it $50 and I'll write you something this morning.


SRD comments:

Sounds fair, John.


John Cotton comments:

Great - you bump the prize, I'll write some code.


John Cotton comments:

[[LINK href="http://dynamicarray.co.uk/clients/csv-category-importer.zip"]]Try this[[/LINK]]


SRD comments:

Is this accessed through Tools > Category Import?

If so, I select the taxonomy type for import as category, and upload it.

I receive a message:
<blockquote>13 parent terms added.
418 child terms added.
3 child terms updated.</blockquote>

There are only 16 categories created, which are the parent categories. There are no subcategories created.


John Cotton comments:

<blockquote>13 parent terms added.
418 child terms added.
3 child terms updated.
</blockquote>
That means it worked....

Try adding a temporary category manually (you can delete it afterwards) to make sure your cache is showing the correct list.


SRD comments:

Adding a temp category manually didn't fix it, nor did clearing the cache and doing a hard refresh.

A search of the database in PHPMyAdmin says the subcategories are found in a table called wp_importtowns


John Cotton comments:

<blockquote>A search of the database in PHPMyAdmin says the subcategories are found in a table called wp_importtowns</blockquote>

??? What's that?

The plugin uses wp_insert_term/wp_update_term so, unless you've got a very odd set-up, then the data will go into wp_terms/wp_terms_relationships etc...

If you'r happy PMing me your login details, I'll take a quick look.


SRD comments:

Never seen it before. The filename of the first CSV I used was import_towns.csv, but this didn't work properly, I think because it had ; as field seperators.

I changed ; to , and saved this as import_towns2.csv.

I'll PM you some details. Note, the database table prefix is not the standard wp_, it is a custom prefix as a security precaution.


John Cotton comments:

<blockquote> it is a custom prefix as a security precaution</blockquote>
That's fine - mine aren't either.


SRD comments:

Thanks John

Your plugin has done the job.

2012-01-22

Arnav Joy answers:

check this

http://wordpress.org/extend/plugins/wordpress-importer/


SRD comments:

This requires the import file to have been exported from an existing Wordpress website.

It hasn't; my import file is just a CSV file.

2012-01-22

S├ębastien | French WordpressDesigner answers:

i have a software i have coded which transform a tabel to csv you can import into wordpress.

I can do that in 2 minuts

send me an email to maildeseb @ gmail .com if you are interested