Questions tagged [order-items]
Denotes questions related to sales order items.
40
questions
0
votes
1
answer
86
views
Magento2 product_options field into the sales_order_itmes table
Does anyone know why, sometimes, into the table sales_order_itmes, I see rows that has product_options fields like this:
{
"info_buyRequest": {
"uenc": "...
- 103
0
votes
0
answers
126
views
Magento2 Item order refund programmatically
I'm using Magento 2.4.4 and I would like to understand if this code is correct about the automatic online item refund.
private function createCreditMemoByRma($rma, $order) {
$totalQty = 0;
$...
- 103
0
votes
0
answers
16
views
order_items table contains simple item without prices
I noticed a strange behaviour and I'm not able to understand if this is correct or not.
First of all I would like to specify that I'm not a Magento expert. I started with Magento just now.
On a ...
- 103
0
votes
0
answers
122
views
Not able to add filters on getItemsCollection in admin order page
I am implementing a feature, where I need to filter the order item list in order admin page. I have checked and found the list is getting from method getItemsCollection(). But when I am trying to ...
- 971
0
votes
0
answers
193
views
Split Custom Line Item in magento 2
I need a functionality to split custom line item in magento 2.3.4 .
For example, suppose Product A has custom addon Child A, then by default magento will show like this Product-A-Child-A in sales ...
- 403
1
vote
0
answers
344
views
Magento 2 Item with the same ID "24" already exists error
I don't know what is going on, but everytime I go to Sales > Orders, I see this error message:
Item (Magento\Framework\View\Element\UiComponent\DataProvider\Document) with the same ID "24"...
- 533
1
vote
2
answers
50
views
How to get all items of product purchased in Magento 2?
I would get information on all items of product purchased.
I proceeded by this way but I can not have any information on all items of product purchased :
<?php
namespace MyTestSpace\...
- 21
0
votes
1
answer
959
views
How to delete the order Items from magento using Rest API
I want to delete the order Item form the Successfully placed Order how to delete the order item.Can anyone help to solve this situation.
Thanks in Advance :)
- 328
2
votes
1
answer
598
views
I can't understand difference between quote/quoteitems and order/order Items Magento 2.3
I can't Understand the difference between Order And Quote or Order Items And Quote Items please explain what is it and how it works
- 328
0
votes
2
answers
1k
views
Magento 2 - Override Reorder controller and skip some items from reorder
I have to skip some items when the customer does Reorder. For this, I have overridden the controller Using Plugin.
di.xml
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/...
- 63
0
votes
2
answers
281
views
Magento 2.2.10 is it possible to get all the orders status is pending?
I want to get all the orders where the status is pending.
I want to do a second check where if the item status is cancelled.
Is this possible to do?
- 319
1
vote
0
answers
442
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 ...
- 330
1
vote
1
answer
6k
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(...
- 837
2
votes
2
answers
4k
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\...
- 137
2
votes
1
answer
505
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) {
...
- 9,344
1
vote
0
answers
293
views
How to get bundle options qty ? Magento 2
How to get bundle product options qty from $order->getAllVisibleItems() ?
- 771
1
vote
0
answers
177
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.
...
- 1,484
0
votes
1
answer
554
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 ...
- 517
1
vote
2
answers
2k
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 ...
- 837
2
votes
3
answers
2k
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-&...
- 1,641
3
votes
1
answer
870
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,641
1
vote
1
answer
1k
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,641
3
votes
2
answers
783
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,641
1
vote
1
answer
4k
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
1
answer
63
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 ...
- 1,591
6
votes
2
answers
4k
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 ...
- 1,160
3
votes
1
answer
3k
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 ...
- 772
1
vote
0
answers
417
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
0
answers
189
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 ...
- 103
2
votes
1
answer
1k
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?
- 775
0
votes
0
answers
226
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 ...
- 41
2
votes
1
answer
478
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
0
answers
197
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
2
answers
2k
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,
...
- 419
2
votes
3
answers
9k
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)
{"...
- 2,014
1
vote
2
answers
3k
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 ...
- 2,662
1
vote
1
answer
4k
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 ...
- 928
1
vote
1
answer
643
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 ...
- 928
2
votes
4
answers
5k
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\...
- 2,559
4
votes
1
answer
533
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,903