Your error seem to be "Error Code: 1052. Column 'price_type' in where clause is ambiguous" Try $_product = Mage::getModel('catalog/product')->load(1); $collection = Mage::getModel('catalog/product_option') ->getProductOptionCollection($_product) ->addFieldToFilter('default_option_price.price_type', array('eq' => 'percent')); Try debugging using echo $collection->getSelect();