StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11689489
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-07-27T14:08:11.053
FavoriteCount
0
LastActivityDate
2012-07-27T14:08:11.053
LastEditDate
LastEditorUserId
0
OwnerUserId
465971
ParentId
11687630
PostTypeId
2
Score
18
ViewCount
0
LastEditorDisplayName
text
Body
It depends on the purpose of your customization. Order Item has custom options stored as serialized array and at any time it is possible for your to modify it. Unlike quote item, in order item it has different name for retrieving them. The method is called <code>getProductOptions()</code> Also there is another method that allows you to set them <code>setProductOptions(array $options)</code>. Here is some examples of this method usage in different test cases: <ol> <li>If you need to store it only for internal code usage, you can just add option into array array and set it back: <pre><code>$existentOptions = $orderItem->getProductOptions(); $existentOptions['your_custom_option'] = $yourCustomValue; $orderItem->setProductOptions($existentOptions); </code></pre></li> <li>If you need to show your custom option in the printed document, you need to add your custom option into special option of options, that have structure for showing up its value on the frontend, pdf documents, items list <pre><code>$existentOptions = $orderItem->getProductOptions(); if (!isset($existentOptions['additional_options'])) { // If special options of options array is set before, create it. $existentOptions['additional_options'] = array(); } // Adding visible options value $existentOptions['additional_options'][] = array( 'label' => 'Your Option Label', 'value' => 'Your Option Value', // The last one that is optional (if not set, value is used) 'print_value' => 'Your Option Value shown in printed documents' ); $orderItem->setProductOptions($existentOptions); </code></pre></li> </ol> Both of these methods even can be combined, if you need one option that is visible to customer and another option that is required for your code. Also don't forget to save your order/order item after you deed your modifications. Advice If you save order and haven't modified the order model itself, you need at least change some data in it, to force order model save all sub entities. For making this possible, you even can just set some non existent attribute. Case when save operation will not be invoked: <pre><code>$order->load($id); $orderItem->getItemById($itemId); $orderItem->setSomething(111); $order->save(); // Order Item will not be saved!! </code></pre> Case when save operation will be invoked: <pre><code>$order->load($id); $orderItem->getItemById($itemId); $orderItem->setSomething(111); $order->setSomeNonExistentProperty(true); $order->save(); // Now it will be saved </code></pre> Have fun with Magento development
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHowto update order item's custom option in Magento?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USIvan Chepurnyi
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. This table or related slice is empty.

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.