Documentation for Import Export Product Attributes

• Import Export Product Attributes for Magento 2 extension helps administrators to quickly import product attributes into websites via a standard CSV file.
  

• Admin needs to prepare a CSV file with all necessary information about product attributes, then import by only one click.
  

• the extension also supports exporting all available attributes into a CSV file conveniently.
  

• Import/Export Product Attributes for Magento 2 extension is often used in case store owners want to change their Magento 2 websites into new ones or change from another platform to Magento 2.
  

There are two ways of installing extension in magento2.

1. Using COMMAND LINE.
   
2. Manually Install extension.
   

Option 1: Magento 2 install extension using COMMAND LINE (Recommended)

Follow below steps to install extension from the command line.

Step 1: Download the extension and unzip it.

Step 2: Upload it to code directory in your magento installation’s app directory. If code directory does not exists then create.

Step 3: Disable the cache under System → Cache Management.

Step 4: Enter the following at the command line:

           Php bin/magento setup:upgrade
           Php bin/magento setup:static-content:deploy

Step 5: Once you complete above steps log out and log in back to the admin panel and switch to Stores → Configuration → Mageants → Import Export Product Attribute, the module will be displayed in the admin panel.

Option 2: Magento 2 install extension manually

Step 1: Download the extension and unzip it.

Step 2: Upload it to code directory in your magento installation’s app directory If code directory does not exists then create.

Step 3: Disable the cache under System → Cache Management Edit app/etc/config.php file and add one line code: ‘Mageants_Import Export Product Attribute’ ⇒ 1

Step 4: Disable the cache under System → Cache Management

Step 5: Once you complete above steps log out and log in back to the admin panel and switch to Stores → Configuration → Mageants → Import Export Product Attribute, the module will be displayed in the admin panel.

After Installation of Extension login to Magento admin panel to set configuration of the extension.

You can find configuration at System → Product Attribute Import

Import Behavior: There are 3 options for you to select.

Add/Update: This option allows administrators to add new attributes to the website. In addition, it also updates attributes if their attribute_codes exist.

Replace: This option allows administrators to add new attributes to the website. In case attribute _ codes in the import data match with attribute_codes of existing attributes, these attributes are deleted and new records are created using the CSV data.

Delete: This option allows administrators to remove attributes in case their attribute_codes exist.

Validation Strategy: select one option from the drop-down list to determine how the system operates when there are errors in the import process.

Stop on Error: the system stops importing when there are errors.

Skip error entries: the system skips errors and continues to import.

Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds that maximum number you fill in this field, the system will stop importing.

Multiple value separator: Choose a character to separate data in a field column. In our CSV sample file, the vertical bar ( | ) is set up as the default value.

Before you import product attributes via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File. Then you open this file and fill in fields:

Your CSV file must include enough the number of columns like the sample file so that you can successfully import it. (If the number of columns is greater or fewer than those in the sample file, the system will notify you about errors).

After you finish the CSV file, tab Choose File button to select the file to import.

If your CSV file is free from errors, there is a message to notify validation results and the Import button now appears to click.

You click the Import button to start importing product attributes in the CSV file into Magento 2 website.

You go to System ⇒ Export Product Attributes and select Product Attributes in the drop-down list of Entity Type.

choose CSV in the Export File Format field.

you can export all available product attributes by choosing All from the drop-down list or export each attribute set.

After selecting attribtue set When Admin Click Export Attribute button a CSV file is Downloaded.