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

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

How to disable products not available in an import file for specific Magento 2 websites

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

We’ve already explained how to update Magento 2 products that are not available in an import file. Today, we explain a more specific case: you will learn how to disable products that are not available in an import file. Moreover, there is a possibility to disable the on specific Magento 2 websites. Of course, you won’t be able to do that with the default Magento 2 import tool. You will need the Improved Import & Export extension to transfer the update as intended.  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 Import Data via GraphQL API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 graphql import export

The following article describes how to import and export data into/from Magento 2 with the help of GraphQL API. This connection type is yet impossible out of the box, but the community is working hard to introduce it as a replacement for REST API. At the same time, some tools enable Magento 2 GraphQL API import and export right now. For instance, you can leverage the Magento 2 GraphQL API import and export processes with the Improved Import & Export Magento 2 module. The following article sheds light on how to import data into Magento 2 via GraphQL API with the help of our extension. You will find out how to enable the Magento 2 GraphQL API import and what extra benefits it is associated with. If you are not familiar with what GraphQL API is, we’ve also prepared a chapter that describes this standard and its benefits over REST and SOAP. Besides, there is an FAQ section that provides answers to frequently asked questions about GraphQL and Magento 2 import/export processes.
Continue Reading

How to Import Data via SOAP API into Magento 2

Magento 2 SOAP API Data Import

Below, we shed light on how to enable Magento 2 SOAP API import. Unfortunately, this functionality is not possible by default, but you can add the missing feature to your e-commerce store with the help of a third-party extension. The following article sheds light on SOAP, compares it with REST, and offers a reliable tool for enabling the corresponding functionality for Magento 2. You can leverage the Magento 2 SOAP API import and export processes with the Improved Import & Export Magento 2 module

The following article sheds light on how to import data into Magento 2 via SOAP API with the help of our extension. We discuss how to enable the Magento 2 SOAP API import and what extra benefits you can get. If you are not familiar with what SOAP API is, we’ve also prepared a chapter that describes this standard. Besides, there is an FAQ section that provides answers to frequently asked questions about SOAP and Magento 2 import/export processes.
Continue Reading

How to Import & Export Product Reviews in Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Product Reviews Import Export

Although Magento gets new and new features providing its customers with multiple opportunities that have been previously available only via third-party extensions, the platform still lacks some vital data transfer functions. For instance, you cannot import and export product reviews to/from Magento 2. However, there is always a possible resolution in a huge ecosystem of modules. Below, we shed light on how to import and export product reviews in Magento 2 in the most user-friendly manner with the help of the Improved Import & Export Magento 2 extension. You will discover a sample import and export table for product reviews with all its attributes explained. After that, we will teach you how to automatically import product reviews to Magento 2 on a regular basis. The corresponding export processes are described too. These and other nuances are available below. But before going any further, let’s emphasize several aspects of our extension that take place in the Magento 2 product reviews import and export
Continue Reading

How to Map (Match) Attribute Values During Import in Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Attribute Values Mapping Import

You might have already faced numerous problems caused by attributes and attribute values that don’t follow the Magento requirements. By default, it is impossible to import them to Magento 2. Different systems have unique requirements regarding the way information is stored in their databases. Therefore, you cannot transfer data between them directly. It is always necessary to apply changes to the output created beyond Magento 2 to run a successful import to your e-commerce website. And this process is usually time-consuming. The more unsupported values your data file contains the more work has to be done. 

However, there is a user-friendly way of editing third-party data. Meet the Improved Import & Export Magento 2 extension. The module lets you automate the attribute editing processes so that you can freely import data from external platforms to Magento 2. Below, we shed light on how to match third-party attributes and attribute values to the corresponding Magento 2 values during import. You will find a guide for the default Magento 2 import tool. After that, we provide a description of our approach that saves tons of time and lets you automate further data updates.
Continue Reading

How to Import and Export Magento 2 Shared Catalogs

- E-Commerce, Magento 2

Magento 2 Shared Catalogs Import and Export

In the following article, you will find everything about Magento 2 shared catalogs. It is a guide dedicated to this B2B entity where we also explore various associated management processes. You will find out what Magento 2 shared catalogs are, how to create shared catalogs, what the nuances of sharing are, and how to import and export shared catalogs in Magento 2. The entity has huge potential for B2B merchants; however, if you don’t know how to manage shared catalogs you will probably waste it. Therefore, arm yourself with patience and peruse this guide. If you don’t know how to import or export shared catalogs between your Magento 2 store and an external e-commerce website, you’ve come to the right place. But let’s first define what shared catalogs are.
Continue Reading

How to Import and Export Customer Shopping Carts in Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Shopping Carts Import Export

The shopping cart functionality of Magento 2 has been updated multiple times. Every new version introduced vital improvements for both customers and store administrators. In the following post, we shed light on new Magento 2 shopping cart features, discuss the updated functionality, and provide a tool designed to import and export Magento 2 shopping carts and all the related data within just a few clicks.

As a store administrator, you get the ability to manage shopping carts of customers who are now online – a new feature that is explained below. Besides, it is possible to access the persistent carts – a new term used to call abandoned carts – of shoppers who are not currently logged in to their accounts.

In both cases, you are able to add and remove products, transfer items from customer activities, and create orders. As for the respective import and export processes, they are available via third-party software. In this article, we use the Improved Import & Export Magento 2 extension to show how to transfer Magento 2 shopping carts. Continue Reading

How to Import Compressed Data (ZIP, TAR, TGZ) to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Compressed Data ZIP TAR TGZ Import

What if your partner provides a vital data update in a compressed file? Prior to importing it to Magento 2, you need to unpack the archive. Next, if a file stored there is not CSV, you need to run the conversion. Furthermore, if it contains unsupported attributes, you need to replace them with the ones used in Magento 2. All these actions consume tons of time. However, it is possible to automate them. 

The following article discusses two ways of importing compressed data to Magento 2. Firstly, we shed light on a common approach that slightly simplifies the algorithm described above. Secondly, you will discover an alternative solution that dramatically improves the corresponding admin experience. It not only enables the import of archives to Magento 2 but also supports many more file types and enables the import of third-party data to Magento 2. Below, you will find out how to import ZIP and TAR to Magento 2 with the help of the Improved Import & Export extension.

Continue Reading