How to import CSV into Custom Post Type custom fields?

1 Views

I have created a Custom Post Type and then used a plugin to create the custom fields for that post type.

It will display a type of membership:
Name
Address
Zip
Website

Read More

But I am stuck on how to take the csv file I have, which has 700 entries and import it to create 700 entries under the CPT I created and autopopulate the custom fields I created.

I tried a lot of plugins, but none seemed to do both parts. Some let me just select the CTP but I couldn´t get all the fields populated.

Just needed to know best way to accomplish this.

Post Views: 1

Related posts

3 comments

  1. I’m using a plugin called TurboCSV (found here, at the time of writing). The plugin offers support to add data to your various custom fields, which need to be created before the import takes place. In my personal use, I was able to successfully import thousands of items from one .csv, including hundreds of taxonomy terms and custom fields.

    Have a look at the plugin’s documentation to see how involved it is and how much you’re able to do.

  2. I used a plugin called Really Simple CSV Importer https://wordpress.org/plugins/really-simple-csv-importer/

    If that link is dead, you can find it on github here: https://github.com/dansullyLT/rs-csv-importer

    It populated my custom fields that I made in ACF.

    Here is how I used it.

    Download the sample CSV file the plugin dev offers you. You make each header row the field name and import through the WordPress > Tools > Import menu.

    You have to include a column of post_id and post_name, but you can leave them blank. Make the post_type column the name of your custom field group and set the post_status. You may get some errors on import, but just read them carefully and you’ll be able to correct them.

    It worked great for all of my ACF except images. My images were a little complicated though.

    Good Luck!

  3. http://www.wpallimport.com/

    There’s a free version of this plugin that should do all the necessary work to import Custom Post Types from a CSV or Excel file.

    The paid versions also allow you to import users and to better modify advanced custom fields associated with CPT’s as well.

Comments are closed.