Monthly Archives: July 2021

How to Import Disabled Products to Magento 2

July 30, 2021 - 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

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

July 29, 2021 - E-Commerce, Magento 2

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

Chances are, you are going to connect your Magento 2 store to an external platform that works with order data. It can be any service that simplifies the default ecommerce routine or adds some new possibilities. ERPs, CRMs, warehouses, dropshipping systems, or carriers may require this information. Unfortunately, it is hard to provide it unless you use a third-party Magento 2 module. Below, we compare four different Magento 2 order export extensions: Amasty Export Orders, Xtento Order Export, Wyomind Mass Order Export, and Commerce Extensions Import Export Bulk Orders. Besides, you can check our Improved Import Export for Magento 2, which also helps to achieve the same goal and provides dozens of features that are not available with the solutions mentioned above. Continue Reading

How to Export Products from Magento 2 via CLI

July 26, 2021 - 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.

SAP Business One In-Depth Review: How to Use the Wizard to Execute an MRP Run in SAP Business One

July 24, 2021 - E-Commerce

sap business one tutorial

In the previous two articles about SAP Business One, we explain what MRP is and how to prepare for a new MRP run in SAP B1. With an accurate model of your business in place, you can leverage the potent tool to figure out how to get the materials you need, making or selling products in time. In the following article, we shed light on how to use the Wizard to execute an MRP run in SAP Business One and how to work with the provided data.

The blog post describes a basic MRP run in SAP Business One for a multilevel bill of materials. It focuses on the core steps of this process: selecting a scenario for your MRP run, choosing items, specifying inventory data sources, providing documents, executing the MRP run, and taking action. Besides, you will find out what consuming forecast and order consolidation are.

Amasty Export Orders Extension for Magento 2 and 1

July 23, 2021 - E-Commerce, Magento 2, Magento tips & tricks

Amasty Magento 2 Order Export module review

If you are looking for the most powerful migration tool for Magento 2 or Magento 1, check out our Improved Import Magento 2 Extension and Improved Import Magento Module.

The Magento marketplace also offers alternative solutions for improving the default Magento import/export process. In this post, we shed light on the Magento 2 Export Orders extension by Amasty. This tool offers only export features but does everything quite well. Also, note that we’ve compared the Amasty Magento 2 export orders module with other similar extensions here: Magento 2 Order Export Extensions Comparison.

The best Magento 2 extensions | The best Magento extensions

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

July 23, 2021 - 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 Product Images into Magento 2 in Bulk

July 22, 2021 - Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

Below, we describe how to import images into Magento 2 in bulk. You can add them to product pages one by one but what if there are thousands of items on your storefront? In this case, manual upload doesn’t seem to be a good idea. However, there are two methods described in the official documentation that dramatically simplify your efforts. First of all, you can leverage your local server to upload product images to Magento 2 in bulk. Secondly, the system lets you use a remote server for this purpose. However, both methods incorporate the default data transfer instruments of Magento 2 which are a little bit limited. Alternatively, you can use the Firebear Improved Import Magento 2 extension. Let’s see how the default methods look and what benefits our module offers. For more useful tips visit our Magento 2 Developer’s Cookbook.
Continue Reading

How to import data from external MySQL database to Magento 2

July 21, 2021 - E-Commerce, Magento 2, Our extensions

Magento 2 mysql data import

Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases.

In the following post, we shed light on how to achieve this goal in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.

On the contrary, you will find out how to avoid numerous unnecessary chores while importing data to Magento 2 from a MySQL database. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.

After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
Continue Reading

How to Import Individual Product Data for Each Store View in Magento 2?

July 20, 2021 - Fire development, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

In case you run a multilingual storefront, this article is for you. Below, we explore a situation when you need to transfer product data to Magento 2 per store view. While this procedure may seem quite exhausting when you use the default import tools, there are several ways to simplify these data management chores. Below, we provide community-based recommendations for both Magento 1 and Magento 2. At the same time, you will find a solution proposed by the Firebear team.

The article incorporates materials from the StackExchange question by ruuter. Once we came across it and decided to share our experience in the same area. Thus, if you don’t know how to import individual product data per store view, we will teach you how to do that.

Also, note that the article compares the traditional approach that works for Magento 1.X with the new way introduced in Magento 2. As for the improved solution, we shed light upon how to automate product import processes, transfer product data per store view from external sources, and use alternative data sources, such as Google Sheets or API connections. Continue Reading

How to Export and Import Magento 2 Categories

July 20, 2021 - E-Commerce, Magento 2

Unfortunately, Magento 2 doesn’t let you import and export categories by default. Although the platform’s capabilities associated with data transfers are fairly limited, you can address the existing issues with ease. It is necessary to install a third-party module to import and export categories to Magento 2. In the following article, we shed light on how to transfer an existing category tree to/from your e-commerce website using the Improved Import & Export Magento 2 extension. After describing the Magento 2 category export, we peruse a sample import table that contains product categories. After that, our attention is focused on specific Magento 2 category attributes: we explore use cases and attribute mapping to let you transfer categories to Magento 2 from any external platforms. Next, there is a detailed step-by-step guide that depicts Magento 2 category import. Also, you will find out how to import product positions in categories (a part of the Visual Merchandiser functionality of Magento 2) and move Magento 2 categories per different store views.