Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [orders]

Mark questions related to Magento orders

Filter by
Sorted by
Tagged with
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.
user avatar
  • 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. ...
user avatar
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 ...
user avatar
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: ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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
user avatar
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.
user avatar
  • 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 ...
user avatar
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?
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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
user avatar
  • 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 :-)
user avatar
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->...
user avatar
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: ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
  • 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....
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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()...
user avatar
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 = $...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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`.`...
user avatar
  • 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.
user avatar
  • 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 ...
user avatar
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?
user avatar
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 ...
user avatar
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 ...
user avatar
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
user avatar
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
user avatar
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
user avatar
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 ...
user avatar
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/...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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\...
user avatar
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.
user avatar
  • 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 ...
user avatar
  • 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 :)
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 109

1
2 3 4 5
45