Monthly Archives: August 2021

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

Magento 2 Backend Exploration: Invoices

- E-Commerce, Magento 2

Magento 2 invoices generate import export

The article below provides a detailed description of the Invoices screen situated in the depths of the Magento 2 admin. We shed light on how to work with the corresponding grid and individual invoice pages. Besides, you will discover how to import/export invoices in Magento 2 most efficiently. 

The Magento 2 Invoices Screen chapter unveils various control elements associated with the corresponding admin page and describes the default Magento 2 Invoices grid. After that, we proceed to an individual invoice view associated with Magento 2. You will also learn how to create Magento 2 invoices, invoice orders, and print invoices. Besides, the article sheds light on how to import and export invoices in Magento 2 with the help of the Improved Import & Export extension.
Continue Reading

How To Import Configurable Product To Magento 2

- E-Commerce, Magento 2

improved import and export - Magento 2 extension

It is not a problem to import a single product to Magento 2, since you have all the necessary tools under System -> Export. But if you need to move configurable products from the old site, it may take a lot of time and effort, since in this situation the import procedure is much more sophisticated. However, it is still possible to import a configurable product with its simple products to Magento 2, and below we shed light on what is necessary for a successful import. Note that the following article only briefly describes the process. For further information on how to import configurable products to Magento 2, read this guide: The Complete Guide to Magento 2 Configurable Products.
Continue Reading

How to Import Data via GraphQL API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 graphql import export

The following article describes how to import and export data into/from Magento 2 with the help of GraphQL API. This connection type is yet impossible out of the box, but the community is working hard to introduce it as a replacement for REST API. At the same time, some tools enable Magento 2 GraphQL API import and export right now. For instance, you can leverage the Magento 2 GraphQL API import and export processes with the Improved Import & Export Magento 2 module. The following article sheds light on how to import data into Magento 2 via GraphQL API with the help of our extension. You will find out how to enable the Magento 2 GraphQL API import and what extra benefits it is associated with. If you are not familiar with what GraphQL API is, we’ve also prepared a chapter that describes this standard and its benefits over REST and SOAP. Besides, there is an FAQ section that provides answers to frequently asked questions about GraphQL and Magento 2 import/export processes.
Continue Reading

How to Import Data via SOAP API into Magento 2

Magento 2 SOAP API Data Import

Below, we shed light on how to enable Magento 2 SOAP API import. Unfortunately, this functionality is not possible by default, but you can add the missing feature to your e-commerce store with the help of a third-party extension. The following article sheds light on SOAP, compares it with REST, and offers a reliable tool for enabling the corresponding functionality for Magento 2. You can leverage the Magento 2 SOAP API import and export processes with the Improved Import & Export Magento 2 module

The following article sheds light on how to import data into Magento 2 via SOAP API with the help of our extension. We discuss how to enable the Magento 2 SOAP API import and what extra benefits you can get. If you are not familiar with what SOAP API is, we’ve also prepared a chapter that describes this standard. Besides, there is an FAQ section that provides answers to frequently asked questions about SOAP and Magento 2 import/export processes.
Continue Reading

How to update product price during Magento 2 import

- E-Commerce, Magento 2

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? With the default data transfer tools, you have to apply such adjustments manually to every product in your catalog. The more products you have, the more time you will spend. Therefore, nobody wants to calculate and apply each new price manually. In this article, we will tell you how to automate the process. You will need the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2 and introduces the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products. 

Continue Reading

How to Map (Match) Attribute Values During Import in Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Attribute Values Mapping Import

You might have already faced numerous problems caused by attributes and attribute values that don’t follow the Magento requirements. By default, it is impossible to import them to Magento 2. Different systems have unique requirements regarding the way information is stored in their databases. Therefore, you cannot transfer data between them directly. It is always necessary to apply changes to the output created beyond Magento 2 to run a successful import to your e-commerce website. And this process is usually time-consuming. The more unsupported values your data file contains the more work has to be done. 

However, there is a user-friendly way of editing third-party data. Meet the Improved Import & Export Magento 2 extension. The module lets you automate the attribute editing processes so that you can freely import data from external platforms to Magento 2. Below, we shed light on how to match third-party attributes and attribute values to the corresponding Magento 2 values during import. You will find a guide for the default Magento 2 import tool. After that, we provide a description of our approach that saves tons of time and lets you automate further data updates.
Continue Reading