// *Special note: make sure you check your sql table name, // and change the option title from what i have below. // rbanh special methods private function rbanh_get_custom_option_id($product_id) { $sql = " select o.option_id from catalog_product_option o inner join catalog_product_option_title t on t.option_id = o.option_id where t.title = 'Shipping Description' and o.product_id = '".$product_id."' limit 1 "; $data = Mage::getSingleton('core/resource') ->getConnection('core_read')->fetchAll($sql); if (count($data) > 0) { return current($data[0]); } return false; } // rbanh special methods private function rbanh_add_custom_option($product_id) { // make the option active //$write = Mage::getSingleton('core/resource')->getConnection('core_write'); //$write->query("update catalog_product_entity set has_options = 1 where entity_id='$product_id'"); $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $sql = "update catalog_product_entity set has_options = 1 where entity_id=?"; $write->query($sql, $product_id); $product = Mage::getModel('catalog/product'); $product->load($product_id); $opt = Mage::getModel('catalog/product_option'); $opt->setProduct($product); $option = array( 'is_delete' => 0, 'is_require' => false, 'previous_group' => 'text', 'title' => 'Shipping Description', 'type' => 'field', 'price_type' => 'fixed', 'price' => '0.0000' ); $opt->addOption($option); $opt->saveOptions(); return $this->rbanh_get_custom_option_id($product_id); }
Wednesday, July 16, 2014
11:57 PM
Magento auto add product custom options
MR: EDITOR
A blogger
I am passionate blogger cum B.Tech. Computer engineering graduate. I love writing blog post. I spend my free time in writing blog post that will useful to everyone (including me). I have had some success making money blogging and want to help others do the same. I just figured that by creating a great and free resource a lot of links would follow – and they have. Some people ask me how they can repay me – which is not necessary - but for those wanting to show their appreciation, I just say linking to the article from their blog is the best compensation I could receive. Thanks for reading!
Related Posts
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment
Thanks for commenting. I will Reply you soon