Bulk post type conversion

I have been given a client’s wordpress site to update & improve. Biggest problem – I need to take about 200+ posts of a specific category, ‘reviews’ and convert them all into a custom post type ‘reviews’.

On top of this I need to move a few custom fields that have been attributed to these posts, so they remain intact once moved.

I expect I’ll have to write a custom script that will change the mysql direct. But before I get my hands dirty- does anyone have any experience with doing this? Any tips/ gotchas/ scripts out there I can use?

Cheers

You are not really moving anything just changing a simple field named post_type for each post so you don’t have to worry about custom fields or anything else.

Simply get the post id’s for the posts you need to change and change them and if you don’t want to create a custom sql query for that you can even do that by WordPress:

//first get the post_ids as an array
/*the SQL way 
    global $wpdb;
    $querystr = "
        SELECT * FROM $wpdb->posts
        LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
        LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
        LEFT JOIN $wpdb->terms ON($wpdb->terms.term_id = $wpdb->term_taxonomy.term_id)
        WHERE $wpdb->terms.name="CAGETORY_NAME"
        AND $wpdb->term_taxonomy.taxonomy = 'category'
        AND $wpdb->posts.post_status="publish"
        AND $wpdb->posts.post_type="post"
    ";

    $post_ids = $wpdb->get_results($querystr); 
*/
//
//
//
/* the WordPress Way */
        $post_ids = get_posts(array('post_per_page' => -1, 'cat' => category_id));
    //then update each post
        foreach($post_ids as $p){
            $po = array();
            $po = get_post($p->ID,'ARRAY_A');
            $po['post_type'] = "NEW_TYPE_NAME";
            wp_update_post($po);
        }