"Magento 2 Developer’s Cookbook"

How To Update Order Status Via CSV In Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

In the following article, we shed light on how to update orders in Magento 2 with the help of CSV files. Since this procedure is impossible if you use the platform’s default import tools, many merchants try to find the most reliable and flexible solution. We will describe such an instrument below. In this article, you will learn how to update the order status in Magento 2 via CSV and files of other formats. As you might have already guessed, there is no need to reinvent the bicycle. It is only necessary to choose one of the available solutions. So, let’s see what Magento 2 extension lets you update orders in Magento 2 in the most flexible manner. Please, check our cookbook for more similar articles. Continue Reading

How To Fix Error 1062 Upon Magento 2 Database Import

- E-Commerce, Magento 2

Magento 2 Development; Magento 2 tutorial

We recently came across another StackExchange topic related to database import. While moving a database to Magento 2, user104747 faced an obstacle – ERROR 1062. We explain the problem in the following article. Also, you will find the suggested fix to this Magento 2 database import error below. Since the system does not allow you to move a database directly to Magento 2, the process may become fairly complicated. An output file with a specific object must always be created. And this procedure should adhere to numerous strict requirements. For instance, it is vital to divide your file into two distinct tables if it contains multiple categories of data (for example, products and orders). All other nuances are described below.

Additionally, you must always modify imported file attributes to conform to Magento 2 specifications. Otherwise, no database may be imported into Magento 2. Also, note that regular data transfers from a database to an e-commerce website cannot be automated. But all of these problems can be resolved with a single instrument. It doesn’t matter whether you want to fix error 1062 upon Magento 2 database import or implement the lacking data transfer capabilities, we know a perfect solution designed to address all the most common import issues. Meet the Improved Import & Export Magento 2 extension. After we go through a solution offered in the StackExchange discussion, you will find out how this module addresses database import problems associated with Magento 2. Read our Cookbook for more guidance and suggestions. Continue Reading

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

- Fire development, Magento 2, Our extensions

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 fix the “URL key for specified store already exists” issue on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s suppose that you need to import a product CSV file, that follows the Magento 2 requirements, to a new installation. What could go wrong? Unfortunately, several errors may occur when you do that, including “URL key for specified store already exists”. In the following article, we explore the issue on the example provided in a StackExchange discussion, where Zed Blackbeard argues that it is impossible to import products to Magento 2 due to the general system exception. Magento informs its administrator who runs the update that the URL key for the specified store already exists. After that, the system breaks the import. 

Below, you will discover the conditions that cause the problem. After that, the article provides several possible resolutions. To be more specific, we provide recommendations from the appropriate StackExchange discussion as well as deliver our approach that incorporates the Improved Import & Export extension. If you face other issues while using your Magento installation, you may try to find them described in this blog post: Magento 2 Cookbook.
Continue Reading

How to export a custom entity from Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s assume that you’ve created a custom entity in your Magento 2 backend. However, you cannot either import or export it using the default tools of your website. Furthermore, the built-in import and export solutions don’t let you transfer most default entities Magento 2 relies upon. So, is there any way to enable synchronization with third-party platforms and partners that ask for your newly-created custom record? 

As you’ve probably guessed already, you need a third-party import and export solution to import and export a custom entity in Magento 2. A reliable module lets you export a custom entity from Magento 2 as you do with products, orders, and other records. At the same time, you may try to implement one of the community-proposed solutions. But what way to choose? 

In the following article, we detailly describe a StackExchange discussion and the related data transfer case. Its author complains that it is impossible to export a custom entity from Magento 2. People in the thread propose different resolutions described below. Since they are aimed at tech-savvy users, most Magento merchants are not able to address the existing issue following these recommendations. However, the Firebear team provides a more user-friendly way to cover the existing gap between business needs and the default functionality of Magento 2. We explain how to export a custom entity from Magento 2 with the help of the Improved Import & Export extension. For more useful tips on import and export, follow this link: Magento 2 Cookbook.
Continue Reading

How to export customers with custom attributes in Magento 2

- E-Commerce, Fire development, Magento 2, Uncategorized

Magento 2 export CLI

We continue sifting the endless StackExchange desert in an attempt to discover the most helpful discussion. This time, our attention has been captured by an export-related issue. Transferring customer data from Magento 2 has never been a problem. Unless you change something. In this StackExchange discussion, the author created a custom attribute before moving prospect data from the website. However, the default export tool failed to satisfy the designated business requirements. 

Below, we shed light on how to fix the problem and export customers with custom attributes in Magento 2. We provide the solution from the StackExchange discussion. You will find a method that helped its author export customers with custom attributes from Magento 2. Note that it requires coding experience to be implemented. Thus, non-technical users won’t be able to satisfy similar business goals with this approach. Therefore, we also deliver an absolutely different way of transferring any custom buyer data from Magento 2 based on the Improved Import & Export module. The tool lets you work with any custom attributes and also delivers numerous other features that simplify data transfer processes.
Continue Reading

How to Import Disabled Products to Magento 2

- Fire development, Magento 2

Magento 2 import export debug log

If you cannot import disabled products to Magento 2, you’ve come to the right place. We will probably help you with that. Below, you will find two possible solutions. As usual, one of them is proposed by a StackExchange user, while another one is developed by Firebear specialists. In both cases, we deal with products that have the “disabled” status. As for the corresponding import file. It doesn’t contain the “status” column. If you add it, nothing changes. So, how to import disabled products to Magento 2? You will find the answer below. We also provide recommendations on how to import disabled products to Magento 2 automatically and via various file formats using Improved Import & Export. For more tips, proceed to our Magento 2 Cookbook.
Continue Reading

How to export custom SKU column from Magento 2 with all content

- E-Commerce, Magento 2

Magento 2 export CLI

How often do you face export processes that the default Magento 2 instruments cannot cope with? We regularly witness the inability to run even the most basic tasks, not to mention unique use cases that require additional customizations. For instance, we’ve come across a situation when the default export solution of Magento 2 wasn’t enough to transfer a custom SKU column. What’s the story behind this use case?

 Paras Sakariya has added a custom SKU column to a sales order grid. While the corresponding records appear on the backend side, no data is displayed in exported files. Below, explore this situation, providing possible resolutions. Firstly, we focus on the origins of the issue, describing the newly created custom conditions. After that, you will find a solution proposed on StackExchange. However, it is quite complicated and requires lots of technical knowledge. Therefore, we provide our own way to export a custom SKU column from Magento 2 that incorporates the Improved Import & Export Magento 2 extension. You can find more similar issues described in our Cookbook.
Continue Reading