How to Map (Match) Attribute Values During Import in Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Attribute Values Mapping Import

You might have already faced numerous problems caused by attributes and attribute values that don’t follow the Magento requirements. By default, it is impossible to import them to Magento 2. Different systems have unique requirements regarding the way information is stored in their databases. Therefore, you cannot transfer data between them directly. It is always necessary to apply changes to the output created beyond Magento 2 to run a successful import to your e-commerce website. And this process is usually time-consuming. The more unsupported values your data file contains the more work has to be done. 

However, there is a user-friendly way of editing third-party data. Meet the Improved Import & Export Magento 2 extension. The module lets you automate the attribute editing processes so that you can freely import data from external platforms to Magento 2. Below, we shed light on how to match third-party attributes and attribute values to the corresponding Magento 2 values during import. You will find a guide for the default Magento 2 import tool. After that, we provide a description of our approach that saves tons of time and lets you automate further data updates.

Standard Way of Matching Attribute Values For Magento 2 Import

By default, you can match third-party attribute values to the appropriate Magento 2 attribute values manually. The following step-by-step tutorial explains how to do that.

  1. First of all, export product data from an external system or get an update from a partner.
  2. Open the document and edit it. You need to match both attributes and attribute values to the corresponding Magento 2 parameters.
  3. If it is not a CSV file, you should convert it to the supported format.
  4. Now, when attributes and their values are matched and saved as a CSV file, you can start the Magento 2 import.

Pros

The only positive aspect of the standard way of matching attribute values for Magento 2 import is that you make a third-party output file suitable for updating your store database. Indeed, it’s your primary goal, and you should achieve it anyway, but what are the drawbacks of the described approach?

Cons

Unfortunately, the standard way of matching attribute values is exceptionally far from being ideal. There are two core problems with the described procedure: complexity and volume. You need to edit substantial data files making them suitable for Magento 2 import. The more attributes and their values the data file consists of; the more work should be done. The procedure requires extra concentration and patience increasing the probability of mistakes. Thus, you need to double-check everything, and if there is an issue, you won’t import the external output correctly, or in the worst-case scenario, the update won’t be possible. Considering that, we’d like to introduce you to an entirely different way of attribute values matching.

User-Friendly Attribute Values Mapping for Magento 2 Import

Meet the Improved Import & Export extension – your number one time-saver when it comes to making data from external systems suitable for Magento 2 import. It already does a lot of work to make every import intuitive and straightforward (we describe the corresponding features below), and attribute values mapping is among the provided options.

The feature is implemented along with the default attributes mapping. Thus, you can match external attribute values while configuring attributes themselves. You need to create a new import profile. While in the mapping section, select an external attribute you want to match to the corresponding Magento 2 attribute. Do the mapping and repeat similar actions for the values of the selected attributes. That’s all! Values are successfully mapped!

Let’s explore a simple example to illustrate the enhanced mapping functionality introduced in the Improved Import & Export Magento 2 extension. For instance, “color” is a default Magento 2 attribute. “red” is its value used in the Magento database. Your vendor provides a data file where the same attribute has three similar values: “pink”, “light-red”, and “dark-red”. The Improved Import & Export Magento 2 extension lets you map all three values to the default one (“red”) right in the admin section of the module within a few clicks. Just point all third-party attribute values to the corresponding Magento 2 value.

Pros

By choosing this approach, you save tons of time and dramatically decrease the probability of errors. Furthermore, you don’t need to convert the external output to CSV, since the Improved Import & Export Magento 2 extension supports multiple file formats. Another significant benefit provided by our module is the ability to save the created mapping scheme for further updates. Thus, mapping turns into a one-time procedure as opposed to the default matching described above.

Cons

The only drawback of the user-friendly attribute values mapping for Magento 2 import is the necessity to install a third-party extension, but what is Magento without the vast ecosystem of modules?

Get Improved Import & Export Magento 2 Extension

Other Mapping Capacities

To illustrate the mapping potential of the Improved Import & Export extension, we should describe all corresponding sections of the module. In addition to attribute values mapping, it also offers attributes mapping and category mapping. Besides, we should say a few words about the ability to import Magento 2 attributes, attribute values, and attribute sets as well as the opportunity to modify attribute values during import processes.

Attributes Mapping

If the import file has a custom structure, you can always make it suitable for the Magento 2 requirements with the help of the mapping section of the Improved Import & Export Magento 2 extension. It offers the ability to apply presets for the import tables. Thus, you can map external attributes with the ones in your Magento 2 database within just a few clicks. Select a platform from which you are importing the update file and apply the predefined scheme. The extension supports Prestashop, Magmi, Shopify presets that can be specified in the Import Settings section. For the migration from Magento 1.x to 2.x. we offer the free Migration add-on that follows the logic and interface of Improved Import and Export.

The module compares product attributes of Magento 2 (System Attribute column) with ones from the import file (Import Attribute column). Next, it automatically applies mapping for fields that don’t satisfy system requirements. As a result, you should see the following picture:

