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
24 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
60 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
21 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 ...
3
votes
2answers
286 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
26 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
28 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
54 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
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....
0
votes
1answer
37 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
26 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
85 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
24 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
31 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
14 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
138 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
59 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
117 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
229 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
38 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
71 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
13 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
158 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
68 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
329 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
0answers
98 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
8 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?
0
votes
0answers
200 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
71 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
168 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
91 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
22 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
73 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 ...
-1
votes
0answers
37 views

Magento2 : How to add custom filters to order reports?

New to Magento2 and I'm having a bit of trouble, on our store we host products and services that our department offers and products for other departments. However we'd like to generate order reports ...
2
votes
0answers
141 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
349 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
22 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 ?
0
votes
0answers
22 views

Altering Old Order Increment ID's in Magento 1

I've had a request to alter the order increment id's (numbers starting 1000xxxx, 2000xxxx for example) for some older orders that are in the system. The reasoning is because there was an ...
0
votes
0answers
28 views

Facing issue in Magento 1

We have added the column in Order Grid --- we have named as order items and below is the code, it was working fine suddenly its appearing in the backend (the menu is missing) can you let me know if ...
0
votes
2answers
29 views

Remove Website and Website Group from Order Grid

How can I remove "Main Website" and "Main Website Store" from admin order grid? I need to have only Store Name example "Italia" or "Asia" etc
0
votes
1answer
485 views

Magento 2.2: Order, Invoice, and Shipment do not display in admin grid

I added a product to the cart and create order. It displays properly on the front side in "My Order" tab. But, when I checked in admin side order grid, then records not updated in order grid. I have ...
0
votes
0answers
21 views

Magento 2 - Purchase Order Templates

I would like to split purchase orders away from standard orders in two ways. I would like to have a seperate tab for purchase orders so they wont be shown in the usual grid on sales/order/index I ...
0
votes
0answers
109 views

Magento 2 Sales Order View Grid

I have created a new module which has it's own custom database table and creates a new tab. What I would like is a Magento Grid for this new tab but I am unsure how to pull the data from the Model or ...
0
votes
0answers
26 views

Magento 2 Admin - Create New Order

I am struggling to configure the Create New Order product grid in Magento 2. When you click the button Add Products and the product grid appears it is showing all products. How can I update so only ...
0
votes
1answer
186 views

Magento - Set default filter of customer attribute in order grid

I've just managed to include a custom customer attribute in the order grid columns like this: $agenteAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'agente'); $agenteTable =...
1
vote
0answers
24 views

Problems on checkout with a particular product

I have one product that is a cause for concern when checking out. Whenever this product is in the cart the checkout throws many popup alerts. I'll link images to help with visuals as I go through ...