Questions tagged [sales-order]

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

429 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
131 views

Replicate order summary block Magento 2

I want to add order summary at checkout success page, I want to replicate the existing order summary block and template file whether its from backend or frontend. Which block and template file to ...
5
votes
1answer
96 views

This order no longer exists for all sales orders > 1 month

i just realized that i cannot open any SO which is created more than 1 month ago, i'm getting error This order no longer exists : respective records exist in tables sales_order and ...
4
votes
0answers
143 views

Magento 2.1.5 - Sales Order reports show missing data

I am having issue with order sales report its skipping some data from monthly order report, Some order dates are missing in reports but in order gird it displays same dates order Magento: 2.1.5 ...
4
votes
1answer
654 views

Magento-2 : How to display custom field just after payment method list and save on place order

I want to display one text area, just after payment method list, on checkout page. Text area value should be saved on place order. Saved value also need to be displayed in Admin >> sales >> order >> ...
4
votes
1answer
569 views

slow INSERT query in sales_flat_order_grid

We see in newrelic some peaks if orders are inserted into sales_flat_order_grid. I tried to figure out why, but couldn't find the reason. This peaks appear ~ 1 of 100 orders. First of all I thought ...
4
votes
0answers
580 views

customers cancel return products in my account page- Magento 2

My requirement is adding cancel and return option in customer account page. add cancel option after place order. add return option after delivered. I am wondering it is a very essential option but ...
4
votes
1answer
2k views

Magento - Show custom data on Order Information page (Customer Account)

I need to display points earned by customer on Order Information page under customer account. module.xml <sales_order_view> <reference name="order_items"> <action method="...
4
votes
2answers
1k views

How to create custom grid like sales order in magento2?

How to create custom grid like sales order gird with new,edit,save,delete,status,massdelete..etc in magento2.?
3
votes
1answer
76 views

Change quote currency before place order

I want to change my quote currency code to EUR when an order is placed in any other currency. I tried writing event and observer of event sales_order_place_before. In my observer I have this code ...
3
votes
0answers
31 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. ...
3
votes
1answer
33 views

How can we write the below code in magento 2.2.5?

How can we write the below code lines in Magento 2.2.5 controller and model? $order = Mage::getModel('sales/order') ->getCollection() ->addFieldToFilter('quote_id', $...
3
votes
1answer
572 views

How to find missing orders in Magento

When I check the orders were placed on our site in the Magento admin panel, some of the order numbers are missing or we can say there's no sequence in order number. Example: Magento was at number ...
3
votes
0answers
338 views

Order duplication on magento2

On March 22nd, 2018 we went for a Sale on our Magento 2.1.5 live site deployed on an AWS server m4.4xlarge. On 12am sale started with 1500 online visitors and in the next 3 peak hours, there are some ...
3
votes
2answers
436 views

Magento 2 SALES Order and REPORT Orders Export data qis inconsistent

Two different operating places in the background. Choose the same time (one day) for testing. The output is different. SALES Order count is same as my database query result. This is SALES Orders ...
3
votes
0answers
307 views

Random integrity constraint errors saving orders in Magento 2.1 after payment

I have a system that generates quotes, then submits the quotes, which processes a payment. The system is pretty standard: nothing really complicated is going on. The quotes have a single product in ...
3
votes
0answers
321 views

Company Column on Sales Grids (Order, Invoice, Shipment, Credit Memo)

This is a continuation from my previous question: Billing and Shipping Company Column on Sales Order Grid I was able to place the Ship-to and Bill-to Company Columns on the 4 Sales Grids, but I am ...
3
votes
2answers
675 views

Disable Order Confirmation Email for particular customer group

Is there a way to disable a Magento Order Confirmation Email for a particular customer group ? I won't mind someone giving me a guide on how to create a custom module for this function. Thanks
3
votes
0answers
197 views

Prevent place order using observer in magento 2

Hi I'm trying to prevent placing order with the help of observer i have already trigger the event "sales_order_place_before" with this i got all the details of the order like products in cart ,...
3
votes
1answer
542 views

what is entity when create an order using REST api

I am trying to create order using REST API I have got an error message ordered: {"message":"%fieldName is a required field.","parameters":{"fieldName":"entity"}}" What is entity field in order of ...
3
votes
0answers
363 views

Join sales/order and ordered items in grid column render Magento 2

I created a custom column in sales/order grid named Product name, They are coming fine on first time, When I am doing sorting Found : Column not found: 1054 Unknown column 'product_name' in 'order ...
3
votes
1answer
770 views

sorting not working magento 2

I created a custom column "product_name" in sales/order grid, When I am sorting this column grid showing error: Item (Magento\Framework\View\Element\UiComponent\DataProvider\Document) with ...
3
votes
0answers
902 views

Checkout Order Total summary went on refresh of checkout page Magento 2.0

I have rearrange the checkout summary block after the cart items and whenever i tried to refresh the page or i add a new address or switch between multiple addresses Order Total Summary block removed ...
3
votes
0answers
431 views

Shopping cart price rule not applying when creating order by REST Api

I'm working with Magento CE 1.7.0.2. I create order by sending REST Api request (working fine) but when I'm adding coupon code to my XML (or JSON) request, the discount is not applying and the amounts ...
3
votes
0answers
606 views

Custom Options of Configurable product do not display in email

I have an extension that do not offer any support so i am trying to fix by my own. So far what i did is locate the file that is responsible to render the custom options as this is my issue, it is ...
3
votes
1answer
6k views

How to change invoice status paid to pending_payment when order status is processing

I have used Magento version 1.9, when order is placed then order status is pending. when submit invoice then order status changes to processing but invoice status is showing paid. But I want to ...
2
votes
1answer
28 views

Order has discount but the discount was not applied in the item level

Can someone help me understand why my order has a discount but the discount is not divided into each of the items accordingly. In most of the orders, the discount amount is divided into each item ...
2
votes
1answer
24 views

Save an order from admin without submitting - quotation

Can I save an order from admin without submitting? So without triggering the payment logics? I want to create an internal management of quotation that could then become orders. An idea is to not use ...
2
votes
0answers
39 views

How to correctly add an extra charge to a Magento 2 order's total amount?

We're using a custom module to calculate an amount we need to include in the grand total of the order, i.e. the customer will be charged for the product PLUS this custom amount. The result is our ...
2
votes
0answers
19 views

$order->getCustomerName() returned ?? for unicode customer name

Under Magento EE 1.14, I have unicode characters in the customer name, the following code does return correct name in unicode for the first time: $order = Mage::getSingleton("sales/order")->...
2
votes
0answers
34 views

Getting an error: No such entity with cartId = 17090. How to resolve it

Magento give me this error when I create order using the backend. When creting the order with frontend, it works fine. I am using multi-website functionality in my project. I have creted custom quote ...
2
votes
1answer
298 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); ...
2
votes
1answer
26 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 ...
2
votes
1answer
23 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
44 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 ...
2
votes
1answer
222 views