Please, contact our support regarding mapping presets for your specific business case. Leave your requests here: Firebear Help Center. If there is no preset for your particular integration or you want to explore the mapping functionality by yourself, the Improved Import & Export plugin provides the ability to do the same procedure manually. You should:

  • Select a default Magento 2 attribute in the ‘System Attribute.’
  • Specify a corresponding import attribute.
  • Set a default (hardcoded) value for selected attributes if necessary (it is added for each imported item in the appropriate column).
  • Click on the black bin icon to remove a mapping item if necessary.

You must admit that it is a very user-friendly way of attributes matching. When the mapping configuration is prepared, you only need to hit the ‘Validate’ button. This action will validate mapping.

Category Mapping

In case you are going to import categories, the Improved Import & Export extension will help you seamlessly map external values to ones used within your e-commerce website. To adjust the categories of the products from the import table, proceed to the Map Categories section.

Here you can define the root category where all the imported products will belong to. To start mapping categories, you should load all values from the ‘categories’ column of the import table. Hit the ‘Load Categories From Import File’ button. Now, the Improved Import & Export extension knows what categories are specified in the import table. You can click the ‘Add New’ button to map the first category. The ‘Import category path’ field lets you select any categories from the import table. Choose the one you want to map. Finally, you can select a category from your Magento 2 website in the ‘New category path’ field to move the product to it.

Furthermore, the Improved Import & Export Magento 2 extension provides the ability to add new categories right from the import job. Hit the ‘New Category’ button, specify a name of your new category and select its parent category.

Attribute Import and Export

The Improved Import & Export Magento 2 extension provides the ability to revamp the manual attribute import creation entirely. Instead of recreating each attribute and its value manually, you can save tons of time and effort by importing a single table.

The module allows importing attributes, attribute sets, and attribute values using multiple file formats, including CSV, XML, JSON, ODS, and Excel. At the same time, you can use them for the corresponding export processes. As we’ve just mentioned above, it is possible to apply mapping for import to modify any third-party attributes in accordance to the default Magento 2 requirements.

A seamless transfer of all attribute details is another benefit of the Improved Import & Export Magento 2 extension. Freely import/export properties, options, swatches, etc. And you can always rely on a sample file provided by the plugin. Creating new attributes on the fly during import is another robust feature you will be able to leverage after installing the Improved Import plugin.

Let’s see what you can create with the help of the extension during the import. First of all, it is attribute groups, attribute set names, and multiple attribute sets. Next, you can leverage your store views to create attribute labels and options on their basis. And as mentioned above, new attributes can be generated on the fly.

The corresponding update functionality of the module lets you renew data for attribute labels and option values for each store view individually.

Attribute Values Editing

Magento 2 attributes, values, and attribute sets import and export

In addition to the ability to map attribute values during Magento 2 import, the Improved Import & Export module lets you edit them using multiple rules. First of all, you can add a prefix or/and suffix to SKU and other attributes. For instance, it is possible to create a rule that will add the “light-” prefix for all “red” values of the “color” attribute.

Next, you can easily split data from one block to multiple blocks if it is related to different products of values. The opposite action is possible as well: merge data from various blocks into one if necessary.

Note that you can manipulate the values in the source file with the help of RegEx. The Improved Import & Export Magento 2 extension lets you create multiple combinations using these rules.

For further information, check this post: How to Modify Attribute Values During Import and Export in Magento 2.

New Attributes On The Fly

And if the import file lacks attributes, you can create them on the fly during the import process. Replace an attribute name in the attributes column with data necessary to create an attribute. Specify an attribute set, a frontend label, scopes, etc. The general format of an attribute creation column looks as follows:

Note that a pipe symbol is utilized for separating values. A new attribute column should start with ‘attribute’ to let the Improved Import & Export extension understand that it is a new attribute.

The aforementioned general format can be transferred into something like this scheme:

For further information, proceed to the official manual of the Improved Import & Export Magento 2 extension: Product attributes import.

Other Features

To give the full picture of how the attribute values mapping can be improved, we should describe two more features: extended connectivity options and advanced scheduling.

Extended Connectivity

As mentioned above, Magento can import only CSV files. Thus, you should convert the third-party output into them. The Improved Import & Export Magento 2 extension solves that issue by introducing support for multiple file formats. Now, you can freely import data using CSV, XML, JSON, ODS, and Excel files.

Furthermore, the Improved Import & Export module introduces multiple file sources so that you can transfer data using either a local or remote server (FTP/SFTP), a Dropbox account, or import them from a direct URL. Note that all compressed files are unzipped automatically. For further information, check this article: How to Import Compressed Data to Magento 2.

And if file transfers are not suitable for your business case, our module offers the ability to import data from Google Sheets. The process is illustrated below:

Magento 2 Google Sheet import

