"Magento 2 Developer’s Cookbook"

How To Import Customer Passwords To Magento 2

- E-Commerce, Fire development, 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

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 Products from Magento 2 via CLI

- E-Commerce, Magento 2

Magento 2 export CLI

Although most Magento 2 administrators prefer working with their e-commerce website strength in the admin area, there are still many people who require the same management opportunities to be implemented with the command line interface. However, the default data transfer solutions of Magento 2 don’t let you do that. Both import and export tools are useful only for basic purposes. If you want to export products from Magento 2 using the command-line interface, you need a third-party solution. In the following material, we describe how to transfer data via CLI from your e-commerce website with the help of Improved Import & Export. Besides, we shed light upon the corresponding data import processes. You can find more tips on how to work with Magento 2 in our Cookbook. To make the long story short, let’s focus on how to import and export products and other entities in Magento 2 via CLI.

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

How to Import Multiselect Attribute Values to Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 import export debug log

The default data transfer capabilities of Magento 2 still need various improvements, especially if you use the Open Source version of the platform. However, numerous community-based initiatives that tend to improve the basic functionality are at your service. They vary between coding tricks and standalone extensions. Depending on the complexity of your business, your technical skills, or the faced issues, you can select one that perfectly suits your needs.  What to do if you cannot find the solutions? Ask the community for support. 

Recently, we came across an interesting issue on Stackexchange. The author was wondering whether it was possible to create values for a multiselect attribute when uploading a CSV file. Below, we share two solutions: the community-based algorithm of addressing the problem and the Firebear-proposed tool. While the first one requires additional coding experience and is almost unreal to implement for non-technical users, the extension we offer is admin-friendly and intuitive so that anyone can use it to cope with the difficulties described below. 

To make a long story short, let’s explore the issue and describe how to import multiselect attribute values to Magento 2. More tips are available here: Magento 2 Cookbook.
Continue Reading

How to export data from Magento 2 in XLS & XLSX formats

- E-Commerce, Magento 2

Magento 2 export CLI

The default import and export capabilities of Magento 2 are fairly limited. Depending on the platform’s editions, they vary a little bit but neither of the existing versions lets you work with XLS and XLSX files by default. However, you can implement the missing functionality with a few lines of code or a third-party solution. 

In the following article, we depict the background of XLSX and XLS files and try to figure out what’s wrong with Magento 2 regarding them. You will find the existing solution to the problem posted on StackExchange. Since it is quite complex and not suitable for most merchants, we also provide a more user-friendly way of exporting data from Magento 2 in XLS & XLSX formats.

Recently, we’ve come across a question by user00247 where they ask how to export data from Magento 2 in an XLS format. Another StackExchange user proposes a solution that is provided below. Since it is aimed at technical users only, we’ve decided to elaborate the provided answer with an alternative, shedding light on how to export data from Magento 2 in XLS & XLSX formats for non-technical users. You will discover the difference between the two approaches and pick the one that is more suitable for you.
Continue Reading

How to Export Data to Custom Table in Magento 2

- E-Commerce, Magento 2

Magento 2 import export debug log

Recently, we described how to import custom CSV files to custom Magento 2 tables. This article is available in our Cookbook, and now it’s time to say a few words about the opposite process – exporting data to a custom table in Magento 2. Since this procedure is impossible by default, you need to learn a tiny trick to complete the procedure. So, how to export data from Magento 2 to a custom file?  Continue Reading