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.

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)

3.7.2 (released 17.02.2022)

Features

• Product name column has been added to product reviews export to help you identify the products
• Downloadable product link has been added for order export and import

Bugfixes

• Fixed issue with regeneration of url-keys by name attribute when updating products with ‘sku’ and ‘name’ columns
• 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 incorrect creation of configurable variations after each bunch, when a configurable product and its variation in different bunches
• Fixed issue with updating stock status
• Fixed issue with empty columns in an export file after exporting products with the ‘Only fields from Mapping’ option enabled
• Added resizing of images to the image import process queue
• Fixed issue where it was not possible to update image labels for products
• Fixed issue with order filtering by Sales Order Products
• Fixed issue with incorrect tier prices export when exporting products
• Fixed “Test XSL Template” error when XML file as URL is used and XSLT configuration is enabled
• Fixed issue when using PHP function in XSL (registerPHPFunctions)
• Fixed issue with incorrect copying of an attribute values when using the “Custom logic for creation of configurable products behavior
• Fixed issue with products export where an image becomes hidden for all store views instead of for a specific store view
• Fixed issue with custom logic ‘Product attributes to copy value’ for relates_skus
• Fixed issue with the YouTube video import, where particular URL format has been required
• Fixed issue with importing URL rewrite for cms-pages and products
• Fixed issue with creating new columns in the database to store logs when upgrading to a new version of the extension
• Fixed issue with running import jobs in a chain
• Fixed issue with an attribute ‘Replace’ behavior
• Fixed issue with getting OneDrive redirect URI
• Fixed issue with ‘Delete’ behavior with the “URL rewrite” entity for import jobs
• Fixed issue with configurable products not being displaying at the store’s frontend after being created via import

3.7.1 (released 15.10.2021)

Bugfixes

• Fixed issue when creating configurable product during import resulted in adding system attribute values from child products even if these attributes have not been specified.

3.7.0 (released 20.09.2021)

Features

• Added filter by product categories for product export jobs
• 20-30% speed improvements for the import jobs with code refactoring
• Added possibility to store job logs inside the database for multi-server Magento 2 setup

Bugfixes

• Raised the version of “salsify/json-streaming-parser” module from ~6.0 to ~8.0
• Fixed issue with the “Map Attributes” section mapping validation
• Fixed issue with the validation strategy when importing a file with less rows than the maximum number of allowed errors
• Fixed issue with the wrong order of options after importing attributes
• Fixed issue when importing images with different roles for products when the role hasn’t been assigned
• Fixed issue with updating the status and visibility of configurable products when using the ‘Custom logic for creation of configurable products’ setting
• Fixed issue with ‘Disable products which are not in the file’ functionality when using the ‘MagMi’ platform for product import
• Fixed issue with OneDrive permission problem and root slash
• Fixed issue with the parallel launch of jobs not being executed properly
• Fixed issue with export filter for product ‘quantity’ not working properly
• Fixed issue with importing orders when the order isn’t correctly displayed at the store’s dashboard
• Fixed issue with json serializer with malformed UTF-8 characters error
• Fixed issue with CmsPage and CmsBlock export job filters not displaying relevant attributes
• Fixed issue with Product export job filter by stock status
• Fixed issue with import product category errors not allowing to rename categories
• Fixed issue with updating the Salable Quantity of the product during import
• Fixed issue with import configurable and simple products when using a Magento 1 platform

3.6.2 (released 15.09.2021)

Features

• Removed Laminas library dependency for proper Magento 2.4.3 support

3.6.1 (released 18.08.2021)

Features

• Fixed serializer for compatibility with Magento 2.4.3

3.6.0 (released 3.08.2021)

Features

• Improved Import & Export version 3.6.0 supports only Magento 2.3.x and 2.4.x versions. The latest version of Improved Import & Export to support Magento 2.2.x is 3.5.2
• Added possibility to schedule the jobs to run one after another
• Added possibility to associate child simple product reviews to parent configurable and bundle products during product import
• Box/Spout library version support upgraded to ^3.1 to properly work with other extensions on the market
• Added possibility to add tracking number to the orders without importing product SKUs and completing the order
• Added possibility to import only fields from attribute mapping for the following entities: products, orders, categories, customers main, customer addresses, and customers and addresses (single file from Magento 1)

Bugfixes

