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.
+ Asynchronous import and export - import tables with thousands of products through Magento 2 admin panel.
+ 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.
+ Categories import and export NEW! - categories can now be imported and exported just like products. Magento 1 and Shopify presets for categories also available.
+ CMS pages import NEW! - import CMS pages in bulk using CSV files or Google Sheets and fill your store with content in one go.
+ Cart Price Rules import NEW! - 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
- Initial products and customers import to Magento 2 from various suppliers, warehouses, e-commerce systems, or any 3rd party services (PIM, SAP, ERP, CRM, etc.) which produce output in XML, CSV, or TXT files.
- Scheduled product stock updates in different profiles to keep inventory up to date using multiple product data sources.
- Export orders, shipping, and invoices to accounting systems - upload files directly to the remote server in the required custom format.
- Export customers, products, and product stocks to files.
- Migration from another e-commerce platform with a custom complex data structure.
- Massive and fast update of product and customer attributes via CSV, XML, or TXT files in bulk by import jobs - save hours of time necessary on manual admin work!
- Export products to feeds for marketplaces and other platforms; any file structure can be achieved with static hardcoded values and filters.
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!
- 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!
- Order import - CSV & XML.
- 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 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
- Supports CSV and XML tables
- Schedule import and export with cron (admin, CLI)
- 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
- Price adjustments for imported products
- Import: 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
- 1 Year of free support & upgrades
- 100% Open Source
Extension works on hundreds live Magento 2 stores worldwide!
I'm very satisfied with this extension and about the support I'm getting from Jack. can everyone recommend this.