Quote Originally Posted by heavenlynights View Post
I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA
It seems there is no real answer, at least not one I could find here.

Another way to add attributes is to add them direct to your database via phpmyadmin. I have tried this and it works fine.

My store is live but not 'released' as such, ie, it's brand new I haven't advertised it and it has no traffic so it's ok to mess around with things. What I did is this.

Go to your database via phpmyadmin and click on the products_attribute table then the export tab. Select csv for MS Excel and select put field names in first row, select zipped then click go. Save to your computer when asked.

I only had a few products added to my DB so it was easy to see what was required when editing the spreadsheet, when you have finished editing delete the row with field names and save as a .csv

Putting it back is basically the export procedure in reverse. Go to the products_attributes table and click the import tab then browse to your saved .csv file, then click the csv option in the format of imported file box and be sure to change the field terminated by ; to , (semi colon to comma) there are other options for 'replace table data with file' this will replace all the data within the table, and ignore duplicate rows. I usually select replace table data.

This has worked fine for me, it worked fine with oscommerce too. Two rules.

1) BACK UP FIRST
2) Never forget rule 1.