Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
77 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
58 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
32 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
135 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
23 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
284 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 ...
1
vote
2answers
180 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
26 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
28 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
43 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
26 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
51 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
45 views

How to get bundle options qty ? Magento 2

How to get bundle product options qty from $order->getAllVisibleItems() ?
0
votes
1answer
39 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
41 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
80 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
52 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
2answers
373 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
402 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
65 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
108 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
217 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
21 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
183 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
188 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?
3
votes
0answers
45 views

How to correctly add an extra charge to a Magento 2 order's total amount?

We're using a custom module to calculate an amount we need to include in the grand total of the order, i.e. the customer will be charged for the product PLUS this custom amount. The result is our ...
0
votes
0answers
115 views

How to duplicate the grid of sales order according to client group magento 2

I want to have two grid of sales order i tried with this code but i have the error 500 : ` Magento\Sales\Model\ResourceModel\Order\Grid\Collection DistFilterPool ...
0
votes
1answer
31 views

Magento Shipping country ID is shown as NULL in the reports

I'm using PostgreSQL in my data ware house for reporting purposes, and for a certain report I have to show the sum of revenue for each month grouped by country. When i pulled the report the ...
0
votes
1answer
77 views

Magento 2.2.6 : Authorize.net not working. Giving Below Error

Argument 1 passed to Magento\Authorizenet\Model\Directpost\Request::__construct() must be an instance of Magento\Framework\Intl\DateTimeFactory This error is getting displayed when I am clicking on ...
0
votes
2answers
1k views

How to adding Custom Attributes to Magento 2 Quotes and Orders

I have followed this: https://www.siphor.com/adding-custom-attributes-to-magento-2-quotes-and-orders/ It works well when creating custom attributes and adding data quote but after checkout, quote ...
0
votes
0answers
46 views

order sale vs purchase order in Magento (not getting the difference)

I dont fully understand what is the difference between Sale Order and Purchase Order in MAGENTO. In my system i have 4 tables that are related to the Sale Order and 4 tables that are related to the ...
0
votes
0answers
11 views

How to save offline custom payment drop-down data in sales order and Display in sales grid

I created one payment method swipe machines. That swipe machine have a master. We are saveing Machine Name,Tid,Mid, Percentage in master. In payment section of swipe machine we are just looping data ...
0
votes
0answers
13 views

Magento 2 discount applied to all items in the order

Can someone explain why magento spread the discount to all items bought in an order even thought the discount was against 1 items. NOTE: the discount is spread only in backend order for the customer ...
1
vote
0answers
26 views

Magento 2 add custom shipping cost to order

How can i add custom shipping cost to the order here is the code. $shippingAddress = $quote->getShippingAddress(); $shippingAddress->setCollectShippingRates(true) -&...
0
votes
0answers
25 views

Magento1 admin order status update 404 error page

I have Magento1 website but when Admin panel Order Grid select any order then submit that order status update click on submit button show second page 404 error come. So solution please this problem. ...
0
votes
2answers
50 views

Magento 2 create Order programatically and set a custom date to it

I have a order to create an order in magento 2. But the order it create is with the date when i run the script. I don't want to save the current date for the order. I want to set a certain date to the ...
4
votes
1answer
180 views

Change quote currency before place order

I want to change my quote currency code to EUR when an order is placed in any other currency. I tried writing event and observer of event sales_order_place_before. In my observer I have this code ...
0
votes
2answers
203 views

magento 2 sales order grid add payment transaction column

How to add Payment transaction column to sales order grid in admin? Can you please help me step by step? Regards Hiren Shah
0
votes
0answers
13 views

Payment section on Order detail Page Magento 2

On the admin side, payment section (Order detail page) data is not showing. I am trying to override the default code or change the current code but couldn't find the proper class. Need guidelines for ...
1
vote
0answers
37 views

Magento2.3 how to add custom option of product when create order programatically? [duplicate]

I am using Magento2.3 I need to how to add custom option of product when create order programmatically? I used below code for add custom option to product but it is not working $product = $om->...
0
votes
1answer
133 views

How to get tracking number for items using order id for an order

I am getting the order information using $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $order = $objectManager->create('Magento\Sales\Api\OrderRepositoryInterface')->...
0
votes
3answers
418 views

How to get data from sales_order_item table in magento 2

I am new to Magento 2 and I want to get all data from sales_order_item table in Magento 2. How to get that can anyone answer?
1
vote
1answer
39 views

How to get tracking number and its title(FEDEX) for each item in Magento 2

I need to get a tracking number which resides in sales_shipment_track for each item in an order. Right now I am iterating all items of an order. foreach ($_order->getAllItems() as $item) { echo $...
0
votes
1answer
25 views

Invoice VAT - Non VAT

Placed an order with an incorrect VAT number, which then allowed me to submit my order as a Non-Vat customer. Is there any way to now change that order to a VAT customer and submit a new invoice ...
1
vote
0answers
20 views

Item level status in magento 2 via Netsuite

We have used Netsuite for items shipment tracking, now I don't know on which table of Magento 2, Netsuite updates item level status. Like for an order, there can be multiple items, and I have to show ...
0
votes
0answers
24 views

Get the list of most seller combined products with its orders

I want to get the most frequently sold product combinations, along with number of orders ( and Orders if possible). I have customized the Magento tables for my warehouse activities and the sample ...