• Fixed issue with duplicate images in the database, when importing products for all store views
• Fixed issue with the incorrect updates of customizable options when importing simple products with ‘Add/Update’ behavior
• Fixed issue with “Clear Attribute Values” feature with ‘Only Update’ behavior
• Fixed issue with downloadable products missing information in the export file, courtesy of Magento 2 native import behavior
• Fixed “Item with the same ID already exists” error after importing a downloadable product
• Fixed issue with imported products not being available, when importing with ‘Remove All Images’ and ‘Remove Images from Directory’ enabled at the same time
• Fixed issue with tabulation separator providing incorrect import results
• Fixed issue with downloadable products when ‘group_title’ attribute value was not imported
• Fixed issue with sending emails without the error log and before process completes
• Fixed issue with export products when ‘base_image’, ‘base_image_label’, ‘thumbnail_image’, ‘thumbnail_image_label’ attributes values were not with ‘Only field from mapping’ feature set to ‘Yes’
• Fixed issue with product import when ‘use_config_manage_stock’ attribute hasn’t been updated to ‘Yes’
• Fixed error ‘Undefined index: copy_simple_value’
• Fixed issue when importing products with ‘image’ attribute and without ‘store_view_code’ attribute wouldn’t update the images at all store views
• Fixed issue when ‘Delete file after import’ wouldn’t work
• Fixed issue with validation strategy ‘Skip error entries/Stop on Error’ not working when running an import job by CRON
• Fixed issue with behavior ‘Delete’ not deleting products if the file didn’t have ‘product_type’ attribute
• Fixed issue error ‘Integrity constraint violation’ when importing orders

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

3.5.1 (released 19.02.2021)

Features

• Magento 2.4.2 support and compatibility
• Find & Replace filters for Import jobs – allows searching for attribute values and replacing phrases or individual words or numbers with new values
• Index management – it is now possible to choose which indices should be reindexed after the import is finished
• Archive file after import – it is now possible to archive imported files downloaded to Magento 2 server right after the import is finished
• Archive file after export – it is now possible to archive exported files right after the export is finished
• Archive file before consecutive export – it is now possible to archive exported files before the consecutive run of the export job to preserve previously exported file
• Attribute Mapping section pagination added – now every 10 rows of mapping are grouped into a page to improve the import job load speed 
• Magento 1 product mapping preset has been reenabled and is now available
• Improved import job pages loading speed

Bugfixes

• Fixed issue when trying to save a job from the job grid
• Fixed issue where Json file type and ‘URL’ import source would receive three or more calls to retrieve the import file
• Fixed conflict between ‘Disable products not in list’ and ‘Enabled Cache Products’, when cached products were considered as not in the list and were disabled after consecutive import
• Fixed issue with Categories import, when ‘Use default value’ checkbox was not applied to ‘URL Key’ field after import
• Fixed issue with adapter classes loaded through DI.xml or ObjectManager
• Fixed issue with export jobs running automatically on Magento 2 System Events even when disabled
• Fixed issue when export files were not available for download from Magento 2 admin panel when export job was executed from the command line
• Password field now properly hides any input
• Restricted use of the same file path for multiple export jobs – now every export job should have a unique destination
• Fixed issue product import resulting in Option.php error
• Fixed issue with REST API when using import
• Fixed issue with undefined index issue on Import job save
• Fixed issue when ‘Advanced Pricing’ entity files couldn’t validate on Magento 2 Cloud
• Fixed issue with ‘Map Attributes’ section displaying attributes only for ‘Products’ entity

3.5.0 (released 7.12.2020)

Features

• It is now possible to import and export jobs from one Magento 2 instance to another
• Product URL generation by pattern is now available
• All password fields are now properly hide and protect entered values
• Added log message to the console to show that the product image is downloaded from the import source
• Improvements to XSLT Translation

Bugfixes

• Fixed issue with the the undefined tooltip at the export job page
• Fixed issue with the incorrect sorting of the attributes for the order entity, when only fields from the mapping feature are selected on the export job page
• Fixed issue with importing ‘product attributes’ entity when switching from dropdown to textswatch type
• Fixed issue with the array to string conversion, when the widgets entity selected
• Fixed issue with importing credit memos
• Fixed issue with the tier price update, when the percentage_value attribute updated
• Fixed issue with the price rules creating extra rows during export
• Fixed issue with updating product images
• Fixed issue with the disallowed XML file format
• Fixed issue with the ‘category’ entity validateRow when used with the required attributes
• Fixed issue with updating URL key at the store view level
• Fixed issue with the Allowed Errors Count setting, it now properly counts the errors
• Fixed issue with the the incorrect export file structure, when the file format is XML or JSON, and the entity is a sales order
• Fixed issue with the error while creating object for Magento\MediaGalleryIntegration\Plugin\SaveImageInformation for Magento 2.4.x
• Changed the list of the allowed file extensions specifying which export file formats are available for download
• Out of stock qty attribute is now added to the product attribute mapping section

3.4.6 (released 18.09.2020)

Features

• Added functionality to update the order in which configurable product variations should be displayed at the frontend
• Added functionality to reindex only required indices after import process is finished, instead of reindexing all indices

