Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
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
167 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
177 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
35 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
103 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
308 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?
2
votes
2answers
231 views

How reorder verifies guest and logged in user

When customer or guest uses "reorder" Magento2 somehow verifies, that user has access to order details (either logged in person owns order or guest verified that it is his order through /sales/guest/...
1
vote
1answer
36 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
20 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 ...
1
vote
0answers
31 views

Filter a custom attribute in Order Grid

I added new attribute and new column to Order Grid : [vendor]\[module]\view\adminhtml\ui_component\sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www....
0
votes
1answer
34 views

Order Emails are not generated :: SMTP configurations required :: Magento community open source

Magento 2.3.1 PaymentGateway: Fatzebra OS: Ubuntu 18.04 Environment: Dev I have used following code from here: https://magecomp.com/blog/send-order-confirmation-email-after-successful-payment-...
0
votes
0answers
6 views

Order shipment creation takes around 2 mins in magento 2

While creating shipment for order in magento2 is very slow. It takes around 2 mins for complete the process. How to solve this.
0
votes
1answer
79 views

Set default filter for Customer grid during order creation in Magento2

I added a Customer Group column in Customer grid during order creation for Magento2, Then I filtered this grid base on Customer Group. Customer grid filtered and it is working fine but module ...
2
votes
2answers
453 views

Custom order status not working like magento predefined order status

I created a custom order status like below.(This is a big issue that i am simply missing some small stuff and hope to figure out with the help of a member). config.xml <sales> <order>...
1
vote
2answers
736 views

Orders belongs to custom created order status is not showing in my account recent orders?

I created a custom order status like below. config.xml <sales> <order> <statuses> <backorders translate="label"> <label>Back Orders<...
0
votes
0answers
32 views

Magento 2 - Sales email template override don't work

I customized store email template on the theme (header, footer, and content by module), however, those related to orders (Magento_Sales) aren’t working and display the LUMA theme email. The other ...
2
votes
1answer
149 views

Add a new column of “Customer Group” in a Customer grid during order creation

I want to add a Customer Group in a Customer grid during order creation For Magento2. I made [vendor]\[module]\view\adminhtml\layout\sales_order_create_customer_block.xml like this: <?xml ...
1
vote
2answers
788 views

Get all orders of customer by email id Magento 2

How can I get all orders of a customer via his/her email id who is logged in, I am using current session to get user's email id public function getCustomerData() { if ($this->_customerSession-&...
2
votes
2answers
4k views

How to export orders in csv file?

I'm new on Magento. How to export orders with code SKU price etc. I read the link below but didn't get where to add this code and how this code works please help. Programmatically Export Sales ...
0
votes
2answers
103 views

How to get value from sales_flat_order_item table using quote_item_id?

Using the sales_order_place_after event in my custom Observer. I have the quote_item_id value (example 324). How to get the corresponding item_id value from the sales_flat_order_item table? I am ...
3
votes
1answer
101 views

Mass Action: Bulk invoice - Shipping charges issue

I have created mass action in order grid to create bulk invoice. And after successfully creating invoice on multiple orders I am facing issue with shipping charges. i.e, for first order it is adding ...
2
votes
1answer
2k views

Magento 2 Override Magento sales order totals block

I am trying to override Magento 2 sales order totals block. I am setting preference for the same in my custom module as the function to be overridden is protected function, please find code below: &...
3
votes
1answer
292 views

Magento 2 - How to add admin username in order comments on admin action

I need to add admin username in order comment history whenever I create invoice shipment and On Cancel order.
2
votes
2answers
538 views

Order Status Processing after Shipment and Generate Invoice also Invoice status showing pending in Magento2

Shipment completed and generate invoice but order status showing Processing and invoice is in pending. Also invoice showing a Capture button. why? Anyone Know?
2
votes
0answers
19 views

$order->getCustomerName() returned ?? for unicode customer name

Under Magento EE 1.14, I have unicode characters in the customer name, the following code does return correct name in unicode for the first time: $order = Mage::getSingleton("sales/order")->...
0
votes
4answers
5k views

How to show additional column from sales_order_item to order view information

I'm trying to show additional column in the order view -> information page this is the url page : rootDomain/admin_an2/sales/order/view/order_id/40/key. From what I understand this data is coming ...
0
votes
0answers
22 views

Adding textarea to admin product view to show customers who ordered product?

I want to add a textarea to the Magento 2 admin product view which contains the customer ids of the customers who ordered that product. What would be the best approach? Has anybody done something ...
1
vote
0answers
127 views

Sales orders not showing for new Admin user in magento2

I have created new User here System -> Permission Assigned User Role as Administrator But when logged in with the new user which i created now, I can't see the orders for the newly created admin ...
0
votes
0answers
46 views

Cancel order item without cancelling order in magento 2

How to cancel order item without cancelling order in magento 2? Is it possible
0
votes
0answers
59 views

Magento2 Split Order Functionality

I am using b2b marketplace extension in my website. I need to split orders based on vendor id. I got one split order module https://github.com/magestat/magento2-split-order , which is splitting orders ...
2
votes
1answer
610 views

Magento 2.1.6 Cannot save shipment

Been testing the payment function, there are some test orders I made myself as a guest and a signed-in customer. But when I select Ship > Submit Shipment I get this error "Cannot save shipment.". ...
3
votes
1answer
56 views

Sales email layout not showing proper Magento 2

I am using clue theme for Magento 2.3.There is an issue with my all transactional email. Please check my order email layout. If i switch the theme to luma and check order email then it looks fine. ...
3
votes
3answers
440 views

Magento2 Check Order Was Created by Admin or Customer?

I want to check whether an order is created by an Admin or by the customer.
1
vote
1answer
856 views

Magento 1.9 — Add SKU column to Sales Orders Report

I am trying to add a SKU column to the Sales > Orders column. After looking at the article below, I was going to change the copy of core sales order grid (app/code/local/Mage/Adminhtml/Block/Sales/...
3
votes
1answer
338 views

Magento2 : add New address type to customer

I want to Create a new address type "neighbors address / alternate address " . To assign it to customer i have created new customer attribute ( just like "default_shipping" and "default_billing" ) "...
1
vote
0answers
25 views

Magento2.3 SetTemplate is not working first time ajax

I would like to add additional some field info in sales_order_create_index.xml I used setTemplate: <referenceBlock name="data"> <action method="setTemplate"> <...
5
votes
1answer
1k views

How to create shipment using API (SOAP V1) with specific items in it?

I'm looking to find how should array of items look like. I have found an example here: $orderIncrementId = '200000006'; $itemsQty = array('3' => '3', '4' => '5'); $result = $proxy->call( ...
0
votes
1answer
2k views

The requested Payment Method is not available

I'm trying to create order programmatically by following code but getting payment not available. $customer = Mage::getModel('customer/customer')->load($data->user); $quote =Mage::getSingleton('...
2
votes
1answer
78 views

How do I add the manufacturer attribute to sales_flat_order_item?

Hi we use the manufacturer attribute a lot. And often in code we have to grab it separately because it is stored as a product attribute. question: Is it possible, just like the flat_catalog tables, ...
1
vote
2answers
125 views

Magento 2.3: How to attach a pdf file with new order mail?

I am using magento 2.3.1 I need to send a pdf with new order mail, I have already done that for magento 2.2.6 but that is not working with 2.3. Can any one help me with this?
2
votes
1answer
338 views

Magento 2 - Reverting cancel orders programmatically

For some reason order canceled in bulk through my customly added order cancel mass action. Now I need to uncancel all orders. Change status from cancel to the status that was previously set on order ...
0
votes
0answers
21 views

Magento 1 Authorize.net issue | order created from admin panel is getting redirected to front-end cart page

I am using a Magento 1 of version 1.7.0.2. Recently i update a patch for Authorize.net and right after that i started getting issues. Currently in the site with live Authorize.net credentials if a ...
0
votes
1answer
36 views

Magento 2 - Order Item changes

I want to inform customers with email all the details of their orders and I want to be able to show the difference. For example: Those items shipped: ... Those items cancelled: ... Those items ... ...
1
vote
2answers
156 views

Get order increment id in observer

I have created a module to save order details to a custom mysql table after checkout completion. All works fine but the order id saves in the format "210"(order_id) instead of "1000000210"(...
1
vote
1answer
37 views

Efficient method to load/get and assign multiple custom options/attributes from quote item?

Is there a more efficient way to load and assign quote item custom options/attributes? This is code in my Observer: public function MyFunction(Varien_Event_Observer $observer) { $QuoteObject = Mage::...
0
votes
1answer
43 views

Change Email Template On Specific Order Status:Magento2

I am trying to use different e-mail template for one of my custom order status when the status is changed from the admin. I have used the event sales_order_save_after <observer name="...
0
votes
2answers
34 views

How to get the items orders by the customer in the order collection?

I need to get the collection of orders with the the items ordered by using the customer ID. But I am not getting the items ordered in my collection. Please help. $objectManager = \Magento\Framework\...