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 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

How to export specific data sets for a particular entity in Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

Another interesting StackExchange discussion has recently come under our scrutiny. This time the problem was associated with the inability to export relevant data from Magento 2. The user under the Magento Team nickname wondered how to add the Select All option into the Export Settings of Magento 2. The task was to export a single attribute of a product. However, this action is impossible in Magento 2 by default. Let’s see how tech-savvy users can address these issues and share a more merchant-friendly solution of exporting relevant data from Magento 2. Continue Reading

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

- E-Commerce, Magento 2

Magento 2 export CLI

Recently, we’ve come across a question by user00247 regarding how to export data from Magento 2 in an XLS format. Another StackExchange user proposed a solution that is also provided below. However, it is aimed at technical users only. Therefore, we’ve decided to elaborate the provided answer with an alternative solution, shedding light on how to export data from Magento 2 in XLS & XLSX formats and what’s the difference between them. Before going any further, pay heed to the fact that Magento 2 supports neither XLS nor XLSX files by default. Continue Reading

How to export a custom entity from Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s assume that you need to export a custom entity from Magento 2 as you do with products, orders, and other records.  However, the platform doesn’t let you do that by default. The list of supported entities is quite limited. In the following article, we explain how to extend it and achieve your goal. 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

Magento 2 export CLI

We continue sifting the endless StackExchange desert looking for 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. Below, we shed light on how to fix the problem and export customers with custom attributes in Magento 2 more efficiently.  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

Zed Blackbeard argues that it is impossible to import products to Magento 2 due to the general system exception. Magento notifies that the URL key for the specified store already exists and breaks the import. In the article below, we explore conditions that cause the problem and offer several possible resolutions. You can find more similar articles in this blog post: Magento 2 Cookbook. Continue Reading