Questions tagged [order-items]
Denotes questions related to sales order items.
30
questions
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
126 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(...
2
votes
2answers
61 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
1answer
81 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) {
...
0
votes
0answers
29 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
1answer
47 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
150 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 ...
2
votes
3answers
172 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-&...
3
votes
1answer
170 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?
1
vote
1answer
267 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\...
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.
1
vote
1answer
241 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 ...
0
votes
0answers
23 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
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 ...
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 ...
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 ...
1
vote
0answers
368 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 ...
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 ...
2
votes
1answer
450 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?
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 ...
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 $...
1
vote
0answers
65 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....
2
votes
2answers
343 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,
...
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)
{"...
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 ...
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
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 ...
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\...
4
votes
1answer
324 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:...
