11.6 Migrating or Importing WordPress Data

Created by Danny Wong, Modified on Sun, 9 Aug, 2020 at 3:01 PM by Danny Wong

While it will likely be much easier for you to simply create your WordPress Posts, Pages, CPT's, Tags, Categories, and Custom Taxonomy manually, you can use the Importer to import them as well.

Here's a breakdown of what each of these CSV files should look like:

Posts CSV Format

Required Columns:

post_title -- The title of the Post.

Optional Columns:

Any standard fields accepted by wp_insert_post.
tax-<taxonomy slug> -- Whatever taxonomy terms that are associated with this posts. The taxonomy slug is provided with the column name by prefixing it with 'tax-'. The terms for this taxonomy to be applied to the post associated with the current row of the CSV will be provided as a comma-separated list of values.
All other columns in the CSV will be stored as postmeta.

Pages CSV Format

Required Columns:

post_title -- The title of the Page.

Optional Columns:

Any standard fields accepted by wp_insert_post.
tax-<taxonomy slug> -- Whatever taxonomy terms that are associated with this posts. The taxonomy slug is provided with the column name by prefixing it with 'tax-'. The terms for this taxonomy to be applied to the post associated with the current row of the CSV will be provided as a comma-separated list of values.
All other columns in the CSV will be stored as postmeta.

Custom Post Types CSV Format

When you select Custom Post Types in the MemberPress Importer you'll need to select the custom post type that you're uploading posts for.

Required Columns:

post_title -- The title of the Post.
post_type -- The Custom Post Type slug.

Optional Columns:

Any standard fields accepted by wp_insert_post.
tax-<taxonomy slug> -- Whatever taxonomy terms that are associated with this posts. The taxonomy slug is provided with the column name by prefixing it with 'tax-'. The terms for this taxonomy to be applied to the post associated with the current row of the CSV will be provided as a comma-separated list of values.
All other columns in the CSV will be stored as postmeta.

Tags CSV Format

Required Columns:

term -- The tag to be created or updated.
slug -- The slug of the tag.

Categories CSV Format

Required Columns:

term -- The category to be created or updated.
slug -- The slug of the category.

Custom Taxonomy Terms CSV Format

When you select CustomTaxonomy Terms in the MemberPress Importer you'll need to select the custom taxonomy that you're uploading terms for.

Required Columns:

term -- The term to be created or updated.
slug -- The slug of the term.
taxonomy -- The slug of the taxonomy the term belongs to.

Uploading the File

To upload the file that you have created, simply follow these steps:

Go to the MemberPress Plugin > Import. Once there, select Users from the type of file to import drop down menu:
Next, use the "Choose File" button to upload your file.
Finally, click the upload button.

Importer Messages

After you import your file, the importer will show you a couple of different lines and boxes to let you know how your import went. Below these are outlined.

X Rows Successfully Imported - Here, the importer will tell you how many rows (in the place of X) were successfully imported.

X Rows Failed to be Imported - Here, the importer will tell you how many rows (in the place of X) failed to import.

X Total Rows Processed - Here, the importer will tell you how many total rows (in the place of X) were processed.

Row Success Messages: - In this box you will see any success messages related to your most recent import.

Row Errors: - In this box you will see any errors related to any rows from your most recent import. The message should be detailed enough for you to be able to know what you need to fix so your file works properly upon import.

CSV for failed rows ... copy these, fix and reimport: - Here you will be given the exact rows that need to be fixed. Make note of them to fix the rows with the errors.