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