Magento2: Order updated_at stored in DB in timezone CEST but delivered/transformed to UTC by $order->getUpdatedAt in Environment “crontab”

we are facing a strange behavior for value of updated_at saved in db table sales_order. Server timezone is CEST, updated_at date therefor is saved in CEST to database. This is validated. Default ...
2
votes
1answer
152 views

Magento 2 - Order Cancellation Charges

I want to reduce 1% of the total ordered amount when someone cancels an order. So even though an order is canceled, the customer still has to pay 1% of the total amount he ordered. How do I achieve ...
2
votes
0answers
127 views

How can I display product attribute in order summary in Magento2?

I am trying to display weight of the products in the order summary like I have shown in the below screenshot. Anyone who knows help me out.
2
votes
1answer
427 views

Customize Reorder function Magento2

like it says on the title, I want to 'customize' in a manner of speaking the reorder function that appears on the 'My Orders' section in the Customer Dashboard. What I have to do is to remove that ...
2
votes
0answers
86 views

Create order programatically without billing and shipping address

I have a couple of virtual products in my Magento 2 website, I’d like to create the order programmatically without inputting shipping and billing address, is that even possible?
2
votes
2answers
228 views

Create Admin grid from join table collection

I'm new to magento 2, I have a query to join multiple table, only 1 custom table I've made and the rest is from Magento 2, the query looks like this: SELECT marketplace_orders.entity_id as id, ...
2
votes
0answers
475 views

Add custom attribute to sales order address

I have a custom attribute for customer address which I setup using EAV, I load the custom attribute for customer address using order like this: // Magento\Customer\Api\AddressRepositoryInterface $...
2
votes
0answers
344 views

Magento 2: Sales Order report show wrong data

Orders Report gives wrong results when compared with the actual orders. For example, in Dec 22,2017, there are total 5 orders having "complete" status. But when I view orders report after applying ...
2
votes
1answer
45 views

Order collection not showing the order that have been invoiced

I try to retrieve all the order collections, but when I observe by looping the collections and print the order id, I notice the order that has been invoiced is not inside the collection. $collections ...
2
votes
0answers
595 views

Magento 2 Rest API get Quote Item Custom Option values

Hi I have tried with the magento 2 rest apis 1) V1/orders/:order-id 2) V1/orders/items with serach filter order id 3) /V1/carts/:quoteid/items The above apis are not returning the Order item ...
2
votes
0answers
681 views

magento 2 override Magento\Sales\Model\Order.php get method for REST api

magento 2 override Magento\Sales\Model\Order.php get method for REST api to add some details. i am getting an error in di compile Fatal Error: 'Uncaught TypeError: Argument 1 passed to Custom\\Sales\...
2
votes
0answers
121 views

Magento 2 How can i Change Sortorder in fornted order_view.xml in order_total

I want to change sorting order in order_total block in frontend order view page. can any one tell me how i can change sorting order.
2
votes
0answers
175 views

Using numeric only increment_id for orders? READ THIS! Magento 1

There's a bug in MySQL which disabled searching by index if two columns are compared which are of a different type. Magento stores increment_id as VARCHAR in sales_flat_order but Magento does not cast ...
2
votes
0answers
370 views

How, where and when does Magento 2 save customer Tax/Vat number to the order?

I can not understand why the customer_taxvat field in sales_order table is empty for customers who have Tax/VAT number. Please advice
2
votes
0answers
26 views

Redirecting admin user before creating an order in adminpanel issue M1

I have a custom condition for customers . If that condition is satisfied I would like make a redirect with a message that 'the order cannot be created'. I used the sales_order_place_before event to ...
2
votes
0answers
469 views

Magento2 - Create A Custom Report Displaying Order Items

I'm trying to create a report that displays all order items along with some additional columns displaying things like customer name, customer billing address, order ID, payment method, etc. Can ...