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.1 (released 7.11.2022)

Features

  • Full compatibility with Magento 2.4.5
  • Added possibility to assign customer group to customers using the customer group name with “Customers Main” entity. The following fields have been added to the “Customers Main” export and import: _customer_group_code (name of the customer group), _tax_class_name (name of the tax assigned to the customer group), _tax_class_id (ID of the tax assigned to the customer group). The customer group can only be created if the tax class specified already exists at the store.
  • Added ability to use auto-increment for order increment_id. Meaning that if you do not have an increment_id – it will be generated and assigned automatically. Useful when importing orders from your CRM or ERP, or integrating with a marketplace.
  • Added feature “Update Products that are not in the import list” for product import. Which allows to set products inside your catalog, which are missing from the imported file as: out of stock, quantity=0, out of stock with quantity=0, disabled.
  • Added system events for import and export jobs which can be used as hooks during the integration.

Bugfixes

  • Fixed issue with importing downloadable product links
  • Fixed issue when the email notification on the failed job would not trigger
  • Fixed issue with importing product with ‘only update’ behavior with ‘Undefined index:sku’ exception
  • Fixed issue with importing YouTube/Vimeo videos a for a specific store view, when video data is not displayed for the default store view
  • Fixed issue with importing categories with the incorrect type of the “path” column
  • Fixed issue with filtering orders by invoice dates when exporting orders
  • Fixed issue with updating a category path when importing categories
  • Fixed issue with copying relates_skus, crossell_skus and upsell_skus from a simple product to a configurable product when ‘Custom logic for creation of configurable products’ is enabled
  • Fixed issue with copying category ids from a simple product to a configurable product when ‘Custom logic for creation of configurable products’ is enabled
  • Fixed issue with exporting orders, when an increment_id is specified for each row
  • Fixed issue with importing products with custom options
  • Fixed issue with updating a category path when importing categories when path has invalid value
  • Fixed issue where patches were not being applied
  • Fixed issue with URL rewrite generator for the configurable product
  • Fixed issue with incorrect category name in an export file after moving the category
  • Fixed issue with updating a salable qty when importing products

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