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.
+ 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.
+ Extension is running live on production by hundreds Magento 2 merchants on Community, Enterprise, and Cloud editions.
New import sources
+ 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.
+ 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.
+ 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.
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.
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!
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 XLST - 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 one year and also will get 50% discount on the second year upgrades! This mean you can buy the extension now to use current features and get free updates with powerful new features!
- Full REST API support - import any XML or JSON data from REST API with automatic authorization, data mapping, and processing. Establish flexible connection to any system.
- 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.
- Duplicate import and export jobs, jobs settings, configuration and other.
- 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).
- Price and other product attribute modification on the fly during the import - increase, multiple, decrease, percent, etc.
- Continuous import/export mapping improvements - merge or separate fields and import to a specific attribute.
- MS Excel XLSX files native import and mapping - processing of complex Excel files with multiple pages, flexible file files mapping to Magento 2 products, customers, and orders structure.
- PDF spreadsheet parsing & OpenOffice formats support.
- JSON format support for import and export products, orders, etc.
- 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!
- Import & Export of ALL Magento 2 entities. Custom data structure mapping for discount codes, catalog price rules, CMS pages & static blocks, etc. Full flexibility of data import & export to Magento 2.
- 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.
- API for Magento 2 Import and Improved Import functionality.
- 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
- XSLT support - import any XML file structure to Magento 2
- Supports CSV, XML 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
- 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
Regular Price: $600.00
Special Price: $400.00
You can trust us
Extension works on hundreds live Magento 2 stores worldwide!
We needed some special functionality and run into some issues and they helped us immediately.
Great Product and Support.
I'm very satisfied with this extension and about the support I'm getting from Jack. can everyone recommend this.