Post, Page & Custom Post Import

Ultimate CSV Importer lets you import setup fields like WordPress Posts, Pages and Custom Posts created by third party add-ons. It includes all the default WordPress fields and custom fields of third party pluginsaddons. Import of Post and Page follows the general import procedure.

Post

In default, WordPress allows you to create posts for your website. The blogs that are shown on the site considered as posts. It is in chronological order. You can create posts for your website manually. But you have to create each post separately and update that on your site. It takes a lot of time and manpower to create and update posts. An alternative solution for this is to prepare a CSV or XML file that includes all your post data. Then upload and import that data with CSV Importer plugin.The figure below shows the post lists that are imported using WP Ultimate CSV Importer.

wordpress-bulk-image-import-csv

In categories and tag fields, you can add tags based on the post in comma separator.

Multiple & Nested Categories

You can mention the category values in your CSV like below, if you have to display multiple categories values for the appropriate post.

  • To use multiple categories you can use Comma separator.
    • Eg: WordPress Import,Data Import,Importer
  • Nested Category – Use > (greater than) symbol as separator.
    • Eg: WordPress Import >CSV Import
  • Multiple Nested Category – Use Comma separator for multiple categories and greater than symbol for nested category combination.
    • Eg: WordPress Import >CSV Import,WordPress Import >XML Import

The fields required for importing post CSV files are listed below and here you can get the Post CSV File

WP Field Description & CSV Values CSV Sample Value
post_title Your post title WP Ultimate CSV Importer Pro
post_content Your post content is Editable WP Ultimate CSV Importer Pro is an import plugin to import data into your WordPress from any CSV/XML file.
post_excerpt Your post excerpt WP Ultimate CSV Importer Pro is an import plugin.
post_date The published date of your post.
Format – yyyy/mm/dd
And add a space, then add the time
2018/09/20 10:30
post_category Mention the category name.
Refer below for Multiple & Nested categories.
WordPress Plugin
post_tag Mention the tag name. Use comma(,) separator to add multiple tags. Pro plugin,WP plugin,CSV import
post_author Add the author name(WordPress User Name) of your post. Smackcoders
featured_image Use media gallery URL or any publicly accessible external URL. http://www.planwallpaper.com/static/images/434976-happy-valentines-day-timeline-cover.jpg
post_slug Add your post slug. wp-ultimate-csv-importer
post_status Mention the post status. publish / draft / pending / sticky / private / protected.
For private and protected give the password within curly braces {loginpassword}
publish
post_format Mention the value to select the desired post format
0 – standard
1 – Aside
2 – Image
3 – Video
4 – Quote
5 – Link
6 – Gallery
7 – Audio
0

Custom Post Import

WP Ultimate CSV Importer allows you to import the Custom Post information created by Toolset Types, Custom Post Type UI, Pods, CCTM and CustomPress. The CSV values are the same as that of WordPress default Post fields.

Click here to know how to create a custom post using Toolset Types.

Page

Pages in WordPress are static and in non-chronological order. Home, About us, Contact us pages on the website listed inside the WordPress Pages section. You can create pages manually using WordPress.

But creating all pages data as a CSV file and importing them into WordPress is the easiest way to complete your work in a limited time.

wordpress-bulk-image-import-csv

The fields required for importing page CSV files are listed below and you can get the Page CSV File

WP Field Description & CSV Values CSV Sample Value
post_title Your page title WP Ultimate CSV Importer Pro
post_content Your page content is Editable WordPress Ultimate CSV Importer Pro is an import plugin to import data into your WordPress from any CSV/XML file.
post_date The published date of your page.
Format – yyyy/mm/dd
And add a space, then add the time
2018/09/20 10:30
post_author Add the author name(WordPress User Name) for your page. Smackcoders
post_slug Add your page slug wp-ultimate-csv-importer
post_status Mention the page status. publish / draft / pending / sticky / private / protected.
For private and protected give the password within curly braces {loginpassword}
publish
post_parent If you have a parent page for your current page, mention your Parent page Title or ID. WordPress(Parent Page title)
menu_order Specify a numerical value to order the menu.
By default, it is alphabetically arranged.
3
wp_page_template Some themes have custom templates you can use for certain pages that might have additional features or custom layouts.

Bulk image import by CSV Importer

WP Ultimate CSV Importer lets you upload bulk images into WordPress from your local computer or from any publicly accessible external URL along with the image SEO options.

1. CSV Preparation

Take a zip of all your images to upload into WordPress. Now mention the exact image location from where you’ve taken the zip followed by the image name(Eg: pictures/imagename.jpg). If you’ve taken a zip just the images, you can mention the images name alone in your CSV file. For images uploaded from URL, add the external URL in your CSV as mentioned in the below image.

wordpress-bulk-image-import-csv

