The following article is dedicated to a small section of your admin section – Magento 2 import history. Available by default, it lists all import processes that take place in your backend. Thus, you can always control what data files have been transferred from external systems. Let’s explore the core functionality of the section and the most efficient improvement to the whole import and export routine.
Table of contents
- 1 Magento 2 Import History Grid
- 2 Magento 2 Import History Improvement
- 3 Magento 2 Export History
- 4 Improved Import & Export Exclusive Features
- 4.1 Automated Import & Export Processes
- 4.2 Advanced Mapping Features
- 4.3 Extended Connectivity Options
- 5 Conclusion
Magento 2 Import History Grid
The Magento 2 import history grid is available under System -> Data Transfers -> Import History.
The grid consists of the following seven raws:
- ID – an internal ID number of every import process;
- Start Date & Time – a column that lets you view import processes in chronological order;
- User – this one allows sorting imports by a user;
- Imported File – here, you can download imported files related to import methods;
- Error File – files related to errors;
- Execution Time – this column shows how much time the process took or whether it was failed;
- Summary – a short description of an import process: the column describes either errors or successful results.
Note that you can change the sort order of jobs by clicking on column headers. At the same time, it is possible to apply filters to find the exact processes.
And now, imagine that you have to run multiple import processes per day, how would your Magento 2 import history grid look? The example above includes only six records, but what if you run six import processes per day during the whole year? It would be quite hard to find a particular import process in such a grid. Therefore, we’d like to introduce you to the improved Magento 2 import history.
Magento 2 Import History Improvement
Meet the Improved Import & Export extension – a module that dramatically revamps the default import and export functionality of our favorite e-commerce platform including Magento 2 Import history. We will briefly describe other enhancements below. Now, let’s concentrate on the Magento 2 import history improvement introduced by the plugin.
Instead of a single grid where all import processes are collected, you have multiple grids related to each import job. It means that each integration has its own history. Thus, you can find the desired data file or an import process description faster. It is only necessary to:
Open the extension’s import grid:
Find a particular import job, click “Select” from the “Action” column and choose “Edit & Run” just like shown below:
On an import job configuration page, hit “View History” from the top menu:
Here, you can see a job title as well as start and finish date. But the essential difference between the improved and default Magento 2 import history is that Improved Import & Export lets you download a log for each particular import job!
Hit the “Download” button and view all details related to the chosen import process. Note that nothing similar is available in Magento 2 by default.
Magento 2 Export History
In addition to the improved import history, our module offers Magento 2 export history which is absent in Magento 2. It is absolutely the same as the grid we’ve just described. To find Magento 2 export history, open the extension’s export grid:
Find a particular export job, click “Select” from the “Action” column and choose “Edit & Run” just like in the example above:
On an export job configuration page, hit “View History” from the top menu:
Here, you can see an export job title as well as start and finish date. Besides, Improved Import & Export lets you download a log for each particular export job!
Hit the “Download” button and view all details related to the selected export process. Note that nothing similar is available in Magento 2 by default.
You can find more information about Magento 2 import and export logs here: How to debug and log Magento 2 import and export process and errors. Now, let’s focus on other features of Improved Import & Export that improve data transfers.
Improved Import & Export Exclusive Features
Hundreds of merchants all over the world already use the Improved Import & Export extension to simplify their daily duties. If you face integrations, data transfers, and synchronizations with external systems, you know how hard and overwhelming small tasks can be. But the Improved Import & Export Magento 2 extension lets you automate all of them. Below, we shed light on the module’s core features that dramatically improve your daily routine. Note that they are either not represented in Magento 2 by default or introduce the improved functionality. Let’s take a look at the automation of data transfers first.
Automated Import & Export Processes
With the default import and export tools, you have to control all import and export processes manually. As for the Improved Import & Export extension, it provides two different ways of automating data transfers. With the help of the module, you can create update schedules or specify event-based triggers that launch import and export processes in real time. Let’s explore the first opportunity.
The magic behind schedules is quite simple: they incorporate cron to provide the desired automation. This technology allows you to create any custom update schedule. You only have to apply the default cron syntax.
At the same time, the Improved Import & Export Magento 2 extension offers a list of predefined intervals. Select one that suits your needs and apply it to your import/export job. It is also necessary to mention that all predefined intervals are fully customizable.
You can also create profiles that have no schedules. They are especially useful if there is no need to run frequent updates, a single data transfer is required, or updates are provided asynchronously. At the same time, every profile can be launched manually even if it is automated.
Despite a selected schedule type, all jobs include a history section where you can view various details as well as download a log file.
Also, note that configuring a schedule is a very straightforward process:
Now, let’s take a look at event-based triggers. Being an alternative way of automating import and export processes, they enable real-time updates.
For instance, a customer places an order on your store. You can turn this event into a trigger that export order data to an external ERP system. Every data export launched by the trigger is saved in the Magento 2 export history. The same is about import processes. Initiated by a trigger, they are recorded as a part of the Magento 2 import history for a particular job.
It is also necessary to mention that the Improved Import & Export Magento 2 extension lets you select system events as well as specify custom ones as triggers. After a trigger is defined, create conditions to make its work more efficient. Nothing similar is possible in Magento 2 by default. For further information about this feature, read this article: How to Run Magento 2 Import or Export After Specific System Event or Process.
Advanced Mapping Features
Magento 2 not only lacks automated import and export processes but also doesn’t prevent problems caused by different attribute standards. Therefore, you have to edit multiple data files every time a new update is required. Most import bugs are caused by the problem of different attribute standards that prevents you from direct transfers into your e-commerce store. Most external systems reject your exported files unless you edit them. As a result, a seamless connection with tools beyond the 2.x is often hard to achieve. But the Improved Import & Export Magento 2 extension dramatically simplifies the Magento 2 import and export processes in terms of mapping. Let’s take a look at several significant enhancements.
With our extension, you can solve the problem of different attribute standards within a few clicks. The Improved Import & Export module offers a list of presets that match external designations to the corresponding internal ones automatically. You choose a preset and start the import procedure. In its turn, the extension analyzes the input data and replaces all external attributes with ones used in Magento 2. As you can see, admin duties are reduced to selecting and applying a preset related to a particular integration.
As for the default attribute editing, you have to transfer data via files editing their content manually. The more attributes they include – the more pain you get. Luckily, the Improved Import & Export Magento 2 module lets you forget about that. The image below illustrates the simplicity of the process:
At the same time, you can solve the problem of different attribute standards manually but in a user-friendly manner. The Improved Import & Export Magento 2 extension lets you map attributes right in your admin. Select a third-party designation and specify the corresponding internal one in front of it. Repeat this action until no third-party designations are left. You no longer need to use a file editor to improve provided updates.
Furthermore, it is necessary to create the scheme only once since it is saved and applied for further data transfers automatically. You can map attributes as follows:
Also, note that the Improved Import & Export extension introduces the ability to set hardcoded attribute values via the “Default Value” column. Set an attribute value here and it will be provided to all items related to the attribute.
Attribute Values Mapping
Some import processes are prevented by unsupported attribute values, but you can easily map them with the Improved Import & Export Magento 2 extension. The module allows mapping attribute values just like attributes. The easiest possible solution is based on the same logic as the attributes matching described above. Although there are no presets, it is much quicker than doing everything manually in a data file.
Select a third-party designation and specify the internal one in front of it. Note that the process should be applied to all external attributes. For further information, read this article: Attribute Values Mapping.
Attribute Values Editing
Another extension’s feature aimed at attribute values is the ability to edit them in bulk. The Improved Import & Export Magento 2 module offers the following rules:
- Add a prefix to multiple attribute values in bulk;
- Add a suffix to numerous attribute values in bulk;
- Split multiple attribute values;
- Merge various attribute values.
The best thing is that you can combine them as well as create conditions to increase the efficiency of bulk editing. For further information, follow this link: How to Modify Attribute Values During Import and Export in Magento 2.
How often do you import product data? How much time do you spend editing third-party categories and organizing newly imported products according to your catalog? With Improved Import & Export, you can easily avoid this routine due to the category mapping functionality. When it comes to moving product data from a third-party system to your Magento 2 store, the Improved Import & Export Magento 2 extension lets you match the external categories to the ones used internally right during the import process as follows:
To create new categories on the fly, select a parent category and specifying the name of a new one. That’s it! Both features are described in this article: Category Mapping.
Attributes On The Fly
The lack of attributes also prevents Magento 2 import processes. To solve the problem, our module lets you create missing attributes on the fly. With the Improved Import & Export Magento 2 extension, you can specify all the necessary parameters using the following general form:
The full process is described in more detail here: Product attributes import.
Extended Connectivity Options
When it comes to various connection options, Improved Import & Export is the number one tool in the whole ecosystem. While the standard data synchronization between Magento 2 and other platforms is based on CSV files, our module introduces support for numerous file formats, API standards, and intermediary services. If an update file isn’t provided in CSV, it causes import errors unless you use Improved Import & Export. Let’s take a look at all provided opportunities regarding the extended connectivity.
Multiple File Standards
With the Improved Import & Export Magento 2 extension, you get numerous new file formats that can be imported and exported. Our tool adds support for XML, JSON, ODS, and Excel. And of course, it works with the standard CSV! You can freely import and export data using these formats. All the extension’s features are suitable for all of them letting you automate transfers and match attributes and their values. Magento 2 history is available for every job and every file format!
Multiple File Sources
To make file transfers more flexible, the Improved Import & Export Magento 2 extension also offers several connection points:
- FTP/SFTP connection allows leveraging a local or remote server as a place of transfers.
- The same functionality is possible with a Dropbox account. Alternatively, you can rely on Box, OneDrive, Google Drive, iCloud, and Amazon Drive.
- When you want to transfer data to your website, a direct URL is enough.
It is also worth mentioning that our module lets you import compressed files. There is no need to extract compressed data manually before transferring it into the system. The extension does everything for you.
Alternative Ways of Import & Export
And don’t forget that the Improved Import & Export extension lets you establish direct API integration between your website and other external systems. Magento 2 history and logs are available for this connection type as well. The module uses REST, SOAP, and GraphQL APIs to synchronize your e-commerce store with any third-party systems.
At the same time, it supports different online sheets for various data exchange purposes. Create a bridge between your Magento 2 website and external platforms using Google Sheets, Office 365 Excel, or Zoho Sheet. You will find the appropriate records in the Magento 2 import/export history! Integrations based on Google Sheets looks as follows:
Watch the following video to see the extension in action:
The Magento 2 import history is an inevitable part of your import routine, but the default solution is quite limited. But you can always get the missing functionality with the Improved Import & Export Magento 2 extension. It not only adds a history section for each job but also enables the same functionality for export processes. Besides, your module lets you automate data transfers as well as import and export all entities, including ones used in the Commerce edition only. For further information, follow the links below: