Now compatible with Magento 2.4.4 PHP 8.1 Check new release of Improved Import & Export

"Magento 2 import"

FireBear Improved Import & Export for Magento 2 – Extension Change Log

- Magento 2, Our extensions
improved import and export - Magento 2 extension

The following blog post will help you retrace the evolution of the Improved Import & Export Magento 2 module. The article gathers updates associated with the extension’s each new version from the very beginning. At the time of 1.0.0, it was a basic import solution with an existing import jobs architecture and import cron automation. With the next few versions, the module got such enhancements as product attribute import on the fly, transfers from FTP, SFTP, URL, and Dropbox, custom mapping, etc. Each new release made the Improved Import stronger and stronger. However, it was still an import-only tool until 1.5.0 was released. With this version, our extension became capable of both import and export processes. You can peruse the detailed evolution of the module and see its latest features below. 

Extension Manual | FAQ | Demo | Sample Files

3.8.1 (released 7.11.2022)


  • Full compatibility with Magento 2.4.5
  • Added possibility to assign customer group to customers using the customer group name with “Customers Main” entity. The following fields have been added to the “Customers Main” export and import: _customer_group_code (name of the customer group), _tax_class_name (name of the tax assigned to the customer group), _tax_class_id (ID of the tax assigned to the customer group). The customer group can only be created if the tax class specified already exists at the store.
  • Added ability to use auto-increment for order increment_id. Meaning that if you do not have an increment_id – it will be generated and assigned automatically. Useful when importing orders from your CRM or ERP, or integrating with a marketplace.
  • Added feature “Update Products that are not in the import list” for product import. Which allows to set products inside your catalog, which are missing from the imported file as: out of stock, quantity=0, out of stock with quantity=0, disabled.
  • Added system events for import and export jobs which can be used as hooks during the integration.


  • Fixed issue with importing downloadable product links
  • Fixed issue when the email notification on the failed job would not trigger
  • Fixed issue with importing product with ‘only update’ behavior with ‘Undefined index:sku’ exception
  • Fixed issue with importing YouTube/Vimeo videos a for a specific store view, when video data is not displayed for the default store view
  • Fixed issue with importing categories with the incorrect type of the “path” column
  • Fixed issue with filtering orders by invoice dates when exporting orders
  • Fixed issue with updating a category path when importing categories
  • Fixed issue with copying relates_skus, crossell_skus and upsell_skus from a simple product to a configurable product when ‘Custom logic for creation of configurable products’ is enabled
  • Fixed issue with copying category ids from a simple product to a configurable product when ‘Custom logic for creation of configurable products’ is enabled
  • Fixed issue with exporting orders, when an increment_id is specified for each row
  • Fixed issue with importing products with custom options
  • Fixed issue with updating a category path when importing categories when path has invalid value
  • Fixed issue where patches were not being applied
  • Fixed issue with URL rewrite generator for the configurable product
  • Fixed issue with incorrect category name in an export file after moving the category
  • Fixed issue with updating a salable qty when importing products

Improved Import Export Magento 2 Roadmap – vote for the most exciting features and we will implement them first. Leave your suggestions in the comments and we will add them to the poll.

Continue Reading

How to Import Magento 2 Cart Price Rules

- E-Commerce, Magento 2

Magento 2 cart price rules are an invaluable tool for running promotions. They work perfectly along with catalog price rules. And while Magento 2 lets you easily configure both, it is impossible to import cart price rules unless you use a third-party instrument. Thus, having migrated from Magento 1 or other ecommerce platform to Magento 2, you can find yourself in need of the solution to import cart price rules and coupon codes.

In this post, we will show you how to import coupon codes and cart price rules to Magento 2 with the help of the Improved Import & Export extension. You will discover how a sample cart price rule import table looks, what cart price rule attributes are used, and how to import Magento 2 cart price rules.

Continue Reading

How to Import and Export Magento 2 Catalog Price Rules

- E-Commerce, Magento 2, Our extensions

Consider Magento 2 Catalog Price Rules a sales booster that allows running price-focused campaigns based on the discounts. You can apply them to products with particular attributes and their combinations to achieve the highest possible flexibility. Another good thing about catalog price rules in Magento 2 is that it is a platform’s native marketing tool. Also, Catalog Price Rules are extremely user-friendly to set up. However, there is one notable inconvenience associated with this entity. You cannot import Catalog Price Rules to Magento 2 by default. Luckily, there is an opportunity to get the missing functionality. You need the Improved Import and Export extension to transfer Catalog Price Rules between Magento 2 and external systems. The details are carefully noted in the article below. You will find a sample table for the Catalog Price Rule import. After that, we will explore the Catalog Price Rule attributes used in Magento 2. Also, there is a detailed description of how to prepare for and configure a Catalog Price Rule import process.

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 Import/Export Categories to Magento 2

Magento 2 Development

Below, you will find a brief description of how to import/export categories between two Magento 2 websites. Unfortunately, this functionality is not available by default. Magento 2 leaves you alone with a huge category tree. You need to recreate it manually or rely on third parties. And we know for sure how to import and export Magento 2 categories most efficiently. This post was inspired by the Magento StackExchange discussion. Question by Rafael Corrêa Gomes; answer by KAndy. However, it is only a partial overview of the Magento 2 category import and export. A full-featured guide on how to import and export categories, with all attributes explained can be found here: Read full-featured Magento 2 Category import and export guide. Continue Reading

