How to add attributes via CSV?

Scenario

Suppose you want to add attributes to your category pages on the store so that the products listed can be filtered accordingly. You want these attributes to be inserted directly via CSV file.

Examples

Steps

StoreHippo offers an easy way to update the attributes for category pages through CSV at the same time. To do so, follow the process given below:

1. Go to Products > Products section in StoreHippo Admin Panel.
2. Click on the Export button to export all products or specific products for which you want to add attributes.
   
3. A dialog box for exporting file opens. Fill up the fields as shown below:
   
4. Click on Send to Email. The CSV file is sent to you in the email or you can download the file from Export logs.
5. View the downloaded CSV file. The CSV file appears like this: 
   
6. First, create a column for the above-mentioned attributes by the name attributes.Size and attribute.Color. Go to the attributes.Sizeand attribute.Color column which you created and enter the values with respect to the particular products for which you want that product to be listed under. If you have multiple values for an attribute, you can provide the attributes separated by a comma.
                                              
7. Also, if you wish to add more attributes you can subsequently create columns for the same as attributes.attribute_name and provide value to it with respect to a particular product row.
8. When you have entered all the desired attributes and provided the attribute values for each product, go to the Products section of the admin panel. Click on the Import button to import the edited CSV file.
   
9. The dialog box for importing file opens. Upload the file in which you made changes and click on Import file.
   
10. You can check the status of the imported CSV file by clicking on the notification icon or in Import logs.
11. The attributes will be updated in the admin panel and the respective category pages.