Magento 1.9 – Get Custom Option Values of a Product

configurable-productcustom-optionsmagento-1.9

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?

Best Answer

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);
}

Related Solutions

Custom Option Validation in Magento

Finally i found the custom-option-text field is located at: ..\app\design\frontend\base\default\template\catalog\product\view\options\type\text.phtml

for the line

<input type="text" onchange="opConfig.reloadPrice()" id=.... $_option->getIsRequire() ? 'required-entry'.....

I used "required-entry validate-alpha" to replace the default 'required-entry', now for all custom options with text field it allows alphabet only, hard coded. Hope this may help anyone in needed.

Magento 1.9 – How to Get Selected Values of Product Custom Options?

Try the below code,

    $order = $observer->getEvent()->getOrder();
    $items = $order->getAllVisibleItems();
    foreach ($items as $item) {
    $options = $item->getProductOptions(); 
    $customOptions = $options['options'];   
    if(!empty($customOptions))
    {
      foreach ($customOptions as $option)
      {     
         $optionTitle = $option['label'];
         $optionId = $option['option_id'];
         $optionType = $option['type'];
         $optionValue = $option['value'];
      }
   }

Best Answer

Related Solutions

Custom Option Validation in Magento

Magento 1.9 – How to Get Selected Values of Product Custom Options?

Related Topic