Magento – Where magento stores custom options for the products added to cart

customcustom-optionsmagento-1.7

Assume that you are going to add a product which has custom options. So when you add that product to the shopping cart, where will the magento save those custom option's values persistently?

Any suggestions will be appreciated.

Best Answer

The selected options are stored in the table:

sales_flat_quote_item_option

When the quote is converted to an order the info_buyRequest data is transferred to the field product_options in the sales_flat_order_item table.