Ask your WordPress questions! Pay money and get answers fast! (more info)

Import blog posts from old blog as drafts WordPress

  • SOLVED

Hi Guys

I need to import 100's of blog post into another site but I don't want them to be published. I would like them to be imported as drafts so i can tell them apart from the current posts.

Is this possible?

Thanks
Steve

Answers (2)

2013-08-05

Navjot Singh answers:

Just run this sql query on the old site before running an import.

UPDATE 'wp_posts' SET 'post_status' = 'draft' WHERE 'post_status' = 'publish'


Steve Watson comments:

Haha, yes of course!

thanks Navjot

2013-08-05

Francisco Javier Carazo Gil answers:

Steve,

The easier way can be import all them firstly and then, create a little script to pass all them from published to drafts.