Import data with WP–CLI

WordPress Ultimate CSV Importer now supports WP – CLI.

Import your Data with WP – CLI(WordPress Command Line Interface), no need for a web browser. It is a powerful command line tool to run and import your data.

You can use WP – CLI to do multi-tasks in the WordPress Database. You’ll note that WP-CLI contains streamlined commands designed for WordPress sites if you’re familiar with utilizing SSH commands. WP – CLI import helps to import the data faster and avoid the timeout error.


For Linux/Mac Users:

To check WP – CLI installation with CSV importer, type the following command in Command Prompt.

cd /var/www/html/(wordpress root file)/wp –help

And Enter.


Once the plugin is installed, the list will include our import plugin.



For Windows Users:

  • Install SSH Client, PuTTY
  • (PuTTY is a reasonably well-known SSH client, and installing and configuring it should be rather simple.)
  • Enter your Host Name


  • Select SSH from the Radio button option
  • Click Open
  • Your username and password must be entered when requested.
  • If we establish a connection to our server, we should see if our host has pre-installed WP-CLI.
  • Check this by typing the following command into the prompt.

cd /var/www/html/(wordpress root file)/wp –help



Import data with CSV/XML

You can import the data of posts/custom posts/ pages/ Users/ WooCommerce and many more. For Custom fields, create a field with the supported third-party plugin. Then create a CSV file based on that.

The import process is the same as the normal import till the Media Handling section.

Step 1 – Browse a file

Select any one of the modules from the import. We are providing four options to upload the required CSV file. Upload files from the desktop, FTP, external URL, and from the server.

(Note: If you are updating the data, select Existing Items.)


Once the file is uploaded, select the desired option from “Import each record as”.

Step 2 – Mapping Section

In the mapping page, map the WP fields with CSV header fields.


Check all the necessary fields are mapped and click continue.

Step 3 – Media Handling

To download external images in your WP media, Featured Image Handling is used. You can configure this by enabling the ‘Download external images to your media’ button. This option is enabled by default. Feature Image handling option allows you to assign new or existing WP gallery images.



Step 4 – WP Ultimate CSV List and Run

Open your Command Prompt.

Then log in with the User name and Password.

Using WP Ultimate CSV importer PRO

Type the following command to get the CSV file to run.

wp ultimate-import list


Then the list of files with the template name and ID will appear.

Type the following command to run the import with a specific template ID.

wp ultimate-import run (ID)

Ex: wp ultimate-import run 3


 Here, we can see the data progress details also.

Also, the log details will be displayed after the completion of the import.



Using CSV importer – Free version

Type the following command to get the CSV file to run.

wp ultimate-csvimport list


Type the following command to run the import.

wp ultimate-csvimport run (ID)

Ex: wp ultimate-csvimport run 1,3

(Using comma separator for Multi-import)



Using WPML

Type the following command to import the data with the WPML plugin.

wp ultimate-wpmlimport list


To import with a specific template ID, type the below command

wp ultimate-wpmlimport run (ID)

Ex: wp ultimate-wpmlimport run 3



Using WP Custom Fields

Enter the following command to get the CSV file template.

wp ultimate-cfimport list


Mention the following command to run the import.

wp ultimate-cfimport run (ID)

Ex: wp ultimate-cfimport run 1


We can import multiple templates using a comma (,) separator.

Eg: wp ultimate-import run 1,2



Update data

Enable the Existing Items options to execute the update operation. Start by importing your updated CSV or XML file. Configure the Mapping and Media Handling section that follows the same update procedure. With the WP Ultimate CSV Importer plugin, update all the WordPress field data by enabling Do you want to handle the duplicate on existing records?

csv-importer-update data-via-wp-cli