StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12129056
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-08-26T09:37:26.200
FavoriteCount
0
LastActivityDate
2012-08-26T09:42:51.067
LastEditDate
2012-08-26T09:42:51.067
LastEditorUserId
1613360
OwnerUserId
1613360
ParentId
12129017
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
In your theme, for the file: template/checkout/cart.phtml Add the new heading along with other heading for cart items. <pre><code>1 <th><?php echo $this->__('Comments') ?></th> In the file: template/checkout/cart/item/default.phtml </code></pre> Add a new column <pre><code>1 <td class="a-center"> 2 <textarea name="cart[<?php echo $_item->getId() ?>][comments]" rows="3" cols="20"><?php echo $_item->getItemcomment() ?></textarea> 3 </td> </code></pre> For Older version of Magento it would be: <pre><code>1 <td class="a-center"> 2 <textarea name="cart[<?php echo $_item->getId() ?>][comments]" rows="3" cols="20"><?php echo $this->getItemItemcomment($_item) ?></textarea> 3 </td> </code></pre> The next step is to save the comment in DB, when customer update the cart. So add a new field ‘itemcomment’ in the tabel ‘sales_flat_quote_item’. (For older version of Magento the table would be ‘sales_quote_item’) Now we are going to add the code which will do the DB operation. For this we will need to modify the file: app/code/core/Mage/Checkout/Model/Cart.php (Note: If you are planning to upgrade your Magento setup, copy this file to local & modify.) Here we need to add some code to the function updateItems(), such a way that the function should now look like below: <pre><code>01 public function updateItems($data) 02 { 03 Mage::dispatchEvent('checkout_cart_update_items_before', array('cart'=>$this, 'info'=>$data)); 04 05 foreach ($data as $itemId => $itemInfo) { 06 07 $item = $this->getQuote()->getItemById($itemId); 08 if (!$item) { 09 continue; 10 } 11 12 if (!empty($itemInfo['remove']) || (isset($itemInfo['qty']) && $itemInfo['qty']=='0')) { 13 $this->removeItem($itemId); 14 continue; 15 } 16 17 $qty = isset($itemInfo['qty']) ? (float) $itemInfo['qty'] : false; 18 if ($qty > 0) { 19 $item->setQty($qty); 20 } 21 22 /* Start: Custom code added for comments */ 23 if(!empty($itemInfo['comments'])) { 24 25 $write = Mage::getSingleton('core/resource')->getConnection('core_write'); 26 27 # make the frame_queue active 28 $query = "UPDATE `sales_flat_quote_item` SET itemcomment = '".$itemInfo['comments']."' where item_id = $itemId"; 29 $write->query($query); 30 31 $item->setItemcomment($itemInfo['comments']); 32 } 33 /* End: Custom code added for comments */ 34 35 } 36 37 Mage::dispatchEvent('checkout_cart_update_items_after', array('cart'=>$this, 'info'=>$data)); 38 return $this; 39 } </code></pre> Showing the comment in Admin -> View Order Add a new function getItemcomment() to the file below: app/code/core/Mage/Adminhtml/Block/Sales/Order/View/Items.php If you are on verstion 1.5 or later.. add it to the file below. app/code/core/Mage/Adminhtml/Block/Sales/Order/View/Items.php <pre><code>01 public function getItemcomment($item) { 02 $itemId = $item->getId(); 03 04 $write = Mage::getSingleton('core/resource')->getConnection('core_write'); 05 06 $query = "SELECT q.* FROM `sales_flat_order_item` o 07 LEFT JOIN `sales_flat_quote_item` q on o.quote_item_id = q.item_id 08 WHERE o.item_id = $itemId"; 09 10 # For older versions of Magento 11 /* $query = "SELECT q.* FROM `sales_order_entity_int` o 12 LEFT JOIN `sales_flat_quote_item` q on o.value = q.entity_id 13 WHERE o.entity_id = $itemId AND o.attribute_id = 343"; */ 14 15 $res = $write->query($query); 16 17 while ($row = $res->fetch() ) { 18 if(key_exists('itemcomment',$row)) { 19 echo nl2br($row['itemcomment']); 20 } 21 } 22 } 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: 1 . 2 . 3 <tr class="headings"> 4 <th><?php echo $this->helper('sales')->__('Product') ?></th> 5 <th><?php echo $this->helper('sales')->__('Comments') ?></th> 6 <th><?php echo $this->helper('sales')->__('Item Status') ?></th> 7 . 8 . 9 . 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. view sourceprint? 1 . 2 . 3 <td><?php echo $this->getItemcomment($_item) ?></td>  4 <td class="a-center"><?php echo $_item->getStatus() ?></td> 5 . 6 . </code></pre> Doing upto this will show the comments column in the item table. This will add a text box with the name as comments(change the name ASAP).Hope this helps. Note:This will add a box only if the item is added to cart and as you said the price doesn't change I think this would be more appropriate.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMagento: Add textboxx on product details page for custom size
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USuser1613360
UserOwnerUserId
1. USuser1613360
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COIs it possible to add the same on product details page? As if it is visible only on cart page, then user first add the item to cart and then they will add their ring size details from cart page, which will be 2-step process.
 singulars
 PostPostId
 PO
 UserUserId
 USPrashant
2. COThere is a bug in magento which prevents from making the feature built in or doing so results in error.I have spent more than 2 weeks in researching this but no use believe me.If you find the solution please do share here.I worked as a magento developer in indiaplaza.
 singulars
 PostPostId
 PO
 UserUserId
 USuser1613360

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.