Bugfixes

• Added missing swatch attribute values into the mapping section
• Added possibility to export tier prices for products in the same file, using custom tier price attribute of Improved Import Extension
• Product option values are now added to the order export file
• Fixed issue with validation errors output
• Fixed issue with the shipment track generation
• Fixed issue with json validation for order export
• Fixed issue with product import process leading to 500 internal server error
• Fixed issue with DotMailer for M2.3.3-p1
• Fixed issue with changing XSLT templates if wrong XSLT attached not being possible
• Fixed issue when extra fields were added to file during order export with enabled ‘Only fields from mapping’ option.
• Fixed issue with the number of columns not corresponding to the number of rows in the header for ODS export files
• Fixed issue with ‘category’ url not being updated for different store views
• Removed custom options from Magento’s default __EMPTY__VALUE__ constant
• Fixed issue with products export to GoogleSheet having a limitation if exporting more than 500 rows

3.4.3 (released 24.07.2020)

Features

• Compatibility with Magento 2.4 Open Source, Commerce, Cloud
• Import and export job mapping section improvements
• You can now add product attributes to the exported file of the ‘Order’ entity for better reference

Bugfixes

• Use default value for “enable product” in store views
• Fixed issue with ‘Category’ entity export for ALL STORE VIEWS in Magento 2.4.0
• Fixed issue with ‘Product attributes’ entity export
• Fixed issue with Issue with Magento_Inventory disable for customers then it breaks the import
• Fixed issue with output not needed in processor
• Fixed issue with product ‘url_key’ generation
• Fixed issue with ‘Products’ entity when exporting ‘attribute_code’ of multiple attribute sets

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

3.3.2 (released 21.04.2020)

Features

• Added email notifications upon successful and failed import and export jobs. Notifications can include job log file up to 10Mb.
• Added support for Json file type for export jobs
• Added feature to generate shipment and invoice for orders when importing tracking code with the order entity – order status updates upon importing tracking codes
• Added customer groups id validation

Bugfixes

• Added console error if deleting customer when he is a company admin when importing customers with ‘Delete’ behavior
• Added store view code filter for export page
• Added behavior ‘replace’ and fixed mapping for ‘search synonyms’ entity import
• Added ‘skus’ field validation
• Temporary files are now properly removed after export
• ‘Stock Sources’ entity is no longer displayed if module ImportExportMsi is not installed
• PHP 7.0 – removed protected constants as those aren’t allowed in
• Fixed issue with undefined variables
• Fixed issue with SQL column count error
• Fixed undefined variable warning
• Fixed issue with date format when saved for special_price_from_date being saved wrong
• Fixed issue with exporting XLSX and ODS files to FTP and SFTP
• Fixed store view code filter of export page for CE
• Fixed issue with validating customer’s address entity if same entity id is at another customer. Error is not properly displayed in the log.
• Fix missing data for column ‘category_ids’ when exporting products with mapping, and added column ‘category_ids’ when exporting products without mapping
• Fixed issue with importing product for various store view codes
• Fixed issue with behavior ‘replace’ for ‘quotes’ entity
• Fixed issue with behavior ‘replace’ for ‘search terms’ entity
• Fixed issue with preparing entity name for console output
• Fixed issue with ‘id’ column for ‘search terms’ entity
• Fixed issue with exporting advanced pricing with mappings enabled
• Fixed issue with ‘reviews’ entity export removing extra data
• Fixed issue with ‘widget’ entity export remove extra data
• Fixed issue where the review published date was not imported properly

3.3.1 quick adjustments for Product Feeds (released 26.02.2020)

Features

• Added support of entities limitation count for product export

Bugfixes

• Fixed issue where product categories value has been exported empty
• Method made public in Model\Export\Product.php for add-on attachments

3.3.0 (released 26.02.2020)

Features

• Export process speed improvements
• Added new entity Newsletter Subscribers (read more)
• Added new import and export source Google Drive (read more)
• Added export to Google Sheets (read more). It is now full circle integration.
• Added filter by store view for entity ‘CMS blocks’
• Now, when importing categories and url_key и url_path attributes are empty or missing the category URL is automatically generated using name attribute

Bugfixes

• Fixed issue where replace behavior with entity ‘Orders’ has been adding new orders
• ‘Remove current mappings’ selector now properly clears attribute values
• Fixed issue with entity ‘Orders’ filter by SKU not importing proper data
• Fixed issue where you could import entity ‘Catalog Price Rules’ with only a single attribute
• Fixed issue where product attributes couldn’t be allocated to proper store view after the import
• Fixed issue where all filters for entity ‘Catalog Price Rules’ were of the ‘text field’ type
• Fixed issue with opening jobs with FTP and SFTP import sources
• Fixed issue with custom_theme_value not being imported properly for ‘CMS Page’ entity
• Fixed issue where the success message has been missing after importing ‘Catalog Price Rules’ entity
• Fixed issue where it has not been possible to import XLSX file with source ‘Direct URL’

