How do I bulk update or force publish all posts

  • I have imported 150K posts into WordPress showing post_status = publish, but most of the other fields are empty or zero.

    ‘post_date = 0000-00-00 00:00:00
    post_date_gmt = 0000-00-00 00:00:00
    comment_status =
    ping_status
    post_name
    to_ping
    pinged
    post_modified = 0000-00-00 00:00:00
    post_modified_gmt = 0000-00-00 00:00:00
    guid’

    When I edit a post and click the update button all the field are populated correctly.

    Hopefully I’m asking the right question- How do I bulk update or force publish all posts so all relative field values are populated?

    Thanks in advance, Murray

  • The topic ‘How do I bulk update or force publish all posts’ is closed to new replies.