insert post ID with wp_insert_post

Question

how can I choose post ID, when inserting new post, ex:

$post = array(
'ID'                =>  3333,
'comment_status'            =>  'open',
'post_content'      =>  'hi world!',
'post_name'         =>  'title_1',
'post_status'       =>  'publish',
'post_title'        =>  'sdfsfd fdsfds ds',
'post_type'         =>  'post',
);  

$post_id = wp_insert_post($post);

want to insert new post with id = 3333

`id` is an auto increment primary field in the database. I don't suppose you can do that. Why exactly do you want to do this? — Dogbert, Jul 02 '11 at 16:41
I also have a situation where this is necessary. I am migrating thousands of custom posts from another site, each with taxonomy and meta data. By setting the post ID to the same as the old site, it makes it much easier to import the rest of the data. I was able to use `import_id` successfully, as suggested by @daveaspinall below — Astrotim, Jun 19 '13 at 13:05
For future readers, please scroll below the accepted answer as there is a *very* useful answer below. — armadadrive, Aug 16 '21 at 19:30

score 27 · Answer 1 · edited Jun 14 '14 at 14:06

27

Thought you might like to know you can use 'import_id' instead of 'ID' and it will "try" and use that.

See the second example here: http://codex.wordpress.org/Function_Reference/wp_insert_post#Example

edited Jun 14 '14 at 14:06

BenMorel

34,448
50
182
322

answered Nov 16 '11 at 15:16

daveaspinall

1,395
1
17
28

score 10 · Answer 2 · edited Sep 07 '19 at 05:37

Here is my simple solution:

//check if post with id 3333 is already in database, if so, update post 3333
if (get_post_status(3333) ) {
    $post = array(
    'ID'                =>  3333,
    'comment_status'    =>  'open',
    'post_content'      =>  'hi world!',
    'post_name'         =>  'title_1',
    'post_status'       =>  'publish',
    'post_title'        =>  'your title',
    'post_type'         =>  'post',
    );  

    $post_id = wp_insert_post($post);
}
//if not in database, add post with id 3333
else {
    $post = array(
    'import_id'         =>  3333,
    'comment_status'    =>  'open',
    'post_content'      =>  'hi world!',
    'post_name'         =>  'title_1',
    'post_status'       =>  'publish',
    'post_title'        =>  'your title',
    'post_type'         =>  'post',
    );  

    $post_id = wp_insert_post($post);
}

'ID'=> post_id will update that post, while 'import_id'=> post_id will create a new post with that id.

You can also loop through and feed the IDs to run multiple insertions/updates without the risk of creating an infinite amount of new posts.

Thanks for telling about "import_id" – Farzad Hoseinzade Jun 23 '20 at 12:15 — Farzad Hoseinzade, Jun 23 '20 at 12:15

score 2 · Accepted Answer · answered Jul 02 '11 at 16:49

2

Sorry buddy, not doable. Here is what the devs say at the codex:

IMPORTANT: Setting a value for $post['ID'] WILL NOT create a post with that ID number. Setting this value will cause the function to update the post with that ID number with the other values specified in $post. In short, to insert a new post, $post['ID'] must be blank or not set at all.

http://codex.wordpress.org/Function_Reference/wp_insert_post

answered Jul 02 '11 at 16:49

Banago

1,350
13
22

5

This is not actually the correct answer (despite being accepted). See this answer instead http://stackoverflow.com/a/8153962/192705 – Ben Mar 06 '17 at 09:29

score 1 · Answer 4 · answered Jun 03 '13 at 12:54

As daveaspinall say. I do a function that do that.

require( 'wp-load.php' );
function simpleImportPost($title,$import_id,$content){
// Create post object
$my_post = array();
$my_post['post_title'] = $title;
$my_post['import_id']=$import_id;
$mypost['comment_status'] = 'closed';//I'll set all closed
$my_post['post_content'] = $content;
$my_post['post_status'] = 'publish';
$my_post['post_author'] = 1;
$my_post['post_category'] = array(0);
// Insert the post into the database
return wp_insert_post( $my_post );
}

example:

simpleImportPost('My Post 35',35,"35 Content");

score 0 · Answer 5 · answered Oct 12 '11 at 22:52

It is possible to do this, just not with the API's insert function. You can write your own INSERT query instead. You always want to use the API when you can, but sometimes it's not possible. The query would look like this:

global $wpdb;
$wpdb->query( $wpdb->prepare("
    INSERT INTO {$wpdb->posts}
    VALUES( %d, %d, NOW(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s, %s, %d, %s, %d, %s, %s, %d )",
    $ID,
    $post_author,
    $post_date_gmt,
    $post_content,
    $post_title,
    $post_excerpt,
    $post_status,
    $comment_status,
    $ping_status,
    $post_password,
    $post_name,
    $to_ping,
    $pinged,
    $post_modified_gmt,
    $post_content_filtered,
    $post_parent,
    $guid,
    $menu_order,
    $post_type,
    $post_mime_type,
    $comment_count
) );

You'll have to make sure that the ID doesn't already exist in the database first. If the post table schema changes in the future you may need to update the query to account for the changes.

insert post ID with wp_insert_post

5 Answers5

Linked