Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
23 views

Magento 2.X : Add custom columns to sales_order_payment

I already inserted columns on table sales_order_payment with db_schema. I created new payment method with custom input field in Form payment template like this : <select id="paiement_echeance" ...
0
votes
0answers
12 views

Magento 2 help validate function to count bundle product child items of an order

I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped. The tricky part is, magento formats line items ...
0
votes
1answer
20 views

Magento 2.3: How to print order without invoice

It looks like in the admin, you're only able to print the order via the invoice or shipment -- but orders that are pending that were paid via PO or COD methods, there's no option to print the order. ...
0
votes
0answers
16 views

How to get all transaction_email ,transaction status from sql query Magento 2

I am trying to get all transactions,transactions_id,transaction_email,transaction status by SQL query. I found the table where all transactions are stored sales_payment_transaction, ...
0
votes
1answer
21 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->...
1
vote
1answer
26 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
18 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
12 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
0answers
32 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
17 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
18 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
20 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
46 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 ...
0
votes
0answers
16 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
15 views

show product label on sale products

How to show product label sale only on products that are on sale?
0
votes
0answers
29 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 ...
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
45 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
17 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 ...
0
votes
1answer
72 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
33 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
32 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
26 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
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
1answer
54 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
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
17 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 ...
3
votes
2answers
76 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 ...
0
votes
0answers
44 views

Magento 2 Custom sales report export issue

I have referred below link to export custom sales report. https://github.com/yash7690/magento2-customreport I need to export collection as like below into csv file. order_id | discount_code | sku | ...
1
vote
2answers
59 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
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 ...
1
vote
0answers
18 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
21 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
0answers
18 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 ...
1
vote
1answer
34 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 ...
0
votes
0answers
20 views

How to get bundle options qty ? Magento 2

How to get bundle product options qty from $order->getAllVisibleItems() ?
0
votes
1answer
26 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
34 views

How to display products images on page sales/order/view? [duplicate]

I'm very new in Magento. I want to display products images on page sales/order/view. How can I do that? Anyone can help? Thank you!
1
vote
0answers
27 views

Product stock not returning to available stock in canceled order

Is there any explanation of why product stock from canceled order is not returning to available stock? Step to reproduce: I tried to order an item X (until place order) Open admin site, edit ...
0
votes
1answer
24 views

handle conflicts when override Order Sender class in magento 2

I am overriding OrderSender class for add custom variable in order confirmation mail. This variable's value is dynamic. but this file conflicts and give an error like "Type Error occurred when ...
2
votes
1answer
44 views

New orders are not showing in the orders grid but payement received?

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 and emails are not sent !! when I check ...
0
votes
1answer
107 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 ...
0
votes
0answers
14 views

Edit Order return Guest form

I like to edit order return guest form. I edited in app/design/frontend/[theme]/Magento_Sales/templates/guest/form.phtml but form settings are in vendor/magento/module-sales/Helper/Guest.php. ...
0
votes
1answer
19 views

Magento 2 option products of bundle are not showing in my orders magento core

I need the Qty of bundle options that I have ordered. I can see getChildrenItems() on getting the count it returns me 1, it doesn't include child products. Bundle/templates/sales/order/items/...
0
votes
0answers
39 views

Magento 2: New order email totals/subtotal decimal places

we have changed our site to display prices in 4 decimal places using this extension However on the new order email we would like to trim off the extra zeros. This is how it is displaying... Subtotal ...
0
votes
0answers
15 views

Sales order report per currency

We are using the M1 default sales order reports for our internal reports. However we have three different sites (language purpose) sharing the same base currency, but they can all have up to three ...
0
votes
2answers
54 views

Magento 2 - How to call sales_order_save_after Observer manually for testing?

i have a working Observer on the event sales_order_save_after. The Observer looks like this: namespace Company\ExportOrder\Observer; use Magento\Framework\Event\ObserverInterface; class Observer ...
1
vote
1answer
67 views

Magento 2 set created date to order when creating

I have followed the below steps to create an order in magento 2. But i want to set my preference date when creating it. How to create order programmatically in Magento 2?