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
Improved Import & Export for Magento 2
Extension Manual | FAQ | Demo | Sample Files

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.

3.4.1 and 3.4.2  (released 16-17.06.2020)

  • Quick fixes for Magento Marketplace submissions, installation, and dependencies

3.4.0 (released 11.06.2020)

Features

  • Image import transferred to PRODUCT QUEUE (only for Magento 2.2 Commerce and 2.3 Open Source and Commerce versions) – Improved Import will use RabbitMQ if installed, or DB queue, to import images after the products are imported
  • Enabled Cache Products – for ‘Products’ entity you can now enable caching by row. If new rows are added to the file, or existing rows changed, only the new and changed rows will be imported. Row hashes are cached.
  • Major import speed improvements for ‘Products’ entity
  • Import categories with ‘entity_id‘ attribute as identifier – to import categories per store view with different languages, names, and paths
  • Full support of Magento 2.3.5

Bugfixes

  • Improvement to uploader class for image.
  • Fixed issue with ‘Attribute’ entity import with the ‘Append’ behavior
  • Fixed issue with mapping of the ‘Order’ entity attributes
  • Fixed issue with logging import jobs when Email Notifications are enabled
  • Fixed issue with ‘Customers and addresses’ entity files not validating properly before import
  • Fixed issue with importing configurable products with custom logic, when links to images refer to store root
  • Fixed issue where during ‘Only update’ behavior URLs for products that have already been created were re-generated automatically if url_key attribute in the import table was empty
  • Fixed issue where bundle products were missing from the frontend after re-importing the same file
  • Fixed issue with ‘Cart Price Rules’ entity, where ‘Replace’ behavior has been adding new rules
  • Fixed issue with ‘Reviews’ entity, where after re-importing file ratings have been doubled at the frontend
  • Fixed issue with ‘Orders’ entity, where order totals were missing after re-importing a file without full attribute list

Continue Reading

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

Manual for
Improved Import / Export extension for Magento 2

Improved Import and Export extension allows importing csv/xml/json files with products 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 file, and starting from 2.1.1 version Google Sheets (Read about Google Sheet Master Table). 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.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

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 migrate from Magento 1 to Magento 2 with Improved Import and Export extension

Migrating from Magento 1 to Magento 2 is not a simple task. Using Magento data import tool may be a difficult task for the store owners who are not familiar with coding and working from the command line. Even for the Magento 2 developers this task may prove difficult because of how different the entities are 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 Improved Import and Export extension. 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

The Complete Guide to Magento 2 Product Import / Export

- Magento 2

Magento 2 Product Import Export Tutorial

Magento 2 and Magento 1 are quite different systems. Despite both have a lot of common features, there are some core differences between them as well. For instance, there are some unique opportunities related to Magento 2 product import/export. We’ve already written about import / export in Magento 1, so you can easily compare the old procedure with the new one. As for product import / export in Magento 2, it is fully described below.

Continue Reading