Magento 2 Export and Import Product Attributes Extension

Configuration Settings

To access the configuration settings for this extension, log into the Magento Admin panel and go to STORES ⟶ Configuration ⟶ ULMOD EXTENSIONS ⟶ Export/Import Product Attributes.

Log all Product Attributes Export History -  set to "Yes", to log all Product Attributes export history in the admin panel, all history will appear under SYSTEM → Export/Import Product Attributes by Ulmod → Export Product Attributes History. Set to "No" if you do not want to log all Product Attributes export history

Auto-Clear Product Attributes Export History After X Days -  enter the number of days to automatically clear Product Attributes export history. Eg. 30. If you do not want to clear the Product Attributes export history automatically, set this to 0.

Export Product Attributes

To export product attributes, please go to SYSTEM ⟶ Export/Import Product Attributes by Ulmod ⟶ Export Product Attributes.

Export Product Attributes

In the Entity Type select the "Product Attribute" entity.

Select the Attribute Set to export

Click the Export Product Attributes button to export. The product attributes will be exported to a CSV file. eg. "product_attribute_DDMMYYY.csv"

Prepare CSV Import File

Before you import product attributes via a CSV file, you need to prepare the CSV file. You can download our sample import CSV by clicking Download Sample File which is close to Import Settings -> Entity Type field.

Please edit the CSV file to import on google docs or similar tools. If you edit on google docs, make sure to download as CSV (File ⟶ Download as ⟶ Comma-separated values(.csv, current sheet))

If you expect to delete or replace the attribute during the import ("Import behavior": Delete or Replace ), make sure that your attribute(s) in the CSV file has is_user_defined field set to 1.

is_user_defined value:

• 0 = attribute is defined as a system attribute and can not be deleted during the import
• 1 = attribute is not defined as a system attribute and can be deleted during the import

Import Product Attributes

To import product attributes, please go to SYSTEM ⟶ Export/Import Product Attributes by Ulmod ⟶ Import Product Attributes.

Under "Import Settings" section:

set Entity Type to "Product Attributes"

Click Download Sample File to download the sample Product Attributes import file. Check the structure of the sample Product Attributes import file and use it to prepare your CSV import file. More details on the "Prepare CSV Import File" section.

Under "Import Behavior" section:

Import Behavior selects the import behavior:

• Add/Update: this setting adds to the database/site, new product attributes from the import file. If the product attribute already exists in the database/site (eg. attribute_code exist), the product attribute will be updated.
• Replace: this setting adds new product attributes to the database/site. If product attributes in the import file have attribute_code that exist in the database/site, the extension will delete existing product attributes and add the ones from the import file
• Delete: this setting delete from the database/site any product attributes in the import file if their attribute_code exists.

Validation Strategy choose to "Stop on Error" or "Skip error entries" when an error is encountered when importing data

Allowed Errors Count enters the number of errors that can occur before the import is stopped.

Specify the Field separator and Multiple value separator. A comma is the default separator in a CSV file. If you want to use a different character, make sure that the data in the CSV file matches the character that you specify.

select the Fields Enclosure checkbox, if you want to enclose any special characters that might be found in the data as an escape sequence.

Under "File to Import" section :

Click Choose File to select the Product Attributes file to import. Make sure the file is saved in UTF-8 encoding for proper import

click Check Data in the upper-right corner to validate the CSV file. Wait a few moments for the validation process to complete. If the CSV file is valid, the following message appears:

If the CSV file is valid, click Import to import the file. Otherwise, correct each error is listed in the validation result, and try to import the CSV file again.

When the import is complete, a message appears. Example of a successful import

Export Product Attributes History

To access the Product Attributes export history, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ Export/Import Product Attributes by Ulmod ⟶ Export Product Attributes History.

You can choose the column to show or hide on the grid and filter log by export date, admin username, file name, attribute set, execution time, status, and message

To delete/clear all export history manually, click the "Delete All Export Logs" button, all history is deleted

Sample Downloads

Click To Download Sample Import and Export Product Attributes Files
The sample Product Attribute Export is also available under the extension live demos.
The sample Product Attribute Import is also available under the extension import settings (by clicking Download Sample File which is close to Import Settings -> Entity Type)