2. Upload your CSV

Browse and upload your CSV file through four different locations. Then choose images in the import each record as field.

bulk-image-csv-upload

3. Mapping

Map the desired CSV and WP fields like Image titles, alt text, caption and description. In the Featured images section map your CSV header which contains the image name or Location.

Once done, navigate to the Media Upload fields section and upload your images zip file. You can also find this section in Drag ‘n’ Drop mode. Now, you can also delete any of the unwanted images at runtime.

wordpress-bulk-image-import-mapping

Click on Continue.

Media Handling

Enable the Download external images in your media. Click on ‘Download post content external images to media’, if you have to display inline images on the site. Otherwise click “Continue”.

bulk-image-upload-into-wp

Import images

Once done with the process, click on Import to upload all your images into WordPress Media Gallery along with its title, alt text, caption and description.

Import images along with your Post

WP Ultimate CSV Importer, lets you import both inline and featured images into your WordPress. You can either use the existing WordPress media images or external links of Google images, pexels, pixabay, etc,. For image import, you need to enable CRON (Refer our blog enable & Configure WP-Cron)

To import, enable the Download external images to your media in the Featured Image Media Handling.

Image Handling

WP Ultimate CSV Importer lets you handle duplicate images in 2 different ways.

  • Use media images if already available – Enable it to use your existing image.
  • Do you want to overwrite the existing images – Enable to overwrite the existing image with a new image(mentioned in your CSV).

Image sizes

Allows you to import images in a specific size. WP Ultimate CSV Importer offers you with different sizes like Thumbnail, Medium, Medium Large and Large. You can also add custom size to your images using the Custom size option.

SEO Friendly

WP Ultimate CSV Importer lets you import images along with their SEO fields like Image Name, Description, ALT text and Caption. For this, check on the fields that you need to import and map the desired CSV fields.

Finally, click Continue to proceed your import.

wordpress-image-import-media-handling

Import remote images without downloading into local media

It’s possible to import remote external images without localizing/downloading it into WP media. Also, you can switch to enable this download option at any time if needed. This is applicable to post content images which are 3rd party remote URLs. This feature does not affect the featured image import.

Important Note

  • The external URL with Password protected image cannot be uploaded.
  • The featured image will be visible, only if the theme supports.

Post Categories, Tags & Custom Taxonomies Import

Ultimate CSV Importer allows you to import Post Categories and Post Tags and Custom Taxonomies into your WordPress. You can import this either separately or along with your post.

Post Categories

The post category is used when you have to specify records based on their classification. For example, you’re owning digital marketing blogs. You have to split the blogs based on category. At that time you can use this field.

Create your CSV file based on the following table.

Get your Post Sample CSV File

WP Field Description & CSV Values CSV Sample Value
category_name Mention the Category Name. WP Ultimate CSV Importer
category_id Mention the category ID. 68753
category_slug Specify the Category Slug wp-ultimate-csv-importer
category_description Mention the Category Description. To categories the CSV Importer post.

Upload your CSV: You can create a category field in your CSV file. Upload files and choose Category in the ‘Import record as’ dropdown.

 category-upload-csv

Mapping: Map CSV file header with the WordPress fields to import the data in the correct field.

category-import-mapping

Import: Now you can import your Category information into your WordPress.

Category Update: You can update your categories based on category_id or category_slug.

category-update-csv-uploadcategory-update-csv-import

Post Tags

You can use post tags when you have keywords for your blog. You can add multiple tags to your blog. The below list describes the fields in the WordPress header.

Click here to get the Post Tag Sample CSV File

WP Field Description & CSV Values CSV Sample Value
tag_name Mention the Tag Name. CSV Importer
tag_slug Specify the Tag Slug. csv-importer
tag_decription Mention the Tag Description. Tags for CSV Importer

Tags Update:

You can update your category based on tag_id or tag_slug.

Custom Taxonomies

In custom Taxonomies, you can add extra taxonomies by providing the details of :

  • taxonomy_name
  • taxonomy_slug
  • taxonomy_description

The below-listed table explains the CSV values of custom taxonomies.

Here you can get the Custom Taxnomies Sample CSV File to test importing the custom taxonomies.

WP Field Description & CSV Values CSV Sample Value
taxonomy_name Mention the Taxonomy Name. CSV Importer
taxonomy_slug Specify the Taxonomy Slug. csv-importer
taxonomy_decription Mention the Taxonomy Description. Taxonomies for CSV Importer

Update Custom Taxonomies:

You can update taxonomy using taxonomy_slug and taxonomy_id.

eCommerce Imports

With the WordPress Ultimate CSV Importer plugin, you can import data from any third-party plugins. We provide support to import data of WP ecommerce plugin and Marketpress plugin.

WP eCommerce

