Improved Import and Export is an extension for Magento 2 that introduces enhanced import functionality. The extension is installed and managed via Magento 2 admin panel, meaning that you can configure it from any place at any time, and you are not dependent on running applications.
The extension allows scheduling import and export procedures to run automatically according to specified scenarios. Improved Import and Export allows importing XML and CSV tables, supports numerous import sources including Google Sheets and other. The full list of features can be found below.
General extension features
+ Import & Export jobs - are flexible import and export rules that can be scheduled by cron as well as run directly from the Magento admin in the browser or via CLI.
+ MagMi Magento 1 file support - the extension supports MagMi Magento 1 files. You can now import and migrate your old MagMi files to Magento 2 with attribute mapping preset.
+ Import Excel and OpenOffice formats to Magento 2 NEW! - the extension supports XSL, XSLX and ODS tables. You can use your Excel and OpenOffice tables to import different entities to Magento 2.
+ XML and CSV file format support - you don’t have to convert tables your suppliers provide.
+ Import Json files NEW! - you can import Json to Magento 2, a first step to the Rest API support of your software.
+ Asynchronous import and export - import tables with thousands of products through Magento 2 admin panel in a couple of minutes.
+ User-friendly interface - with extended debug with logs and history of running import/export jobs. Detailed logging by SKU, time of import, etc.
+ No programming skills required - everything can be managed via Magento 2 admin panel via the familiar interface.
+ 100% Open Source - the code of the extension, created by Certified Magento Developers, is open to Magento 2 best practices.
+ Composer - easy installation and upgrade by composer.
+ Extension is running live on production by hundreds Magento 2 merchants on Community, Enterprise, and Cloud editions.
New import sources
+ REST and SOAP API Support NEW! - now you can create Rest and Soap API requests to import XML and Json files to your Magento 2. XSLT transformation is also available for XML files obtained via REST or SOAP. Paste an API Call URL, specify request options and body, and you are good to go.
+ Google Sheet import support NEW! - paste a link, run the job. Import is simple.
+ Dropbox - share an account with your supplier, the import jobs will fetch the table and import it on schedule.
+ Direct URL - whether your supplier always keeps the product updates table shared you can always paste the link from your browser.
+ FTP/SFTP - use any FTP or SFTP server for import/export purposes.
+ Direct file upload - import and export source files and product images from/to the same server, remote FTP / SFTP server, Dropbox, direct URL or upload in a browser.
Additional import entities
+ Supports all default Magento import entities - products, customers and advanced pricing can now be scheduled to run automatically.
+ Product Attributes NEW! - import Magento1 product attributes, attribute sets, attribute groups as a dedicate entity and control every attribute setting.
+ Order import NEW! - import orders to Magento 2, transfer all order details from previous versions, map order attributes and automate process.
+ Categories import and export - categories can now be imported and exported just like products. Magento 1 and Shopify presets for categories also available.
+ CMS pages import - import CMS pages in bulk using CSV files or Google Sheets and fill your store with content in one go.
+ Cart Price Rules import - make sure to update your store with relevant special offers by uploading a list of Cart Price Rules.
Import and Export features
+ Schedule Magento 2 import and export with cron - the schedule is available in admin panel and it is as powerful as via CLI.
+ Clear attribute values NEW! - allows you to clear optional attribute values for products. E.g. such attributes as ‘color’ and ‘size’ will lose their values.
+ Consecutive export NEW! - export jobs can remember already exported entities and on the consecutive run export only new data.
+ Add date and time to export files/Dynamic export file name NEW! - date and time of the export jobs execution can be added to the exported files automatically.
+ Shopify import mapping preset NEW! - map product, category and other attributes in few clicks when importing from Shopify to your Magento 2 store.
+ Magento 1 preset for import jobs - easily migrate products from Magento 1 to Magento 2.
+ Powerful import & export mapping - to handle any data structure with filters and static values. Specify separators to import custom-formatted CSV and XML tables.
+ Export orders - with invoices, shipping, credit memo, etc.; using mapping and filters.
+ ZIP & TAR archives support - with import source files.
+ Generate URL if duplicate - allows to avoid ‘URL key for specified store already exists’ error.
+ Improved speed and stability - of default Magento 2 import & export.
+ Import default product variations - the extension is compatible with Improved Configurable Product Magento 2 extension, that allows specifying default configurable product variations and more. These default variations can now be imported with configurable products.
+ Import all files from the folder - you can now import all files from the specified folder, making bulk import available for Magento 2.
Magento 2 product import
+ Support for all product types - simple, configurable, downloadable, group, bundle, virtual.
+ Configurable Products created on the fly - specify SKU of the configurable product, simples should belong to, and it will be created automatically.
+ Creation of new products attributes and values on the fly during import process – if attribute or value doesn’t exist on Magento 2 database it will be created during the products import process.
+ Tier Prices/Advanced pricing imported with products in the same table - introduce any necessary changes to the product catalog in a single import run.
+ Price rules for imported products - you can now adjust product price during the import procedure. Apply conditions to select products for the price update.
+ Categories mapping NEW! - you can now map category paths during the import process. This becomes particularly useful if you are importing categories from different ecommerce platform.
+ Fixed Product Tax (FPT) import - to apply country-specific taxes.
+ Color swatches Magento 2 import - now you can import both colors and images for product color swatches. Read documentation to learn how to do it.
Looking for some specific import feature, modification or connection to Magento 2? - Contact us to discuss and get specific complex import solutions!
We know you are missing Magmi for Magento 2 - that’s why we aim to implement core Magmi features in our extension - fast import, CLI for cron jobs import, flexible CSV format support with mapping, on the fly attributes and values creation, support for all product types, and many more!
Compatibility with other Magento 2 extensions
We are working hard to make sure you are using Improved Import and Export extension without any issues. That's why we are identifying the most popular extensions the store owners use for their catalogs and make sure our extension is working with them properly.
At the moment, Improved Import is fully compatible with the following extensions that have caused issues:
- MageWorx Advanced Product Options
- MageStore Inventory Management
- Wyomind Advanced Inventory
- Magedilight Price per Customer
Magento 2 import and export use cases
- Build a complete drop shipping solution for Magento 2 - import products from any supplier, use any format, modify prices, add extra fees, export orders and shipping
- Manage Magento 2 catalog directly from Google Sheet – edit product and customer tables together with your colleagues, and use thousands of available Google Sheet plugins for data modifications
- Import broken or incomplete product data - add missing content from various sources or hardcoded values with the attribute mapping
- Perform complex XML data modifications and adjustments with XSLT - useful while working with complex XML structured produced by various catalogs and enterprise middleware software
- Synchronize multiple Magento 2 instances including all available data
For development agencies
At FireBear we are working in close cooperation with leading Magento oriented development agencies on implementing client requests and requirements. Talking from our experience, any import, export or 3rd party system integration is the most time-consuming part of every Magento 2 project.
That’s why we are constantly working on Improved Import and Export extension – the most complete Magento 2 extension for integration purposes. With the help of the extension and FireBear support team, you can minimize the integration part of the Magento 2 projects and provide your clients with effective import solution.
Improved Import for Magento 2 upcoming features RoadMap
Since we are continuously working on Improved Import features following community and merchant needs, here are forthcoming features which we are working on now. After purchasing the extension, you will receive free upgrades during six months! This mean you can buy the extension now to use current features and get free updates with powerful new features!
- Import and export events and job queue and restrictions - build flexible conditions for running import and export jobs after any Magento 2 update, queue jobs, automatically block jobs that depend on any system event or process. For example: order placed, new product or customer created, attribute modified.
- Magento 2 product image processing settings and configuration - crop and scale, adjust size and files name, convert to different format, compression and performance optimization.
- Email, WhatsApp, Telegram and other notification possibilities for jobs - send status and debug information about import and export processes.
- Import diff system – a smart algorithm for comparing the current state of Magento 2 and data in the specified import source. Save time and resources by updating only relevant data.
- Imports job filtering - flexible rules and conditions for updating and importing specific data from any source.
- FireBear Composer repository - for extension installation and upgrade with Composer package manager.
- Simplified and improved import of bundle and grouped products – import and create on the fly complex products by the fields of the child products.
- Full support of Magento 2 Multiple Source Inventory extension and its workflow.
- Full support and compatibility with Magento 2 B2B and Omnichannel.
- Price and currency formatting.
- Get raw SQL query of import & export job to run and adjust directly to Mageto 2 MySQL server.
- Dry Run (Test import) - preview and test imported data without actual import. Useful for debugging and catching issues before import.
- Full circle Magento 2 integration and synchronization of products and orders with top drop-shipping providers (Doba, Dropship Direct, Wholesale2b, Aliexpress, Taobao, Alibaba etc. more details at Ultimate List Of Drop Shipping Platforms And Integrations).
- Continuous import/export mapping improvements - merge or separate fields and import to a specific attribute.
- PDF spreadsheet parsing & OpenOffice formats support.
- CSV mapping import/export presets for Zoey, BigCommerce, WooCommerce, Prestashop and other major ecommerce systems - to make a migration to Magento 2 and sync with the platform extremely easy.
- API connection between Magento 2 and Shopify, BigCommerce, and other cloud-based SAAS ecommerce platforms - effortlessly import and export products, customers, and other data on the fly - without creating CSV files! Setup synchronization between your Magento 2 store and other ecommerce platforms in a few clicks.
- Improved Import auto-upgrade - built-in system to keep your Improved Import copy up to date and get new import features, bug fix and patches in Magento 2 instantly!
- Product data auto translation during import by Google or Bing - great for import to different store views.
- Integration with API of data crawling services, such as https://www.import.io/. Crawl product data from any source and import it directly to Magento 2 - this opens nearly endless possibilities!
- Full coverage by unit and integrations tests.
- The extension is submitted and will be available soon on Magento Marketplace.
- Option to delete/disable products which are not included in a CSV file or specific import job
- API connection to external SAP, ERP, PIM, CRM, POS systems.
- Combine import/export jobs to queue with dependencies and custom logic.
- Multiple files and sources input for one import/export job - merge and split data and files on the fly, advanced data modificators, and processors (export only products with stock less than X, etc.).
- Implement all features of MAGMI for Magento 1 - custom images processing, improved speed, advanced data modifications on the import.
- Import products to Magento 2 from open product catalogs like IceCat etc.
- Data feed export presets - easy export products from Magento 2 to major marketplaces and catalogs (eBay, Google Shopping, Google Product Ratings, Amazon Product Ads, Bing Product Ads, etc.).
Vote for upcoming features and give us your feedback!
Looking for some specific import feature , modification or connection to Magento 2? - Contact us to discuss and get specific complex import solutions!
Improved Import & Export for Magento 2
- Supports sources: Google Sheets, FTP/SFTP, URL, Dropbox
- Support of MagMi Magento 1 files for migration to Magento 2
- EAV and custom attributes import and export
- XSLT support - import any XML file structure to Magento 2
- Supports CSV, XML, Excel XLSX, ODS and Json files
- Migration presets for Magento 1 and Shopify
- Automatically upload and synchronize external product listings with M2
- Powerful import & export mapping for any data structure with filters and static values
- Rest and SOAP API support for integration with third-party software
- Supports all product types
- Create configurable products on the fly
- Import tier prices with products
- Import: Orders, CMS pages, categories, cart price rules
- Export: orders, invoices, shipping, categories
- User friendly & intuitive interface
- No programming skills required
- Handle millions of products on single file
- Average import speed - 3000 products/min
- Open code, customization endpoints
You can trust us
Extension works on hundreds live Magento 2 stores worldwide!
absulute 5 starts for this plugin and company!!
Last thing about the support that is fast and always ready to help. Thanks
This product had some instability, as any fast growing, but with help by Mr.Jack all troubles successfully resolved
Look forward to new features
For sure I´ll buy more ext and service from them ... JACK you amazing bro
We needed some special functionality and run into some issues and they helped us immediately.
Great Product and Support.