products_options_values_to_products_options Table ?

[stantheman]

Can anyone tell me what this table is used for and how it is created?

 

products_options_values_to_products_options

[AG]

If you look in your phpAdmin and look at your db, I think it will make sense.

 

Basically,

products_options gives you things like Mode, colour, size etc

products_options_values give you things like 1mb, 10mb, blue, red etc

 

products_options_values_to_products_options has id starting from 1 and assigns which applys to which etc.

 

All of this can be done from your Admin section where you set your product attribute.

 

Hope this make sense :wink:

AG

[stantheman]

Thanks for your reply. I am familiar with the links and information stored in these tables.

 

I may have asked the question incorrectly? I will try again.

 

How does data get written to these tables?

 

I have gone into Product Attributes in the Admin section and added attributes but this hasn't written any records to products_options_values_to_products_options