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 [sales-order-grid]

Denotes questions regarding Magento Sales Order Grid

0
votes
1answer
24 views

Magento 2 Add Billing and Shipping Company Column on Sales Order Grid

I have added two new column ('Billing Company', 'Shipping Company') in sales order gird using below code. di.xml <type name="Magento\Framework\View\Element\UiComponent\DataProvider\...
1
vote
1answer
17 views

How save value in custom_attribute of “sale_order_grid”

I have to save value in custom_attribute(current_seller_id) in "sales_order" table. using event below code But now i want to save same value in custom_attribute(current_seller_id) of "sale_order_grid"...
2
votes
1answer
38 views

Getting order id for guest checkout order

I need to assign a Guest Order to a Customer, so i found this link How to assign a Guest Order to a Customer - Magento 2 Using SQL UPDATE sales_order SET customer_id = {YOUR CUSTOMER ID}, ...
0
votes
1answer
17 views

How to update sales_order_grid table in M2 production mode?

We have a working, well filled sales_order_grid table. But those orders we add via custom integration do not show up there - or show up, but with a very long delay. We found in the cron_schedule ...
2
votes
0answers
44 views

how to add Custom column with link in sales order grid magento

I want to add custom column in sales order grid. in the row data i want to add link using block render or using UI component.
1
vote
0answers
18 views

Magento 2: Add invoice Increment ID to Order grid

I am trying to add invoice increment ID to order grid in magento 2 admin like below: app/code/Payment/Status/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"...
0
votes
1answer
34 views

Remove sale order grid total count in magento 1

I am on Magento 1.9 and would like to remove one of the block in sales -> orders page See attachment. Can someone please show me which file that i need to edit in order to remove that? thanks in ...
1
vote
1answer
18 views

Magento 2 : Currency Symbol missing when exporting Saler Order Grid

