Ask your WordPress questions! Pay money and get answers fast! Comodo Trusted Site Seal
Official PayPal Seal

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

2013-08-06 by Steve Watson

Answers (2)

2013-08-06

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-06

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.