Get Custom Option Values of a product

Question

In my magento store, I have implemented a custom module to add configurable products programmatically. In those products I have added Custom Option, a text field for user to input some data.

Now I have this requirement of retrieving all the values of the custom option entered by users who purchased the specific product. (I need to retrieve the values using the product ID)

Is there a way I can achieve this?

Answer 1

Check product_options column in sales_flat_order_item table.

You can use order_item collection and get the value of that field like that:

$orderItems = Mage::getModel('sales/order_item')->getCollection()->addFieldToFilter('product_id', '123');

foreach($orderItems as $orderItem){
    $options = $orderItem->getProductOptions();
    var_dump($options);
}

Answer 2

You need use this code to get custom options of the product:

    if($_product->hasOptions()) {
        foreach($_product->getOptions() as $option) {
            echo 'Option title is: ' . $option->getTitle();
            echo 'Option type is: ' . $option->getType();
            echo 'Option values:';
            foreach($option->getValues() as $value) {
                echo '- ' . $value->getTitle() . ': ' . $value->getPrice();
            }
        }
    }