Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [sales-order-item]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
300 views

Why is the configurable product sometimes in sales_order_item?

we are having a problem with some reportings. The "problem" is, that Magento sometimes stores the configurable product along with the actual variant in sales_order_item. +--------------+-----...
Luco's user avatar
  • 23
0 votes
1 answer
282 views

what is the use of qty_invoiced column in sales_order_item table?

I want to know that what is the use qty_invoiced column in the sales_order_item table in Magento 2.
Yasir Minhaj's user avatar
0 votes
1 answer
70 views

How do I get sale_order_item table data by using injection method?

I am trying to use the itemFactory to get last 30 minutes (updated_at) data from sales_order_item table , but not success. Anyone can hep to verify where I did wrong? use Magento\Sales\Model\Order\...
Paul Fan's user avatar
  • 658
2 votes
3 answers
5k views

Magento 2 how add extension attribute to order item

I need to save the extension attribute for Order item. I have tried using plugin with below code, but it is not working for me. I have placed a log inside the method but the method is not working. <...
Antony's user avatar
  • 63
1 vote
0 answers
208 views

To Show catalog price rule id applied on products in order API response

I have created a custom field named catalog_price_rule_id in sales_order_item. Now i need to get the catalog price rule applied on that orderitem; then i need to store that into the custom field and ...
Pankaj Sharma's user avatar
1 vote
0 answers
142 views

how to add a value to new column created by my module in the table 'sales_order_item'

How I can add a value to new column created by my module in the table 'sales_order_item'? I have a problem, could you help me ? I explain : In the Magento table, 'eav attribute set', the 'attribute ...
learner's user avatar
  • 21
0 votes
1 answer
350 views

how to find my new product's attribute into the MySql's table "sales_order_item" (magento2.5)

I have created a 'New Attribute' into the Product Attributes [/admin/catalog/product_attribute/] for products : [specificity_trait_type]. And then, I added this attribute into the my products [/admin/...
learner's user avatar
  • 21
1 vote
2 answers
303 views

Can't copy data from quote_item to sales_order_item

I have a custom value (In a Magento 2.3.3 installation )that gets added to the quote_item table when I add an item to the basket. When I go to checkout I want to pass that value to the same-named ...
Martin Peasley's user avatar
0 votes
2 answers
4k views

Magento 2 Get Value of Custom Attribute on Magento 2 Rest API V1/orders/items

I am trying to get the Custom Attribute I have in the sales_order_item to display on the rest/V1/orders/items API call. I was able to get the Attribute to display on the rest/V1/orders API call. Using ...
Kenny M's user avatar
0 votes
1 answer
152 views

Add custom attributes with product quotation and save in product orders

Add custom attributes (i.e hire start date & hire end date in below picture) with product quotation and save in product orders items details. I want these attributes should be visible on checkout ...
Ghulam Akbar's user avatar
0 votes
2 answers
298 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?
Jack Brooks's user avatar
0 votes
3 answers
2k views

custom "sales_order_item" attribute to API response

I followed this guide to add a custom product attribute to quote and sales order item throughout the order process and this works fine. My custom attribute is added to the sales_order_item table ...
JohnRP's user avatar
  • 1
0 votes
0 answers
76 views

Get custom attribute from product in ToOrderItem convert method

I'm implementing a plugin for Magento\Quote\Model\Quote\Item\ToOrderItem public function aroundConvert(\Magento\Quote\Model\Quote\Item\ToOrderItem $subject, \Closure $proceed, \...
user3109848's user avatar
2 votes
2 answers
445 views

Magento2 How to get customer group from sales order item collection

I want to get customer group from sales order item collection. How do i get that? In Magento 1 it is like this $customer_group = Mage::getModel('customer/group')->load($order->...
Smita Kagwade's user avatar
2 votes
1 answer
3k views

How to update sales_order_item in Magento 2.3 using order_id(entity_id)?

In Magento 2, we can update an order data (a data in sales_order) using Magento Sales OrderRepository . My questions is: How we can update the sales_order_item data (the qty_invoiced and ...
fmsthird's user avatar
  • 4,592