Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [order-grid]

Questions specific to the admin panel order grid

1
vote
1answer
30 views

How to add custom column as link in sales order grid in magento 2

I wish to add a column as link in sales order grid. While clicking the link, I wish to perform some logic, I have reffered the below link for magento 1 which is based on layout grid add button inside ...
0
votes
0answers
10 views

Quantity Increments not working for creating orders in Admin

The product quantity box does not respect a configurable product's quantity settings when creating an order in Admin. It defaults to whole numbers regardless of product Qty Increment settings.
0
votes
0answers
16 views

Magento 2 - Call custom phtml before order grid

I want to show statistics graph in custom phtml. My question is, how can I call my custom.phtml before order grid
0
votes
0answers
22 views

Magento 2 How to add SKU in Order Grid with filter

I am trying to add SKU in sales order gird and also want to make it filterable. This is the code that i am using. I am able to add SKU in order grid and it is also working with sku filter as well. But ...
0
votes
0answers
15 views

Orders are placed in magento 2 enterprise even when transactions have failed

Some of our clients has faced some downtime issue due to which they tried to place order repeatedly as order confirmation was not being displayed. But when i verified CMS, multiple orders in ...
0
votes
0answers
28 views

How to add new column in order csv export

I am trying to add a new field called quantity to the order csv export, but I am not able to do it. With all the other fields that get exported, I want another column called quantity which shows the ...
1
vote
0answers
7 views

Is there any way to retain the entered customer billing/shipping addresses in magento admin once entered?

We see that the addresses of billing/shipping added to the order creation process gets erased if we remove all line items from the cart and then add back new product using "Add products by SKU" button....
3
votes
0answers
17 views

Magento2.1 payment method and shipping method on my orders of buyer panel

I want to show shipping method and payment method of my orders in my orders on customer panel. i'm using magento 2.1
2
votes
2answers
65 views

Magento2 filter not working for request parameter for order grid

I want to filter Sales Order query based on request parameter passed in querystring like following: http://127.0.0.1/website/admin/sales/order/index/key/...
2
votes
1answer
69 views

Why Order tab of Customer Information Section is not showing in Magento-2.2.7?

Order Tab is showing Blank when i click on the following path in admin panel: Customers->Edit(Particular Customer)->Click on Order Tab of Customer Information Section. This is the screenshot ...
0
votes
1answer
62 views

HOW TO ADD COLUMN TO 'Order Total Report' GRID and display custom customer data to new column in magento 2?

There are so many post discussing how to add column to sales order grid, but no one discussed about HOW TO ADD COLUMN TO Order Total Report GRID (REPORTS > Customers > Order Total) and display ...
5
votes
2answers
495 views

Add Phone Number column in sales order grid

I am trying to add phone number column in my order grid. I have added new column through sales_order_grid.xml in my ui_component directory. Code is below: <?xml version="1.0" encoding="UTF-8"?>...
1
vote
0answers
32 views

Magento 2.1.7 Create Shipping label popup in Order grid view

I am using Magento 2.1.7 inbuilt Fedex Create Shipping label in our client website. Is it possible to bring the "Create Shipping Label" side popup in Sales Order grid view? Currently, this button is ...
0
votes
0answers
43 views

Getting error when open any order Exception occurred during order load in Magento 2.2.2

I am facing issue when click on view order link in admin. Exception occurred during order load How can I fix the issue? I am working on Magento 2.2.2
0
votes
2answers
95 views

How to remove/hide columns from sales grid by default

How can I remove or hide some of the columns from sales_order_grid. For example I want to hide next columns: Purchase point Ship to Name Signifyd Guarantee Decision I tried with overriding ...
1
vote
1answer
127 views

How can i filter in sales order grid magento 2?

While i am using same code for filter it's working but i have break other grid like customer,invoice,cms page and get error "Not registered handle cms_page_listing_data_source" While i have moved di....
0
votes
1answer
55 views