3.2.4 (released 21.01.2020)

Bugfixes

• Fixed issue with the number of products being different after exporting and re-importing
• Added improvement to product URL key generation on import
• Fixed issue with downloading an exported file if the REST API source is selected
• Added improvement to product image uploads from external URLs, now the Import properly checks if images already exists by filename
• Fixed issue where importing bundle products with dynamic price wouldn’t set the product price to dynamic
• Added ‘attribute set’, ‘store id’ and ‘group:name’ filter for Product Attributes export
• Fixed issue with deleting mapped attributes from the Map Attributes section
• Added improvement for the category URL key generation if the entity with the same URL key already exists
• If store view field for Products is empty or missing in the imported file, the admin value will be assigned to it automatically
• Custom URL rewrites are now properly validated when generating URLs for imported categories
• Added correct reset data for filters

3.2.3 (released 10.12.2019)

Features

• Images for swatch attributes can now be uploaded via ‘Attribute’ entity
• Added option to resize product images after the import process, for cases when watermarks are enabled in Magento 2 Enterprise. Uses native Magento 2 libraries and can use additional library found in the manual.
• Product video URLs from YouTube and Vimeo can now be included inside product image attributes

Bugfixes

• Free Migration Add-on improvements – disable Magento 2 Enterprise and Cloud staging preview when migrating to avoid errors
• Fixed issue with JS showing import job features when wrong entity selected
• Fixed issue with export product grid sometimes breaking
• Fixed compilation issue with Magento 2.2.x
• Fixed issue with directory separators if the filename is not followed by the slash
• Fixed sql issue with Magento 2 Enterprise and Cloud instances for entity ID columns
• Fixed issue with creating Configurable Products and image copy
• Fixed issue with empty import source when any platform is selected for import
• Fixed issue with decoding transaction additional_information in json format. The unnecessary decoding has been removed
• Numeric validation for attribute code has been added to Attribute entity import

3.2.2 (released 19.11.2019)

Features

• Added new entity Catalog Price Rules import and export
• Excel files can now fetch sheets through other sources

Bugfixes

• Fixed issue with php 7.3.11 breaking on using continue in switch statements
• Widget entity import and export format updated
• Fixed issue with saving attribute_set_id for eav_attribute_group table
• Fixed issue with category name not exporting store view level
• Fixed issue with file path field missing in import jobs
• URL key now properly cleared with ‘Only Update’ behavior
• Fixed issue with configurable product with values like 0 or 00

3.2.1 (released 7.11.2019)

Hotfix

• PHP 7.3.11 support for Magento 2.3 added. Issue with breaks on using continue in the switch statement

3.2.0 (released 31.10.2019)

Features

• PHP 7.3 full support
• Full compatibility with Magento 2.3.3 versions
• Timestamp added for each log entry
• Added a selector allowing to remove product associated images from the server to free up server space, if import constantly imports new images
• Widget import rework to include all attributes

Bugfixes

• Added custom Search terms mapping
• Added custom Search synonyms mapping
• Added Remove all address association checkbox for Customer addresses import. Firstly remove all addresses when customer addresses import
• Fixed issue with ‘Search Synonyms’ import if mapping default value is empty
• Fixed all filters for export jobs
• Fixed Search Terms export issue with filters
• Fixed issue with Map Attributes Default value for all rows and empty rows
• Fixed form break when category id is not found
• Fixed import remote images issue
• Fixed issue with importing attributes to General group
• Fixed Categories import ‘replace’ behavior
• Fixed Reviews import ‘replace’ behavior. ‘Replace’ must add nothing, only replace existing reviews
• Fixed issue with export folders couldn’t be created for some systems
• Fixed issue with permissions for newly created folder while exporting
• Fixed issue with exporting to FTP recursively creating a folder
• Fixed issue with ‘cart price rules’ entity hanging the page when edit job on Magento 2.3.3
• Fixed View History – when two or more job tabs are open in the browser
• Fixed issue with HTTPS type image URLs import
• Fixed error on import building address information based on customer information if missing
• Fixed if ‘isset’ category_position not adding products to the proper category
• Removed duplicates for attribute mapping
• Defined variable for uploader
• SFTP will now properly create a new folder if the folder does not exist
• Improved ‘Root Category’ selection
• Improved downloadable products import
• Extension details link was removed from the extension menu
• Configurable Products custom logic has been moved to function based

3.1.8 (released 16.09.2019)

Features