The Complete Guide to Magento 2 Related Products, Up-sells, and Cross-sells, and how to import them

- E-Commerce, Magento 2, Our extensions

To sell effectively one must learn to predict and analyze. What are people looking for at my store? How can I make their search fruitful? At what point do the results become satisfying? Will it be enough to improve customer lives? The answers to the questions lie within everyone’s reach — run through some behavior statistics and create the most relevant offers for your audience. The related product, up-sell, and cross-sell functionalities are the very tools that will help you understand the customers’ needs.

You can consider related products, up-sells, and cross-sells a promo engine for your e-commerce website. Each relation type is distinguished following the display location and specific marketing goals. However, the core idea of being a purchase stimulus is similar for all the triplet items. In this guide, we will cover how to enrich your store content by using related content. You will learn how to use, import, and export Magento 2 related products, up-sells, and cross-sells. Since this publication is another one in the series of educational posts dedicated to Magento 2 import and export processes, you may be interested in the Magento 2 Import/Export Guide list that contains other similar guides.

As for the following article, it sheds light upon what Magento 2 related products, up-sell products, and cross-sell products are. We explain how to assign them to product pages as well as describe the corresponding import processes. Thus, you will learn what attributes are available in a CSV table, how to use the native Magento 2 import & export tools to transfer related products, up-sells, and cross-sells. And of course, there is a chapter that portrays a more user-friendly way to move them with the help of the Improved Import & Export extension.

Continue Reading

How to Import Excel (XLS & XLSX) and OpenOffice (ODS) Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Excel import export

We’ve already described hundreds of data import cases related to Magento 2 and many more are left to be mentioned in our blog. This time, we return to the topic of importing file standards the Magento 2 doesn’t support. Unfortunately, the system works with CSV files only and it is not the only requirement you should follow to be able to transfer an update to your database. You also have to edit third-party data and columns to make the file suitable, but let’s return to the unsupported formats.   

If you have an Excel (XLS or XLSX) or ODS file with data that should be imported to Magento 2, you’ve come to the right place. Although Magento 2 doesn’t let you do that by default, there is a reliable alternative solution at your service. Meet the Improved Import & Export extension – a tool that offers the most user-friendly way of Magento 2 Excel and ODS files import.

In the following article, we shed light on what to do with XLSX, XLS, and ODS files if you want to move them to Magento 2 via the default data transfer tools. After that, you will find a guide on how to import Excel and ODS files to Magento 2 in a way more user-friendly manner. Continue Reading

The Complete Guide to Magento 2 Grouped Products, and how to import them

- E-Commerce, Magento 2

Magento 2 grouped products are one of the three complex product types represented in Magento 2. Why do we call them complex, you will ask? Because a group of products, that is often called a parent product, consists of several simple products, that are called child products. Thus, you get an unusual structure with its own rules and laws that are quite hard to manage. 

In the article below, we will show you what Magento 2 grouped products are and how they work. Besides, there is a small guide to creating grouped products in Magento 2. In addition to that, you will find out how to import grouped products to Magento 2. We will explore a corresponding import table with the required columns. Besides, you will learn how to remove product associations. At the end of this blog post, there is an FAQ section with other general facts about Magento 2 grouped product import.

Continue Reading

How to Import JSON Files to Magento 2

Magento 2 JSON Import

The default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, but what if a more complex task must be solved? For instance, you need to import JSON files to Magento 2, while the system supports only the CSV standard. Therefore, you need to convert your JSON files to the supported file type in order to move them to your e-commerce website. Luckily, there is a more user-friendly solution for importing JSON to Magento 2.

Meet the Improved Import & Export Magento 2 extension. This module supports JSON data import so that you can move all the necessary information to your e-commerce store without comforting it to CSV. You can effortlessly move data in this format in both directions: to and from your Magento 2 website.

In this article, we discuss JSON file requirements for importing data to Magento 2 and provide a list of supported entities (you can transfer all core entities now). Besides, there is a step-by-step guide to importing JSON data to Magento 2. And if you are not familiar with the JSON format, you will find its brief description below. Continue Reading

How to Import Magento 2 Advanced Pricing

- E-Commerce, Magento 2

Although setting up tier prices in Magento 2 is an exhausting task, you can dramatically simplify the related chores. But why is it so time-consuming? Setting up advanced pricing in Magento 2 requires going through the products one by one, submitting values in a dedicated window, and then saving. The more products you have, the more actions you need to apply. However, the Magento 2 import procedure lets you save hours of manual management time. In this article, we describe how to import advanced pricing to Magento 2. Below, you will find a sample advanced pricing import table described. Next, we provide advanced pricing attributes used in Magento 2. With this information in mind, you can proceed to importing Magento 2 tier prices

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for tier prices which are provided via another spreadsheet. You must admit that it is not very convenient, especially when you move the entire catalog. 

To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and tier prices in a single file. Importing Magento 2 products with tier prices in a single file is based on the following steps. Firstly, prepare an import table, following our recommendations. After that, create a new import job as described in this blog post.

Continue Reading