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, CSV, Json, XLSX, ODS 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.
+ Export job event system NEW! - define a Magento 2 event for triggering an export job. When a Magento 2 system event specified takes place the export job is run automatically. Three events currently available: new order placed, order edited, product edited
+ Import Excel and OpenOffice formats to Magento 2 - 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 - 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 - 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 - 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.
Improved Import and export speed reference
Import and export performance tests have been conducted on the following setup:
8 core CPU
64 Gb RAM
MariaDB 10.1.26 (MySQL 5.7)
Intel(R) Xeon(R) CPU E3-1275 v5 @ 3.60GHz
DDR3 ECC 16Gb
2 x Crucial MX550 SSD
Magento 2 b2b import and export
+ Import Magento 2 companies NEW! - create companies using import, update company credit balance, assign the administrator account and customer group. Every attribute of the company entity is available.
+ Import Magento 2 shared catalogs NEW! - create shared catalogs using import and assign products directly to the shared catalogs, assign pricing using Advanced Pricing import, assign companies to the catalogs.
+ Import Magento 2 quotes and negotiable quotes NEW! - import abandoned carts of the customers and use pre-created carts for promotional purposes. Import negotiable quotes for the companies, use different discount models to approve the quotes.
+ Import Magento 2 requisition lists NEW! - let your b2b customers send you the requisition lists and import them directly to the company administrator accounts.
Additional import entities
+ Supports all default Magento import entities - products, customers and advanced pricing can now be scheduled to run automatically.
+ Supports Magento 2 MSI (multi-source inventory) NEW! - import products directly to the specified warehouse.
+ Product Attributes NEW! - import Magento 2 product attributes, attribute sets, attribute groups as a dedicate entity and control every attribute setting. And decide if you want product attribute sets updated or not.
+ Order import NEW! - simple order import with minimum attributes is now available. 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 - allows you to clear optional attribute values for products. E.g. such attributes as ‘color’ and ‘size’ will lose their values.
+ Attribute mapping NEW! - allows you to map attributes from the imported table with the Magento 2 attributes. You can also create new attribute values, replace all values with a default one, or fill in empty attribute values.
+ Attribute value mapping NEW! - you can map Magento 2 attribute values with the values of the imported attributes - for example map description value of the imported products, quantity values and other.
+ 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 - 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 NEW! - you can now adjust product price during the import procedure. Apply conditions to select products for the price update. You can also automatically round prices to 0.99 or 0.48 whichever value is closer.
+ 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. You can also set the Root category of your store to serve as a reference to all import paths.
+ 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!
Add-ons of Improved Import and Export extension
+ MSI Add-on NEW! - allows to import and export entities added to Magento 2.3 with official Multi-Source Inventory extension: warehouses and product quantity per warehouse.
+ B2B Add-on NEW! - allows to import and export entities added to Magento Commerce (Cloud) with official B2B extension: companies, shared catalogs, requisition lists, quotes, and negotiable quotes.
+ WooCommerce Migration Add-on NEW! - allows to migrate from WordPress to Magento 2 with little to no programming knowledge. Add-on allows to import WooCommerce products, customers, addresses, and orders to Magento 2.
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 for Magento 2
- 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
Services and Magento 2 customization
Firebear Studio offers services on customizing and integrating your Magento 2 stores with third-party software. The services include:
- Magento 1 to Magento 2 data migration
- Shopify, Bigcommerce, Prestashop, Wocommerce to Magento 2 data migration
- Dropshipping and multi-chanel sales setup and customization
- Syncronization of any third-party systems like CRM, ERP, PIM etc via REST/SOAP APIs
- Assitance with exporting Magento 2 feeds of any format
- XSLT templates for XML files. Free assistance with composing first XSLT template
- Extension customization services
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.
Learn more about partner program
Benefits of using Improved Import and Export extension for Magento 2:
- Magento 2 store migration and drop-shipping solution - the extension offers ready-made platform for building Magento 2 projects.
- Cut down the project development and management time by using Improved Import and Export extension as a base for your migration, catalog update and dropshipping customer needs.
- Save costs on importing custom data formats and custom integrations with CRM and ERP systems.
- Explicit documentation on Magento 2 import and export flows will help you understand how native Magento 2 import works while you integrate Improved Import and Export solution. The documentation also offers step-by-step instructions for the merchants to help them get accustomed with Magento 2 import and export procedures.
- Updates coming out regularly. FireBear Studio team always listens to our customers needs. We are constantly developing new features and integrations with third party platforms and software.
- Open code with customization endpoints and dedicated customization module to help you integrate new features to the extension. No ionCube.
- Partnerhip discounts for development agencies and bulk license purhcases. Priority support on any issues during development.
As you can see the Import extension is a comprehensive tool that can help you cut down the project development time and help leave the store owner with a full-featured backend sulution one can use without the coding knowledge.
For more inforamtion on the usecases and additional features required - consult FireBear Studio support team by submitting a ticket or via chat.
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
- Magento 2 b2b companies, shared catalogs, quotes, requisition list import and export
- 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
- Add-ons available: B2B, MSI, WooCommere Migration
You can trust us
Extension works on hundreds live Magento 2 stores worldwide!
Last but nost least, support is great. They are very helpful and they respond quickly.
Jack helps me a lot always when I need help to use this modul.
In my opinion this is the best plugin for import/expot. Is full of featured, simple to use and fast.
absulute 5 starts for this plugin and company!!
Last thing about the support that is fast and always ready to help. Thanks