Questions tagged [sales-order]

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

532 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7
votes
0answers
159 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 ...
6
votes
0answers
959 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 ...
5
votes
1answer
420 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
613 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
29 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
1answer
296 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 ...
4
votes
0answers
39 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
0answers
438 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
176 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
1k 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
1k 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
732 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
54 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
709 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
828 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
571 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 ...
3
votes
0answers
1k 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\...
3
votes
0answers
537 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
222 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
731 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
380 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
876 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
935 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
536 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
613 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
7k 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
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 ...
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 ...
2
votes
1answer
301 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
0answers
57 views

Magento 2 show custom table data on the admin order detail tab

I am building a custom module to store multiple rows of custom data while user placing the order. Following fields are in my custom table, “entity_id”, “order_id”, “sku”, “some_customvalue”, “...
2
votes
1answer
56 views

How to add additional options in order admin side in Magento 2.3?

I am sending additional custom options in the cart when add to cart a product. I have used this link . Using this link I have added custom options in the cart as well on checkout page and minicart. ...
2
votes
1answer
43 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
29 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
1answer
855 views

new orders are not showing in orders grid

I upgraded from Magento 2.5.0 to 2.3.1 I am using only PayPal as a payement method. new orders are not showing in the orders grid in Admin > Sales > Orders when I check PayPal summary I can find ...
2
votes
0answers
22 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
66 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
2answers
343 views

Where is the original price set in sales order item table?

In quote_item table we don't have a column original_price. So when and how sales_order_item table get the original_price value. Post order we are seeing original_price as 0 in admin sales order view ...
2
votes
1answer
906 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
32 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
47 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
222 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
179 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
1k 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
122 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
118 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
725 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, ...

1
2 3 4 5
11