We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [sales-order]

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

442 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
670 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 ...
6
votes
0answers
138 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
158 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 ...
5
votes
0answers
587 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
0answers
21 views

Magento 2 : How to change in order status and order id for display purpose in custom POS

We have Custom POS system enabled on the website. Like to append some labels in the order id and order current status for the display purpose only in the POS system not for the website(frontend) ...
4
votes
0answers
33 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. ...
4
votes
1answer
750 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 ...
4
votes
0answers
339 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 ...
4
votes
0answers
151 views

Magento 2.1.5 - Sales Order reports show missing data

I am facing 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 display with same dates order Magento: 2.1.5 ...
4
votes
1answer
725 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
2answers
752 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
4
votes
1answer
599 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
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
0answers
45 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 ...
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
0answers
380 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
474 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
374 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
0answers
398 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
3
votes
0answers
203 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
577 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
368 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
792 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
916 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
447 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
608 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
0answers
34 views

Grand total is storing as 0 while ordering the products in magento 2

Before placing the order it shows correctly the order total but after placing the order, it stores the grand total as 0 in the database table. How to fix this problem?
2
votes
1answer
29 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
25 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
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
36 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
432 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
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 ...
2
votes
1answer
30 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
67 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
263 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
160 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
139 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
504 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
91 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
0answers
88 views

Magento 2 add country field in order export

I need to add counrty field in order export Magento 2. Means when I click in export and csv or xml and Export button expected data with country name also. Thanks
2
votes
2answers
333 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
495 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
384 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
63 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
732 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
142 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
192 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 ...