Questions tagged [sales-order]
Denotes questions related to Magento Sales module's order functionality.
1
vote
1answer
15 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
17 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()->...
1
vote
1answer
30 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
52 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
0answers
7 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
63 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.
0
votes
1answer
34 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
39 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
19 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 ...
1
vote
1answer
14 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
33 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
0answers
25 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
0answers
16 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
21 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
26 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
19 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
33 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 ...
0
votes
1answer
16 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 ...
1
vote
1answer
25 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
20 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
21 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
29 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
8 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
28 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
17 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 > ...
2
votes
2answers
52 views
Magento 2.2 - Get product attribute value in order detail Admin
How to show product attribute value in order detail in Magento 2.2.6?
I already tried below code but not working:
File Path:
public_html/vendor/magento/module-sales/view/adminhtml/templates/items/...
0
votes
0answers
6 views
Order Totals Block Missing in admin and customer portal Magento1.9.2.4
When I view orders in admin and customer portal the totals section is not displaying in the table footer section.
The same issue with invoice and credit memo in the customer portal and admin panel.
...
0
votes
2answers
44 views
Where is “status” located in the database from Magento 2 order grid
I want to change all the orders that are in the status of "Processing" to "Complete" state.
I managed to find this in the sales_order table and set the state and status to complete. This worked fine ...
0
votes
0answers
10 views
How can we retain the invoice number same as previous when we update order details in magento?
We have Magento 2.2.6 version and installed mageworx order edit extension on top of it.
We are trying to implement the logic to retain invoice number even if we update the order details.
0
votes
0answers
9 views
How to merge multiple order and create new one order in magento 2?
try {
$store=$this->_storeManager->getStore();
$websiteId = $this->_storeManager->getStore()->getWebsiteId();
$customer=$this->customerFactory->...
0
votes
1answer
20 views
Fetching order details but items and extension_attributes array are empty
public function execute()
{
$order=$this->orderFactory->load(1);
$orderItems = $order->getAllItems();
foreach ($orderItems as $item) {
//echo $item->getProductId();
...
0
votes
1answer
17 views
Magento 2 - can't change the zip code in order
I have a very strange issue in Magento 2 orders. In some orders the first number in the zip code is removed automatically. For example 07716 will be 7716. So the zero was dropped.
I try to edit the ...
3
votes
0answers
22 views
How to hold an order right after the payment was received
We have orders that have to be approved by another party after ordering and receiving the payment.
So I want to set it onHold after payment and unHold it via an API call I have to implement as well.
...
0
votes
1answer
52 views
Magento 2.3: Add Attachment with email (Magento 2.3 use zendframework 2)
I am working on a module in which I need to attach an attachment with sales email. However, Magento 2.3 use zendframework2 so email attachment is not the same as zendframework1 (in Magento 2.2).
Can ...
1
vote
2answers
36 views
Get salesrule id from order id in Magento 2
How to get salesrule id from order id,for example:
public function getSalesruleIdByOrderId($orderId){
//???
}
0
votes
0answers
11 views
How to set Billingaddress during sales_order_place_before programmatically
I need all orders to have the same billing address (its because the store is used company internal) but the shipping address may vary. My thought was to set the Billing Address programatically during ...
0
votes
0answers
24 views
How to update Sale Order Status in custom database Magento 2
I am taking an order from an observer. its current order status "pending" is displaying in my custom table but after the invoice is done.... the order status "processing" is not changed in my database ...
0
votes
1answer
60 views
Magento 2 : How to get order collection group by customer?
To get order collection by customer wise i.e.., customer A and customer B have placed order and it should retrieve by customer wise per collection?
public function getOrdersByCustomer() {
$...
0
votes
0answers
26 views
Custom order number during manual order entry
We need to be able to make a custom order number during manual order entry. Instead of auto-assigning, we would like a field to enter order 13455 (for example) and Magento accept it as the order ...
0
votes
1answer
16 views
Add Date filter in object-manager
I have Code for getting all order But I want date filter in Object-manager. How Can I add date filter in it. I tried but I got Blank array.
I am using Object manager in the script so I am suitable ...
0
votes
2answers
51 views
How to remove/hide columns from sales grid by default
How can I remove or hide some of the columns from sales_order_grid. For example I want to hide next columns:
Purchase point
Ship to Name
Signifyd Guarantee Decision
I tried with overriding ...
0
votes
1answer
49 views
add username to order comment history
I wanna show the username who commented on order history
my question is like below question
https://stackoverflow.com/questions/6219620/add-username-to-order-comment-history
but it is for Magento 1....
0
votes
0answers
15 views
How to show Gift Message on Order Invoice Pdf Magento 2?
I am trying to display Gift Message on Order Invoice Pdf if order
customers are applying Gift Message While placing order Magento 2. If
anyone have idea please guide me.
1
vote
0answers
24 views
Magento 1 - How to exclude column data from export csv file?
I want to exclude Email and Billing Telephone columns data from orders export csv file for specific user. I am using Rave Infosys Order Import / Export extension.
These columns data should be empty ...
1
vote
0answers
29 views
Magento 2 How to send HTML in Order Comment Section of Transactional E-Mails
I am trying to send HTML structure in order comment section, but in email it convert in simple plain text. any idea?
Comment:
Hello, <a href="example.com">Click Here</a>
Current ...
1
vote
0answers
14 views
How to add Backorder in Customer account dashboard in magento 2.1?
I want to display backorder if any sku have backorder list.
See below screenshot:
For ITP7 SKU :
ordered :1
shipped : 1
backordered : 0
For ITP1 SKU :
ordered :1
shipped : 0
backordered : 1
0
votes
0answers
24 views
Auto selected shipping method in magento2
I want to show auto selected shipping method based on order subtotal.
So customer need not to manually select it.
2
votes
1answer
249 views
Show order comment history on invoice
I'm trying to show the order comments history on the invoice (Magento 2.2.6)
I've written the following override:
app/code/Denial/InvoiceComments/etc/di.xml
<?xml version="1.0"?>
<config ...
0
votes
1answer
28 views
How to render HTML entities in the wishlist sidebar
I have added the © symbol to product names in Magento 2. These all appear fine on the category and product pages, however when I add an item to my wishlist the product name appears with the text &...
0
votes
0answers
16 views
Magento1.9 shipping method must be specified when admin edit orders
I am trying to edit order in the admin section when showing "Shipping method must be specified." enter image description here
