Improved Import / Export extension for Magento 2 provides a possibility to import your csv files with products data and product images to Magento 2 from a remote FTP / SFTP server, Dropbox or a direct URL of a source CSV file as well as offers a dedicated categories import from CSV files, on the fly import of product attribute values, cron jobs import, and more!
Complete features list of Improved Import Magento 2 Extension
Import csv files with data for import from remote FTP / SFTP server, Dropbox or direct URL
Import product images from remote FTP / SFTP, Dropbox or direct URL of product image
Dedicated simple categories import from CSV file (by default in M2 categories can be imported only together with assigned products)
Creation of new products attributes on the fly during import process
Creation of new attribute values on the fly – if attribute value don’t exist on Magento 2 data base – it will be created during the products import process
Con jobs for any kind of import (products , categories, customers , stock, attributes etc.) – flexible and extremely powerful feature of Magento 2 Enterprise Edition available for Community Edition!
Full support of Import configurable products – files can be placed locally or imported by remote URL source
Import fields mapping (in Magento 1.x style!) – you can map Magento 2 product attributes to any custom CSV column in your file! Fully flexible and powerful way to import custom data structures in Magento!
Here, you can configure Dropbox API details and FTP / SFTP credentials for catching source CSV files and images. Such configured sources as Dropbox and FTP/ SFTP will be available during the import procedure configuration on the Source dropdown:
Select a source for the csv file – Dropbox, FTP, Custom URL
A path to the csv file should be specified from the root folder of your source (Dropbox or FTP), for instance “/import/sample.csv” means that you have a root folder on your Dropbox account called Import.
Images should be located in the same folder or a subfolder where the csv file is placed. Thus, if you have images in the same with the csv file folder, use only image names (“image.jpg”) without any path to indicate images for import.
For example, if you have a folder named “magento_import” in the root of your Dropbox folder with the “products.csv” file with product data, then the correct File Path is “/magento_import/products.csv”, and if images are located in the same folder, use only their names (“picture.jpg”). If you create a subfolder for images in the “import” folder named “img”, then the path to the image in a csv file should look as follows: “img/picture.jpg”
For the URL source, you should provide a direct URL to your csv file: http://site.com/import/products.csv
When the configuration is complete, you can check data and run the import process
Import by Cron – Import Jobs
The Import Jobs feature allows you to run any kind of import processes via a scheduled cron job with configured frequency. Go to:
Magento admin -> Configuration -> Import Jobs
Here you can see and manage all Import Cron jobs:
Title of cron job
Status – Enabled or Disabled
Cron column showing frequency of jobs running in a cron format
Frequency of running in a human format: Day , Hour , Week etc.
Entity type of imported data – products, categories, customers
Import source – Local file, Dropbox, FTP, Url
Action: Delete or Edit import cron job
Click Add New Job to add a new process:
Configure import parameters:
Title of Import Job – use a clean self explanatory title that will be easily understandable in future 😉
Select a preset frequency of import:
Every minute (*/1 * * * *)
Every hour (* */1 * * *)
Every day at 3:00am (0 3 * * *)
Every Monday at 3:00am (0 3 * * 1)
Every 1st day of month at 3:00am (0 3 1 * *)
The custom format of a Cron job can be configured with the help of the standard Cron syntax:
Category import offers different opportunities, so you can set a category position and location:
Import by name and full path to category (Default Category/Women/Dresses);
Import by category name & path to category
Import by parent category id (parent_id)
CSV file columns:
name – Category name
Parent_id – existing parent category id
url_key – URL keys of category
Description – category description
Is_active – category Enabled / Disabled
Include_in_menu – include category to main menu on frontend
Is_anchor – Is Anchor – required for displaying layered navigation on category
Custom_layout_update – custom XML layout update for category
Once extension installed and enabled – you will have categories on entities dropdown for import :
Product attribute values on the fly import
Product attribute values which is do not exist in your Magento 2 database will be automatically created on the basis of info from a product import CSV file. Default Magento 2 requires creating product attributes manually before importing products with them. This feature can save tons of time on large amount of products with different attribute values to Magento 2.
Product attributes import – creation of new attributes on the fly during the product import
The idea behind the import of product attributes to Magento 2 on the fly during the product import is pretty simple and common – instead of having only attribute name on a column with attributes we add all data required for attribute creation there. For instance, attribute set, frontend labels, scopes, etc. You can find a structure sample and a sample CSV file below. Please follow the examples carefully and import CSV file with products first. If it works correctly, you can create a custom attribute column and add new attributes. This will reduce possible problem, debug time, and time necessary to fix issues.
The general format of an attribute creation column can be described as follows:
attribute name | attribute property name : attribute property value | …
On the table below, you will find each property required for attribute creation in Magento 2 during import process as well as appropriate possible values. As you can see, only attribute set and frontend label are required for creating attribute in Magento 2 during the import process. Another quite important attribute property is attribute code which actually define the type of your attribute (text field, dropdown etc). If you do not specify it, attribute will be created with type XXX
Default label for specified store
Where [n] is the store id
Catalog Input Type for Store Owner
text: Text Field
textarea: Text Area
multiselect: Multiple Select
media_image: Media Image
swatch_visual: Visual Swatch
swatch_text: Text Swatch
weee: Fixed Product Tax
This is used internally. Make sure you don’t use spaces or more than 30 symbols.
24-WG085_10,Sprite Yoga Strap6foot10,sprite-yoga-strap-6-foot-10,,Default,simple,Black,S,Ray-Ban,"Default Category/Gear,Default Category/Gear/Fitness Equipment,Default Category/Yoga/Style",base,"<p>The Sprite Yoga Strap is your untiring partner in demanding stretches, holds and alignment routines. The straps 100% organic cotton fabric is woven tightly to form a soft, textured yet non-slip surface. The plastic clasp buckle is easily adjustable, lightweight and durable under strain.</p><ul><li>100% soft and durable cotton.<li>Plastic cinch buckle is easy to use.<li>Three natural colors made from phthalate and heavy metal free dyes.</ul>","asd",1,Taxable Goods,"Catalog, Search",14,Meta Title,"meta1, meta2, meta3",meta description,,,,,,,01.07.201515:38,01.07.201515:38,,,Block after Info Column,"has_options=0,required_options=0,size_strap=6 foot",100,0,1,0,0,1,1,1,0,1,1,,1,0,1,1,0,1,0,0,1,,,,,,"name=Custom Yoga Option,type=drop_down,required=0,price=10.0000,price_type=fixed,sku=,option_title=Gold|name=Custom Yoga Option,type=drop_down,required=0,price=10.0000,price_type=fixed,sku=,option_title=Silver|name=Custom Yoga Option,type=drop_down,required=0,price=10.0000,price_type=fixed,sku=yoga3sku,option_title=Platinum"
24-WG085_11,Sprite Yoga Strap6foot11,sprite-yoga-strap-6-foot-11,,Accessories,simple,Yellow,S,Dior,"Default Category/Gear,Default Category/Gear/Fitness Equipment,Default Category/Yoga/Style",base,"<p>The Sprite Yoga Strap is your untiring partner in demanding stretches, holds and alignment routines. The straps 100% organic cotton fabric is woven tightly to form a soft, textured yet non-slip surface. The plastic clasp buckle is easily adjustable, lightweight and durable under strain.</p><ul><li>100% soft and durable cotton.<li>Plastic cinch buckle is easy to use.<li>Three natural colors made from phthalate and heavy metal free dyes.</ul>","asd",1,Taxable Goods,"Catalog, Search",14,Meta Title,"meta1, meta2, meta3",meta description,,,,,,,01.07.201515:38,01.07.201515:38,,,Block after Info Column,"has_options=0,required_options=0,size_strap=6 foot",100,0,1,0,0,1,1,1,0,1,1,,1,0,1,1,0,1,0,0,1,,,,,,"name=Custom Yoga Option,type=drop_down,required=0,price=10.0000,price_type=fixed,sku=,option_title=Gold|name=Custom Yoga Option,type=drop_down,required=0,price=10.0000,price_type=fixed,sku=,option_title=Silver|name=Custom Yoga Option,type=drop_down,required=0,price=10.0000,price_type=fixed,sku=yoga3sku,option_title=Platinum"
Import downloadable products in Magento 2
Files for downloadable products can be imported in two ways:
1. Import files from remote URL for downloadable products – you need to specify full URL to file on CSV file and make sure following directory is exist and writable /pub/media/downloadable/links/files/
2. To import local files – you need to upload your files to directory you choose on import page (input – Images File Directory).
You can also export existing products and customers from your store to get a correct CSV file structure of your store, products, attributes, columns, etc. The feature is available under:
Magento admin -> System -> Export
Import fields mapping (in Magento 1.x style!)
The powerful mapping feature allows you to map Magento attributes to custom columns in your CSV file.
After specifying the source of your CSV file for import on the General tab of Import Job (System -> Import Jobs) and clicking Save Job – column names from your CSV file will be available for mapping to Magento system attributes on the Map Attributes tab.
In the left column there is a dropdown with all Magento attributes to select:
In the right column – a dropdown with column names from your CSV file (a source file should be specified on the General tab and Import Job should be saved!)
Once you have finished with mapping – Save Job and run it from the command line to test and then schedule cron import.
With the import fields mapping feature you can import custom CSV files from various e-commerce systems, PIM, ERP, SAP.
We are working now on import profile pre-sets for Magento CE & EE 1.x, WooCommerce, Shopify, Prestashop etc. But now, you can already map any custom data structure to Magento product attributes for import.
Improved Import for Magento 2 upcoming features roadmap
Since we are continuously working on Improved Import features following community and merchant needs, here are upcoming 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 for the second year upgrades! This mean you can purchase extension now to use current features and get free updates with powerful new features!
CSV mapping presets for Magento 1.x CE & EE , Shopify , BigCommerce , WooCommerce , Prestashop, and other major ecommerce systems – to make 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!
Unzip / untar archive with a CSV file before import – flexible import of large compressed data;
Export mapping – all import mapping flexibility during data export from Magento 2 – create any kind of CSV, XML, and TXT files to export product, categories, orders, and customers from Magento 2!
Custom data structure mapping for categories, customers, discount codes, catalog price rules, import! Full flexibility of data import 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 oppens nearly endless possibilities!
For further information, consultation, or to request individual features use our contact form!