Questions tagged [sales-order]
Denotes questions related to Magento Sales module's order functionality.
1,248
questions
0
votes
1answer
13 views
How can I store product custom price with tax in an order?
I modified the products price in my custom module. How can I store correctly the product price with tax in the order?
I need to store the net amount and tax amount separately for each product in the ...
0
votes
1answer
38 views
What is best approach to add a Counter in Custom Module
I want to count Order placed after My Module installation that counter can be reset By User and have Custom Starting Value and Steps Bases On Config Value
I am thinking of creating New Config Feild
If ...
1
vote
2answers
27 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.
<...
0
votes
0answers
20 views
not received the site owner emails for the two specific orders
I used Magento 2.3.4, but not received the site owner emails for the two specific orders.
the order has places but I didn't get Order Email, only two specific order,
I have checked all email settings, ...
0
votes
0answers
17 views
Sales Order Custom Option query
I wanted to do a simple MySQL search for the "Custom Options" that customers input when making product purchases but I wasn't sure where to look. Most of what we use is the "Text Field&...
0
votes
0answers
26 views
Magento 2 How to get order id and set custom order attribute after or before order placed
when using these events -
1 - sales_order_place_after
2 - sales_order_save_before
3 - sales_order_place_before
Using these events I am able to set custom order attributes but unable to get order ID ...
0
votes
0answers
8 views
is it possible to get register customer last order attributes values?
Is it possible to get registered customer last order attributes values at the checkout page? the last purchase record with custom attributes values, can be found on the sales_order table.
0
votes
2answers
56 views
How to add payment filter in Order collection factory magento 2.3
I need to add the "po_number" as filter in order collection factory, i am trying to implement this in the sales order history page using getOrders function in the History.php
Full Code :
<...
1
vote
0answers
23 views
how to join custom table in sales order table \Magento\Sales\Model\OrderRepository magento 2
i want to join custom table in repository in magento 2
but i tried
this tutorial (blog)
https://fishchenko.com/blog/magento-2-join-table-in-orderrepositorygetlist-custom-field/
it was not clear
is ...
0
votes
0answers
15 views
Send Order Email Copy To in order not working in magento 2
In Magento 2, Order confirmation Email is successfully sending to the customer. But Send Order Email Copy To is not working. I had given bcc as method. While searching I found that below is the file ...
0
votes
2answers
18 views
Magento 2: Payment methods not showing on admin create order
When creating an order from the admin panel I cannot see payment methods available
However, in the fronted, customers can see the available payment methods, which are CHECK / MONEY ORDER and ...
1
vote
1answer
19 views
Magento 2: Make sales without stock
I need to allow the customer to compare the product even if there is no stock, in fact I need my simple item to behave when out of stock as if it were normally available.
What would be the best way to ...
1
vote
1answer
17 views
How to get InvoiceId from sales_order_invoice_pay in magento 2
How to get invoiceId from sales_order_invoice_pay event.
$invoice = $observer->getEvent()->getInvoice();
$invoice->getIncrementId();
Can't get with this code But with ...
2
votes
1answer
84 views
Magento 2 How to Update custom order attribute using REST API
I am using this -
extension_attributes.xml
<extension_attributes for="Magento\Sales\Api\Data\OrderInterface">
<attribute code="custom_sales_id" type="string&...
2
votes
1answer
25 views
How to add custom dropdown button to Admin Sales Order View in Magento 2
I've followed this link to add custom button in Admin Sales Order View in Magento 2, and it works great. Now I want to replace this button with 3 dropdown options button. Something like changing store ...
2
votes
1answer
22 views
Using Observer stop execution of next function in Magento 2
I am using an observer on event sales_order_save_before to check for a condition and based on that condition I was to stop the save functionality.
Currently I am using it on Submit Comment in Sales ...
1
vote
0answers
11 views
Personalized order number for Trade customers in Magento 2
I'm currently looking into setting up a wholesale version of my Magento 2 store to cater to bulk buying customers, which I have previously handled manually.
Everything is set to go apart from one ...
1
vote
2answers
20 views
Can't get order with OrderRepositoryInterface
I have an order in sales_order with entity_id = 1 and increment_id = 000000001.
Both ways of trying to get this order fails with the same response.
$searchCriteria = $this->searchCriteriaBuilder
...
1
vote
0answers
13 views
Magento2 get invoice detail based on tax percent group
I want to get invoice detail based on TaxGroup percentage, How can I achieve this.
Using sales_order_save_after event observer.
InvoiceObject = {
'orderId': 2324234,
'invoiceId': 443322,
'...
0
votes
1answer
22 views
How to add new column in sales_order_grid.xml dynamically or direct from class?
I have created a configuration for selecting fields from sales_order table to join with sales_order_grid table. I need to show these selected extra fields on the sales order listing page. like the ...
1
vote
0answers
5 views
order placing emails not sending to admin
I am using magento 2.3 for one of my clients. I am facing an issue that one of my customer placed an order. He is receiving the order detail mails. but i had not received the order placed mail.
how ...
1
vote
1answer
21 views
Magento 2 : which tables is used for Related Products, Up-Sells, and Cross-Sells?
I'm trying to get which table saves the Related Products for items and order-items?
Is there any way to know how many items sold by these property.
I try to check this table sales_order_item but I don'...
0
votes
1answer
52 views
How to modifiy order response Rest API magento 2
How i can modify order response only needed fields
Request url
http://localhost/magento2/index.php/rest/V1/orders?searchCriteria[currentPage]=1&searchCriteria[pageSize]=1
Reponse:
{
"...
1
vote
0answers
18 views
Magento2 Sales Order Totals Wrong on Order Email
I'm using Magento 2.3.4 and have my catalog set up so all the prices include tax, all the emails include tax and all the prices include tax.
The issue is that the order confirmation email doesn't send ...
0
votes
0answers
11 views
Unable to Filter Order Grid Collection for Diffrent Layouts in magento 2
i am using sales_order_grid in two layouts
sales_order_index and custom_order_index
I want to filter collection for both grid based on a custom attribute in sales_order_grid table its name is archived
...
0
votes
1answer
29 views
How to make inline edit in admin order grid row?
Can any one please let me know how to override admin sales order grid ui component to make it inline edittable? I have added custom column in the sales order grid and want to make it edittable. Please ...
0
votes
0answers
12 views
Magento 2.3: How to capture event after paypal payment
I have tried sales_order_save_after and sales_order_save_after but I cannot capture the order event after paying with paypal.
How can I capture this type of payment?
0
votes
0answers
16 views
Remove Configurable Product in Listing for Edit Order
Can anyone help me with how to alter this template? I want is to remove all configurable product in listing in Editing Order.
0
votes
0answers
18 views
How to update customer_address_id for order billing address?
After order is placed by a Guest user, I am trying to update customer_address_id for order billing address but could not update.
Tried with following ways to update, but couldn't do it
1st method
$...
0
votes
0answers
10 views
Get custom option in sales order api
I'm trying to get the value of a custom option field via the order api, but I don't see any fields in the API to do that. How can this be done?
0
votes
1answer
40 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/...
1
vote
1answer
26 views
How to change order status of Pending to Payment Review on homologation environment?
Hi i'm new at magento 2 and i want to change an order status of Pending to Payment Received, but i'm in homologation environment using sample data to test my store, so I still don't have a functional ...
0
votes
0answers
22 views
Custom template file is loading after hard refreshing the page in Magento 2
I override vendor sale module template file Module-sales/view/adminhtml/templates/order/create/sidebar/items.phtml in custom module with directory name Vendorname/Companyname/view/adminhtml/layout/...
0
votes
0answers
23 views
Magento 2: How to change order status of Pending to Payment Received?
Hi i'm new at magento 2 and i want to simulate the order status change of Pending to Payment Received. How can i do this? And which event can i observe to when the order status get changed to Payment ...
0
votes
0answers
21 views
Creating a draft order and emailing customer?
I am trying to determine if Magento 2 Open Source has the functionality where as an admin I can create a draft order and email it to the customer for them to pay. Shopify has this awesome feature ...
0
votes
0answers
9 views
Magento 1 - Orders are getting cancelled automatically
I have three payment gateway Paytm, Citrus Pay, Payu money. For some orders what we noticed is after successful payment orders are getting automatically canceled after 1 or 2 minutes. We are not able ...
0
votes
0answers
19 views
Custom mail template after order cancel from admin side in magento2
$orderWebsiteId = $this->_storeManager->getStore($observer->getOrder()->getStoreId())->getWebsiteId();
$templateOptions = array('area' => \Magento\Framework\App\Area::AREA_ADMIN,...
0
votes
0answers
14 views
Magento 2: Update order email address when change in customer email address
When I change the customer email address from the Admin it should change the email in Orders to.
So which event I can use for it and how to use it with the orders?
adminhtml_customer_save_after
...
0
votes
0answers
15 views
Can anyone help me getting the sales order detail using massaction in magento 1.9
I am try to get the data such a order_id, billing name, purchased data and other to just print or to store it in the custom made database all by just using the mass action from the sales order grid.I ...
0
votes
0answers
93 views
Magento 2 Invoice PDF date is showing wrong
Magento 2 order date showing wrong in Invoice PDF,the order date is showing correct in admin order page but it is not showing correct when generate invoice PDF.
Magento 2 admin order page(looks good) ...
0
votes
0answers
16 views
Magento 2: invoices are not always auto generated
I noticed on Magento 2.2.8 that the invoices are auto generated. Sometimes they're not autogenerated and I need to manually create the invoice.
Why does this happen?
PS, I'm using PayPal and ...
0
votes
0answers
13 views
When order Items has zero order quantity the order items are not showing - magento 2.3
When Order items has zero order quantity then order items are not showing in order admin panel how can i resolve it.
How to get solution for this scenerio in magento 2.3
Note : I need to give zero(...
0
votes
1answer
53 views
add order comment in order pdf
im work on print order to print order comment when we do print order from front end,
My Orders->Print Order
when click on Print Order the same comment print on PDF,
for that i have created Module ...
0
votes
0answers
67 views
Magento 2 - Order Id increment jumps
In my sales > Orders what I'm seeing is order is not continuous it jumps after some orders. Attaching screenshot for your reference
As above you can see that it directly jumps from 000008844 to ...
0
votes
1answer
109 views
how to add order comment in order pdf?
im new in magento 2,
im work on print order to print order comment when we do print order from front end,
My Orders->Print Order
when we click on Print Order the same comment print on PDF
as per ...
0
votes
0answers
15 views
Some successfull paypal payment order is not found in magento order
Some order records have been lost, but their IDs are already being used by payment gateways (like PayPal) for your current Merchant account. These IDs is not found even in order grid and sales_order ...
0
votes
0answers
20 views
How to export the order with order line item with products in magento 2.3
I need to create a Order CSV with order Line items in default the order Export only gives the order details. So how can i do it problematically or any other way.
Thanks in Advance :)
0
votes
0answers
20 views
I need to change the order page title
I need to change the order page title.
I don't want to show the Magento order ID I need to show ** External order Id** from Database how to change it.
0
votes
2answers
69 views
Want to add a order line item column in the admin panel order view page
I need to add the additional column in the table the field is already in the table i don't want to create it. Field name in table is additional_data in sales_order_item table. The below showed image ...
0
votes
0answers
20 views
Code not working on Live Server
This code line working on my testing server but not working on live
$collection = $this->_order->create()->getCollection();
I am getting my code stuck on this code and not creating log ...
