A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [sales-order]

Denotes questions related to Magento Sales module's order functionality.

Filter by
Sorted by
Tagged with
2
votes
1answer
498 views

How to create duplicate new quote from old order quote Magento 1.7?

I want to create a new order programmatically by copying an existing order's quote. Here is what I have tried: <?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); ...
1
vote
0answers
134 views

Sales orders not showing for new Admin user in magento2

I have created new User here System -> Permission Assigned User Role as Administrator But when logged in with the new user which i created now, I can't see the orders for the newly created admin ...
1
vote
0answers
50 views

cancel an order customer did not receive an email

I like to send an email to customer if admin cancel an order. Please help to solve the solution. Thank you.
2
votes
1answer
27 views

How to hide item with qty 0 after shipment created

I just very curiously how magento can process this . Default when create shipment with set item qty to zero. It's will not visible in shipment But i can't find file to process this Can anyone show me ...
1
vote
0answers
76 views

Magento 2.2.5 Override sales order item block not working

We are working on Magento 2.2.5, override the \Magento\Sales\Block\Order\Items class method _prepareLayout but it is not working showing error. File : etc\module.xml <?xml version="1.0" ?> <...
1
vote
1answer
28 views

Magento 1 - Predict Order Id Before creating the order

I have a use-case where I need to know the order id from Magento before completing the order. The idea is that I essentially call an API and if the API call is successful, then I proceed to complete ...
0
votes
1answer
393 views

Information Changes have been made to this section that have not been saved. This tab contains invalid data. Please resolve this before saving

I am getting below error on order view page in magento 2, what is the reason for this error. Information Changes have been made to this section that have not been saved. This tab contains invalid ...
0
votes
0answers
47 views

Cancel order item without cancelling order in magento 2

How to cancel order item without cancelling order in magento 2? Is it possible
0
votes
1answer
117 views

how to update Items Ordered order qty in magento 1

how to update order Items qty in admin panel? (magento 1.9)
1
vote
2answers
605 views

Magento2 : Add sales_order column coupon_code in sales order grid

In sales_order table we have a column coupon_code. I need to show it in sales order grid. I have added the column coupon code by overriding sales_order_grid.xml file. The column is being shown. Now I ...
1
vote
1answer
115 views

Magento 1.9 - Customer placed the order successfully but its not in the Magento Admin Panel

I am facing a very serious issue with Magento 1.9 website. This has happened a couple of times. Customer places the order, they even get an email confirming the order but the order does not show in ...
1
vote
1answer
92 views

My Account dashboard orders (Magento 2)

I am currently showing all my orders in My Account dashboard. The problem only 5 orders are shown when I fetch all orders. $_orders = $block->getOrders(); but I have 29 orders in the database, it ...
3
votes
3answers
503 views

Magento2 Check Order Was Created by Admin or Customer?

I want to check whether an order is created by an Admin or by the customer.
2
votes
1answer
406 views

Magento Recommended way to add comment to order

I am looking for the Magento recommended best practice for adding a comment to an order. I can easily accomplish this using things such as $order->addCommentToStatusHistory($message)->save() and ...
1
vote
2answers
132 views

Magento1.9 Product SKU in Sales order grid

i have use default collection and change this file /app/code/core/Mage/Adminhtml/Block/Sales/Order/grid.php Now replace your _prepareCollection() function to this following code protected ...
1
vote
1answer
31 views

How to get coupan code(Promotion code) amount for an order (Magento 2)

I am getting the coupon code(promotional code) for an order For a coupon code, I am using this $order->getCouponCode(); How to get the coupon code discounted price so I can show it to the user. ...
1
vote
0answers
168 views

Missing Rows In Sales Order Grid

I have an interesting issue. Admin sales order grid does not show all records in sales_order_grid table. I tried several solutions. For example, I activated async grid generation on admin panel, ...
0
votes
1answer
297 views

Magento 2.2 - Add link to product (front end) within a custom column in sales order view items list?

