Support » Installing WordPress » Creating Categories from Excel

  • Hi,

    I have a wordpress site that will have over 800 categories. I have created the hierarchy in Excel and dynamically created the relavant Headspace fields depending on where a category is in the hierarchy.

    My question is, how can get these categories created in my wordpress site? I need the categories created in order as well so that the default URL for a post with multiple parents follows a specific path

    Thanks in advance 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • Might look at the code that WordPress uses to populate the ‘first’ category when doing an install–see wp-admin/includes/upgrade.php lines 96-99 (version 2.7.1). Then just create tne necessary SQL statements to use, either in phpMyAdmin or in a script.

    Hi Michael,

    Thank you for this. As I am very new to WP and SQL etc, I hope I understand what you are saying.

    Basically SQL Statements can be used either in phpMYAdmin to create the category structure exactly as it is in Excel and then go to wp-admin/includes/upgrade.php lines 96-99 (version 2.7.1) to change the category ids?

    I am using 2.7.0 as there are some plugins which dont work in 2.7.1 – will I be looking at the wrong line in this case?

    Thanks once again 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Creating Categories from Excel’ is closed to new replies.