Questions tagged [orders]
Mark questions related to Magento orders
2,215
questions
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
9
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
1
answer
31
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
14
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 ...
- 65
0
votes
0
answers
14
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
31
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
24
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
- 340
0
votes
1
answer
16
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,167
0
votes
0
answers
10
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
152
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,705
0
votes
0
answers
18
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 ...
- 902
0
votes
0
answers
21
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
38
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,059
0
votes
0
answers
13
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
15
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->...
- 39
0
votes
1
answer
50
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
59
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,838
0
votes
0
answers
9
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 ...
- 29
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
52
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
14
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
24
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,280
0
votes
2
answers
68
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
15
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 = $...
- 57
0
votes
0
answers
15
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
15
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 ...
- 526
0
votes
1
answer
31
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,838
0
votes
0
answers
17
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 ...
0
votes
1
answer
30
views
How to get ordered product count in magento 2.4
How to get ordered product count of product. I want to how many product is there in that order?
- 1,959
0
votes
0
answers
17
views
Magento 2 (My Orders) - Logged in user able to view other users order by passing the order id on the URL
Magento 2 - I'm new to Magento Logged in user is able to view other users orders by changing the order id on the URL. How to restrict this?
Also, I'm showing the CSV option to download the order ...
0
votes
1
answer
103
views
Create Credit memo using API in Magento 2
I am using the console command to delete an order item so I need also to create a credit memo based on the delete item price and refund the payment to the customer online using API.
I used the ...
0
votes
1
answer
53
views
Magento 2.4 Get tracking Information from order/shipment [closed]
Track My Orders Using Order Status in Magento 2
Pending as Ordered
Processing as Accepted
Shipping as On It's Way
Completed as Delivered
0
votes
2
answers
69
views
Magento 2.4 - product images & product names in the order history page on the customer account tab
I want to load product images & product names in the order history page on the customer account tab
0
votes
0
answers
15
views
Review Order is not working
When fetched all magento2 backend payment options on veniapwa theme frontend and then go to the checkout page and click on review order then button is disabled and place the order is not show
0
votes
1
answer
19
views
Some old random orders are associated to newly registered customer Magento 2.3.5-p2
I have a problem about customer's orders. When new customer registers there is a chance that some random order will be attached to it. If I go to customer's orders I can see that they got orders which ...
- 3
0
votes
0
answers
18
views
Error: Call to a member function hasErrors() on null
Error: Call to a member function hasErrors() on null public_html/vendor/magento/module-shipping/Model/Shipping/LabelGenerator.php:78 Stack trace: #0 /home/adminironcar/public_html/vendor/magento/...
0
votes
0
answers
125
views
Magento 2.4.3 | TypeError | While Making Shipment & Tracking
I'm using Magento 2.4.3, my code works fine on Magento 2.3.5, after the upgrade I got this error when I try to make shipment & tracking:
[2021-12-15 11:11:34] report.CRITICAL: TypeError: Argument ...
- 1,178
0
votes
1
answer
25
views
Admin input value is not accessible after adding the order increment ID while executing the command
I created a custom CLI command where I have to delete the order Items using the Order Increment ID, Item SKU.
I used the ask() method after executing the command php bin/magento webkul:orderDelete ...
0
votes
1
answer
107
views
Magento 2 Admin Orders Date show not actual result
I have Magento 2.4.2-p1 EE.
When i filter orders by dates, example: Purchase Date: 12/12/2021 - 12/12/2021
I have result with 777 found orders.
But on last page i can see orders with wrong dates for ...
- 93
0
votes
0
answers
59
views
How to get purchased order id for a gift card?
I am using Magento 2.4.3 enterprise edition. I have purchased a gift card and used it in a few orders.
Now I need to retrieve the gift card purchased order_id or increment_id using the gift card code ...
- 954
0
votes
2
answers
56
views
Shipping charges not showing on Totals admin order
I am trying to create an order from the backend side. after adding all details and selecting any shipping method the price adds to the total but is not visible on the order. Any way to override the ...
- 574
0
votes
0
answers
37
views
How to calculate some custom value in Order Total?
I need to calculate some custom value in the checkout summary section, for that, I have written some code In the model file,
but it was doing only Addition in the Order total. I need multiplication or ...
- 105
0
votes
0
answers
15
views
Product added to existing order does not merge and does not add when more than one item
order code does not merge the same products, but I include separate and even separate if you have more than one item and do not multiply the unit value by the quantity.
namespace Funarbe\...
1
vote
0
answers
27
views
How to validate Cart Price Rule in Custom Module?
I want to validate cart price rule in custom module.
- 13
0
votes
2
answers
88
views
Apply "OR" condition in Order Collection in Magento 2.4.3
How to apply "OR" Condition on Order Collection ??
Example:-
I want to filter order collection on these 4 date on order collection.
November 27, 2020
November 29, 2019
November 23, 2018
...
- 5,586
0
votes
0
answers
37
views
In a custom PHTML file add "Add products" Section in Magento 2.4.3
How do I add the "Add Products" section using a custom PHTML template file?
Thanks in Advance :)
- 5,586
0
votes
3
answers
49
views
Magento 2 How change ID for order?
I have order with ID = 00000188
UPDATE `sales_sequence_profile` SET `prefix` = '9' WHERE `sales_sequence_profile`.`profile_id` = 1;
And now my order ID = 900000188
But I want change to this format ...
- 93
1
vote
1
answer
51
views
Refund part order but don't refund shipping
at the moment I have a function which will refund the invoice on an order. However the shipping is currently also being refunded, which I don't want.
Is there a way to set the shipping to zero on an ...
- 109