I would like to add a column after "Product" to have a link to the product on the front end so it is easy to identify the product. Nearly all our products are one off items so I'm looking for an easy ...
2
votes
2answers
593 views

Order Status Processing after Shipment and Generate Invoice also Invoice status showing pending in Magento2

Shipment completed and generate invoice but order status showing Processing and invoice is in pending. Also invoice showing a Capture button. why? Anyone Know?
2
votes
2answers
202 views

Magento2 filter not working for request parameter for order grid

I want to filter Sales Order query based on request parameter passed in querystring like following: http://127.0.0.1/website/admin/sales/order/index/key/...
2
votes
1answer
96 views

Can't change customers groupId in observer

I try to change the customers group id in the observer sales_order_place_after but it seems to be impossible. I successfully managed to change the firstname of the customer just for test, but groupId ?...
1
vote
1answer
92 views

Get total in observer sales_order_place_before

I try to get the total value (price of his order) of the customer in the sales_order_place_before event. How can I read the total value? This is a part of my observer, it is getting called, I only ...
2
votes
1answer
34 views

change email template before sending email

Guys am trying to modifying variables used in email templates, like store name, store email for every email. How can we do this good manner? Add plugin on \Magento\Framework\Mail\TransportInterface ...
2
votes
1answer
114 views

What is different between subtotal and subtotal_invoiced

Sometimes I have seen in order in the sales_flat_orders table that have a subtotal but have no subtotal_invoiced. What is different between them? Here is a sample row extracted from sales_flat_orders ...
2
votes
1answer
349 views

How custom attribute of “sales_order_item” table will be save also in “sales_order”

