Questions tagged [sales-order]
Denotes questions related to Magento Sales module's order functionality.
1,120
questions
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?
