Bulk upload of Attributes & Attribute values, and product info

[pamelasplayroom]

Hi All.

 

just getting to grips with the sharp end of prestashop, and was wondering if it was possible to produce a csv file containing attributes and associated values that could be uploaded, instead of having to enter all the attributes and associated values individually.

 

if so, what format (field headers) would be required, and how / where to upload it.

 

i have had a quick look at the database tables, and it seems that the information is spread between 6 or more tables, and duplicated for each language available, thus making direct manipulation / population of the data tables difficult and dangerous.

 

the reason im looking to do this is that i have a great many attributes, some with a lot of values (length, width, height - values 0 to 120 each would be some of them), and its going to take days. if i could extract the info from my excel files into a csv, and upload i could be done in a couple of hours max.

 

Also, when adding products via csv file, can say, the width attribute be set to show choices between 60 and 80 in the csv file, and would a value of 160 automatically be added to the attribute values for the width.

 

As there is no way that i can see (but i may be missing it) to do a csv export of the data without purchasing a module, its going to be a bit dificult to work these things out without a sample data set to work from.

 

Hope this makes sense and many thanks in advance for any help.

Adrian