I am using plugin for converting "quote_item" to "sales_order_item" from below give code it work. public function aroundConvert( \Magento\Quote\Model\Quote\Item\ToOrderItem $subject, \...
1
vote
1answer
282 views

Magento 2.2.3 - Full text filter not working for sales order grid

The full-text search filter is not working for sales order grid. Other filters are working correctly for sales order grid.
1
vote
2answers
420 views

How to get order collection filter with customer_is_guest and email (Magento 2)

How to get order id from collection with filter customer_is_guest = 1 and customer email $order_collection = $objectManager->create('Magento\Sales\Model\Order')->getCollection()->...
2
votes
1answer
138 views

Getting order id for guest checkout order

I need to assign a Guest Order to a Customer, so i found this link How to assign a Guest Order to a Customer - Magento 2 Using SQL UPDATE sales_order SET customer_id = {YOUR CUSTOMER ID}, ...
1
vote
2answers
909 views

Get all orders of customer by email id Magento 2

How can I get all orders of a customer via his/her email id who is logged in, I am using current session to get user's email id public function getCustomerData() { if ($this->_customerSession-&...
1
vote
1answer
67 views

Magento 2 Main Configurable Products Duplicated in Order Info When Configurations are Ordered

In our Magento 2.2.7 store we have a number of Configurable Items, they are one Main item with a number of individual items as configurations. When a customer orders them, they strangely appear as ...
3
votes
1answer
328 views

Magento 2 - How to add admin username in order comments on admin action

I need to add admin username in order comment history whenever I create invoice shipment and On Cancel order.
1
vote
1answer
384 views

Get all order details from getItems() / getAllItems() / getAllVisibleItems()

I am trying to get all the order data. So I came across these three different types of methods to get items from an order getItems() getAllItems() getAllVisibleItems() I tried the first two getItems(...
1
vote
0answers
87 views

Magento 2 admin panel throw error

Order saving error: Public hash should be defined I am go to magento 2 admin panel and sales and go throw places order this error is coming how to slove it?
0
votes
1answer
311 views

HOW TO ADD COLUMN TO 'Order Total Report' GRID and display custom customer data to new column in magento 2?

There are so many post discussing how to add column to sales order grid, but no one discussed about HOW TO ADD COLUMN TO Order Total Report GRID (REPORTS > Customers > Order Total) and display ...
2
votes
1answer
260 views

How to get applied coupon code amount in the order collection in magento2

I have applied a coupon code and placed an order.I need that coupon code amount that has been applied from the order collection. Thanks in advance. I got the coupon with this piece of line $order-&...
0
votes
1answer
102 views

What is the best method to retrieve a SINGLE ITEM order details in Magento2?

I am currently using the \Magento\Sales\Model\OrderFactory $_orderFactory and loadByIncrementId($id) in my custom block and calling it in my .phtml file. I get basic details of the order, but I ...
0
votes
1answer
50 views

In Magento 2 will new sales overwrite migrated sales orders?

I'm currently migrating an existing Magento 1 site to Magento 2 and I wondered how the sales number would behave after migrating data. We’ve migrated all of our existing sales data from our Magento 1 ...
3
votes
1answer
162 views

Magento 2 : Item order details not showing after migration for old records

I have migrate magento1 to magento 2.2.5, after migration in old order records item details are not showing in backend. In database all details are available but still item not showing in backend ...
0
votes
0answers
59 views

Magento 2 order email confirmation display backorder information

Hope someone could help me with this. I have backorder enable on my website and I would like to add a backorder notifacation to the order email that displays the items that is backordered and the ...
0
votes
1answer
47 views

How to get refunded and canceled orders in one grid

How can I Get Refunded Orders And Canceled Orders ( Without invoice being generated ) in one grid and apply date filter on which the refund/canceled orders will be generated ?
0
votes
1answer
790 views

Sending order confirmation email template in Magento 2

I am trying to send an order email confirmation with adding extra attributes values to Admin, But it's not working for me. Here I have 2 Email templates. 1) It's a default email template 2) ...
0
votes
1answer
42 views

Please confirm returns logic

I'm very new on Magento 2 framework. Can anyone help me from this problem? I Don't know how it actually product returns work. Is there any standard Magento logic for returns or can you advise on ...
2
votes
1answer
91 views

Magento 2 $this->checkoutSession->getLastRealOrder() and $this->checkoutSession->getLastRealOrderId() returning null

$this->checkoutSession->getLastRealOrder() $this->checkoutSession->getLastRealOrderId() returning null after payment gateway redirect. Strange thing is that it is working some time and ...
3
votes
1answer
102 views

Mass Action: Bulk invoice - Shipping charges issue

I have created mass action in order grid to create bulk invoice. And after successfully creating invoice on multiple orders I am facing issue with shipping charges. i.e, for first order it is adding ...
0
votes
0answers
144 views

Problem in Creating Custom Order Programmatically

I need to create a custom order programmatically to be used with a subscription program. How can I call to this createCustomOrder function in the helper file when Renew Subscription button is ...
0
votes
0answers
131 views

Received orders with a duplicate order ids

We have received 2 orders with the same order id. Like We have 2 orders with the following order Ids: 000001256 000001256 How is this possible? Does anyone has faced this type of issue OR any idea ...
0
votes
1answer
131 views

Create public function for updating sales_order data Magento2.3

Help, please! I'm using Magento 2.3 and I am trying to update sales_order table data programmatically. What's the best way to implement it?
0
votes
0answers
46 views

How to send a purchase email to the suppliers manually by clicking a button on order detail page in Magento 2?

After creating an invoice for the order, I want to able to send a purchase email to the related suppliers manually by clicking a button for each supplier on order detail page. The order may include ...
1
vote
1answer
670 views

Admin>Sales>Orders list not showing

I'm using Magento 2.3. How can I fix Admin>Sales>Orders? The list is not showing. I have orders but it's not showing. Please help!!
0
votes
0answers
25 views

Changed order number, but storeview gets wrong number

I changed my order number with a prefix for all my store views. For example, i have the following construction: Web Site 1 > Store 1 > Store view 1 Web Site 1 > Store 1 > Store view 2 Web Site 2 > ...