I am exporting Magento 2.1.9 Saler Order Grid to CSV and XML formats using the provided buttons. But when I open the file in Excel the currency symbol is missing in Grand Total (Base) and Grand Total (...
0
votes
1answer
22 views

Adding Custom massAction to Orders Grid in Magento 2

I added the custom massAction to Orders List and it's executing my massAction method but it's redirecting to dashboard. for these I have written below code. protected function massAction(...
1
vote
1answer
67 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....
1
vote
0answers
21 views

Order purchase date filter range not showing expected results

Preconditions Magento 2.2.2, Nginx, Redis. Magento local timezone AEDT, server time AEDT mysql SELECT CURRENT_TIMESTAMP(); returns AEDT time SELECT @@global.time_zone, @@session.time_zone; returns ...
0
votes
1answer
33 views

add condition to collection join

$collection = $observer->getOrderGridCollection(); //get the attribute id of our custom eav $attributeId = Mage::getResourceModel('eav/entity_attribute') ->getIdByCode('catalog_product', '...
3
votes
2answers
234 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 ...
1
vote
0answers
47 views

Duplicate sales order grid to custom admin page

I need to copy the sales_order_grid table to a custom admin page. Is there a way to do so using Magento's API?
0
votes
0answers
21 views

Magento 2 - How can I add data to the array sent to my controller via mass action?

I have created a mass action and some columns in sales order grid in admin view. These columns are inline editable. How can I pass their values when clicking on the mass action to my controller and ...
0
votes
1answer
74 views

Show popup when clicking on custom mass action on sales order grid

I am new to Magento 2. I have managed to add a new mass action on sales order grid following some guides that exist out there. What I want to do next is when clicking on the custom mass action to show ...
0
votes
0answers
116 views

Magento2 : Add custom column in sales order grid

I have added a custom column in sales order grid, and it is also coming in export CSV file but at the first position. But I want to add it after id column (any place after id column) in CSV export ...
0
votes
1answer
725 views

Magento2 : sales order grid add new column with it's values

when order placed at that time in admin sales order check that there is a gift option available or not if it is available that dispaly "yes" in order grid column else display "no". please see ...
0
votes
0answers
88 views

Mage_Sales_Model_Order with the same id already exist

when I place an order, transaction completed successfully, getting order confirmation emails, and order is showing in my account dashboard, but in admin panel i can't see "sales/order grid", its ...
0
votes
0answers
53 views

Magento 2 join 2 table of sales for Order Custom Grid

I am trying to merge two sales table. One is sales_order and second one is sales_order_item. following etc/di.xml. <virtualType name="Namespace\Module\Model\ResourceModel\Item\Collection" type="...
0
votes
0answers
269 views

Magento 2 block page Not registered handle

I have created a module, from that the super admin can assigns an order to the sub-admin, the sub-admin can only view that assigned orders. for that in sales_order_grid table, I have added two ...
0
votes
0answers
40 views

Magento1.9 : How to add a custom button in sales page in the admin to change pending order status ?

How to add a custom button in the sales orders page in the admin. this button will change the pending order status without entering the order. Please check this image will describe what I need to do
1
vote
1answer
87 views

How to get billing address from sales/order_grid_collection?

I have sales/order_grid_collection where I'm getting the desired attributes on my grid, but the last one attribute I need is the billing street of the order, how can I get that programmatically? ...
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
42 views

Sales order: add custom value

we have 3 stores based in one Magento2.2.1 installation, each store uses own theme but admin part and theme is common. We need to see some custom value (carrier pickup point) in Sales Order, so we ...
3
votes
1answer
685 views

Hide or remove column from sales order grid

I want to hide or remove Purchase Point column from sales order grid in backend using custom module, how do i do this?
0
votes
1answer
163 views

Company Column on Sales Order/Invoice/CreditMemo/Shipment Grid

I have built a module to show the Billing and Shipping Company Name in the Admin Grids for Order, Invoice, CreditMemo, and Shipment. I still can't believe this is not built into Magento2. At first I ...
1
vote
0answers
92 views

Company name in Billing and Shipping Columns On Sales Order Grid

I need to know how to insert company name for Billing and Shipping Columns on sales order Grid in Magento admin, also Company name need to display on both billing/shipping columns under Sales shipment ...
0
votes
0answers
49 views

How to add Image to Column header in sales orders admin grid in Magento 2

Is it possible to add an Image to column header from custom module
1
vote
1answer
811 views

Magento 2: admin sales grid, filter column from sales_order table

I have added a column "rescue_order_name" in sales_order table. Now i want to display the values of this column in the admin panel, sales, order grid and give the option to the admin to filter ...
1
vote
2answers
685 views

Magento 1.9 : sales_flat_order and sales_flat_order_grid tables are not updating

I used many update methods for update values in sales_flat_order and sales_flat_order_grid tables.but no method didn't work. I don't know why the update is not done. Method 1:- $coreResource = Mage:...
3
votes
0answers
126 views

Magento 2.1.5 - Sales Order reports show missing data

I am having issue with order sales report its skipping some data from monthly order report, Some order dates are missing in reports but in order gird it displays same dates order Magento: 2.1.5 ...
2
votes
2answers
585 views

Magento 2.1.9 : Product Details Column in Sales order Grid

I need to extra column to Sales Order Grid that displays product name or product SKU.
3
votes
1answer
336 views

Magento 2 bar disappeared in Sales Order Grid after adding column

My custom module adds a column to the Sales Order grid. The problem is that the bar above the Grid disappeared. This is shown in the screenshots. With my module: Without my module: In order to add ...
0
votes
1answer
350 views

backend sales order view filter are not working in magento 2?

Sales order view page, we have added some custom columns, but filters are not working. Please, check below screen-shot. <?php /** * Copyright © 2016 Magento. All rights reserved. * See ...
0
votes
1answer
46 views

Why my sales aren't showing in Magento 2 Admin Panel?

I can see my sales in sales_order table, though, I can't see in sales_order_grid. I guess that it's some related to it, how can I solve it?
2
votes
0answers
204 views

Company Column on Sales Grids (Order, Invoice, Shipment, Credit Memo)

This is a continuation from my previous question: Billing and Shipping Company Column on Sales Order Grid I was able to place the Ship-to and Bill-to Company Columns on the 4 Sales Grids, but I am ...
1
vote
1answer
183 views

Billing and Shipping Company Column on Sales Order Grid

I am able to show either the billing or shipping company for an order but I can't seem to grasp how to show both at the same time. Here are my files to show billing company name. etc/di.xml <?...
1
vote
2answers
3k views

Magento 1.9 add custom button in admin order grid page

i need to add a custom button on admin sales order grid page like this:I'm trying to create a module for this using this code in my config.xml file: <adminhtml> <events> ...
3
votes
2answers
1k views

Magento 2 how to pass order id's from sales order grid to my module controller

I am working on a custom module. I need order data in my own controller. I want users to use the checkboxes to select orders so i can use the order id's/data in my controller. How do I do this? What ...