General Questions on Improved Import extension for Magento 2
How much technical knowledge required to use Improved Import & Export? Do I need a developer?
No, you can handle it on your own. However, prepare to study the information on how Magento 2 import works, and learn how to work with the entity attributes.
We have composed guides and manuals to help you get into Magento 2 data transfer processes. Firebear Studio blog is the most complete source of information on how Magento 2 import functions on the web.
Every piece of information on import and export processes can be found inside Magento 2 import and export guide list.
You can also create a ticket and ask Firebear Studio support team for advice.
Do you have a manual or user guide? I don’t know how to use the Import Export extension. Where can I view full instruction?
Yes, we do. We have composed an explicit manual that describes every option of Improved Import and provides necessary examples. For every entity you can import to your Magento 2 we have also composed a dedicated blog post, where we describe every single attribute and list entity import peculiarities.
And if you want a private demo of the Magento 2 Enterprise/Commerce version of the extension, please leave your request in the chat window in the bottom left corner of the screen.
Is the extension open source?
The extension has open code. Meaning that your in-house developer can make necessary adjustments if required, or completely customize the extension.
However, in case the customization is done to extension, we may be of limited assistance with technical support if anything breaks.
Additionally, heavy customizations mean that you will likely have issues with updating the extension to the newest version.
We advise having your developer provide you with the exact list of the modifications made, including file names and paths. Every modification should be thoroughly described. Developers tend to come and go, however, you will be working with the extension, and it is better to have everything ready for another developer to jump into the project.
Is the extension PWA-compatible?
Improved Import and Export is PWA-compatible. The functionality is purely backend-operational and it doesn’t affect the frontend performance of your store.
How my developers can customize the extension?
The code of the extension is open, you can have your developers study the extension code, and make necessary modifications. We also offer a customization module for building plug-ins for Improved Import & Export extension.
How Improved Import & Export is better than the default/native Magento 2 import?
Improved Import & Export is an extension that works similar to native Magento 2 import, however covers every Magento 2 entity, introduces support of multiple file types and sources. Refer to the table below for comparison.
Improved Import and Export
Native Magento 2 import tool
An open code Magento 2 extension
Open code with customization end-points and customization extension
File, FTP, SFTP, Google Sheets, Dropbox, direct URL, Soap API, Rest API, HTTPS
Add/update, only add, only update, replace, delete
Add/update, Replace, Delete
Attribute mapping for all entities
Map by attribute name, set default or clear attribute value
Import file separators mapping
All file types, either separator table or XSLT templates
Explicit documentation covering every entity both import and export
Documentation is lacking on attributes and how they behave
No programming skills required
No programming skills required
Migration from other e-commerce platforms
Magento 1, Shopify, Prestashop presets
How Improved Import & Export extension is better than a cheaper competitor import extension X which did exactly what I needed?
Development– the extension is being developed by certified Magento 2 specialists. We are a proud member of ExtDN – a network of developers that try to take the extension development to a new level of quality.
Support– six months of support are included in the extension price. Along with technical assistance, you can consult Firebear specialists on how to handle your import and export cases to make the solution suitable for your needs.
New features every quarter or often – we are constantly improving the extension introducing new entities, new sources, new file type support, and other conveniences.
Long run instead of a short job – import and export processes can improve your management and overall store performance. Integrations with CRM and ERP software, stock and price updates, customer and order management – this is the daily routine Improved Import & Export has been built for. When purchasing an import extension, think about how it can benefit you in the long run and think on the ROI.
Integrations– we have built many integrations with CRM and ERP software to make the Magento 2 the center of your business platform. Instead of SAAS, we offer every connector for a fixed price.
When the next version of the extension will be released
We tend to release new versions with updates at least every month. Minor releases with bugfixes tend to take up to two-three weeks, including testing, and fixes. Major releases introducing new functionality, entity support, and other features, tend to take about a month.
Can I import and export a custom entity? For example, I have an extension that makes my Magento 2 a marketplace where vendors sell their goods. Can I import these vendors?
With some modifications to the extension’s code – yes. Submit a support ticket with an inquiry. Maybe we already had a customer with the same request and have a ready code.
Generally, if you have a third-party extension that introduces a custom entity, or adds custom attributes to the existing entity, Improved Import can be adjusted to fetch necessary attributes.
However, it heavily depends on the modifications to the Magento 2 code. Anyways, hit us a line, and we will try to help.
Will the extension support custom attributes of customer, order, etc.?
Custom attributes for the entities which do not support manual creation of the attributes by the native means of Magneto 2 is a matter to look into. Submit a support ticket and provide the Firebear team with samples of the files you want to import. We will try to help you.
How I can import and export data created and managed by a third-party Magento 2 extension?
We try to support all the most popular third-party extensions that make any changes to the entities of Magento 2. Currently supported extensions include:
MageWorx Advanced Product Options for Magento 2
MageStore Inventory Management
Wyomind Advanced Inventory
Magedelight Price per Customer
Submit a support ticket and provide the Firebear team with samples of the files you want to import. We will try to help you.
How I can request new feature X and how much it will cost?
We are always having a poll on the new features to add to the Improved Import and Export extension you can find here.
If you require a particular feature developed for your project or require it on short notice, you can submit a help desk ticket. In the ticket, please describe what you want to achieve by composing a simplistic technical specification. Direct the support team to ask you questions.
After the feature request has been confirmed and discussed we will make you an offer you can accept or reject.
Does it work with Magento 2 order management, Magento 2 shipping?
FireBear offers the free Magento 2 migration add-on of Improved import and Export that allows performing migration of a Magento 1 store database to a Magento 2 instance or transferring data between two Magento 2 sites. Similar to the parent extension, the add-on requires no programming skills from users and supports transfers of all Magento 1 entities to Magento 2. The details on how to arrange a migration with the add-on you can find in the manual.
Also, we provide assisted migration so that our team will help you with a migration process. For requesting Magento 1 to Magento 2 migration contact our support team.
How to migrate data from ecommerce platform X to Magento 2 using Improved Import and Export?
The extension has numerous means for enabling synchronization between Magento 2 and other ecommerce systems, including file transfers, FTP/SFTP, or direct connection via API. The mapping feature allows you to transform data to applicable form for Magento 2 logic. As the migration works you can see following the example of FireBear Woocomerce to Magento 2 migration add-on.
I have used other import and export extension and now want to handle that process with Improved Import and Export. How to do it?
Improved Import and Export is extremely user-friendly. Starting with the extension requires no programming knowledge.
Each import and export you can configure at the corresponding tab at the Admin sidebar: System > Improved Import/Export > Import/Export Jobs. For each import or export job you can select a particular entity for a transfer, set up behavior, choose the best options for data sources and file formats, map attribute values.
Did you have Improved Import and Export for Magento 1 or another ecommerce platform?
At the moment, Improved Import and Export is the extension exclusive to Magento 2 platform. However, the extension has a high connectivity potential and can process data transferred from other e-commerce platforms or Magento 1 and prepare Magento 2 data for implementation into other system databases via integration add-ons.
Why Magento 2.0.x and 2.1.x is not supported? Why older versions of PHP and MYSQL are not supported?
Magento 2.0 and 2.1 are outdated in relation to the platform feature set and current technical requirements. Magento, an Adobe Company, has already stopped supporting the versions and moved on to newer PHP/MYSQL versions and upgraded system functionality.
As of now, only few merchants use Magento 2.0 and 2.1 versions for their stores. So to maintain the moderate price of Improved Import and Export on the same level we’ve decided to stop the versions support as well.
Is there API for import and export jobs?
API for import and export jobs is currently under development. The estimated time for the API release is 2021 till then you can turn to Magento API. As Improved Import and Export has open code you can modify it upon wish any time.
Firebear Studio services and policies
Can I request a refund for Improved Import & Export or other Firebear Studio extensions?
Yes, you are protected with a 30-days money-back guarantee. Meaning, that you can request a refund within 30 days since the date of the purchase. 30 days mark comes from the limitations of the payment methods used.
Do you offer installation and support?
Yes, FREE installation in the purchase of any paid Firebear Studio extension. If you require installation – please submit a support ticket with the request and SSH access to your Magento 2 store server and admin panel.
Six months of technical assistance are also included in the extension price. After the six months period, if you require additional technical assistance you can renew the support period from your account at https://firebearstudio.com/
Why should I pay for support and updates after 6 months? Why is the support period is paid?
Support is an on-going procedure. Your Magento 2 store is constantly developing, gets new extensions installed, new processes implemented, etc. That’s why technical issues may arise. Especially if you have integrated your CRM or ERP systems via Improved Import & Export extension. Third-party software is being updated constantly, and reevaluating and re-adjusting solutions take time and human hours.
Updates are also dependent on a couple of facts. Magento 2 updates and releases of the new versions mean that Firebear has to spend more time testing the extensions. 2.3 version of Magento differs greatly from 2.2, and 2.2 differs from 2.1. In addition, the Firebear development team constantly improves the Import extension. In a year the extension you have purchased will get a dozen new features, required polish, and speed improvements.
These two processes are constant, that is why we charge you for the updates and technical assistance. However, we don’t make it mandatory. You decide if you need new features, or if everything works fine and you are happy with the extension as it is of now.
Can I use the on multiple Magento 2 instances, is there dev and staying licenses?
The rule is – one extension license per single LIVE Magento 2 installation. You can use the extension on multiple development environments, however, the license agreement only allows the use of the extension on a single live Magento 2 store.
Multiple stores and store views are supported and allowed.
Can I transfer the license to another domain and Magento 2 instance?
Yes, you can do this. However, you must stop using and delete the extension from the previous instance. You are limited to a single live Magento 2 installation with installed extension per license.
If you want to have multiple Magento 2 installations with Firebear Studio extensions installed – you need to purchase additional licenses.
How can I change the customer account or email associated with the purchased license?
Please submit a help desk ticket and provide all the required details, including purchase information so we could confirm that you are the owner of the account.
How I can be ensured that sharing access credentials with Firebear Studio support like SSH, Magento admin, etc. is secure?
Firebear support team is only interested in providing technical assistance with the Improved Import and Export extension and solving any issues you might have with it.
You may want to restrict the SSH access to the required directories and database tables if you would like.
How I can request a trial for the extension?
At the moment we are not offering the extension for a trial.
However, we offer a 30-days money-back guarantee. So, in case the extension doesn’t work as you have expected you can always ask for a refund.
When my support ticket will be answered and resolved?
Our support team responses within 24 hours. Each and every case is reviewed individually and may take different amount of time to be solved. When you get your ticket resolved depends solely on the complexity of the task.
In which language can I get support?
We provide support in both English and Russian.
Can you provide support by phone, Skype, and TeamViewer?
If it is needed, we can provide communication with our developers via TeamViewer.
Can you configure and get it all up and running for me with custom files, systems and requirements?
We provide free installation and configuration services. As for custom work, we may provide it for free, if it is not that complex in terms of support.
As for complex solutions, we will need to estimate the project first.
Is there a discount for multiple licenses or agencies?
Contact our support team to get the best price on the extension.
Technical questions on Improved Import and Export
I stuck with import or export error, what to do?
Specify the Validation Strategy option to Skip error entries to import the only valid entities from the file.
Analyze the import job log and find data in the file which may be the cause of the issue.
Check if you have installed the last version of Improved Import Export.
Analyze the export job log and check the reason for the issue.
Check if you have installed the latest version of Improved Import Export.
Import or export job takes too long to load. Import and export is very slow
Try to split the file into several small files and import the files one by one.
Check that other processes like the reindex, the other import not run at the same time.
Use the Deferred Import Images option to import images by The Message Queue Framework.
Use the Enabled Cache Products option to import the only updated products after the latest job execution.
Use the filters to export only the needed entities.
Use the Consecutive Export option to export only new items after the latest job execution.
I am run out of server resources during the job run, how to fix this?
Change the Bunch size file attribute value to manage the entity count which is stored in the one database table row. To change the value go to Stores > Setting > Configurations > FIREBEAR STUDIO > Import Export -> Import Config.
Specify the General File Bunch Size and the Import FormatV2 Bunch Size values.
For export products to the CSV file: use the Export page by page option and specify the Page size attribute value on the Export Behavior tab.
Use the filters to export only the needed entities.
Use the Consecutive Export option to export only new items after the latest job execution.
I’m getting Fatal error: Interface ‘Box\Spout\Reader\IteratorInterface’ not found in /Users/jordanschinella/Sites/m2ee/ app/code/Firebear/ImportExport/Model/Import/Source/Spout/Ods/RowIterator.php on line 18 during di compile? What is the issue?
In case you didn’t use the composer for installing the extension you may be missing box/Spout library, which is required to import and export XLSX and ODS file formats. To fix the issue, in the command line, run:
composer require box/spout:2.7.3
Flush store cache, log out from the backend, and log in again. You now have the required version of box/Spout library installed.
If you have used the composer for installing the extension, the library should add automatically.
New attribute values have not been created after I imported products. Why?
You need to enable this setting first. Go to admin panel page Stores>Configuration>FIREBEAR STUDIO>Import Export find Create attributes values on the fly and set this setting to ‘Yes’.
How to create a new product (EAV) attributes during the import process?
You can use dedicated entity ‘Product Attributes’ to import and create attributes in your Magento 2 store. The step by step guide with sample tables can be found inside the Improved Import & Export Guide List blog post.
Product images were not imported when import processed?
There are two possible options how can one import images along with products:
For product image attributes use direct URL links. This way the extension will upload all images during the import
Upload all product images into /pub/media/import folder of your Magento 2 installation. This way the extension will always have a fresh reference to the product images.
NOTE: in your imported file, the values of all product image attribute columns should only include the path to product images relative to your import folder. For example, you’ve uploaded firebear.jpg to /pub/media/import, then you only need to insert /firebear.jpg to your CSV file.
Additionally, Starting from version 2.1.2 the extension comes with the Use Image Import Source switch. The switch decides how the extension will handle image paths if your source is FTP or SFTP.
If the Use Image Import Source switch is disabled, the extension will look for the images inside your Magento 2 root catalog, according to the path specified in any image attribute columns of the import table.
If the Use Image Import Source switch is enabled, the extension will look for the images INSIDE of the FTP/SFTP according to the path specified in any image attribute columns of the import table.
How to import media or product gallery images, in other words, bulk image upload to the system?
Upload all images to /pub/media/import folder relative to your Magento 2 root folder.
Insert the image list into the additional_images column of the imported table. The image links should only contain path relative to /pub/media/import and multiple image links should be separated by a comma. For example, if you uploaded all your images to /pub/media/import/my_products, the image path should look like:
If you are using CSV files, – make sure that the ‘Multiple value separator’ field value is set to comma.
I have a custom separator (slash, dash, semicolon, etc.) used for category levels. Can I still import categories?
Yes, you can. For CSV files you can set custom separators for multiple values and particular attributes. To do this, – navigate to the import job, and find two fields:
Category Levels separated by
Categories separated by
In these two fields you can specify the separators your custom file is using.
How to run an import job directly from the command line?
Run the command line:
php bin/magento import:job:runX
php bin/magento export:job:runX
Where X is the ID of the job you can find in the import and export job grids.
How to import downloadable products to the system?
Downloadable products are imported as all other product types, without particular peculiarities. We have composed a dedicated guide to help you import downloadable products. Please read the How to Import Downloadable Products blog post.
You can also look through sample files for downloadable product import:
I have a product attribute with Input Type = ‘Multiple Select’. How to import multiple attribute values?
Improved Import & Export extension can import product attributes to your Magento 2 store. With the Attributes entity, you can create multiple values for any attribute types without any problems. Read how to import product attributes.
Option:base_value and option:value. ‘Base’ value sets the admin value for the attribute. While ‘option:value’ sets the value for a particular store view.
When I import CSV file to my website, I see this error message: “Specified URL key already exists”. How to fix it?
There can be two causes of the issue:
You already have a product at your Magento 2 store with the same URL
Magento 2 specific issue that hasn’t been resolved
Both causes can be avoided using the Generate URL if duplicate setting of Improved Import & Export extension. When the setting is enabled in the import job, the duplicate URLs for both products and categories will be incremented if indeed the same URL already exists.
In the case of Magento 2 specific import issue, we have fixed it for Improved Import. So, if there are no actual duplicates in URL, your products and categories should be created successfully.
Please note, you may want to clear ‘url’ product attribute in the table you are importing. If there is no URL specified in the imported table, – Magento 2 will try to automatically create a URL for the products based on its ‘name’ attribute.
After the import process, all products are out of stock or disabled. Why?
Please make sure the value for ‘qty’ column in your imported table is greater than zero. If product quantity is not set or set to ‘0’ your Magento 2 considers such products as out of stock. Such products will only be enabled if you have allowed backorder functionality inside your store. You can enabled backorders at Stores>Configuration > Catalog > Inventory > Product Stock Options > Backorders.
Then, make sure that ‘is_in_stock’ column of your file is set to ‘1’. Even if you have set product quantity, this product attribute can set the product as ‘Out of Stock’ if set to ‘0’.
After import process, the status of all products is OFFLINE or disabled. Why?
Please make sure the value for ‘product_online’ column in your CSV file is set to ‘1’. This attribute allows you to enable or disable the product. The value for the disabled is ‘2’ not ‘0’ as one would expect. Make sure to consider it.
When I import CSV file, I get an error message like this: “Notice: iconv_strlen(): Detected an illegal character in input string”. How to fix this problem?
It seems that you are using special characters in the CSV file you are trying to import. To solve this problem, you can remove special characters or replace special characters with HTML code. Please follow this link to check for allowed characters: https://www.w3schools.com/html/html_symbols.asp
How to import the product images from the external server to my website using the FTP source, SFTP source, or Dropbox source?
Improved Import extension will download the product images from the external server to your website automatically. Moreover, we have considered the path you have specified to the image files with the Use Image Import Source settings.
Use Image Import Source allows you to tell the extension where to look for image paths – either inside your Magento 2 root folder or, if the option enabled, insider FTP, SFTP, or Dropbox.
For example, if in the imported table you have specified the path to the image as /folder1/folder2/image.png. The setting will define where the extension will look for this path – inside Magento 2 root of your server or inside FTP, SFTP, Dropbox, depending on where your file is located.
After I installed Import Export extension, I went to System > Import Job and see an error message like this : SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘import_jobs’ doesn’t exist … How to fix this problem?
Please go to your phpmyadmin account, then access your database, next find setup_module table, next please delete row containing ‘Firebear_ImportExport’ entry.
After the row is deleted – run the upgrade in the command line: php bin/magento setup:upgrade
I’ve faced Error: Cannot instantiate interface Firebear\ImportExport\Model\Lib\LibPoolInterface in /chroot/home/ae393a83/return2health.com.au /vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:50. What to do?
Try to flush the redis cache.
Where I can get sample files for import or export?
All the values in an import file can be separated with a special symbol, however, make sure to specify the same value separator during the import in the ‘Import Behavior’ settings. This way the extension will be able to process import data correctly.
How does mapping work?
The built-in mapping functionality of Improved import and Export allows modifying attribute, attribute values, and categories.
Mapping of attributes gives users the ability to match system attributes with the ones presented in the import table.
Mapping of attribute values matches system attribute values to the import values.
Category mapping helps create new categories during import, load new categories from the import file, and control the path to the category in the store.
If Remove Current Mappings is enabled – the map attribute section will not be processed.
Also, you can apply default attribute values to all the rows in a table or only to the empty rows.
Can I increase or decrease product price during the import to Magento 2?
Price adjustments can be applied right at the import job page. Scroll down the import job settings to the mapping field where you can find the ‘Price Rules’ section. Here you can round prices and special prices and generate rules for import product prices based on percent or fixed rates.
Can I run multiple import and export jobs at the same time to speed up the process?
You can try to set up cron schedules for import or export jobs and run another via the console. However, keep in mind that in this case server load may influence the overall speed negatively. Manual job running certainly won’t help speed the processes up.
Can I run import or export jobs after a specific event in Magento 2?
Yes, you can set up an export job to run after the following event s within Magento 2:
Specifying the export trigger event can be done in the general settings of an export job in the corresponding ‘Events’ field.
How can I use REST or SOAP connection?
REST and SOAP APIs are supported data sources for improved import. You can transfer your data files using API connection. To do so enable API at the ‘Import Settings’ section during import job configuration and select the relevant API connection at the ‘Import Sources‘ section. Then decide on the file format and enter the necessary call info.
I have files in format X which is not supported yet can I import and export on that format?
You can request the file format support as a feature here.
Can I import products, customers, orders, or other data that are separated into multiple files and data sources, formats?
You can import any entities supported by the extension with partial attributes as the functionality can both add new data and update the existing entities. However, you should keep in mind that with each partial import you will have to specify the required attributes that enable data processing during import. You can find which attributes are considered required in our Master Google Sheets Table in the description to each of them.
Can I set dependency between import and export jobs – run one job when another is done, etc.?
At the moment, the extension doesn’t support the logic. However, you can request the feature in our request form here.
Can it work together with other import or export M2 extension or service within the same Magento 2 instance?
The short answer is ‘probably yes’. However, it greatly depends on which code modifications in the core Magento 2 files has made the third party extension.
If you want to ensure the proper work of Improved Import and Export extension with the third-party module, you may want to set up the development environment and run necessary tests.
We offer a 30-days money-back guarantee. In case the extension doesn’t work as you expected, you can ask for a refund by submitting a help desk ticket.