Quote Originally Posted by Impact-Flies View Post
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.
Thanks Impact. Much appreciate your assistance. This will save me a lot of time..

Do you use easy populate for adding products? if so do you have the same problem regarding no product page created?

TIA