At the same time, you can fully leverage SOAP API, REST API, and GraphQL API connection for the same purposes. Note that all the extension’s features work seamlessly with all file formats, data sources, connection types, and entities. It means that you can freely map attribute values during the Magento 2 import via API, from Google Sheets, or when downloading a table from an URL.

Advanced Scheduling

Now, when you know that it is possible to turn any external output into a data flow suitable for Magento 2 using the flexible mapping interface, we should also draw your attention to the ability to automate both import and export processes. Since the Improved Import & Export Magento 2 extension supports cron, you can create a custom update schedule.

At the same time, the module offers a list of predefined values. Just select the one most suitable for your business needs. If necessary, you can fully customize it using the standard cron syntax.

To manage updates effectively, you can assign each import or export job to a particular cron group.

Besides, the extension enables you to create profiles designed for a manual run only which are useful for infrequent updates. Also, you can run every process manually in an asynchronous mode if necessary. Let’s imagine a situation that your partner has sent a vital update file, but the appropriate import process is scheduled for tomorrow. With the Improved Import & Export extension, you can launch it whenever you want. Take a look at the following gif image as it illustrates the corresponding section of the plugin.

If you want to explore the module in more detail, watch the following video:

Conclusion

You no longer need to edit attribute values manually. Now, you can do that right in the Magento admin with the help of the Improved Import & Export extension. It dramatically simplifies the procedure, helps to save tons of time, and reduces the probability of errors caused by the human factor. For further information about the module, follow the link below. Contact our support if you still have any questions.

Get Improved Import & Export Magento 2 Extension

Magento 2 Attribute Values Mapping & Import/Export FAQ

Let’s take a look at other nuances of importing and exporting data with third-party attributes and values with the help of the Improved Import & Export Magento 2 extension.

How to import and export data with third-party attributes to Magento 2 automatically?

Moving information between Magento 2 and other systems is always blocked by numerous hurdles. While you can transfer several basic entities to Magento 2 using its default tools, it is impossible to automate these processes unless you use the platform’s commercial version. However, you can rely on the Improved Import & Export extension to enable the missing functionality on your Open Source website. The module utilizes a cron scheduler to automate data transfers. As a store admin, you get the ability to import most entities to Magento 2 even if they contain third-party attributes and values automatically after specifying a schedule of updates and creating a mapping scheme. The latter is described in the next question.

How to import data with third-party attributes and values to Magento 2?

If data you are going to import to your e-commerce website doesn’t follow the Magento 2 requirements, the system will block the transfer. It often happens when the imported table contains third-party attributes or unsupported attribute values. However, the Improved Import & Export extension lets you transfer them after creating a mapping scheme. You match third-party attributes and values to ones used within Magento 2. As a result, any external data is easily adapted to the native platform standards. As for export processes, you can also create a map of attributes and values to generate the output your partners need.

How to import and export data that contains third-party attributes and values to Magento 2 via API?

The Improved Import & Export Magento 2 module allows for creating API connections aimed at moving data between your e-commerce store and any external system. The corresponding section is available in the module’s import/export jobs. There, you can specify the parameters necessary to sync the two systems. Also, use cron and mapping to automate the transfers and apply changes to attribute values on the go.

How to import and export data that contains third-party attributes and values to Magento 2 via ODS files?

The Improved Import & Export module lets you move data via ODS files without converting them to CSV. You can also export Magento 2 entities using this file format. Note that both cron and mapping are at your service.

How to import and export data that contains third-party attributes and values to Magento 2 via XLSX files?

The Improved Import & Export module lets you move data via XLSX files without converting them to CSV. You can also export Magento 2 entities using this file format. Note that both cron and mapping are at your service.

How to import and export data that contains third-party attributes and values to Magento 2 via JSON files?

The Improved Import & Export module lets you move data via JSON files without converting them to CSV. You can also export Magento 2 entities using this file format. Note that both cron and mapping are at your service.

How to import compressed data that contains third-party attributes and values to Magento 2?

If your data files that contain third-party attributes and values are compressed, you can use the Improved Import & Export extension to transfer them to Magento 2. Remember that your file archive should be ZIP or TAR containing CSV, XML, ODS, JSON, or XLSX files.

How to import data that contains third-party attributes and values to Magento 2 from Google Sheets?

If data that contains third-party attributes and values is stored in Google Sheets, the Improved Import & Export extension lets you move it straight from the remote table to your e-commerce website. Specify the address of the corresponding Google Sheets page. You can also export data from Magento 2 to Google Sheets.

How to import and export data that contains third-party attributes and values between Magento 2 and Dropbox?

The Improved Import & Export module lets you transfer tables that contain third-party attributes and values between Magento 2 and Dropbox in CSV, JSON, XML, ODS, or XLSX files or ZIP and TAR archives.

How to import and export data that contains third-party attributes and values between Magento 2 and Google Drive?

In addition to Google Sheets and Dropbox, you can leverage Google Drive to import and export data that contains third-party attributes and values. You can move CSV, JSON, XML, ODS, or XLSX files packed in ZIP or TAR archives.