StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9344336
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2012-02-18T21:41:39.933
FavoriteCount
0
LastActivityDate
2012-02-18T21:41:39.933
LastEditDate
LastEditorUserId
0
OwnerUserId
485589
ParentId
9334115
PostTypeId
2
Score
29
ViewCount
0
LastEditorDisplayName
text
Body
The custom options are only stored on the quote as option ID's and values. Every time the options are rendered, they are basically reloaded from the database. If you modify the values, you would need to save them, and that would set them for everybody. That said, I work around the issue by adding an additional custom option with the modified value on the fly, using an event observer. For this I use additional options. Then I remove the original custom option from the quote item. Up to 1.4 Magento took care of the rest, but since then you need to copy the additional options to the order item manually, and also need to take care it's set again if an item is reordered. So here is an example observer configuration. <pre><code><frontend> <events> <checkout_cart_product_add_after> <observers> <customoptions> <type>singleton</type> <class>customoptions/observer</class> <method>checkoutCartProductAddAfter</method> </customoptions> </observers> </checkout_cart_product_add_after> <sales_convert_quote_item_to_order_item> <observers> <customoptions> <type>singleton</type> <class>customoptions/observer</class> <method>salesConvertQuoteItemToOrderItem</method> </customoptions> </observers> </sales_convert_quote_item_to_order_item> </events> </frontend> </code></pre> The rest is handled in the observer class. <pre><code>/** * Add additional options to order item product options (this is missing in the core) * * @param Varien_Event_Observer $observer */ public function salesConvertQuoteItemToOrderItem(Varien_Event_Observer $observer) { $quoteItem = $observer->getItem(); if ($additionalOptions = $quoteItem->getOptionByCode('additional_options')) { $orderItem = $observer->getOrderItem(); $options = $orderItem->getProductOptions(); $options['additional_options'] = unserialize($additionalOptions->getValue()); $orderItem->setProductOptions($options); } } /** * Manipulate the custom product options * * @param Varien_Event_Observer $observer * @return void */ public function checkoutCartProductAddAfter(Varien_Event_Observer $observer) { $item = $observer->getQuoteItem(); $infoArr = array(); if ($info = $item->getProduct()->getCustomOption('info_buyRequest')) { $infoArr = unserialize($info->getValue()); } // Set additional options in case of a reorder if ($infoArr && isset($infoArr['additional_options'])) { // An additional options array is set on the buy request - this is a reorder $item->addOption(array( 'code' => 'additional_options', 'value' => serialize($infoArr['additional_options']) )); return; } $options = Mage::helper('catalog/product_configuration')->getCustomOptions($item); foreach ($options as $option) { // The only way to identify a custom option without // hardcoding ID's is the label :-( // But manipulating options this way is hackish anyway if ('Size' === $option['label']) { $optId = $option['option_id']; // Add replacement custom option with modified value $additionalOptions = array(array( 'code' => 'my_code', 'label' => $option['label'], 'value' => $option['value'] . ' YOUR EXTRA TEXT', 'print_value' => $option['print_value'] . ' YOUR EXTRA TEXT', )); $item->addOption(array( 'code' => 'additional_options', 'value' => serialize($additionalOptions), )); // Update info_buyRequest to reflect changes if ($infoArr && isset($infoArr['options']) && isset($infoArr['options'][$optId])) { // Remove real custom option unset($infoArr['options'][$optId]); // Add replacement additional option for reorder (see above) $infoArr['additional_options'] = $additionalOptions; $info->setValue(serialize($infoArr)); $item->addOption($info); } // Remove real custom option id from option_ids list if ($optionIdsOption = $item->getProduct()->getCustomOption('option_ids')) { $optionIds = explode(',', $optionIdsOption->getValue()); if (false !== ($idx = array_search($optId, $optionIds))) { unset($optionIds[$idx]); $optionIdsOption->setValue(implode(',', $optionIds)); $item->addOption($optionIdsOption); } } // Remove real custom option $item->removeOption('option_' . $optId); } } </code></pre> This is it in a nutshell. Add error checking and taking care of special cases like adding the same product to the cart again as needed. Hope this gets you started working with custom product options. Not half bad once you get familiar with them.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMagento change Custom Option value before adding it to cart
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USVinai
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
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThank you Vinai for the help. I will try this.
 singulars
 PostPostId
 PO
 UserUserId
 USFarrukh
2. COHere is another answer based on this approach with a little different twist and more detail: http://stackoverflow.com/a/9496266/485589
 singulars
 PostPostId
 PO
 UserUserId
 USVinai

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.