cancel
Showing results for 
Search instead for 
Did you mean: 

Table coupling the product attributes and the orders in magento

Table coupling the product attributes and the orders in magento

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.

2 REPLIES

Re: Table coupling the product attributes and the orders in magento

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.

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

Re: Table coupling the product attributes and the orders in magento

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?