I am beginner in Magento, I want to add csv file for attributes, as we have 500 attributes, so we can not upload it 1 by 1 because it takes time. Please suggest me simple way to upload attributes by using csv file?
Here is how I would do it.
Let's say your csv looks like this:
You need to turn this csv into something like this:
All other attribute properties can come from the csv. I just added a few as a proof of concept.
Now use the result as an upgrade script in one of the custom modules. Read this article from Inchoo explaining how to add attributes through code to get a clear view.
The advantages of this approach is that once you create the upgrade script it is portable to all the site instances you have, and you don't have to import attributes each time.
Another way is to add the the Attributes with the soap api. You can write a script that reads your csv and connects it to the soap api.
You have to add a soap role and user in magento Backend
Connect to soap api
Call the soap Api
This is an example from http://www.magentocommerce.com/api/soap/catalog/catalogProductAttribute/catalogProductAttribute.html