Questions tagged [sales-order]
Denotes questions related to Magento Sales module's order functionality.
1,322
questions
0
votes
0answers
7 views
how to get customer postcode and which event to use in Magento 2?
I have to take postcode and customer order details to store in my custom order table which event to use after place order button in the checkout page?
0
votes
0answers
5 views
Partial fulfillment of order from store
In magento 2, how an order can be fulfiiled partially from Source1 and partially from Source2.
For example , I have 2 sources : SourceA having product with quantity 1 and SourceB having product with 3 ...
0
votes
1answer
23 views
How to filter Order Collection by Specific Product Item name?
I would like to know how to filter order collection by using a product item name in magento 2?
$collection = $this->_orderCollectionFactory->create()->addAttributeToSelect('*');
$collection-&...
0
votes
1answer
15 views
How to add Item Status to order confirmation email Magento 2.3.1
Is there a way to add the Item status (Ordered/Backordered) to the order confirmation email?
I tried below code.
<td class="item-status">
<?php if ($_item->getQtyBackordered()...
1
vote
1answer
44 views
Add custom content in order summary on checkout page
I have added a custom text inside the cart summary checkout page using a simple HTML template file.
My question is how can I add dynamic content(from .phtml file or Block file) to this section?
I ...
0
votes
0answers
33 views
how do I make customer order numbers in magento 2.3?
I want to make Magento custom order ids.
I see Magento 2 system order number starts from 1,2 etc.. I want to make it customer like
OD-010121-5001.
I see many extensions are available in market but ...
0
votes
0answers
16 views
Magento 2 unique constraint violation found when submit order
I am facing an issue of unique constraint violation found while submit order from magento backend. This issue only comes if my previous order was failed due to some technical reason and I am trying to ...
0
votes
0answers
13 views
Magento 2 - Admin Create Order. sales/order_create/loadBlock cant retrieve layout with <script type=“text/x-magento-init”>
When Creating an order via the admin. the forms are being loaded by
http://localhost/project/Admin/sales/order_create/loadBlock/block/shipping_method,totals,billing_method?isAjax=true
this request ...
0
votes
0answers
18 views
Magento 2 calling addHandle() on template with <script type=“text/x-magento-init”>
I've tried to add a Js layout in sales_order_create_index.xml in which I override Magento_Sales::order/create/shipping/method/form.phtml
There's not much I did but to call
<script type="...
0
votes
1answer
31 views
Magento 1.9 How to call any api on event “sales_order_invoice_register”?
I want to call my custom API on sales_order_invoice_register event. Menas, when the invoice will generate, will call my custom API and I want to store the response in Database.
Will this kind of ...
0
votes
1answer
46 views
Magento 2 How to send order email copy to custom email address with custom module when order placed, by custom observer and events.xml?
I have one module where i can set email address in back end. When order placed i want to send that order email copy to my custom email address which is set in backend.
I want to add an observer when ...
0
votes
0answers
14 views
Exception occurred during order load - Sales => Orders
Error under Sales => Orders: Exception occurred during order load
Kindly tell me, why this error is coming ? How to I can fix this issue ? I am using Magento 2.4.0.
0
votes
0answers
48 views
Magento 2: Get shipping address on my order page
I want to display shipping data on order page.
This call $block->getFormattedAddress($_order->getShippingAddress()) returns null.
But, this call $block->getFormattedAddress($_order->...
0
votes
0answers
17 views
Magento 2 Create order even if product Qty is Zero
I want to create an order programmatically where a product qty is zero. I am unable to do so at I get a message as
{"0":"The requested qty is not available","1":"#1
...
0
votes
0answers
23 views
Magento 2 quality patches MDVA-28656 is not available in Magento 2.4.1
I'm using Magento 2.4.1, when I order a virtual product then create a pending invoice it will make the order status become closed instead of processing. To prevent this error I must apply Magento ...
0
votes
0answers
13 views
Order without shipping address(downloadable product) not show in Sale Order Grid
I have issue that sales order without shipping address (downloadable products) not appeared in admin sales order grid. Anyone know how to solve this? M2.3.5p2
0
votes
1answer
26 views
How to Create editable filed in sales > order Grid in Magento 2
How to create editable delivery date columns in order grid page.
Please Advice me.How to Create
Thanks.
0
votes
0answers
11 views
How to Add Custom Column in Sales Order Table and Display in Admin Grid and Sales order view?
I want to add a custom attribute in sales order table I have added it using db_schema it is also showing in DB but how will I show it on admin grid and sales order view I also want to change it from ...
0
votes
1answer
39 views
How to get all orders in order history page magento 2.3
I need to get all orders on the sales order history page without any limit I need to get the orders. In Magento 2.3.
I had tried the below code using the OrderCollectionFactory but I am getting the ...
0
votes
1answer
39 views
Magento 2 : How to add country_id column in sales order grid
I want to add/filter country_id column of shipping address in sales order grid.
I refer below link which is useful to display regoin_id.
By doing same I am able to add country id as a column but when ...
0
votes
0answers
18 views
Magento 2: Approval Status is showing disapproved in sales order listing
I purchased the one product by PayPal PayFlow. Product purchased successfully but order approval status is showing disapproved.
Any one can tell me the reason why approval status is set disapproved.
...
0
votes
1answer
17 views
Magento 2 change Ship button in Order functionality
I'm trying to change the functionality of Ship button when you choose an order.
The only thing that I have found so far is this file under /vendor/magento/module-sales/Block/Adminhtml/Order/View.php:
...
0
votes
1answer
21 views
Get Multiple Order details Magento 1
I am using Magento ver. 1.14.2.4
I am trying to get order detail's for 6-7 orders, want to log their data into (var/log)
What's the best way to do it ?
0
votes
1answer
33 views
Payment interface extension attribute not saved in order table
I am trying to add an extension attribute in the Payment API. but value not saved in sales_order table.
etc/extension_attributes.xml
<extension_attributes for="Magento\Quote\Api\Data\...
0
votes
0answers
12 views
Create order without region id
I want to create an order for country US. In Magento we have 2 ways to create an order one on frontent and other from Admin.
We have blocked a particular region Alabama. When we fetch the region ...
0
votes
1answer
17 views
How to set custom_field value from product page to quote after a product added to cart in magento 2?
I have a custom_field on the product details page( Like a hidden field ). Which is not a product attribute.
I can get this field value using checkout_cart_product_add_after event using an observer ...
0
votes
1answer
25 views
Magento 2: get order id on success page
I'm trying to put the conversion event snippet into my success page, but I dont know how do I get the order_id to pass with.
My code is:
gtag('event', 'conversion', {
'send_to': '...',
...
0
votes
0answers
7 views
Can't create new column in sales order by using patch
I want to create a new column in sales_order by using patch. In patch list I can find the patch name but the column is not created. What's wrong here?
<?php
use Magento\Eav\Setup\EavSetup;
...
1
vote
0answers
13 views
Magento 2: edit order items without cancel
There are many extensions in magneto 2 market place for editing the order info without canceling it.
I know I can edit the shipping and billing info but I don't know how to edit the items quantities ...
1
vote
1answer
18 views
Magento 2 - cant modify quote before placing order
I try to delete all items with a custom product type from the quote before the order is placed. So I created an observer for the event sales_order_place_before. In this observer I am collection all ...
0
votes
0answers
14 views
Send mails to stock sources after sources selection in order processing
i wanted to send emails to the sources emails stored in config every time i process order so the get notified before actual shipping process starts, anyone have any idea how to do this.? Any event i ...
0
votes
0answers
27 views
Magento 2 - Where is the template for sales/order/print/order_id/x
I am searching the template for the order PDF which is showing in checkout success when you click the "print receipt" link.
Where can I find it? I have to change the header.
0
votes
1answer
50 views
How to get a custom product attribute in the sales order view?
I am trying to fetch the values from a custom attribute (multiselect attribute) of the ordered products, and display them in the order view in a new section.
In order to do that, my plan was to create ...
0
votes
0answers
15 views
Magento 2 - Setting orders to “complete” automatically after placing an order?
I'm trying to set the order status of new orders to "complete" after a new order has been placed but can't see how this is done in the Magento backend.
I can't select the "complete"...
0
votes
0answers
10 views
How to place customer orders through Admin Token API Magento2
I have to place an order through API REST on behalf of a customer like the Magento admin panel.
Sales >> Order >> Create New Order
I can see on the Doc that an Admin Can create a CART but ...
0
votes
0answers
6 views
Magento 2 how to upload image in order dispatch email
I want to upload the open package image that was taken through mobile, that we'll be able to upload in the complete order template email(shipment email).
the area from where we can be able to upload ...
0
votes
0answers
6 views
Is it possible to “Refund Order to Customer's Payment Method” in Magento?
I am using Magento ver. 1.14.2.4.
I am not sure if its' possible to "Refund Order to Customer's Payment Method" in Magento ?
If yes, then it would be interesting to know how ?
I can see that ...
0
votes
0answers
13 views
Refund Orders to Payment Method (MAGENTO 1)
I am trying to create a script where i can pass
order_number
product_sku
qty
& it should issue a refund to the customer's payment method.
PS. I am using Magento ver. 1.14.2.4.
Basically i am ...
0
votes
0answers
19 views
Magento 2: Unable to add product to package in shipping label
Magento: 2.4
Shipping Module: https://marketplace.magento.com/laposte-magento2-colissimo-module.html
Steps to reproduce
After creating order goto admin > sales > order
Click on ship and check ...
0
votes
2answers
31 views
Magento 2 - How to add custom attribute to sales/order/view?
How can I add a custom field to sales/order/view in adminhtml?
I want to save a tracking number related to the order.
Thanks.
0
votes
0answers
20 views
Magento 2 - How to add a custom field in admin/sales/order/view
How can I add a custom field to admin/sales/order/view?
I'm trying to add a tracking number field to the sales order view.
The tracking number must be saved in the db.
0
votes
0answers
18 views
How do I retrieve the grand total in order currency using MySQL?
How do I retrieve the order amount in the order currency using MySQL?
SELECT entity_id, (base_grand_total * store_to_base_rate) AS order_amount, order_currency_code
FROM sales_order o
WHERE o....
0
votes
0answers
26 views
Show admin order comments in sales order grid
I am trying to show admin order comments in a new column I created in sales order grid. Anyone know how I would do this?
0
votes
0answers
19 views
Magento 2 in Backend Order Creation how to override shipping method section
I have created a custom module in magento 2 and override sales_order_create_index.xml layout file in custom module and set referenceBlock.
But issues that when first time page is loading from magento ...
2
votes
0answers
87 views
Magento 2 get Orders from last 24 hours
i need to extract the list of all orders executed in the last 24 hours, from now.
I have a code almost working but not every orders is processing.
The cronjob runs smoothly but i miss the last 3/4 ...
0
votes
1answer
22 views
Alert admin when order is made with a specific payment method
We currently have, on our site, the option to make payment either by credit card or Bank transfer. We would like a way for the admin to receive an alert email when payment is made using the Bank ...
0
votes
0answers
9 views
Estimation Delivery date by admin
I am searching for an extension admin can able to set the delivery date for the order.
The default order estimation date will be 2 days. If it delays means the admin can change the date of a delivery ...
2
votes
1answer
20 views
Get Latest Ordered Items for a Customer Across Multiple Orders
I am trying to gather the latest 100 items a customer has purchased across all his orders. I know I can use itemCollectionFactory and go order by order, but I was wondering if there is a faster way to ...
2
votes
0answers
29 views
What is the standard order process workflow in Magento 1?
I'm trying to understand the order process in Magento 1.7. The background is: I'm extracting the payment (and later the complete checkout) from Magento to another system, but the order processing ...
2
votes
0answers
29 views
Magento 2 - offline payment have no entry in sales_order_status_history table
I am working on the implementation of Track order functionality in Magento 2 in which I am using the sales_order_status_history table to get all status history related to the orders.
But this is ...
