Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"Magento 2 Developer’s Cookbook"

How to Run Product Import in Magento 2 from CLI

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

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.
Continue Reading

How to Import & Export WSDL Data to/from Magento 2

Magento 2 Development; Magento 2 tutorial

In the following article, we shed light on how to import and export data between Magento 2 and other systems using WSDL. Below, we define what WSDL is and how to manage it. You will find out the background of the Magento 2 WSDL import & export with the Improved Import & Export extension. Besides, we shed light upon the WSDL structure and elements, including the WSDL message part and port type binding. The benefits of WSDL are also listed below. And since the article described various data transfer processes based on the Improved Import & Export module, we also highlight the most important features of the extension. 
Continue Reading

How to fix store ID-related issues on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

StackExchange teems with interesting and useful tips related to Magento 2. This time, we’ve dug up a discussion where the author named Jackson complains about store ID-related issues that occur in Magento 2. Let’s take a look at the problem and provide several possible solutions. Jackson points to a particular script used to import data from a CSV file. However, the use of ->setStoreId(0) causes an issue – two values for the same field in the database table occur. As a result, it is necessary to delete second values to enable changes on the frontend but it often leads to the incorrect display. How to address the problem? You will find out how to fix store ID-related issues on Magento 2 import as it is portrayed in the discussion. At the same time, we provide a reliable alternative based on the Improved Import & Export. Also, you will discover other improvements associated with the module.
Continue Reading

How to Export Products, Orders, Customers, & Other Magento 2 Entities to Remote FTP & SFTP Server

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Unfortunately, Magento 2 doesn’t provide any opportunities to export products, orders, customers, or other Magento 2 entities to a remote FTP or SFTP server. You have to run a standard export procedure instead and transfer the output manually. Besides, it is impossible to automate this process. The system leaves you in a situation when it is necessary to repeat all its steps manually every time an update is required. Luckily, there is a better way of achieving this goal. As you’ve probably guessed, it involves a third-party solution. In our example, we use the Improved Import & Export Magento 2 extension to export products, orders, customers, and other Magento 2 entities to a remote FTP/SFTP server. It also lets you import all entities from this file source. Continue Reading

How To Import/Export Categories to Magento 2

Magento 2 Development

Below, you will find a brief description of how to import/export categories between two Magento 2 websites. Unfortunately, this functionality is not available by default. Magento 2 leaves you alone with a huge category tree. You need to recreate it manually or rely on third parties. And we know for sure how to import and export Magento 2 categories most efficiently. This post was inspired by the Magento StackExchange discussion. Question by Rafael Corrêa Gomes; answer by KAndy. However, it is only a partial overview of the Magento 2 category import and export. A full-featured guide on how to import and export categories, with all attributes explained can be found here: Read full-featured Magento 2 Category import and export guide. Continue Reading

How to Configure Import CSV File Size in Magento 2

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

While importing a CSV file into Magento 2, you may face the following restriction: the size of your file is more than allowed. Below, we shed light on how to change the file size limit in Magento 2. You will find a step-by-step guide on how to apply a new value to the existing restriction. Besides, we shed light upon how to avoid the timeout issue in Magento 2. If you are interested in more tips related to Magento 2, view our Developer’s Cookbook. Continue Reading

How to Run Product Import on Daily Basis in Magento 2

- E-Commerce, Magento 2

Magento 2 Development

Below, we shed light on how to run Magento 2 import processes on a daily basis. You can do that either in your admin interface or via CLI. While Magento 2 doesn’t let you automate data transfer processes and there is no way to use CLI to control imports and exports, you can enable the missing functionality with the help of third-party solutions. In the article below, we explain how to run Magento 2 import processes daily and use CLI to control them with the help of Improved Import & Export.

Also, you can look for an alternative point of view on Magento StackExchange. Take a look at the question by Massimo Camoni and the answer by Khoa TruongDinh. Since we leverage the advanced import functionality of the Improved Import & Export extension to address the issues mentioned in the discussion, you will also find a section that describes other possibilities the module provides.
Continue Reading

How to Import Custom CSV to Custom Table in Magento 2

Magento 2 import export debug log

Recently, we were surfing on the endless StackExchange surfaces and stumbled across an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand. Its probability for an average e-commerce business seemed to be high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue we are going to discuss?

Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although forum members provided several ways to achieve this goal, we didn’t find any user-friendly solution aimed at people with less technical skills than required by the most rated answer. Variants discussed on StackExchange seem to be highly efficient but too complicated. However, there is one more way to import a custom CSV file to a custom table in Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. Since the latter is based on the Improved Import & Export extension, we also share its core features after discussing the corresponding resolution.
Continue Reading

How to import XML to Magento 2

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

We all know that Magento 2 supports CSV import/export by default, but what if you need to transfer data via XML files? Although the default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, there is an opportunity to achieve the goal mentioned above. 

Since the system supports only the CSV standard, you need to convert your XML files to the supported file type. If you don’t want to do that, meet the Improved Import & Export Magento 2 extension. This module offers a more user-friendly solution for importing XML to Magento 2. With its help, you can move all the necessary information to your e-commerce store without converting it to CSV.

In the article below, we provide the description of how to import XML files using the default Magento 2 tools. Besides, you will find a step-by-step guide to Magento 2 XML import and export. More useful tips for Magento 2 users are gathered in our Magento 2 Developer’s Cookbook.
Continue Reading

How To Import Customer Passwords To Magento 2

Magento 2 import customer passwords

What if you need to transfer customer data to Magento 2? You can use the default import tool to do that. However, it doesn’t let you move all the prospect-related information to your database. For instance, it is impossible to migrate customer passwords from external systems. Attempts to address this problem have been made utilizing numerous approaches. Below, we describe two of them. 

You will find out how to import passwords to Magento 2 from external systems by manually editing your data files. Alternatively, we describe how to import the existing customer data including passwords to your e-commerce website on the basis of the Improved Import & Export extension

The problem is that the new platform version utilizes an updated algorithm for storing passwords. Hence, users claim that after migrating to Magento 2 from Magento 1, registered prospects have to re-enter their passwords on a new website. 

Continue Reading