Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"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.5.2 (released 21.06.2021)

Features

  • Added possibility to enable login and password encryption for FTP and SFTP sources. The setting is available under Stores > Configuration > Firebear Improved Import & Export
  • Added possibility to import and export products with the quantity per warehouse. If Magento 2 MSI extension is installed, you can import and export products with additional attributes msi_{warehouse_name}, msi_{warehouse_name}_qty, msi_{warehouse_name}_status
  • Added support of OneDrive as an import and export source. One OneDrive account per store can be added in the extension settings
  • Added possibility to delete an imported file after the import process completes if you are uploading a file to the store
  • Added possibility to use ‘tab’ (just type in ‘t’) as a multiple value separator, and field separator, enabling use of the .tsv files
  • Added possibility to import ALL files from the specified folder, works with sources: file, FTP, SFTP
  • Added possibility to import .zip archives. You still need to select the proper file type which is contained in the archive.
  • Added possibility to specify EMPTY_VALUE constant. You can use any symbol to specify that the field should have an empty value after import completes.
  • Improved URL generation pattern, you can now use [product_attribute_code] to include any product attribute value into the final URL
  • Now it will not be possible to create multiple export jobs which target the same output file. When duplicating the export jobs the output file path is reset and you need to fill it again. Also, the prefix ‘Duplicate of original_job_name’ will be added to the duplicated job.
  • Speed improvements for configurable products import

Bugfixes

  • Fixed issue with product images when Remove All Images and Remove Images from Directory options were enabled together
  • Fixed issue where Skip Errors Validation system wouldn’t work when importing from command line
  • Fixed issue with importing product images from Google Drive and DropBox filesystem
  • Fixed issue when it was not possible to import product price rules by attribute set condition
  • Fixed issue when it was not possible to save the address of the URL if the URL resulted in 404 error
  • Fixed issue with the default product stock update when the imported file doesn’t contain stock attributes
  • Fixed issue when it was not possible to export products page by page
  • Fixed issue with the product images import when the path to the image is not URL
  • Fixed issue with importing orders with Json file type
  • Fixed issue with updating category names using entity_id
  • Fixed issue with the export filters missing multi-select attributes
  • Fixed issue with customers sometimes not being confirmed after the import
  • Fixed issue with the category import when the incorrect value specified for the ‘position’ attribute
  • Fixed issue with the advanced pricing import with ‘Replace’ behavior adding new lines of the advanced pricing
  • Fixed issue with the category mapping tab when several pages are added
  • Fixed issue with the Generate Unique URL if duplicate not working with the URL Generation Pattern
  • Fixed issue with the Advanced Pricing export when the price has been fetched by the entity link field
  • Fixed issue with the product image database entries being duplicated for each store in the multi-store environment
  • Fixed issue with the category mapping preserving cached paths when new import source is selected
  • Fixed issue with FTP and SFTP sources not working properly in several cases and not being able to connect
  • Fixed issue with updating category attribute ‘is_anchor’ for multi-store environment due to the inherited Magento 2 behavior
  • Added URL key validator

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

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

How to Read a CSV File & Convert It into an Array in Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 import customer passwords

The following article describes how to read a CSV file and convert it into an array in Magento 2. We also shed light on an alternative way of transferring data to your e-commerce website, when you don’t need to perform complicated manipulations over CSV files or can eliminate them from data transfer entirely. More useful tips are available in our Magento 2 Cookbook. Continue Reading

How to Import Custom CSV to Custom Table in Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 import export debug log

Recently, we discovered an exciting topic that wasn’t highlighted in our Cookbook. Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although community 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.  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 one very important aspect of every import process – columns (attributes) of an import file. 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. Besides, the following article explains how to import data into Magento 2 if some required columns are missed. Continue Reading

How To Import Custom CSV / XML File Which You Can’t Modify To Magento 2

- Magento 2

Magento 2 Color Swatches Extension

Unfortunately, Magento 2 doesn’t let you import a custom CSV / XML file which cannot be modified. Furthermore, it doesn’t provide any opportunity to work with the XML format. So, if you even have an XML file that satisfies other requirements of the platform, you will never update your store data. Luckily, we know the right recipe, so it is no longer a problem to import a custom CSV / XML file which you can’t modify to Magento 2. Continue Reading