Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"categories 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.5.2 (released 21.06.2021)


  • Added possibility to enable login and password encryption for FTP and SFTP sources. The setting is available under Stores > Configuration > Firebear Improved Import & Export
  • Added possibility to import and export products with the quantity per warehouse. If Magento 2 MSI extension is installed, you can import and export products with additional attributes msi_{warehouse_name}, msi_{warehouse_name}_qty, msi_{warehouse_name}_status
  • Added support of OneDrive as an import and export source. One OneDrive account per store can be added in the extension settings
  • Added possibility to delete an imported file after the import process completes if you are uploading a file to the store
  • Added possibility to use ‘tab’ (just type in ‘t’) as a multiple value separator, and field separator, enabling use of the .tsv files
  • Added possibility to import ALL files from the specified folder, works with sources: file, FTP, SFTP
  • Added possibility to import .zip archives. You still need to select the proper file type which is contained in the archive.
  • Added possibility to specify EMPTY_VALUE constant. You can use any symbol to specify that the field should have an empty value after import completes.
  • Improved URL generation pattern, you can now use [product_attribute_code] to include any product attribute value into the final URL
  • Now it will not be possible to create multiple export jobs which target the same output file. When duplicating the export jobs the output file path is reset and you need to fill it again. Also, the prefix ‘Duplicate of original_job_name’ will be added to the duplicated job.
  • Speed improvements for configurable products import


  • Fixed issue with product images when Remove All Images and Remove Images from Directory options were enabled together
  • Fixed issue where Skip Errors Validation system wouldn’t work when importing from command line
  • Fixed issue with importing product images from Google Drive and DropBox filesystem
  • Fixed issue when it was not possible to import product price rules by attribute set condition
  • Fixed issue when it was not possible to save the address of the URL if the URL resulted in 404 error
  • Fixed issue with the default product stock update when the imported file doesn’t contain stock attributes
  • Fixed issue when it was not possible to export products page by page
  • Fixed issue with the product images import when the path to the image is not URL
  • Fixed issue with importing orders with Json file type
  • Fixed issue with updating category names using entity_id
  • Fixed issue with the export filters missing multi-select attributes
  • Fixed issue with customers sometimes not being confirmed after the import
  • Fixed issue with the category import when the incorrect value specified for the ‘position’ attribute
  • Fixed issue with the advanced pricing import with ‘Replace’ behavior adding new lines of the advanced pricing
  • Fixed issue with the category mapping tab when several pages are added
  • Fixed issue with the Generate Unique URL if duplicate not working with the URL Generation Pattern
  • Fixed issue with the Advanced Pricing export when the price has been fetched by the entity link field
  • Fixed issue with the product image database entries being duplicated for each store in the multi-store environment
  • Fixed issue with the category mapping preserving cached paths when new import source is selected
  • Fixed issue with FTP and SFTP sources not working properly in several cases and not being able to connect
  • Fixed issue with updating category attribute ‘is_anchor’ for multi-store environment due to the inherited Magento 2 behavior
  • Added URL key validator

Continue Reading

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

In this article, we’d like to draw your attention to the Improved Import & Export Magento 2 extensions. The following blog post contains all the information about the data transfer module. Below, you will find the Improved Import & Export Extension manual that sheds light upon all the key aspects associated with the plugin. We describe its installation, configuration, and import/export transfers, teach you how to add a new import and export job, talk about import and export processes associated with different entities. You will also discover various nuances of running data transfers via CLI, automating processes, using extension customization endpoints, and performing troubleshooting. Various use cases and specific features are also described in the manual.

Improved Import and Export extension allows importing and exporting CSV/XML/JSON files with product data and product images to Magento 2. The files can be imported from a remote FTP/SFTP server, Dropbox, direct URL of a source CSV fileGoogle Sheets, etc.  In addition, the extension offers a dedicated category import from CSV files, import of attribute values and new attributes on the fly, import job scheduling with cron jobs, and other features.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

Continue Reading

How to Export and Import Magento 2 Categories

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

Continue Reading

How to improve Magento 2 Commerce/Cloud import and export procedures, import XML and Json

- E-Commerce, Magento 2

It is not a secret that Magento 2 Commerce/Cloud edition import and export procedures can be automated and offer an enhanced functionality compared to Magento 2 Open Source (Community) edition.

Still, there is some functionality lacking. In this post, we have gathered the suggestions on how to improve Magento 2 Commerce/Cloud import and export, how to import XML and Json file, import categories and other entities.

Magento 2 Commerce/Cloud in comparison with Open Source (ex. Community) version comes with improved Import and Export procedures. The main difference with Open Source comes from the possibility to schedule the import and export. Let’s break down the process and look at the features available. Continue Reading