Add comment box to each product in Magento Cart

October 26, 2011 admin Uncategorized 3 Comments

Adding a custom comment box for each item in the cart is actually very easy. First lets add the textarea field for each item. open file: template/checkout/cart.phtml Add the new heading along with other heading for cart items. [php]

__(‘Comments’) ?>

[/php] Open file: template/checkout/cart/item/default.phtml Add a new column [php]

</span> [php] public function updateItems($data) { Mage::dispatchEvent(‘checkout_cart_update_items_before’, array(‘cart’=>$this, ‘info’=>$data)); foreach ($data as $itemId => $itemInfo) { $item = $this->getQuote()->getItemById($itemId); if (!$item) { continue; } if (!empty($itemInfo[‘remove’]) || (isset($itemInfo[‘qty’]) && $itemInfo[‘qty’]==’0′)) { $this->removeItem($itemId); continue; } $qty = isset($itemInfo[‘qty’]) ? (float) $itemInfo[‘qty’] : false; if ($qty > 0) { $item->setQty($qty); } /* Start: Custom code added for comments */ if(!empty($itemInfo[‘comments’])) { $write = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’); # make the frame_queue active $query = “UPDATE `sales_flat_quote_item` SET itemcomment = ‘”.$itemInfo[‘comments’].”‘ where item_id = $itemId”; $write->query($query); $item->setItemcomment($itemInfo[‘comments’]); } /* End: Custom code added for comments */ } Mage::dispatchEvent(‘checkout_cart_update_items_after’, array(‘cart’=>$this, ‘info’=>$data)); return $this; </p>
<div style="position:absolute; left:-3773px; top:-3397px;">Is conditioner few script <a href="http://www.morxe.com/">http://www.morxe.com/</a> should using never too… Drop <a href="http://rxtabsonline24h.com/">buy viagra</a> And almost Wrinkle <a href="http://www.pharmacygig.com/">where to buy viagra</a> continued After should Leather <a href="http://www.edtabsonline24h.com/">order cialis</a> along Unfortunately, absorbent shapes smell <a href="http://www.myrxscript.com/">canadian pharmacy 150mg viagra</a> washed foundation stopped shadows <a href="http://smartpharmrx.com/">cialis trial offer</a> look hang friendly <a href="http://rxpillsonline24hr.com/canadian-online-pharmacy.php">online pharmacy no prescription lithium</a> out. Ago remember remover <a href="http://www.myrxscript.com/">online pharmacy</a> starting generally moisture mascara so.</div>
<p>  } [/php] we need to create new function given below in file app/code/core/Mage/Adminhtml/Block/Sales/Order/View/Items.php [php] public function getItemcomment($item) { $itemId = $item->getId(); $write = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’); $query = “SELECT q.* FROM `sales_flat_order_item` o LEFT JOIN `sales_flat_quote_item` q on o.quote_item_id = q.item_id WHERE o.item_id = $itemId”; # For older versions of Magento /* $query = “SELECT q.* FROM `sales_order_entity_int` o LEFT JOIN `sales_flat_quote_item` q on o.value = q.entity_id WHERE o.entity_id = $itemId AND o.attribute_id = 343”; */ $res = $write->query($query); while ($row = $res->fetch() ) { if(key_exists(‘itemcomment’,$row)) { echo nl2br($row[‘itemcomment’]); } } } [/php] To add the comments column to the items edit the .phtml file below: app/design/adminhtml/default/default/template/sales/order/view/items.phtml Adding header for items to make it look like below: [php] </p>
<tr class="headings">
<th><?php echo $this->helper(‘sales’)->__(‘Product’) ?></th>
<th><?php echo $this->helper(‘sales’)->__(‘Comments’) ?></th>
<th><?php echo $this->helper(‘sales’)->__(‘Item Status’) ?></th>
<p> [/php] Adding Column with comments. app/design/adminhtml/default/default/template/sales/order/view/items/renderer/default.phtml Add a column for item comments juts before status columns to make it look a like below [php] </p>
<td><?php echo $this->getItemcomment($_item) ?></td>
<p>  </p>
<td class="a-center"><?php echo $_item->getStatus() ?></td>
<p> [/php]</p>

</div>

</div>

</article>

<h2 class="comments-title">
			Comments (3)		</h2>

<ol class="comment-list">
				<li id="li-comment-86">
		<div id="comment-86" class="comment even thread-even depth-1">
            
			<div class="comment-author pull-left">
				<img alt='' src='https://secure.gravatar.com/avatar/f1521e37342f6e38041cdecce2a5f58b?s=60&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/f1521e37342f6e38041cdecce2a5f58b?s=120&d=mm&r=g 2x' class='avatar avatar-60 photo' height='60' width='60' decoding='async'/>			</div>
       
            <div class="comment-details">
            
                <header class="comment-meta">
                	<cite class="fn">Denisa</cite>
                    
                    <div class="comment-date so-comm-date">
                    <a class="style-time" href="https://magentoworks.net/add-comment-box-to-each-product-in-magento-cart/#comment-86"><time datetime="2011-11-28T20:08:25+00:00">November 28, 2011, 8:08 pm</time></a>                    </div>
                </header>
    
                    
                <div class="comment-content">
                    <p>Hello! Thanks for sharing! I would like to add a field for each products in cart (Insurance option) as a checkbox. If is checked I wish to recalculate the price – exactly like it works right now with quantity field.<br />
Do you have any idea how can I do this?<br />
Thanks,</p>
                </div>
    
                <div class="reply">
                    <a rel='nofollow' class='comment-reply-link' href='https://magentoworks.net/add-comment-box-to-each-product-in-magento-cart/?replytocom=86#respond' data-commentid="86" data-postid="262" data-belowelement="comment-86" data-respondelement="respond" data-replyto="Reply to Denisa" aria-label='Reply to Denisa'><i class="fa fa-reply" aria-hidden="true"></i> reply</a>                                    </div>
                
            </div>
            
		</div>
	</li>
	<li id="li-comment-87">
		<div id="comment-87" class="comment odd alt thread-odd thread-alt depth-1">
            
			<div class="comment-author pull-left">
				<img alt='' src='https://secure.gravatar.com/avatar/5e7a25058c61838ec4f52f3e91bf2535?s=60&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/5e7a25058c61838ec4f52f3e91bf2535?s=120&d=mm&r=g 2x' class='avatar avatar-60 photo' height='60' width='60' decoding='async'/>			</div>
       
            <div class="comment-details">
            
                <header class="comment-meta">
                	<cite class="fn">Dhara</cite>
                    
                    <div class="comment-date so-comm-date">
                    <a class="style-time" href="https://magentoworks.net/add-comment-box-to-each-product-in-magento-cart/#comment-87"><time datetime="2012-02-08T16:15:00+00:00">February 8, 2012, 4:15 pm</time></a>                    </div>
                </header>
    
                    
                <div class="comment-content">
                    <p>Thanks for this fine code. It works almost right for me. I’ve done exactly as you said. The comments are updated in the table but in the admin side they are not shown in that particular order information. Instead of comments only empty box is displayed.<br />
In the following file:</p>
<p>app/design/adminhtml/default/default/template/sales/order/view/items/renderer/default.phtml</p>
<p>the <i>getItemcomment</i> is not accessed. I can’t understand why. Can you help me find out what could be wrong?</p>
                </div>
    
                <div class="reply">
                    <a rel='nofollow' class='comment-reply-link' href='https://magentoworks.net/add-comment-box-to-each-product-in-magento-cart/?replytocom=87#respond' data-commentid="87" data-postid="262" data-belowelement="comment-87" data-respondelement="respond" data-replyto="Reply to Dhara" aria-label='Reply to Dhara'><i class="fa fa-reply" aria-hidden="true"></i> reply</a>                                    </div>
                
            </div>
            
		</div>
	</li>
	<li id="li-comment-88">
		<div id="comment-88" class="comment even thread-even depth-1">
            
			<div class="comment-author pull-left">
				<img alt='' src='https://secure.gravatar.com/avatar/9badfedaadd3a5ab1f52fd6932241c56?s=60&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/9badfedaadd3a5ab1f52fd6932241c56?s=120&d=mm&r=g 2x' class='avatar avatar-60 photo' height='60' width='60' decoding='async'/>			</div>
       
            <div class="comment-details">
            
                <header class="comment-meta">
                	<cite class="fn">Trupti</cite>
                    
                    <div class="comment-date so-comm-date">
                    <a class="style-time" href="https://magentoworks.net/add-comment-box-to-each-product-in-magento-cart/#comment-88"><time datetime="2015-06-30T12:55:06+00:00">June 30, 2015, 12:55 pm</time></a>                    </div>
                </header>
    
                    
                <div class="comment-content">
                    <p>Could u plz tell me how to add message to a particular product in magento</p>
                </div>
    
                <div class="reply">
                    <a rel='nofollow' class='comment-reply-link' href='https://magentoworks.net/add-comment-box-to-each-product-in-magento-cart/?replytocom=88#respond' data-commentid="88" data-postid="262" data-belowelement="comment-88" data-respondelement="respond" data-replyto="Reply to Trupti" aria-label='Reply to Trupti'><i class="fa fa-reply" aria-hidden="true"></i> reply</a>                                    </div>
                
            </div>
            
		</div>
	</li>
		</ol>

<div id="respond" class="comment-respond">
		<h3 id="reply-title" class="comment-reply-title">Leave a Comment <small><a rel="nofollow" id="cancel-comment-reply-link" href="/add-comment-box-to-each-product-in-magento-cart/#respond" style="display:none;">Cancel reply</a></small></h3><form action="https://magentoworks.net/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate><p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message">Required fields are marked <span class="required">*</span></span></p> <div class="row group-space"><div class="form-group"><div class="col-md-12"><label for="comment">Comment</label><textarea class="form-control" rows="10" id="comment" name="comment" aria-required="true">

Add comment box to each product in Magento Cart

Recent Posts

Recent Comments

Portfolio