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

"csv"

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.4 (released 29.05.2023)

Features:

  • Product Import. The “User Defined” checkbox on the Bundle Options tab of a product page in the Magento admin is linked to the “can_change_qty” column in a product import file.
  • Order Import. The “order_id” and “order_item_id” fields are now optional in the item:downloadable_link_data column when importing orders with downloadable links.
  • Customer Import. A customer group code (“_customer_group_code”) has higher priority than a group ID (“group_id”) during customer import.
  • MSI Product Export.  It is possible to decide whether you need to export salable quantities during product export or not. The export job’s “Add MSI data to export” option enables salable quantity export. If it is turned on, an export file contains the “msi_stock_[stock_id]_salable_qty” and “msi_stock_[stock_id]_is_salable” columns, where “[stock_id]” is a numerical ID of your stock. For instance, msi_stock_1_salable_qty or msi_stock_2_salable_qty.
  • Product Export.  Product export now contains the “parent_sku” column. If a simple product is a child of a few different products, parent products are separated by a comma in the “parent_sku” attribute column.
  • MSI Product Import.  Improved Import & Export automatically changes a stock status based on qty value if the “msi_[source_code]_status” column is omitted, where “[source_code]” is the code of a particular inventory source, such as default, de, or en (e.g., msi_default_status, msi_de_status, msi_en_status). The status is set to “in stock” if qty>0 and “out of stock” if qty=0.
  • Product Attributes. The extension exports product attributes in the same order as on the “Map Attributes” tab.
  • Product Import.  Improved Import & Export converts product weight during import according to the “Weight Factor” value in the import job settings. The default value is “1” – the weight value is exactly as in the import table. To convert kg to g need to set the value to “1000”. To convert g to kg, set the value “0.001”.
  • Order Export. You can export order addresses in a single line with the help of the export job option named “Data in one line”. This feature works only for export. If addresses are separated in different columns in one line – they will not be imported.
  • Category Export. Both a file and mapping tab associated with category export now contain the “parent_id” column.
  • Shipment Import.  The shipment import field named “shipment_track:source_code” provides the ability to create a shipment from the specific stock source.
  • XSLT Field Type. The XSLT field type has been changed to “mediumblob”, which supports more than 65535 symbols.
  • Developer Improvement. The “preparePlatformRowForDb()” public method has been added to the Product class to enable the use of plugins.

Bugfixes:

  • Fixed issue when not all categories were exported due to collection reset.
  • Fixed issue when the global price for a product was exported instead of a website-specific price.
  • Fixed the “Advanced Price” replace behavior. Now it works based on a specific website.
  • Fixed issue with category name export. Initially, names based on the global store view were exported instead of store-specific names.
  • Fixed issue with undefined ‘getMultipleCategorySeparator()’ method while running the core Magento import.
  • Fixed problem when 0 ‘children_count’ was saved to DB during category import.
  • Fixed problem when empty lines were exported during shipment item export.
  • Fixed problem with export category level separator when it was applied only to the first category level.
  • Fixed the category separator on the “Map Categories” import tab. Initially, only ‘/’ was displayed even if another separator was selected. It used to cause problems with categories that already had “/” in their names.
  • Fixed the “Implicit conversion from float to int” error caused by conflicts with some third-party extensions.
  • Fixed problem with the address “imcrement_id”. This column can be used to identify the correct address if an import file does not contain “entity_id”.
  • Fixed problem when only the last bunch of data was exported to a zip file.
  • Fixed the “columnNameInvalid in rows” error when saving Import Job with the “Save & Run” button.
  • Fixed problem when stock qty was not updated using the core Magento import with the enabled MSI modules.
  • Fixed problem when an import process was interrupted if images were not found on a remote OneDrive account. Now, a job shows a warning and keeps running.
  • Fixed the “Object could not be converted to string” error during orders export.
  • Fixed problem with Reviews import when an invalid column error was shown for the “vote:…” column.
  • Fixed issue when a product was accidentally assigned to a “Default source” despite the import file didn’t contain any stock data.
  • Fixed the “Cannot read properties of undefined (reading ‘items’)” JS issue when clicking on the Validate button on the import job page.
  • Fixed memory leak associated with category import caused by the infinite recursive calls.
  • Fixed memory leak associated with product import caused by loading all store products instead of a specific bunch during Product Video Urls loading. 
  • Fixed the “Column cannot be null” error when importing empty values for the “out_of_stock_qty” column during product import.
  • Fixed problem with the export date filter when data was exported till the current time instead of the end of the day.
  • Fixed the export filter field and the “Yes/No” field when products with “No” value were not found.
  • Fixed problem when the configurable product’s “disabled” status became “enabled” even if the import file didn’t contain the status column. 
  • Fixed problem when duplicated attribute options were created during attribute import.

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

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 Update Order Status Via CSV In Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

