Table coupling the product attributes and the orders in magento

[dilani_m]

Which table couples the orders and the product attributes of the related orders such as size, color and price?

For example, if my order contains a shirt, I need to get the color and size of the shirt through a query.

[Damian Culotta]

Hi @dilani_m,

You should check the sales_flat_order_item table.

Take a look at the product_options column. Also, in that case complex porducts (Configurable, Grouped, Bundle) works as parent of the Simple (or Virtual) products so you will be able to get the reelation of items too.

[dilani_m]

product_options column in sales_flat_order_item table is in serialized format. 

example: a:1:{s:15:"info_buyRequest";a:5:{s:4:"uenc";s:68:"aHR0cDovLzE5Mi4yNTQuMjE1LjEzNC9-emlnemFnL3ppZ3phZzEuOS9pbmRleC5waHAv";s:7:"product";s:1:"7";s:8:"form_key";s:16:"S6GrWc78CzMvy3Jd";s:6:"isAjax";s:1:"1";s:3:"qty";s:1:"1";}}

Is there any other table from which I can get these information?