Add attribute values from MySQL database?

[riahc3]

Hello

 

I have a product (this is a simple example), lets say a T-Shirt but instead of dynamically adding things like "Green" "Blue" etc I want to insert it into a database and each time the product page comes up, it should populate a dropdown box with the values from the database.

 

How can I assign a attribue to a product (simple question) and how can I do this population with a database (harder question)

 

Thank you

[RogueWaveLimited]

Can't you do this with product "combinations"?

[riahc3]

Can't you do this with product "combinations"?

Yes but for several reasons, I need to do this with a MySQL database which is used by more than one application so it needs to remain all synced for example.

 

For example: I get green shirts in the store, I want to add them to a physical database so it can show up in physical store one, physical store two, and then of course online store one.

[RogueWaveLimited]

Which is the "master" database? prestashop, store 1, store 2 or is there some other master database?