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

"improved import / export"

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.0 (released 16.05.2022)

Features

  • Compatibility with Magento 2.4.4 Open Source and Adobe Commerce with PHP 8.1
  • Setup scripts changed to a declarative scheme
  • Added ‘Import base image as small and thumbnail’ setting to the import product job
  • Added ‘additional images’ and ‘additional image labels’ fields to the product attributes list for copy values when creating configurable products
  • Added row split by store_view_code during product import
  • Added ‘name’ field of the product for the ‘Reviews’ export

Bugfixes

  • Fixed issue with the ‘Custom logic for creation of configurable products’ functionality when using custom rules
  • Fixed issue with importing an order with multiple shipments
  • Fixed issue with ‘Export page by page’ functionality
  • Fixed issue with URL when importing multiple rows for the same product, now the URLs do not have a duplication issue
  • Fixed issue with adding advanced pricing during product import, it is now added properly
  • Fixed issue with the re-import of images that were deleted from the media directory
  • Fixed issue with extra import file types when the ‘Use API’ is enabled
  • Fixed issue with creating custom options when exporting products
  • Fixed issue with incorrect category image name after importing categories
  • Fixed issue when the associated products were not added to the grouped product if the import table had a specific store view value
  • Fixed issue with products caching functionality when using platforms during import
  • Fixed issue with an empty category field in a configurable product when created using custom logic
  • Added an ‘overflow’ css property to the categories mapping fields
  • Fixed issue with importing products when the catalog price scope is a website
  • Fixed issue with saving category URL key and category URL path
  • Fixed issue with an empty store_name field in the categories export file
  • Fixed issue with replacing advanced pricing because of the missing IDs in Magento
  • Fixed issue with different number of row customizers when running export jobs from different scopes
  • Fixed issue with archiving import file after importing from remote sources
  • Fixed issue with importing product with ‘Only update’ behavior when the ‘Undefined index:sku’ exception occurs
  • Fixed issue with the endless paginated export of products
  • Fixed issue with ‘Map Categories’ mapping section
  • Fixed issue with importing categories from an Excel XLSX file
  • Fixed issue with URL key validation when importing categories
  • Fixed issue with importing products with same URL keys when they are on different stores not being possible
  • Fixed ‘Passing null to argument of type string is deprecated’ issue (compatibility with PHP version 8.1 and Magento version 2.4.4)
  • Fixed issue with nesting level of tags in templates (compatibility with Magento version 2.4.4)
  • Replaced some calls to deprecated js functions with calls to recommended functions (compatibility with JQuery version 3.3.2 and Magento version 2.4.4)
  • Fixed issue with mappings on the product import/export edit page (compatibility with Magento version 2.4.4)
  • Fixed issue with export when source is REST API and file format is ODS, XLSX or JSON
  • Fixed issue with import via sFTP (compatibility with Magento version 2.4.4)
  • Fixed issue with copying multiple additional images from a simple product to configurable when creating a configurable product on the fly
  • Fixed issue with running ‘queue:consumers’ commands (Compatibility with Magento 2.4.4 and php8.1)
  • Fixed issue with product export (Compatibility with Magento 2.4.4 and php8.1)
  • Fixed issue with data export to OneDrive (Compatibility with Magento 2.4.4 and php8.1)
  • Fixed issue with data export to Google Sheets
  • Fixed issue with the order view page after order import
  • Replaced the ‘box/spout’ library with the ‘openspout/openspout’ library (Compatibility with Magento 2.4.4 and php8.1)
  • Fixed issue with a product import when ‘Round Special Price to 0.49 or 0.99’ setting is enabled (Compatibility with Magento 2.4.4 and php8.1)
  • Fixed issue with importing images
  • Fixed issue with order export (Compatibility with Magento 2.4.4 and php8.1)

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

Manual for Product Feed Export Add-on of Improved Import and Export

Welcome to the manual for the free Magento 2 Product Export Add-on of the Improved Import and Export extension. This tool is developed to simplify your integration with all kinds of services that require your product feed: Amazon, eBay, Facebook, or even drop shippers – provide all of them with your catalog in the form of a feed. 

In the article below, we shed light on what the Magento 2 Product Export Add-on of the Improved Import and Export extension is. After that, you will find a guide on how to install the tool. We also explain how the add-on works, including such aspects as feed category mapping and product feed export jobs.

Continue Reading

How to export Magento 2 data to Google Sheets

- E-Commerce, Magento 2, Our extensions

Transferring data between Magento 2 and Google Sheets seems a very efficient and time-saving way of synchronizing your e-commerce website with external platforms and other online storefronts. However, Magento 2 doesn’t let you do that if you rely on its default tools. If you need to import data, it is possible to create a CSV output of a corresponding Google Sheets table and then import it to your store. For the export purposes, you need to generate the output from your website and then open it in Google Sheets. Thus, instead of spending less time on daily duties, you have to perform a time-consuming routine. Luckily, there is a better way of synchronizing Magento 2 and Google Sheets.

FireBear keeps building up Improved Import and Export with powerful updates. Stay focused as with version 3.3.0 of the extension we introduce a long-awaited export of Magento 2 data to Google Sheets. The feature implementation marks the completion of the full-cycle Magento 2 and Google Sheets synchronization project. Now you are able to both import and export files from the source and arrange a highly manageable workflow.

How to do so? Follow this guide to learn more. Below, you will find an overview of the Magento 2 Google Sheets integration project as well as the most frequent use cases. Next, we describe Google API configuration, including such aspects as API library installation, API connection establishment, enabling Google Drive API, generating a Service Account Key, configuring a Service Account, and sharing the corresponding Google Drive folder. After that, we proceed to the Magento 2 Google Sheets export procedure. 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

Product Feed Export with Improved Import and Export

Implementing your product feeds into external marketplaces leads to a huge boost in sales, conversion rates, and overall store visibility within the Internet. It’s a tedious work to do manually, so is it possible to make the routine fast and painless? The answer is ‘yes’. Product feeds can be extracted from your Magento 2 database with the help of the free Product Feed Export add-on of Improved Import and Export. Full control, full automation with minimum efforts from your side. How’re things done? See the guide below.

Continue Reading

The Improved Import / Export Magento 2 Extension by Firebear

- Magento 2, Our extensions

The Improved Import Export Magento 2 Extension by Firebear

Below, you will see a brief description of our project aimed at improving the default Magento 2 import/export functionality. Although the basic processes are significantly refined now, they still lack some important features; therefore, we work on this Magento 2 extension with the aim to build a multi-purpose solution.

Improved Import extension for Magento 2 provides a possibility to transfer your CSV, XML, JSON, XLSX, ODS files with products data and product images to Magento 2 from a remote FTP server, Dropbox, Google Sheets, a direct URL of a source file, supports dedicated categories import, REST and SOAP APIs, on the fly import of product attribute values, import/export cron jobs, and many more features!

In the article below, you will find the extension’s shortened roadmap and brief description. We separately discuss the light version of the module and its entire stack as well as share use cases. Also, this blog post contains information on how to import data from Google Sheets, transfer categories to Magento 2, import product attributes, creating new attributes on the fly, etc. Other useful materials include Magento CLI import commands, import file samples, import fields mapping reference, etc. Continue Reading

How to import and export updates within Magento 2. Consecutive Export

- E-Commerce, Magento 2, Our extensions

Saving time is a priority when we deal with database updates. The most beneficial solution in the situation is to find an adequate method and tool that will reduce the number of backend actions and prevent errors and duplication.

In this guide, we will explore which processes can be used within Magento 2 to add new data to the one previously transferred without running countless imports and exports or recreating a whole new database. 

Continue Reading