Questions tagged [orders]
Mark questions related to Magento orders
2,227
questions
1
vote
1
answer
19
views
Event Observer on the orders grid if someone selects an order and uses one of the actions in the drop down menu items
If someone selects and order by checking the box and then using one of the action items in the dropdown. I would like to add the user and timestamp and the action item they selected to the comments ...
- 61
0
votes
0
answers
13
views
Magento 2 fake customer order came through with weird code instead of customer name
Just had a fake order come through on my Magento2 website. The address is nonsense and instead of a customer name it had this code:
{{var this.getTemplateFilter().filter($order.shipping_address.city)}}...
- 1
0
votes
0
answers
3
views
Magento 2.4 - Sending email for order collection
I have atm one email that will notify the customer when the order has been packed and shipped.
But how can we create an email that is sent when the order is ready for pickup?
How can we separate these ...
0
votes
0
answers
10
views
Set custom tax amount when creating order programmatically
Here is the source code creating custom quote for creating an order programmatically
$quote = $this->quote->create(); //Create object of quote
$quote->setStoreId($...
- 2,088
0
votes
1
answer
16
views
How to clone an order from one customer to another in magento 2
I need to create a button ("Clone Order") in the admin > orders section to clone a customer's order to other customers.
By clicking this button, a new page will open where I need to put ...
- 1
0
votes
0
answers
11
views
How can we write an API call to get a list of all products without orders
How can we write an API call to get a list of all products without sales
Essentially need to retrieve all prodcuts without sales/orders so far
0
votes
1
answer
42
views
Magento 2 - How to add columns to Sales order products grid?
In magento 2 I need to add columns (stock, status, brand) in this admin grid :
Sales > Order > Create new order > Select Product Grid
Do you know how to achieve this ?
Thank you
- 107
0
votes
1
answer
27
views
Order migrate to other magento
How can I achieve to Migrate Orders from the Magento2 instance to another Magento2 instance? Which tables are responsible for managing orders?
- 1,515
0
votes
0
answers
11
views
which possible solution for order migrate
I migrated my store data from m1 to m2 6 months before. Right now development is complete site is ready to live, I have migrated customers from a script this was so easy because in Magento there are ...
- 1,515
0
votes
1
answer
42
views
Magento 2.4: How to change text "Order #" to "Confirmation #" in printed page that appears post order placement?
It happens too often that customers call or email, worried that there were two orders created when they only placed on order. The reason this happens is that Magento issues an order number such as ...
- 552
0
votes
1
answer
48
views
How to Get all Order using GraphQL in Magento 2?
I want to get all Pending order Status Orders using GraphQL, Anyone can share a complete example or module. How to I'll do that ?
I have create Custom module Admin Grid, Now i want to display Only ...
- 362
0
votes
0
answers
10
views
Magento 2: Having issue with Payflow Gateway Secure Token
We have been using Payflow Gateway Credit card payment gateway for 6 years and recently we have been facing the issue of 302 redirection issues on the checkout page while customers place orders.
Below ...
- 1,779
0
votes
0
answers
28
views
Unrecognized REST API order created
We have noticed a new order created in the admin which has come from the REST API. (Order was automatically cancelled)
We have nothing running that creates orders in this way and the IP country and ...
- 474
0
votes
1
answer
21
views
Send order update email programatically?
I need to send the order status update email programatically, I tried with the class Magento\Sales\Model\Order\Email\Sender\OrderSender but it sends the order confirmation email, not the state update.
...
- 129
0
votes
0
answers
33
views
Order items not showing in the shipping mail for the Store owner
I upgraded the website from Magento 2.3.3 to version 2.4.3p2. When I do shipment of order then mail receives for both client and store owner.
But the issue is items are not displayed for the store ...
1
vote
0
answers
29
views
How to we can send Coupon Code For Next Order Discount in Magento 2.4.0?
I want to send Coupon Code for Next Order Discount. When any customer will place an order then customer will received a unique Coupon Code For Next Order.
anyone have an idea how to i'll do this ?
- 362
0
votes
1
answer
30
views
How to intercept customer order in Magento 2?
When an order is submitted, I need to write data to extension attributes. I need to either create an event observer or plugin. How do I do this the right way?
0
votes
1
answer
31
views
Reset billing address to default address
I'm trying to (re)set the billing address to the customers default billing address after receiving an order (this is for B2B clients which are not allowed to change their billing address). To do this, ...
- 53
1
vote
0
answers
30
views
Magento 2 - How To Generate Custom Data Fixture For Integration Testing
I'm required to generate 1000+ orders to test an integration + address verification.
I've come across this data generation technique in my search and wish to create my own data fixture based off:
...
- 561
0
votes
0
answers
55
views
Magento 2:Custom Payment Method Order Status Not Set Pending
I have created a custom offline payment method extension.
I added one field into system configuration for selecting New Order Status.
I set Pending status into that field.still when I try to place new ...
0
votes
1
answer
10
views
Get All Pre orders from Magento
How can I get all orders using Resy API with status as Pre Orders?
I tried using Get Orders but not sure which status will reflect that.
- 1
0
votes
1
answer
50
views
Magento 2 - Orders with deleted products ProductRepositoryInterface The product that was requested doesn't exist. Verify the product and try again
If I want to print my order using some PDF extension which uses the table from transactions emails, some invoices with deleted products are causing an error. As a result the table will be blank. ...
0
votes
2
answers
47
views
Unable to Set Custom Price or Quantity in Admin Orders
I have a Magento 2.4.3-p2 instance running on apache2. When I create an order using the admin backend, I cannot customize the prices and quantities of the products I have added to the order. The ...
- 30
0
votes
0
answers
7
views
Magento 1.9.x Add configurable product image in new order email
There are many threads that I didn't want to resurrect but none solve the problem, they work for the simple product image but not for the configurable one.
Of the many, this one is the most valuable:
...
- 1
0
votes
0
answers
20
views
Magento 2 Order states & status
Good day,
im currently stuck in a situation with the Magento2 order states & status.
I want to create the following workflow:
New Order comes in (Payment in advance / Bank transfer):
Should be ...
- 75
0
votes
0
answers
24
views
Magento 2 error when export orders CSV
when going to export orders in CSV I'm getting the below error. Someone can please help?
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous, query ...
- 43
-1
votes
1
answer
96
views
Order related emails are not being sent in Magento 2.4 (Resolved)
We are using Magento 2 SMTP Plugin for mail communication.
Magento 2.4 is sending user registration, forget password, email confirmation, abandoned cart emails without any issues.
I have created and ...
- 1
0
votes
1
answer
75
views
Magento 2 – Item with the same ID already exists
I am getting this error when try to open product Report. Anyone can help me on this How to i can fix this issue ?
Thanks
- 362
0
votes
1
answer
20
views
How to move order items column in Magento 2.4.2
I want to move order item custom column after qty column in admin. So how can i move it. Can you see my screenshot.
THANKS.
- 3,247
0
votes
0
answers
25
views
Set different email template when order price amount is more than 90
I am using magento 2.3.5-p2 Community Edition
I want the system to send a different email template when the user's new order totaling amount is < 90 and >= 90, there will be 2 template
if the ...
0
votes
4
answers
184
views
Magento 2 : Create script to archive orders
Is there any way we can archive orders in Magento 2 community edition?
What are the steps to create one?
Which things are needed to manage it?
- 2,679
0
votes
0
answers
30
views
Magento 2.4.3 issue in admin order totals
I am using a module which calculates shipping rates with product weight. It sum up weight of each ordered product and returns total weight for each order.
It seems that if there is a configurable ...
- 932
0
votes
0
answers
25
views
Is there any best practice on the integration of Adobe Commerce Cloud and Treasure Data?
We are considering using the Treasure Data Platform to process the order data and then when users open their page, the results of processed order data should be directly shown at the EC site (Magento ...
- 5
0
votes
1
answer
167
views
Get order by date and status filters in magento 2 with rest api
Get Orders details using rest API with filters status and date range in magneto 2.4
- 1,069
0
votes
0
answers
19
views
How do I write an SQL query for Orders by SKU with Shipiping to California between X and Y dates
I can't find a way to generate a table or report that will get me
Orders by SKU with Shipping to California between X and Y dates.
Anyone ever tackle this without an extension.
Thanks so much :-)
0
votes
0
answers
49
views
Magento 2 - How to get order items custom options
I need to get order item's options but I can just get the info_buyRequest instead of additional_option when I use
foreach ($order->getAllVisibleItems() as $item) {
$options = $item->...
- 41
0
votes
1
answer
51
views
ordernumbers only odd numbers
I will get for an order number only odd numbers.
How can I change it that I will get all numbers.
For example I will get only numbers like:
#000000551
#000000553
#000000555
.....
My table looks like:
...
- 17
0
votes
2
answers
189
views
Magento 2 : How to calculate discount and shipping charges to programmatically created order?
I'm creating an order programmatically. I have added cart price rule in backend for subtotal above 1000 will get 30% product price discount on product
When generating order(programmatically) as a ...
- 1,856
0
votes
0
answers
10
views
Admin order view almost empty after upgrading to 2.4.3?
After upgrading from 2.2.6 to 2.4.3 the order view is missing lots of details. This is how it looks: https://i.imgur.com/zVRlYIb.png
Any idea what the problem might be? I checked the logs, nothing ...
- 59
0
votes
1
answer
12
views
Magento 2 Add additional fiels to sales_order and pass addData before save
I am doing a custom order placement based on the API data I receive, I have to introduce the new column on the sales_order table whet I have to add them before order save using addData or setNewfield, ...
- 434
0
votes
1
answer
134
views
How can we resolve the sales order filter with sku gaves "Something went wrong with processing for sku colum....." in Mageto 2
The Sales Order Grid Not Working And It's Gives this kind of error when search by sku
"Something went wrong with processing the default view and we have
restored the filter to its original state....
- 307
0
votes
0
answers
19
views
magento2.4.3-p1. back end. Select customer and View Orders. An error message appears
A Message is displayed : "A technical problem with the server created an error. Try again to continue what you were doing. If the problem persists, try again later."
Have you experienced ...
- 41
0
votes
0
answers
37
views
Sort order collection based on a custom product attribute
I am trying to sort an order collection (\Magento\Sales\Model\ResourceModel\Order\CollectionFactory) based on custom product attribute data for the product items in the order. It is ok just to sort ...
- 1,309
0
votes
2
answers
144
views
Sort order products in categories by custom value attribute first in Magento 2
I want to sort products with custom value (1) numeric attribute. In toolbar.php:
if ($this->getCurrentOrder()) {
$this->_collection->addAttributeToSort(
$this->getCurrentOrder()...
- 15
0
votes
0
answers
17
views
Error with region after buy product
When i try get temp order after buy product:
protected function getTempOrder($customer)
{
$address = [];
if(!empty($customer->getAddresses()) && $existingAddress = $...
- 67
0
votes
0
answers
16
views
Magento 2.4.1 Qty not decrease after order placing or completing order and not descrease qty from selected store/source
I have a Magento2.4.1 setup and I have a problem with when placing the order it doesn't decrease the qty at all after placing an order or even after invoicing or after delivering it. The Qty doesn't ...
- 1,187
0
votes
0
answers
21
views
Is there is a way to Migrate orders from Magento 1.9 to Magento 2
I have two websites Live is on Magento 1.9 and stag. is on Magento 2 which i have recently migrated.
and by my mistake my client has deleted all orders from Live site ( Magento 1.9 ) is there is a way ...
- 566
0
votes
1
answer
49
views
Magento 2 Error while canceling the order
I'm facing the below error while canceling the order
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magentodb`.`...
- 1,856
0
votes
0
answers
28
views
How to remove tracking popwindow in Myorder magento2
How to remove the popupwindow of track the shipment.I wanted to show, When user click the trackshipment link then redirect to the trackinglink of the carrier.
- 1
0
votes
1
answer
15
views
How to convert raw Join Query into Magento Join Query
Here is my query..
$query = "select * from sales_order AS so join sales_order_item as soi WHERE so.entity_id=soi.order_id AND so.status IN('pending','processing') AND soi.item_id NOT IN ( select ...
