Improved Import & Export for Magento 2 extension – Overview 2021<\/span><\/a><\/p>\n <\/p>\n
Improved Import follows the save process pattern as native Magento 2 import and export but enables much more features and automation of the import and export processes. The extension uses the import logic of Magento 2, which means that it maintains the native CSV table structure of Magento 2 and comprehends all of the product data while also providing new attributes to make the import of products, customers, advanced pricing, and categories easier.<\/span><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n
By adding jobs, the addon automates import and export procedures. The jobs are a set of rules which specify the import or export schedule, the entity you wish to import, and the conditions under which you want it to do so.<\/span><\/p>\n <\/p>\n
This is a brief explanation of the job, which serves as the extension’s primary setup point. Later on in this blog post, we’ll talk more about the jobs.<\/span><\/p>\n <\/p>\n
Every job has the option of being set up to execute automatically on a particular day and time. Since the scheduler makes use of cron, you can pretty much cover all intervals if you are familiar with the tool. If you are unfamiliar, it won’t be a problem because the Improved Import and Export extension includes comprehensive documentation that will make using the cron scheduler easier.<\/span><\/p>\n <\/p>\n
By adding jobs, the addon automates import and export procedures. The jobs are a set of rules which specify the import or export schedule, the entity you wish to import, and the conditions under which you want it to do so.<\/span><\/p>\n <\/p>\n
This is a brief explanation of the job, which serves as the extension’s primary setup point. Later on in this blog post, we’ll talk more about the jobs.<\/span><\/p>\n <\/p>\n
Every job has the option of being set up to execute automatically on a particular day and time. Since the scheduler makes use of cron, you can pretty much cover all intervals if you are familiar with the tool. If you are unfamiliar, it won’t be a problem because the Improved Import and Export extension includes comprehensive documentation that will make using the cron scheduler easier.<\/span><\/p>\n <\/p>\n
<\/p>\n
Import and export entities<\/strong><\/h3>\nThe extension has more to offer in terms of Magento 2 entities, basically, it covers every Magento 2 entity for both import and export:<\/span><\/p>\n <\/p>\n
\n- Products<\/span><\/li>\n
- Product attributes<\/span><\/li>\n
- Product reviews<\/span><\/li>\n
- Advanced pricing – tier prices<\/span><\/li>\n
- Gift cards<\/span><\/li>\n
- Categories<\/span><\/li>\n
- Product category positions<\/span><\/li>\n
- Orders<\/span><\/li>\n
- Customers and customer addresses<\/span><\/li>\n
- Newsletter subscribers<\/span><\/li>\n
- CMS blocks and pages (static blocks and pages)<\/span><\/li>\n
- Catalog and cart price rules<\/span><\/li>\n
- URL rewrites<\/span><\/li>\n
- Search terms and synonyms<\/span><\/li>\n<\/ul>\n
<\/p>\n
You can see that the extension offers extra choices for customers and categories in addition to native Magento 2 import and export entities. Any type of data that you have at your store can be imported and exported for further use.<\/span><\/p>\n <\/p>\n
<\/p>\n
Spreadsheet mapping<\/strong><\/h3>\nAdditionally, Firebear Studio is aware that many vendors have various recommended file formats and table mappings.<\/span><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n
You have complete control over the cell and row mapping in import\/export processes for these instances of varied table formats. For instance, your supplier might utilize field separators like underscore or multiple value separators like semicolons that Magento 2 cannot read. You can then provide the appropriate settings to instruct your store to read the imported table in such circumstances.<\/span><\/p>\n <\/p>\n
<\/p>\n
Sources of imported and exported files<\/strong><\/h3>\nImproved Import and Export surpasses native Magento capability in terms of the import source as well. The extension allows you to import items from files, FTP and SFTP servers, Dropbox and OneDrive accounts, directly from Google Sheets and Google Drive folders.<\/span><\/p>\n <\/p>\n
If you and your provider share an FTP or Dropbox account, this is useful. The supplier can keep current delivery notes there, and those notices will be instantly imported into your store.<\/span><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
In addition, you can import the data in any popular file format: CSV, XLSX, XML, ODS, or Json. Improved Import allows you to use any data file that you receive from your warehouse or supplier. And you can use these files for both import and export processes.<\/span><\/p>\n <\/p>\n
<\/p>\n
Map attributes<\/strong><\/h3>\nThe extension also provides attribute mapping. What good does it do? Magento 2 employs specific attribute names that cannot be modified under any circumstances, that\u2019s where the attribute mapping comes in. What you can do is specify which column of your file represents which attribute inside Magento 2 and you are good to go.<\/span><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n
Additionally, the addon is capable of formatting Magento 1 import tables, simplifying the process of migrating a catalog by only selecting an attribute pattern. Therefore, you might wish to learn more about the extension if you intend to migrate from Magento 1 to your Magento 2 store.<\/span><\/p>\n <\/p>\n
<\/p>\n
Import of configurable products<\/strong><\/h3>\nThe Improved Import and Export extension provides unique import logic for the Magento 2 configurable products. Native Magento 2 import allows you to import products that can be customized. But it takes time to do it, and much more time to learn how to do it. The plugin offers three possibilities and streamlines the import procedure for configurable products.<\/span><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n
It operates using the following structure:<\/span><\/p>\n <\/p>\n
You can either add a new column to the imported table or use an already existing one. You enter the SKU of a customizable product to which the simple should be associated in the new column for the simple products.<\/span><\/p>\n <\/p>\n
\n- You choose the column that the extension should read and choose how it should read it in each of the three cases. You define the pattern of how it should be processed, in other words:<\/span><\/li>\n
- Read the entire column and treat each cell’s entry as an SKU;<\/span><\/li>\n
- Count the characters at the start and end of each line as well as those before and after the delimiter.<\/span><\/li>\n<\/ul>\n
<\/p>\n
Following your selection of the configurable product’s desired size, color, and other characteristics. The end of that. All simple products are appropriately assigned to the customizable parents by the extension.<\/span><\/p>\n <\/p>\n
<\/p>\n