WordPress CSV importer custom field

Many people (including me) are searching for, and asking how you can use custom fields in the WordPress CSV importer. The plugin page says:

Any column that doesn’t start with csv_ is considered to be a custom field name. The data in that column will be imported as the custom fields value.

So I made an excel spreadsheet with 2 columns:

  1. csv_post_title
  2. (example) my_custom_field

And by importing this CSV file WordPress gave me the following error:

Skipped 3 posts (most likely due to empty title, body and excerpt). Imported 0 posts and 0 comments in 0.23 seconds

But after trying different combinations of column names as: csv_post_post and csv_post_type nothing worked and every time WordPress gave me the error. So maybe it was my CSV file that isn’t saved the right way. Then I went to Google Drive where you can make spreadsheets. I made a Spreadsheet in Google (the same as my old one, with the 2 columns), Saved it as CSV file, imported it with WordPress CSV importer and it Worked!

So my solution for importing Custom fields in WordPress CSV importer is to use CSV files from Google Spreadsheet.


Search and replace WordPress plugin

With search and replace plugin you can simply search in all your posts, posts from specific categories or specific pages and replace words. This is very helpful if you have many items in your database.


Simple pagination WordPress plugin

A simple pagination plugin: http://wordpress.org/extend/plugins/simple-pagination/installation/

Install it, set the settings and add the following code in your template where you want to show the pagination items.

<?php if(function_exists('wp_simple_pagination')) {
} ?>

You Can also use it for pagination of WordPress comments.

<?php if(function_exists('wp_simple_comments_pagination')) {
} ?>

WordPress advanced custom fields

The WordPress Advanced custom fields is my most used WordPress plugin. This plugin offers you the opportunity to add all kinds of custom fields to your post, page and category pages to specify information per post, page or category.

This plugin offers you a comprehensive documentation page where you can find everything how to use it in your templates.

The WordPress Advanced custom fields plugin page.


WordPress CSV importer

To import multiple posts in one time in WordPress you can use the WordPress CSV importer. This is the best free .csv importer for WordPress. You simply make a .csv file and make a list of post names with at the top of the row: “csv_post_title” so WordPress recognizes which title must use for the post. You can specify post information by extra rows like: “csv_post_post and” “csv_post_categories”. For all information tags visit the “other notes” of the plugin page.