Bulk import of metadata from drafts

  • sulfurito

    (@sulfurito)


    8 years ago

    Hello, I have a big list of movies, already existing as drafts, with post title, post content and excerpt. I want to import movie metadata from (Spanish) IMDB. This forces me to enter search title and click search button, then accept and publish result.

    Is there a way to bulk this process or automate it in some way?

    Thank you

Viewing 1 replies (of 1 total)
  • Plugin Author Charlie Merland

    (@caercam)

    Hi @sulfurito,

    There’s no direct way to achieve this, but you can do it the old way by updating the posts’ post_status row from ‘draft’ to ‘import-draft’ directly in the database. If you’re familiar with MySQL you can use a tool like PhpMyAdmin to get a list of all your movies’ drafts and update their status:

    UPDATE wp_posts SET post_status = 'import-draft' WHERE post_type = 'movie' AND post_status = 'draft';

    Provided that your tables are prefixed with ‘wp_’. It goes without saying, but please do a complete backup of your database before anything so you can restore it later in case you break something.

Viewing 1 replies (of 1 total)
  • The topic ‘Bulk import of metadata from drafts’ is closed to new replies.