WP ecommerce plugin is an ecommerce plugin, where you can store and post your product list. You can create a CSV file in the below table format and import the CSV file in WP Ultimate CSV Importer.

Click here for WP eCommerce CSV file.

  • The importer imports core fields, terms and taxonomies fields along with the meta fields.
  • The post_title field is mandatory.

The below-listed table is the field format to insert the CSV file.

WP Fields Description & CSV Values CSV Sample Value
notify_when_none_left
unpublish_when_none_left
is_taxable
no_shipping
special
google_prohibited
Specify the value to enable or disable this fields
1 – enable
0 – disable
1
0

WP eCommerce Coupons

Like the same, you can create a coupon based product CSV file for your Ecommerce website. Upload it on WP ultimate CSV importer. The below-listed table describes the field for coupon CSV.

Click here for the WP eCommerce coupon CSV file.

WP Fields Description & CSV Values CSV Sample Value
discount_type Specify the type of discount
Percentage / Fixed amount / Free shipping
Percentage
Use_once
Active
Apply_on _all_products
Specify the value to enable or disable this field
1 – enable
0 – disable
1
0

MarketPress

Get Sample CSV here.

  • The importer imports core fields, terms and taxonomies fields along with the meta fields.
  • The post_title field is mandatory for WP Ultimate CSV Importer. This is to avoid importing any empty posts.

The below table list describes the field headers and its values to include in the CSV file.

WP Fields Description & CSV Values CSV Sample Value
variation Specify the already existing product name. Multiple values are separated by comma( , ) Product A
Product A, Product B
regular_price Specify the normal price in numerical or float. Multiple values are separated by comma( , ) 2000,3689
10.2,10.34,95.22
sale_price Specify the sale price for the product in numerical or float – Multiple values are separated by comma( , ) 2000,3689
10.2,10.34,95.22
is_sale
track_inventory
track_limit
is_special_tax
Specify the value to enable or disable this field
1 – enable
0 – disable
1
0
inventory Specify the value for inventory in numerical form. Multiple values are separated by comma (,) 10,12

Users Import by Ultimate CSV Importer

WP CSV Importer lets you import your WordPress Users information from any CSV/ XML file. You can also import the user custom fields information created using WP-Members and Members.

user_login name and user_email are mandatory fields. Map these two fields before importing the users to avoid data import problem. Rows with no data in any one of the fields(login name or email ID) leads to skip the specific row import.

user-import

User Fields

You can create and import your user information from CSV/ XML in the below format. Get your Sample CSV file.

User Field Description & CSV Values CSV Sample Value
user_login Specify the username Smackcoders
user_pasword Mention your user password smackcoders
first_name MSpecify the user first name. Smackcoders
last_name Specify your user last name Technologies
nickname Mention your user’s nickname. Smack
user_email Your user email [email protected]
user_url Your user’s website URL. https://www.smackcoders.com/
user_nicename Specify your user’s nicename. Smackcoders
display_name Choose the name to be displayed in the admin panel. Mention any one name from the drop-down list. Smackcoders
role Mention your user’s role(small letters). Choose the desired role from the drop-down list. admin
biographical_infoe Add a short description of your user. Smackcoders is a fastest growing technology company.
disable_visual_editor Specify whether to enable/disable the checkbox.
Enable checkbox – 1
Disable checkbox – 2
1
admin_color Mention the currency value. 684
Images / Video / Audio / Text Choose your admin panel color theme from the available options(small letters). default/light/blue/coffee/ectoplasm/midnight/ocean/sunrise sunrise
enable_keyboard_shortcuts Specify whether to enable/disable the keyboard shortcuts checkbox.
Enable – 1
Disable – 0
1
show_toolbar Mention whether to enable/disable the checkbox.
Enable – 1
Disable – 2
1

WP-Members & Members import

With WP Ultimate CSV Importer, you can easily import the custom information created using WP-Members and Members plugin.

  • Members – Mention your desired custom user role created using Members. You can assign multiple user using pipeline separator(|). Sample CSV
    • Eg: Clara|Mishael
  • WP-Members – Mention your custom field values created using WP-Members.Sample CSV
WP-Member fields Description & CSV Values CSV Sample Value
Text Specify single line text here. Eg: To get your user company name or any other. Smackcoders
Textarea Mention the paragraph text. Eg: To get your user description.
Email Specify your email with standard @ and dot separator. [email protected]
File Specify the file path in your WordPress media gallery.
URL Specify your URL. https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html
Number Any numeric Values. Eg: User’s Phone number. 98710635456
Hidden Mention your hidden field value.

Import of WooCommerce customer information

If you have WooCommerce in your WordPress website, you can also import the customer billing and shipping information with WP Ultimate CSV Importer.

Cookies help us deliver our services. By using our services, you agree to our use of cookies.