Export and Import Product Attributes for Magento 2
The extension has 2 separate ways of installation, via Composer or by copying the code.
Please follow this Installation Guide to install the extension.
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.
To export product attributes, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ 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"
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 that 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.
- 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
To import product attributes, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ 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 new Product Attributes from the import file. If the product attribute already exists in the database and has the same URL keys (identifier) as the one from the CSV file, the product attribute will be updated.
- Replace: this settings delete existing product attribute and add the ones from the import file
- Delete: this setting delete from the database any product attribute in the import file that already exist
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
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 filters 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
Ulmod Support team is always ready to assist you, no matter which part of the world you are in. If something does happen and you think you might be experiencing an issue or bug, please contact us via [email protected] or submit a ticket from our Helpdesk Ticket and we will help you out.
Should you have any questions or feature suggestions, please Contact Us. Your feedback is welcome!