• Added URL rewrites entity for import and export
• Added Widgets entity for import and export
• Added Product Reviews entity for import and export
• Added Catalog Search Terms entity for import and export
• Added Search Synonyms entity for import and export
• Added Gift Card entity for import and export (Magento 2 Commerce/Cloud only)
• Added Page Hierarchy entity for import and export (Magento 2 Commerce/Cloud only)
• Added Visual Merchandise – product category position attribute – import and export
• Added possibility to ‘disable’ products in your Magento 2 if they are not in the imported table
• Added support for multisheet Excel XLSX files – you can select the sheet to import from
• Added possibility to specify the URL path to images in the Image File Directory field in addition to FTP path
• Added new cron group to register import or export job crons in the same group
• Dropbox source improvements: folder select, whitespaces in filenames, latest file
• Change cron group for dynamic cron handling.
• Upsell and Crossell products can now be removed on import completion
• Categories can now be imported and exported per store view
• Attribute option values can now be deleted during import
• Attributes can now be imported and exported for specific store view

Bugfixes

• Fixed issue where products would export for all store views instead of default only
• Fixed issue where the images with the same filename were uploaded to the server
• Fixed issue with attribute option values not imported for particular store views
• Fixed issue with the order export where the extension log wouldn’t give proper error
• Fixed issue with product import exception generate_url
• Fixed change format curl-request in Dropbox.
• Fixed issue where default attribute value could be deleted
• Fixed unserialized error in the job form
• Fixed issue where date filters wouldn’t work for order export
• Fixed issue where downloadable products wouldn’t import on schedule, only manually
• Fixed issue where rice rules were not applied for existing products (added categories to price rule conditions)
• Fixed issue where long XSLT code was preventing the jobs from editing
• Fixed issue where all file validation errors were cleared
• Fixed undefined error when importing Advanced Pricing
• Fixed issue with exporting customer addresses with invalid _website attribute
• Fixed wyomind integration class definition
• Fixed issue with pipe separator for varchar attribute changed to ‘comma separated’
• Fixed issue where configurable products with only a single variation couldn’t be created
• Fixed issue with Text Swatch attribute type import, if there was a change in description new value were added
• Fixed issue with Text Swatch exporting admin value instead of admin description
• Fixed issue with Categories import with ‘/’ as a separator breaking category pathing for CSV files
• Fixed issue with pipe separator changing to comma for CSV files
• Fixed issue with Product Attributes import with ‘0’ value
• Fixed issue with attributes mapping unable to set default value to ‘0’
• Fixed issue with Advanced Pricing importing only the last value in the row
• Fixed issue with saving export jobs with undefined filter resulting in js error
• Fixed issue with ‘Import source’ field sometimes missing values on first job loads
• Fixed issue with ‘additional_attributes’ column not being removed when ‘Divide additional attributes’ setting enabled
• Fixed issue with importing Magento 1 payment information converting serialize data to json
• Fixed issue with simple products not being attached to grouped products during import
• Fixed issue with ‘Replace’ behavior sometimes giving console error during job execution
• Fixed issue with the Product entity import giving ‘url is not unique’ error with ‘replace’ behavior
• Fixed issue with SOAP API file validation
• Fixed issue with Advanced Pricing export job exporting not all price data
• Fixed issue with the export jobs exporting data for all store views if no store view has been selected
• Fixed issue with setFinishedAt function called before import process is finished
• Fixed issue where product image and status were not imported if attribute mapping has been enabled
• Fixed issue with line breaks when exporting text areas
• Fixed issue with date and time filters for export jobs sometimes functioning improperly
• Fixed issue with Map Attribute sections sometimes deleting incorrect mapping row
• Fixed issue with ‘replace’ behavior adding new entities for Customers and Category entities
• Fixed issue with not working Category Level Separator
• If image is not found the proper message is now displayed in the extension log and console
• Depending on the selected entity, some of the options are not properly hidden
• Updated file validation criteria when importing Product Attributes
• For importing product attributes added an error message if the attribute_set (required attribute) is empty
• Missing attributes have been added to Map Attributes section for ALL entities
• Store view selector is now properly displayed only for the entities that support multiple store views
• Updated sample files in both GitHub and Master Table Google Sheet
• Swatches attribute type values can now be properly imported with additional_attributes column
• Refactored export model configuration, merget config from config.xml and di_export.xml
• EntityInterface implemented into the export models
• Split database setup is not properly supported for Order entity
• Implemented retry functionality when deadlock mysql error occurs
• Magento Order Management is now proprely supported
• Configurable products from Magento 1 MagMi CSV tables can now be properly created in Magento 2
• Import job and console log now properly display error message if the product has empty SKU value
• Products are now exported page by page to avoid timeout issue

3.1.7

