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


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?


Answers (2)


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


Francisco Javier Carazo Gil answers:


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