We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [order-items]

Denotes questions related to sales order items.

Filter by
Sorted by
Tagged with
5
votes
2answers
1k views

How to add new item (product) into existing order programmatically in Magento 2

I have created one virtual product in my Magento2 website. Now, I want to add it programmatically to the existing customer orders on some occasions with its custom price and name. Can someone please ...
4
votes
1answer
319 views

Cannot cancel order in Magento 1

I have an order with processing status and its invoice is canceled. When I use the order->canCancel() function, It returns me false. I checked the core and this is the part why I am getting false:...
3
votes
2answers
289 views

Order Items Collection in Order Detail Page

This snapshot of order detail page. I Just want to known that which file or function call for setting this collection in this page. I want to just get Selected (Filter Row) Items Order.
3
votes
1answer
167 views

How get row from sales_order_item table by item_id in Magento 2?

How get specific row from sales_order_item by giving item_id? Which collection use to filter row? Can anyone guide me ? has any direct or indirect way to fetch sales_order_item record from item_id?
3
votes
1answer
1k views

Magento 2 change order item price

I have an order which has the grand total that I need to fix because one of my products prices is incorrect, to do that I need to change the order item price and recollect order total, is there a way ...
2
votes
1answer
78 views

Magento 2 - After invoice delete programatically can't create new invoice properly

I have used the code if ($order->getInvoiceCollection()->count()) { $_invoices = $order->getInvoiceCollection(); if ($_invoices) { foreach ($_invoices as $invoice) { ...
2
votes
2answers
59 views

How to edit or update the ordered item data in magento 2

I want to edit some data's of ordered items like weight, price and some more. For that, I got the ordered item collection for the specific order. $objectManager = \Magento\Framework\App\...
2
votes
3answers
164 views

How to add custom attribute in Collection?

namespace Magento\Sales\Model\Order; class Invoice { public function getAllItems() { $items = []; foreach ($this->getItemsCollection() as $item) { if (!$item-&...
2
votes
1answer
447 views

How to display tax details at item lines in invoice?

I browsed the tables and discovered that tax rates, codes, etc are saved at order level. How can I display tax summary having tax code, rate, etc at each item line in invoices generated from backend?
2
votes
1answer
174 views

How to get category Id from order Item?

I want to get category Id from order Item. As we aware that we can get current_category on the product page. but how to get that category from orderItem object. We can get Product object via $...
2
votes
2answers
333 views

Create Admin grid from join table collection

I'm new to magento 2, I have a query to join multiple table, only 1 custom table I've made and the rest is from Magento 2, the query looks like this: SELECT marketplace_orders.entity_id as id, ...
1
vote
2answers
1k views

How to get the ordered size of a product In Magento 2

I tried to get the size of a product/products that was ordered. So let's say a product has 5 sizes: S, M, L, XL,XLL and when i made the order the product x was bought with the size M. When i load ...
1
vote
1answer
247 views

How get order items using entity_id

This File responsible for setting Grand Total in Order Grid. I test it. <?php /** * Copyright © Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ namespace Magento\...
1
vote
1answer
229 views

Magento 2 get order item actual price

In Magento 2, how can I get order item actual price? I tried using below way but it returns 0, although the code is working with Magento 1.9 use Magento\Framework\Event\ObserverInterface; class ...
1
vote
3answers
2k views

Magento 2 - Getting an order item tax percentage

I need to get an order item tax percentage <?php namespace Company\Module\Plugin; class myClass { protected $_orderRepository; public function __construct( \Magento\Sales\Api\...
1
vote
0answers
366 views

Order item extension attributes are always last database entry

I have added extension attributes to order items, and values are successfully saved to table, when I get an order from rest API, extension attributes always show the value of last order item row for ...
1
vote
0answers
64 views

Magento 2 - passing variable output to another variable in email template

I'm working on order confirmation email and I want to pass variable output: {{var order.getMyCustomItem().getSomething('key')}} To another variable. In my case it's an order model: {{var order....
0
votes
1answer
45 views

Getting all products of orders of last 24 hours in magento 1 in a large database

I have a third party module in my magento 1 which is fetching products like this: $products = Mage::getModel('catalog/product')->getCollection(); So I want to replace it with selective products which ...
0
votes
2answers
135 views

How to add item status for an order in magento 2

I have multiple items in my order. How can I add item status and its tracking information for that order in My Account Orders? I am using this to get orders $_orders = $block->getOrders(); And ...
0
votes
1answer
39 views

What is the role of visibility filter in colections Magento 2?

I am getting Order Items, from order collection by Order ID but as from the attached screen shot (Order 15) I am getting one product data two times. Can any body explain the reason and what will be ...
0
votes
2answers
2k views

SOLVED - Magento 2 Get product_options value from sales_order_item

In sales_order_item table, there's a column product_options to store some custom values. I need to get the deliverydates from the following value (value from the db column product_options) {"...
0
votes
1answer
1k views

How to get child simple Product Obj from configurable Sales Order Items

I want to get Configurable child simple products from order items.How can I get child simple Product from the configurable product? I want to fetch only simple product object which associated with ...
0
votes
0answers
21 views

Magento 2 help validate function to count bundle product child items of an order

I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped. The tricky part is, magento formats line items ...
0
votes
1answer
107 views

How to get discount amount in Magento 2

I am trying to get discount amount, but no success How to get discount amount from $block->getShipment() <?php /** @var $_item \Magento\Sales\Model\Order\Item */ $_item = $block->getItem(...
0
votes
0answers
28 views

How to get bundle options qty ? Magento 2

How to get bundle product options qty from $order->getAllVisibleItems() ?
0
votes
0answers
18 views

Magento 2 : Display Ordered Items listing in customer account

In Magento 2 customer account I have to add a new tab and when customer visits it then on that page have to display a list of all items from all orders of customers. It will be grids of ordered items. ...
0
votes
0answers
22 views

Override row.phtml and unit.phtml in backend magento_wee module

I would like to override the item ordered tab in BO to delete tax and every think related to price in this tab any help please
0
votes
0answers
122 views

Random missing product name in random orders

On rare and random occasions (once or twice a month) our client receives an order with one missing product name in the items list (see attached screenshot) - however the product name exists and is ...
0
votes
0answers
38 views

Magento 2 : Get Items Ordered in Email Template

I'm looking to achieve a product grid of items ordered in an email template upon successful product. This is what I'm trying to achieve, in this exact order for each product. Is this doable? I can't ...
0
votes
1answer
195 views

how to cancel certain order item rather than cancel whole order?

I need a function which is order cancel based on the item. Current scenario is that Magento does cancel whole order. What I want: A customer placed 2 ordered items. And after placed order, customer ...