Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
847 views

Magento 2 api : order status

I am looking for a way to update order status with rest api (php) based on order ID. I tried several things from the doc (well at least, I have found below code Without success) $data = array( ...
1
vote
1answer
709 views

Magento 1.9 API Performance - Retrieving All Sales Order Info

I'm creating a page that shows order sales data such as sales revenue, total quantity of orders and also best sellers which consist of products from all sales orders. The problem is that this takes ...
0
votes
1answer
80 views

How to set Custom shipping Amount to an order programmatically magento 2.3

Hi all, actually i am creating an order programmatically now i trying to set custom shipping amount to order. @all i tried Magento1.X link there they have implemented using $order->...
7
votes
3answers
6k views

Add More Mass action in Order grid in magento2

I want to create delete order functionality in magento2, but i am not able to add mass action in order grid. please help me how to create delete order functionality in magento2. Please help me if any ...
1
vote
1answer
82 views

How to get discount amount for each item from order id / item id

How can I get the discount amount for each item in an order? using its order id/item id. I am not able to retrieve the discount amount from its order id/item id.
0
votes
1answer
48 views

Check if order line/item was backordered

I'm checking each order line. If the line was ordered, I have to do to something. If it was backordered, I will have to do something different. Like this: private function myFunction($order){ $...
0
votes
0answers
18 views

Change Shipping method in quote before magento validation occurs on admin order create

I am creating order from magento admin side but I want my custom method to be set in the quote before the order is submitted I have tried the following code. di.xml <preference for="Magento\...
0
votes
1answer
31 views

Magento Shipping country ID is shown as NULL in the reports

I'm using PostgreSQL in my data ware house for reporting purposes, and for a certain report I have to show the sum of revenue for each month grouped by country. When i pulled the report the ...
0
votes
1answer
587 views

'Not valid template file' error when printing invoice programatically

I'm trying to find a way to print an order's invoice programatically. For that I tried to get the url that Magento uses in backend to print an invoice but it didn't help as it uses a key that I couldn'...
0
votes
0answers
47 views

Magento 2 view order issue

We are using Magento 2.3.2 version.We are facing issue when we go to Sales --> Order and click on view orders the below error comes up. The error is not coming with pending orders but coming ...
0
votes
0answers
20 views

How to ReOrder automatically in period basis in Magento 2

Is there any way/possible to set to ReOrder the order automatically in period(Day, Weekly, Monthly or Yearly) basis. Please suggest me.
0
votes
2answers
21 views

How to add year in sales order and invoice number

I like to get current year in my order and invoice number. Now i'm getting order id example: "XX-000001" i need to get like "XX-190001" this (19) is current year that need to be change in dynamic. ...
0
votes
0answers
24 views

Get the list of most seller combined products with its orders

I want to get the most frequently sold product combinations, along with number of orders ( and Orders if possible). I have customized the Magento tables for my warehouse activities and the sample ...
0
votes
0answers
21 views

Getting error while changing status of an order Magento 1.9.4

While changing the status of an order or creating the shipment, I am getting below error: Cannot save shipment. I have checked the exception log and found the below message. exception '...
1
vote
3answers
168 views

Magento 2 - Change order status to 'Complete' using observer

I am using sales_order_save_after event to change order status. It's working fine for all order status except STATE_COMPLETE. when i set the order status STATE_COMPLETE to make order Complete but it ...
1
vote
0answers
68 views

Add attribute in magento order email confirmation

Need some help to add a custom attribute to my email order confirmation. I have an attribute Location that I would like to be shown under the product sku in the order confirmation email. Could any ...
0
votes
0answers
43 views

Magento 1.9 order total as zero in sales orders reports

We have multiple websites with single store view and every websites have different currency, time zones. My default website set the AUD currency. I tried with generating the sales order reports based ...
0
votes
1answer
30 views

Magento 2 and MCOM : syncronize return

My Magento 2 is link to the MCOM (Magento Commerce Order Management). Currently, I can syncronize orders status between both. Now, I would like to syncronize return : If a user want to make a return,...
0
votes
1answer
19 views

show product label on sale products

How to show product label sale only on products that are on sale?
3
votes
6answers
13k views

how to display product image in sales/order/view/ page

I am trying to customize sales order view page and I want to show product image in order view page how can we achieve this. and the path of the file is vendor\magento\module-sales\view\frontend\...
0
votes
1answer
426 views

Some Payment Method Not Showing in Sales grid after upgrade magento to 2.3.1

I upgraded Magento version 2.2.3 to 2.3.1 by using composer. All Things are working fine, except Sales order grid. In sales grid it's showing only payment method check, rest other payment methods are ...
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?
0
votes
0answers
33 views

Add product point to quote, order and invoice magento 2

I have a voucher point custom attribute for each of my product. I need to keep track of this point across each quote_item, sales_order_item and sales_invoice_item (Meaning I need a voucher_pts ...
4
votes
2answers
762 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
2
votes
1answer
592 views

how to save the custom time in order comment history in magento 2?

$orderId = $orderId; $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $order = $objectManager->create('\Magento\Sales\Model\Order')->load($orderId); $order->setState(\...
2
votes
1answer
1k views

Order: To get comment field details from DB in magento 2

In admin panel Sales->Orders section, while viewing the order, It show order information like below I need to fetch the comment details from core table (sale_order_status_history).and want to show in ...
0
votes
1answer
72 views

Magento 2.2.6 : Authorize.net not working. Giving Below Error

Argument 1 passed to Magento\Authorizenet\Model\Directpost\Request::__construct() must be an instance of Magento\Framework\Intl\DateTimeFactory This error is getting displayed when I am clicking on ...
0
votes
0answers
14 views

M2.2.4 - Order comments in backend, make asc order instead of desc

We have some extensions that attach comments to the order comments area of an order, however we also have the customer comment order as well, which we would like to make the primary comment on the ...
3
votes
1answer
105 views

How to display custom checkout field value in Admin Sales Order?

I have creat a custom module that adds a custom field to checkout. It is the input text field. I save this value to quote table and to the sales_order table. But now I want to display this value in ...
0
votes
0answers
20 views

Item (Mage_Sales_Model_Order) with the same id “611” already exist (by change “company” in checkout)

I have to fix mistakes of a former colleague. The customer changes his address in the checkout, everything works fine until the moment he uses the field "company". The order goes through completely ...
1
vote
1answer
1k views

How to recognize order before saving in the backend ? - Magento 2

I would like to post some data in admin order create form and check if it exists and is set if not throw an exception. I was thinking about adminhtml_sales_order_create_process_data event, but it is ...
1
vote
1answer
583 views

set discount amount while creating order progrmmatically in magento2

I am creating order pro-grammatically. I have referred below code https://www.rakeshjesadiya.com/how-to-create-order-programmatically-in-magento-2/ My requirement is to set discount amount for each ...
1
vote
1answer
53 views

REST API: get order entity_id from order increment_id

How to get order entity_id from order increment_id by REST API?
0
votes
0answers
12 views

How to set different emials in sales order update?

Is it possible to sent different emails when i change the order status in my backend? Example: My sales order status in Processing, i changed to "verify" (email sent to customer with content "verify")...
1
vote
1answer
54 views

How to save custom value in sales_flat_order_grid on order placement?

I have to save the stock of each product when an order is placed. The custom module is Tbb_StockRegistrar. It creates a column called order_stock_message in sales_flat_order and ...
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 ...
1
vote
1answer
101 views

How to use 'searchCriteria' and 'fields' in REST API for fetch orders

I am using below curl_init like this, $webSiteUrl = 'mydomain.com' $last2DayUpdated = date('Y-m-d',(strtotime ('-1 day', strtotime(date('Y-m-d'))))); $ch = curl_init("{$webSiteUrl}/rest/V1/orders?...
1
vote
0answers
24 views

Do not display out of stock products in reorder admin panel

I don't want to show out of stock products in admin panel reorder or create new order option.
1
vote
0answers
22 views

Purchaseorder method payment dont' write on database

When I shop at my store and using purchaseorder payment method, what happens is that sometimes Magento writes the data in the database and sometimes does not write. I do not know why this is happening....
0
votes
0answers
23 views

Magento 2 how to show custom order attribute in checkout?

how to show custom order attribute in the checkout after shipping methods and admin as well? I am trying below code but it is not working. It also saves on the database. (in the database column ...
1
vote
2answers
456 views

Magento2 : Add sales_order column coupon_code in sales order grid

In sales_order table we have a column coupon_code. I need to show it in sales order grid. I have added the column coupon code by overriding sales_order_grid.xml file. The column is being shown. Now I ...
4
votes
1answer
3k views

Sales orders is not displayed in admin panel in grid of Magento2.2.0?

After data migration process I see that orders data is not displayed in Magento admin sales grid. All data is available in the database. Than why data is not in sales grid? Anyone has idea about ...
3
votes
2answers
200 views

Magento 2 - How use join between sales_order and sales_order_item table

How to use Join in Magento2. i want to get customer_firstname from sales_order table and price , qty_ordered columns from sales_order_item table where sales_order.entity_id=sales_order_item.order_id ...
1
vote
2answers
130 views

Magento 2 how to change order increment id?

I just migrate data from magento 1 to magento 2 Magento 1 order id start with 10000001 and magento 2 order id start with 00000001 So we need order id start from 100000062 in magento 2 (because in ...
0
votes
0answers
10 views

How i can AutoFIll Create Order Form with Quote data

i want to redirect my admin to Create Admin Form with Quote data to Auto Fill Create Order and allow admin Create Order something like that when admin click on create order Action it should redirect ...
2
votes
1answer
26 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 ...
1
vote
0answers
27 views

In sales order email i'm getting “Pay with Credit/Debit Card or Paypa” twice." magento 2

In my sales order email i'm getting "Pay with Credit/Debit Card or Paypa" twice. How to remove "Pay with Credit/Debit Card or Paypa and Payer Email" that i marked in attached image. Please let me ...
0
votes
0answers
31 views

Prevent change order status from processing to pending payment

I developed a plugin for canceling orders which remain pending for more than an hour. The plugin also clears the basket after an hour. The plugin is working fine most of the time. However, on a ...
1
vote
1answer
44 views

Magento 2 - Cancel order incrementing 2 quantity of product

In Magento 2.2.5 EE Before placing order: Product quantity = 1 stock status = 1 After placing order: product quantity = 0 stock status = 0 After cancel order: product quantity = 2 stock status = 1 ...
1
vote
0answers
24 views

How to transform a quote into an order from CALLBACK HOOKS, MAGENTO 2.3

I'm trying to integrate a payment gateway. And they provide a callback hooks i've set for them to return me the CartID (Quote's entity_id). But from here on, it feels like it isnt right for me to ...