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

"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

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 and Export Orders to Magento 2

Magento 2 Orders Import

The following article sheds light on how to import orders to Magento 2. Merchants usually do that when they migrate to Magento 2 or synchronize their business with external marketplaces. However, you cannot do that within the admin’s default tools. Therefore, a third-party extension is necessary to maintain this process. 

Besides, the blog post explains how to export orders from Magento 2. This procedure comes in handy in similar cases: when the migration from Magento 2 is required or orders are processed in external systems. Unlike the Magento 2 order import, the corresponding export process is available in the administration right on the order page. Although you can transfer orders from your website with the help of the default tools, we describe a more fully featured but at the same time natural way of doing that. 

In the article below, you will discover how the order import works. We explore the Magento 2 order file structure and generate invoices and shipments while importing tracking numbers. You will also see how to export orders from Magento 2. The last chapter of the article reveals other features of the tool that we use to run data transfers.
Continue Reading

How to fix “The source file moving process failed” error in Magento 2

- Magento 2

Magento 2 Development; Magento 2 tutorial

In this article, we explain how to fix the “The source file moving process failed” error in Magento 2. It may occur in Magento 2.4 upon import. If you’ve already experienced this issue, you will find the solution below. Check our Magento 2 cookbook for more tips like that. The following material incorporates a Stack Exchange case and our own experience related to Magento 2 data import and export.  Continue Reading

How to import product images in Magento 2 when they already exist in pub/media

- Magento 2

Magento 2 Development; Magento 2 tutorial

Have you ever been in a situation when Magento 2 doesn’t let you import product images? Although there may be numerous factors that cause this problem, we explore a particular case. Below, you will learn why the “Imported resource (image) could not be downloaded” error occurs in Magento 2 and how to fix it. This post incorporates materials from this Stack Exchange question. Follow our Magento 2 Cookbook for more tips like that.     Continue Reading

How To Add ‘Delete Confirmation Popup’ In Magento 2 For Default Import Functionality 

- Magento 2

Magento 2 Development; Magento 2 tutorial

Kavya cheerala asks for help in the following situation via a Stack Exchange question. The author has added a custom entity in the default Magento 2 import. As a result of this improvement, it is necessary to display the Magento 2 delete confirmation popup upon the delete action when you click the import button. How to do that? You will find the answer below. We explain how to add Magento 2 confirmation popup and customize its text message.  Continue Reading

Matrixify Shopify App In-Depth Review: Is It That Powerful?

- Shopify

Matrixify app for Shopify

What is Matrixify? How to use Matrixify? What are its core features and goals? Below, we review the Matrixify Shopify app to let you know the answers. We aim to highlight the core features of this tool, illustrate how Matrixify works, and figure out whether is the number one import and export solution for the Shopify ecosystem or not. A brief Matrixify template tutorial is also available in this article, along with Matrixify pricing plans. 

The core goal of the Shopify Matrixify app is to help merchants bulk import and export human-readable Excel and CSV files. Although the default Shopify data transfer instruments are also capable of doing that, the third-party solution dramatically extends the platform’s basic abilities. For instance, it lets you import Shopify orders! But is it enough to cover all the data transfer demands? You will find out soon. If you want more information on the default instruments, read these two materials: The Ultimate Guide to Shopify Import & The Ultimate Guide to Shopify Export 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 Fix Error 1062 Upon Magento 2 Database Import

- E-Commerce, Magento 2

Magento 2 Development; Magento 2 tutorial

We recently came across another StackExchange topic related to database import. While moving a database to Magento 2, user104747 faced an obstacle – ERROR 1062. We explain the problem in the following article. Also, you will find the suggested fix to this Magento 2 database import error below. Since the system does not allow you to move a database directly to Magento 2, the process may become fairly complicated. An output file with a specific object must always be created. And this procedure should adhere to numerous strict requirements. For instance, it is vital to divide your file into two distinct tables if it contains multiple categories of data (for example, products and orders). All other nuances are described below.

Additionally, you must always modify imported file attributes to conform to Magento 2 specifications. Otherwise, no database may be imported into Magento 2. Also, note that regular data transfers from a database to an e-commerce website cannot be automated. But all of these problems can be resolved with a single instrument. It doesn’t matter whether you want to fix error 1062 upon Magento 2 database import or implement the lacking data transfer capabilities, we know a perfect solution designed to address all the most common import issues. Meet the Improved Import & Export Magento 2 extension. After we go through a solution offered in the StackExchange discussion, you will find out how this module addresses database import problems associated with Magento 2. Read our Cookbook for more guidance and suggestions. Continue Reading