Hi,

Im developing a peice of code that goes through an Excel spreadsheet of products and updates my products details. Basically it will update the price and a course_date attribute I will create and assign to each product. The course_date attribute will have multiple entries e.g.
1 Jan 2008
2 Jan 2008 ...

What I want the process to do is to remove the attributes once the date has passed and add any new ones.

The questions I have are :

1) Is there a database schema for the Attributes and how they link in with the product.

2) What components make up the attribute and what database does the data get written to?
From my understanding there is
a)the option name (e.g. Course code)
b) the values (e.g. 1 jan 2008)
c) which values in the option sit with the product

3) If i remove the attribute values from the product how does that affect existing orders? e.g. removing 1 Jan 2008 from the course_date attribute because it is no longer offered
This sin't a problem at the moment as I m setting the store up as a showcase site but will be adding the options to have a client account in the near future where they can track their orders.



thanks