Features

• Speed improvements when importing and exporting huge data files
• Speed improvements for loading collections
• Files for the jobs can now be uploaded using API
• Added selector to Remove all assigned categories from existing products before import job execution
• General extension code improvements
• Magento 2 Page Builder is supported by CMS blocks and CMS pages entities

Bugfixes

• Fixed all installation issues under different conditions
• Removed ‘Magento 2’ attribute mapping preset
• Improved file validation from FTP and SFTP sources
• Fixed issue with XLSX files having incorrect column count resulting in not all entities imported
• Fixed issue with grouped products ‘catalog_product_relation’ attribute not being read properly
• Fixed issue with URL rewrites not being saved on product URL change during import
• Fixed issue with fatal error being displayed when products had duplocate url_key’s
• Fixed issue with filter section breaking upon adding new filters
• Fixed issue with filter and map attributes sections not being displayed for some entities
• Fixed issue with replace behavior not working with ‘order’ entity
• Fixed issue with category mapping section sometimes hanging the page when there are too many entries
• Fixed issue with import job giving ‘Please make sure attribute “name” is not empty’ for no reason
• Fixed issue with use_product_image_for_swatch attribute when swatches option enabled
• Fixed issue with configurable product thumbnail image not updated properly
• Fixed issue with exporting orders with ‘Only attributes from mapping’ option enabled
• Fixed issue when simple products with custom options caused orders to give ‘Submit shipment’ error
• Fixed issue with exporting bundle products using ‘;’ as multi-value separator giving error messages
• Fixed issue with importing products with mapping sometimes giving exception errors
• Proper error message is now displayed when product_type attribute is missing from product import file
• Fixed issue with B2B add-on when exporting quotes into XLSX file types
• Fixed issue with B2B add-on with products not being removed from the quotes (abandoned carts)
• Importing products no longer puts products out of stock by default (Magento 2 heritage)
• Fixed issue with import jobs permanent loading screen on first load
• Fixed issue with validating ‘Customers and addresses’ files
• Fixed issue for CMS blocks import job validation errors on attribute mapping
• Fixed issue with deleting all products giving 500 error
• Fixed issue with Map Attributes section behavior when deleting mapped attributes
• Fixed issue with Shopify products sometimes missing images after import when migrating to Magento 2
• Fixed issue with broken Map Attributes section block
• Fixed issue with switching entities caused the link to the file to stay
• Fixed “can’t save job” issue
• Fixed issue with ‘Cannot read property ‘length’ of undefined’ error
• Fixed issue with file validation in native Magento 2 import
• Fixed issue with ‘delete’ behavior removing not all products
• Fixed issue with root category in the imported file causing issue with categories import
• Fixed issue with validating Json file types
• Fixed issue with editing import job with entity ‘orders’ giving an exception error
• Fixed issue with ‘The import was successful’ message missing from the log
• Fixed issue when exporting products without url_key attribute
• Fixed issue with downloadable products not being imported if the job runs automatically
• Fixed issue with Typeof verification
• Fixed issue with attribute options not being imported sometimes
• Fixed issue with ‘Advanced Pricing’ not being imported properly
• Fixed issue with ‘Customer finance’ file validation

3.1.6

Features

• Adjustments to the extension’s backend menu
• Added Rest API and an export source
• Added input of a range of values for the filter by price. Range added with a hyphen, e.g. 10-60 or 0-25
• Implemented unification of filter values for a fixed price and a percentage discount
• Added support of removing old categories of the configurable products created on the fly
• Added the ability to add related, cross-sells or up-sells products to “Custom logic for creation of configurable products” – such products are added automatically from the similar attributes of the first simple product in the table
• Improved export speed by avoiding extra data download

Bugfixes

