Creating Categories from Excel (3 posts)

  1. nakusya
    Posted 7 years ago #


    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 :)

  2. MichaelH
    Posted 7 years ago #

    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.

  3. nakusya
    Posted 7 years ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Topic