In the following article, we shed light on how to update orders in Magento 2 with the help of CSV files. Since this procedure is impossible if you use the platform’s default import tools, many merchants try to find the most reliable and flexible solution. We will describe such an instrument below. In this article, you will learn how to update the order status in Magento 2 via CSV and files of other formats. As you might have already guessed, there is no need to reinvent the bicycle. It is only necessary to choose one of the available solutions. So, let’s see what Magento 2 extension lets you update orders in Magento 2 in the most flexible manner. Please, check our cookbook for more similar articles. Continue Reading

How to Run Magento 2 Import if Required Columns Are Missed

- E-Commerce, Magento 2, Our extensions

Magento 2 Import without Required Columns

Below, we shed light on a very important aspect of every import process – columns (attributes) of an import file. What if your data table doesn’t contain one? By default, you face the inability to transfer the update to your Magento 2 website. There are lots of different entities that can be transferred into Magento 2, so you have to deal with different data depending on your particular business case. However, the absence of the smallest detail can ruin all your data transfer efforts. Especially if you use the default data transfer solutions. 

Luckily, we know how to prevent such issues. Meet the Improved Import & Export Magento 2 extension. With the help of this plugin, you can import data to Magento 2 if some required columns are missed. The following article describes this process. You can either add the necessary columns manually or automate the addition of the missing data using the module’s functionality. Besides, you will discover the required CSV file structure as well as core features of the Improved Import & Export Magento 2 extension
Continue Reading

How to Import Custom CSV to Custom Table in Magento 2

Magento 2 import export debug log

Recently, we were surfing on the endless StackExchange surfaces and stumbled across an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand. Its probability for an average e-commerce business seemed to be high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue we are going to discuss?

Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although forum members provided several ways to achieve this goal, we didn’t find any user-friendly solution aimed at people with less technical skills than required by the most rated answer. Variants discussed on StackExchange seem to be highly efficient but too complicated. However, there is one more way to import a custom CSV file to a custom table in Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. Since the latter is based on the Improved Import & Export extension, we also share its core features after discussing the corresponding resolution.
Continue Reading

Amasty Export Orders Extension for Magento 2 and 1

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

Continue Reading

How to migrate from Magento 1 to Magento 2 with Improved Import and Export extension

Migrating from Magento 1 to Magento 2 is not an ordinary routine. Using the standard Magento data import tool for that may be a difficult task if you are not familiar with coding and working from the command line. Even Magento 2 developers rarely rely on the standard instruments since the migration may prove difficult because of the difference between entities stored in M1 and M2.

MIGRATION ADD-ON IS NO LONGER SUPPORTED

That’s why having a tool that simplifies the procedure and leaves you with only mechanical tasks is a great time savior. In this article, we will talk about how to migrate to Magento 2 using the Improved Import and Export extension. Firstly, we will introduce you to the module. After that, you will find out how to import products, customers, and orders to your ecommerce website when you migrate from Magento 1 to Magento 2. The article sheds light on such nuances as getting an export table with a corresponding entity, preparing attributes for import, and transferring everything into your brand new storefront.

Continue Reading

The Complete Guide to Magento 2 Product Import / Export

- Magento 2

Magento 2 Product Import Export Tutorial

Chances are, you already have an e-commerce website and want to transfer the existing products to your brand new Magento 2 storefront or need to move product data from a dropshipping platform – you’ve come to the right place. Perhaps, you want to transfer products and their prices to price comparison engines – you will also find out how to do that below. In the following article, we shed light on various nuances of Magento 2 product import and export

This blog post peruses the Magento 2 import and export processes from the very beginning. It guides you through various prerequisites that you should know prior to importing to Magento 2, such as editing CSV files according to the native Magento 2 guidelines. After that, the article focuses on the default product import/export in Magento 2 Continue Reading

How to Import Custom Files to Shopify

- E-Commerce, Shopify

 shopify import & export app

Fail to import custom files to Shopify? You’ve come to the right place. Although you cannot do that with the platform’s default tools, an alternative solution is suitable for this procedure. In the following article, we describe where the issue comes from and how to address it.  Continue Reading

How to add a custom import adapter in Magento 2

Magento 2 export CLI

StackExchange is always a good source of answers to all possible questions, including ones related to Magento 2. Therefore, we monitor the platform to provide you with the most useful solutions posted there. This time our attention is captured by Mir, who asks about a custom import adapter for Magento 2. The author of the question is not satisfied with the default import opportunities of the platform (and we know why), so let’s find out how to solve the current issue. Find more tips in our Cookbook. Continue Reading