• Fixed issue with export filters for entities: CMS blocks, CMS pages, Attributes
• Fixed issue with validation of the incorrect product_type value
• Addressed potential issues with the behavior ‘Only Update’ when ‘Remove Product Website‘ feature is enabled
• Fixed issue with ‘bundle_type’ attribute import
• Fixed Magento 2 issue with undefined index (https://github.com/magento/magento2/pull/20916)
• Fixed issue with broken mapping section design
• Fixed issue with Advanced Pricing export filters displaying only product attributes
• Fixed issue with Map Attributes section not displaying for particular entities
• Fixed issue with missing job sections when conflicting with third-party software
• Added valuesForOptions for all supported entities
• Fixed issue with category url_key
• Fixed issue with catalog_product_relation
• Fixed issue with category use_default getting removed on category update
• Changed the algorithm for generating a request for sample of data in accordance with the set values of the selected filters
• Fixed issue with SOAP options not being accept while making the call.
• Fixed issue with native Magento 2 import validation
• Fixed errors when importing orders
• Fixed issue with the save_rewrites_history product attribute saving after import
• Fixed empty values for Virtual Swatch and Text Swatch attribute options
• Fixed issue with XLSX file having empty rows
• Fixed issue with replacing orders during import
• Fixed issue with ‘Remove Product Categories’ option interface class
• Fixed issue with filename issue in the url
• Fixed issue with displaying error messages when running export jobs from the console
• Fixed issue tire_prices column having extra spaces
• Fixed issue with JSON parsing finding first array
• Fixed issue with applying ‘Multiple Value Separator’ setting in import jobs when importing grouped products using “associated_skus” column
• Fixed issue with fieldset visibility issue on the import job form
• Fixed issue with attribute value mapping when API returns an array
• Fixed typo error in source_types.xml

3.1.5

Features

• Huge product import speed improvements: memory overflow was fixed, custom options import was refactored
• Added feature to remove images for both simple and configurable products during import

Bugfixes

• Fixed issue when only first custom option was validated while product import
• Fixed customer address import issue. When a file format is ODS
• Fixed issue with import XSLX file. When a file contains empty cells for the last column
• Fixed issue with Allowed Errors Count option. When Validation Strategy is Stop on Error
• Fixed issue show map fields of advanced pricing
• Fixed issue show filter fields of advanced pricing
• Empty user agent parameter issue during export an image from CDN
• Fixed issue with custom options import. When the Map Attributes feature is used

3.1.4

Features

• Remove existing categories from imported products and assign only the categories from the imported file
• Remove existing store views from imported products and assign only the store views from the imported file
• Import product categories by IDs with categories_id attribute (categories should already exist at the store)

Bugfixes

• Added support of increment_id for importing customer addresses, which gives the ability to update existing addresses
• Added support for query type image URLs
• Added UrlKey Manager to check existing product URLs
• Removed extra whitespaces from REST api for JSON options
• Issue with Magento 2.2.7 History Model defined as private in parent class
• Issue when the row does not contain complete information about product custom options
• Issue with mapping same attribute with different system attributes
• Issue with additional images multivalue separator. Added a condition to check for the previous version
• Foreign key issue when using ProxySQL
• Issue with absolute path of хml file (magento 2.1.8)
• Issue with ‘category’ and ‘product_websites’ attributes for products not exporting when multiple store_views are selected
• Issue with fresh installation of the extension
• Issue with importing a single product in several bunches
• Issue with swatch option update during product import procedure
• Issue with importing bundle products in Magento 2.1
• Issue with the stop on error option during the import process
• Issue with directory separator in the export file path

3.1.3

Features

• Magento 2.3 support added

Bugfixes

• Issue with cron expression is not set
• Issue when the row does not contain complete information about custom options
• Custom columns were added to the System Attribute drop-down in ‘Map attributes’ block
• Remove extra whitespaces from xml import form definition
• Issue with bundle product attributes: price_type, sku_type, weight_type
• Added validation of the field “custom_layout_update”

3.1.2

Features

• Magento 2.3 support added

Bugfixes

• Issue when importing empty attributes ‘available_sort_by’ and ‘default_sort_by’
• Issue with duplicated options
• Issue when importing orders with empty country_id
• Issue with “Clear Attribute Values” option
• Issue with import of customers and addresses
• Issue when replacing products: Invalid value for Attribute Set column (set doesn’t exist?)
• Issue when simple products are not attached to configurable
• Compilation issue: Incompatible argument type. Magento compiler allow only one parent::__construct() calls

3.1.0

Features

• Map Attributes – Apply Default Values to – decide if default value should be applied to empty or all rows
• Attribute value mapping – decide which exact attribute values you want to update, paste them and the new value
• Root Category – select root category to reference category paths in the import file
• Round prices and special prices – automatically adjust prices to .99 or .49 whichever is closer
• Export job event system – whenever the Magento 2 event happens the job is automatically executed
• Attribute set update – an additional product attribute which defines if the existing product’s attribute set should or should not be updated
• Configurable product custom logic – copy simple product attributes for configurable – now you can copy selected attribute values of the simple products to configurable product

Bugfixes

• Simple custom options are not imported properly
• Issue with ‘Category Levels separated by’ setting
• additional_attributes attribute missing in the attribute mapping column
• Issue with Only Update behavior importing stock values
• Issue with text swatch attribute displaying as a dropdown
• Fixed Product Tax issue with updating existing products
• Job page loading speed improved
• Imported configurable products are no longer automatically put in stock after import
• Configurable products are no longer created if there are no variations or a single variation
• Issue with importing products with the same URL key creating multiple products
• Updated links to the sample files inside import jobs
• Issue with product export missing bundle and downloadable attributes
• Issue with downloadable product links not being updated on import
• Issue with filter conditions
• Issue with checking for existing SKUs in the database
• Issue with customer composite entity type import
• Issue with exporting products with ‘Divide Additional Attribute’s option enabled

3.0.0

• Added support of Excel XLSX file format
• Added support of OpenOffice ODS file format
• Added support of REST API  – XML files with XSLT templates and custom Json files
• Added support of SOAP API – XML files with XSLT templates and custom Json files
• Added improved Json file compatibility
• Added new entity Product Attributes – now all attributes, attribute sets and groups can be exported and imported to Magento 2
• Added consecutive export procedure – the export jobs can now remember already exported entities and export only NEW entities added since the last run
• Export date and time can now be added automatically to the file name
• All files from the specified folder can now be imported in a single job
• Swatch attribute values, both color and image, can now be imported along with products
• Default product variations of Improved Configurable Product extension can now be imported
• Added compatibility with the following third-party extensions:
  • MageWorx Advanced Product Options
  • MageStore Inventory Management
  • Wyomind Advanced Inventory
  • MageDelight Price per Customer

2.2.0

• Added order import and export
• Added support of Json file import

2.1.8

• Added custom field for attribute mapping
• Added reset mapping button

2.1.7

• Added support of XSLT transformation for XML file export

2.1.6

• Added support of XSLT transformation for XML file import

2.1.5

• Addressed cannot import conditions for CartPriceRules issue
• Addressed cannot add categories in mapping issue
• Addressed cannot add tier prices issue
• Addressed cannot change name of category for different stores issue
• Addressed change CSV for Export Orders issue

2.1.4

• Addressed cannot change mapping categories issue
• Addressed cannot add new values for attribute issue

2.1.3

• Added Categories import and export
• Added category mapping
• Dozens of import / export mapping & filters fixes and improvements
• Bugfixes

2.1.2

• Added Shopify migration mapping preset
• Added price adjustment rules for imported products
• Added CMS pages import
• Added Cart Price Rules import
• Big fixes

2.1.1

• Full support of Google Sheets, Import Jobs can target Google Sheets as a source;
• Google Master Table for quick introduction to import procedure;
• Tier prices can now be imported along with the product catalog in a single column;
• Language/locale settings per Import Job;
• Models refactoring according to Magento marketplace Extension Quality Program;
• Create configurable products on the fly;
• Custom logic for creating configurable products;
• Fixed product tax import;
• Dozens of import / export mapping & filters fixes and improvements

2.1.0

• Added hardvalue for the Entity field;
• Adjusted values for fields of the bundle products;
• Added possibility of automatic reindex after import;
• Improved import process in Magento 2 administrator area, now it is possible to handle huge import jobs from the browser;
• Logs to console via administrator area;
• Adjusted area code in the console;
• ‘Only update’ behavior added to Import Jobs;
• New fields for the Export filters.

2.0.0

• Full Magento 2.2 , 2.2.1 and 2.1.10 – Open Source (Community), Commerce (Enterprise) and Cloud Editions support
• general refactoring
• add export jobs similar to import jobs with mapping
• refactoring and improvements for import mapping
• hardcoded values / default values on mapping export
• Magento 1 pre set for import jobs
• export orders jobs with mapping and filters
• add file validation on import job
• advanced pricing import performance issue
• filtering for export for all entities by attributes
• interaction for default values when should be unique , x1, x2 etc.
• default / hardcoded value suffix & prefix
• detailed logging
• sample files included to extension pack & download from manual
• unzip / untar file before import
• upload CSV directly to import job on import form (in web browser)

1.5.0

• Fixed bugs:
  • Fixed an issue where strategy validation did not work with value “skip on entries”
• Restructured code for form of Import Jobs:
  • Form at style of Accordeon *Add features:
  • Add inline edit for field Cron in Grid
  • Add validate of file after entered data for file
• Add Export Jobs:
  • Add grid
  • Add form
  • Add commands
  • Add crontab

1.4.0

• Bugfixes
• Code cleanup

1.3.0

• Downloabale products import fixes
• Categories import fixes and improvements
• Magento 2 Cloud edition specific fixes

1.2.0

• Implement custom mapping for product import
• Import from FTP , SFTP , URL
• Import from Dropbox
• Performance and security tests and improvements

1.1.0

• Product Attributes on the fly import from CSV file
• Import product attributes on the fly
• Import categories from dedicated CSV file

1.0.0

• Import jobs achitecture development
• Import cron automation implemented

Improved Import & Export FAQ

In addition to the extension’s evolution, we’d also like to introduce you to the key functionalities and features of the Improved Import & Export module. Below, you can see questions that our customers always ask about our tool. Below, you will discover more facts about Improved Import & Export.