v. 30.11.2010

This Wizard will help you to update your database by selecting appropriate action.

Pay attention to each Wizard's page when importing product attributes to Magento. Import is rather complicated procedure and it may be destructive if performed incorrectly. Create database backup before you begin to import product attributes to Magento especially if you do it for the first time.

To start Import Product attribute sets to Magento you need to click on Import/Export which starts the Import/Export Wizard. Product attribute sets Import/Export Wizard is a lot like Categories or Products Import/Export Wizard.

1. First of all prepare a .csv file for Magento Attributes Import. Make sure it contains all necessary fields and all data you need.
   
   
2. Select "Import" in the Import/Export Wizard and click "Next >" button to continue.
   
   
   
   
   
3. Specify .csv file to import or use browse button [...] to select one.
   
   
   
   
   This step you can select File Charset to set up correct coding for your .csv file. 
   
   Also you can Save Import Settings for future import of attributes to Magento or load one to use now.
   
   
4. Source file preview shows a part of .csv file selected to import. There are no options to set, but you should pay some attention to this page. What's so important to look for on this page is field delimiter and quote character, if some is used.
   
   
   
   
   

   If you carefully check the very first line of the example, you'll notice that some words enclosed in quotes (") and are separated by semicolon (;) symbol. That are two important options you have to pay attention to - you will have to setup these settings on next page. Usually it is enough to see first line, no need to investigate entire file. Also you can enable and set the row # you want to start import from.

5. Select fields delimiter and quote character page contains some important settings. If you specify wrong values, import may not work.
   
   
   
   
   

   First option is delimiter character. Most popular delimiters are comma (,), semicolon (;) and tab character ( ) however other symbols can be used as well.

   Note .csv file contains data in row - column format and delimiter character is used to separate one column from another. If you specify incorrect delimiter, file will not be parsed properly and attribute sets will not be imported.

   On previous sample page we have noticed that semicolon symbol was used as delimiter and values were quoted with " symbol. Specify two first settings as shown above.

   Set and Group delimiter is not native .csv setting; it is used only in Store Manager. It is used to separate attribute set and group. By default pipe character is used - |. If any attribute group is assigned to more then one attribute set, double delimiter should be used (for example || )

6. Products were not imported to your database yet. On Import Preview page you can see how .csv file was processed using Magento import attributes settings, which you specified at previous steps. Check whether all columns that you want to be imported are filled with data: some of them may be blank. This means that it is empty in source (.csv) file.
   
   
   
   
   
7. Import options page settings may affect Import results. Please read and check your selection carefully to perform Magento attributes import correctly.
   
   
   
   
   

   Update Existing attributes. It is not recommended to use this option.

8. In the last window of Import Products Attributes Set Wizard will be shown if any errors occurred during import process.
   
   
   
   
   Import log shows you if any error occurs while Magento attributes import. Some of them might be ignored whereas other errors like this one (Could not find image: image_name.gif) has to be fixed.