Magento 2 save product custom attribute in order to retrive them on sales information and otder email

I have created a custom attribute that shows in product detail page like colour and size attribute, I want them to be saved on order placement so that i can retrieve them in order information, order ...
0
votes
0answers
28 views

Where can i find the device_name from which the order is placed in magento 2 db?

Need to know the list of the device names appended in the Magento platform and in which table is it rendering from? for example: "device_name": "Smartphone", "device_name": "Desktop"
1
vote
2answers
134 views

How to remove create an order button in sales order grid in magento2

i m overriding above code in di.xml file in magento2 <type name="Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory"> <arguments> <argument name="...
0
votes
0answers
35 views

Why does an order though Authorize.Net Direct post Method not update sales_order_grid or send e-mail?

I am using the Direct Post Method that is built into Magento 2, and when people order products, the order is properly made and entered into the database, and the products actually get shipped, but the ...
1
vote
0answers
33 views

How to add custom field beside Export To button in Magento2?

How to add custom field as shown in image in sales order admin grid in Magento 2?
0
votes
0answers
15 views

Magento 2: entity_id is 0 in sales_order_grid table for programmatically placed orders

I am fetching data from a webhook into my custom module's controller and placing order programmatically from the controller itself. I am able to place order successfully, however that does not reflect ...
1
vote
2answers
246 views

Payment Method Sales/Order grid - Magento 1.9

We load the following code to show the payment method inside the Sales/Order grid. But this displays the payment code and we want to display the payment title. How can we change our current code to ...
1
vote
0answers
78 views

Update/Refresh Magento UI grid column data only with Javascript (No Ajax)

We have created Mass Action status updates in the grid. Updating the status using the mass action, an ajax call will be initiated and updated the data in the server. Another ajax call will refresh ...
0
votes
1answer
162 views

How to get selected Order Ids in block from Sales Order Grid? Magento2

I want to generate PDF of selected orders, Rest of the functionality is complete just wanted to get selected Ids from sales order grid. For now I am getting full list of Orders on clicking my custom ...
3
votes
2answers
364 views

Magento2 Mass Action to Sales Order Grid

I am trying to apply a mass action to sales_order_grid but there is nothing happening. I have done so for is: vendor_name/module_name/view/adminhtml/ui_component/sales_order_grid.xml <?xml ...
0
votes
1answer
39 views

request sql bad with invalid quote

