How to Run Product Import in Magento 2 from CLI

If you want to optimize your daily routine related to Magento 2 product import, you’ve come to the right place. Below, we shed light on several data transfer optimizations that will help you save tons of time spent on daily chores. Many merchants look for tips on how to import products to Magento 2 using the command line interface or an alternative way to achieve the same goal. Below, you will find the answer. The following article is based on the StackExchange question by Massimo Camoni and the answer by Khoa TruongDinh. However, it extends the solution provided in the discussion. So, let’s see how to run Magento 2 product import via CLI. Also, you will find out what commands to use to export products from Magento 2.

The StackExchange Approach

According to Khoa TruongDinh, you cannot import products to Magento 2 using CLI in the most efficient way. Instead, he proposes to set up the Scheduled Import for the Commerce version under System > Data Transfer > Scheduled Imports/Exports. You can read more about the feature here: Data Scheduled Import Export.

The Improved Import Approach

If you’re using the Open Source version, you should rely on third-party modules, such as the Improved Import & Export Magento 2 extension.

Our module fully supports cron enabling you to create any custom schedule of updates. There is no need to use CLI commands since everything can be configured within the extension’s backend in the most user-friendly manner.

You need to know the standard cron syntax to create a custom update schedule. Alternatively, it is possible to select one of the predefined time intervals to run the update. Besides, you can still run product import asynchronously in manual mode.

For further information about the extension, follow this link:

Download/Buy Improved Import & Export Magento 2 Extension

How to Run Product Import in Magento 2 from CLI

The default import tools of Magento 2 don’t let you use CLI. As you might have already guessed, Improved Import & Export solves this problem. With the extension, you can enable, disable, or start export processes from the Magento 2 CLI interface. Run the following commands in the Magento 2 root folder:

Also, check these CLI export commands:

Note that you have to create corresponding jobs for both import and export processes.

We hope the article was useful. For other Magento 2 tips, check our Cookbook.

Magento 2 CLI Import & Export FAQ