Bulk Wordpress Posts plugin

[AdminAdmin is verified member.]

I've been looking for a WP plug-in than can cope with setting the Posts status on thousands of posts from "draft" to "publish", without success.

There is a bulk edit option in WP but it fails after a few hundred posts at once.

To get around this, I ran the following SQL in PHPMyAdmin:

UPDATE  `%database%_wrdp1`.`wp_posts` SET  `post_status` =  'publish'

It works, quick and simple.

Hope this helps someone.

Admin

 

[fish]

jeeze, how come you needed to do that?

I hope you offset the published date on each of them as well?

 

[AdminAdmin is verified member.]

Importing an affiliate feed via a plug-in that set every post to Draft for some reason.

I removed the "posted" date, does that fool Google or not?