We are trying to migrate our code from magento 1.7 to 1.9 and I have an issue when i build a request with magento 1.9. I wrote this for a column on the order grid : $this->addColumn('id_po', ...
0
votes
0answers
90 views

Order Grid is not showing in Customer->Customer Information(Orders) Admin Panel in Magento-2.1?

Order Grid is not showing in Customer->Customer Information(Orders Tab) on admin Panel in Magento-2.1?Please check screenshot https://i.stack.imgur.com/j0kJq.png What is issue in this? Please guide ...
1
vote
0answers
40 views

client order detail page total due issue magento 1.9

i am using magento 1.9 i have created a rule for if order price is less then $5000 add shipping charges $10. its working fine but what i need is when the rule is applied than plus $10 into total due ...
1
vote
1answer
15 views

Override value of magento order grid column

I want to show only first name in bill to and ship to magento order grid. app/code/local/Mage/Sales/Model/Resource/Order.php /** * Init virtual grid records for entity * * @return ...
1
vote
1answer
220 views

Magento 2 Get Order Data In Order Email Confirmation Template

I have made a custom template to use in my order confirmation email template. I want to get the order data in this template so I can create a custom order grid layout. I'm not sure on how to do this?...
0
votes
1answer
97 views

magento2.2 order status doesnt match status in grid

There is issue for some orders status in grid doesn't match actual order state in order itself, for example order have status "processing", but some why appears as "pending in grid": same order ...
2
votes
2answers
493 views

Magento 2, add color style in Status column in sale order

Using Magento 2.2, Admin Grid. I want to add style to Status column in sale order. How to do this?
0
votes
0answers
17 views

1.9 - Code being carried over to next row(s) in Admin Grid

On my marketplace site, I have a grid for all orders that come in with a column that shows the name of the seller. I've also recently added a "Verification" system where users can verify themselves ...
0
votes
1answer
70 views

get order id on observer

this may seem a duplicate but I couldn't find one and been struggling with for quite some time now. I'm extending Order Grid with a Column on Admin panel. I have core_layout_block_create_after ...
0
votes
1answer
30 views

I have added custom field in sales_order_grid but cannot retrieve data by getData( )

I need to get order comment in order grid, but cannot retrieve data by getData( ) Upgrade script <?php namespace vender\Ordercomment\Setup; use Magento\Framework\Setup\UpgradeSchemaInterface; ...
1
vote
0answers
128 views

Include discount amount on subtotal in order export file Magento 2.2.2

I would like to export sales order from sales->Orders and the column subtotal(in csv and excel file) which should include the discount amount which we have apply while purchasing the product. for ...
0
votes
0answers
9 views

Only viewing orders / sales data from a customer group as an admin user

I have a few admin users and with some of them I only want them to view orders / sales data from certain customer groups. Could anyone advise how this would be possible?
1
vote
0answers
240 views

Error viewing Orders - Magento 2.2.5

When attempting to view an order in Magento 2.2.5 I receive the following error... Order View Information Changes have been made to this section that have not been saved. This tab contains invalid ...
0
votes
1answer
90 views

Increment id is not continuous in magento2

I have got a strange issue when I create a new product in backend my id is incremented +2 see the below image if i place the order .my order id also incremented +2 see the below image in my custom ...
0
votes
0answers
175 views

How I can Filter admin Order collection by status (Pending Only)?

How can I filter admin order collection and showing only pending orders in grid? So how can I extend it in custom module? Any suggestion about that?
1
vote
0answers
104 views

Change default select all to select all on this page in orders table in magento 2

I have local setup of Magento 2 Enterprise edition (ver:2.2.3) In the sales->orders table for mass action i need to select all on this page by default. Now if i click on the checkbox it selects all ...
0
votes
0answers
26 views

Extend order grid layout XML?

This is the layout XML: <?xml version="1.0"?> <layout> <add_order_grid_column_handle> <reference name="sales_order.grid"> <action method="...
1
vote
2answers
94 views

can not add shipping cost in order grid

my requirement is to add shipping cost in sales order grid,i added below code in _preparecolumns(), $this->addColumn('base_shipping_amount', array( 'header' => $helper->__('Shipping ...
0
votes
1answer
62 views

Magento 2 disable column in order grid if order have certain status

I want to remove Column Action from orders grid if order have certain status, how can I accomplish such behavior? Or if it will be easier I would be happy if I could delete this View hyperlink :) ...
2
votes
0answers
168 views

How to display customer telephone number on sales order grid table ? (Magento 2.2.0)

I want to display my customer telephone number checkbox here, so that I can see it in column section too, please guide how can I do this?
0
votes
0answers
405 views

MAGENTO 2 Orders Grid Add SKU and Export to CSV

I have created a module to add sku in orders grid it show all the sku associated to that order but the problem is when I exported to CSV the Sku column is empty! Does anyone know how to fill up the ...
3
votes
1answer
1k views

Magento 2 sales order grid custom column export csv issue

I have added a tracking number(custom field) column in sales order grid. It is displaying in sales order grid and export by XML also working fine. But while I export the data by csv only the following ...
0
votes
0answers
24 views

Change export order report time format

when we download the export order report, we found the time format in this format: Feb 26, 2018, 11:48:51 AM. can we change it to the different format like this: 2/26/2018 11:48?
0
votes
0answers
16 views

How can i get custom product attribute value on order grid admin without renderer?

How can i get custom product attribute value on order grid without renderer ?