Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
54 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
29 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
1answer
109 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
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
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 ...
1
vote
2answers
498 views

Magento2 : Add sales_order column coupon_code in sales order grid

In sales_order table we have a column coupon_code. I need to show it in sales order grid. I have added the column coupon code by overriding sales_order_grid.xml file. The column is being shown. Now I ...
4
votes
1answer
3k views

Sales orders is not displayed in admin panel in grid of Magento2.2.0?

After data migration process I see that orders data is not displayed in Magento admin sales grid. All data is available in the database. Than why data is not in sales grid? Anyone has idea about ...
3
votes
2answers
216 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
151 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
27 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
33 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
1answer
48 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 ...
1
vote
0answers
24 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 ...
12
votes
1answer
11k views

Magento 2 How to create new order attribute programatically

I've been searching the web on how to create an order attribute (if thats whats called), essentially I just want a new database column to appear in the sales_order database, obviously I could create ...
0
votes
0answers
33 views

How to get bundle options qty ? Magento 2

How to get bundle product options qty from $order->getAllVisibleItems() ?
1
vote
0answers
65 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
40 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!
0
votes
1answer
43 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 ...
0
votes
1answer
312 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 ...
2
votes
2answers
2k views

Magento 2.2 - Get product attribute value in order detail Admin

How to show product attribute value in order detail in Magento 2.2.6? I already tried below code but not working: File Path: public_html/vendor/magento/module-sales/view/adminhtml/templates/items/...
0
votes
0answers
52 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
2answers
6k views

Get order Details from Magento 2 Observer

I am trying to build a Magento 2 Order Observer in which I am trying to get the Product Details such as Product ID, Product Name, Product SKU, Product Quantity and Customer Details such as Customer ID,...
8
votes
5answers
13k views

Get Customer information from order Magento 2

I want to retrieve customer information from sales order view observer in adminhtml section, currently i only know how to retrieve order in that observer like this: namespace Namespace\Module\Block\...
0
votes
1answer
76 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
166 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
2answers
132 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 ...
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 ...
1
vote
1answer
159 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
99 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 ...
1
vote
1answer
774 views

Custom Order Status for Cancel not working

I have the following observer method thats been called successfully, but the order status is not changing. public function customCancel(Varien_Event_Observer $observer) { $order = $observer-&...
1
vote
0answers
284 views

How to check all order item already invoiced

Currently I can check if order already has invoice like this: $order = Mage::getModel('sales/order')->load('1'); $hasInvoice = $order->getInvoiceCollection()->count(); if($hasInvoice > 0) ...
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
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. ...
1
vote
1answer
100 views

Magento 2: How can change in the frontend sortOrder of Grand Totals and Tax positions in my account order detail page?

I need to change sort order in order_totals block in the frontend order view page. I want to swap the position of Grand Total & Tax in order_totals child items. Please help to change to order of ...
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
25 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
2answers
48 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 ...
0
votes
1answer
55 views

Magento 2:- How to add order export feature to seller dashboard?

I'm using Marketplace and there is separate dashboard for each seller from where seller can manage their sections e.g-products,stores,orders etc. for now,on order grid seller can't export the order ...
1
vote
1answer
1k views

How to add new input field in cart page in magento2?

In Magento2, I want to add/show custom input field in checkout page and save it to my custom field from Sales_order and Quote table in database.
1
vote
2answers
1k views

magento 2 get category id in ordered product

Magento 2 how to get Ordered product category id My problem is i have same product with multiple category so i want know which category product i place order based on order id <?php $...
3
votes
1answer
163 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
160 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
32 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
100 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')->...