We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
2
votes
1answer
20 views

Magento2 - Filter order grid by multiple order id's

I need to filter the order grid by multiple order id's. So the when i enter comma separated order ids in the id filter it should filter by these ids and give result.
0
votes
1answer
12 views

Change date format of date filter in all admin grids

I'm a magento newbie. My client asked us to change date format of date filter in all admin grids. He needs to change date format to display as dd/mm/yyyy. Can anyone help to solve this? Thanks in ...
0
votes
1answer
9 views

Clickable mailto link in custom order grid?

Magento 1.7.0.2 This is how I show the mail address from my collection in my custom order grid: $this->addColumn('mail', array( 'header' => $helper->__('E-Mail'), '...
0
votes
0answers
32 views

Magento 1.9.4.3 Custom Column Filter not working

I have a custom column on my sales order grid showing the ordered items sku's. Done by following the guide here. It worked well in previous versions but no longer does work correctly in 1.9.4.3. When ...
0
votes
2answers
55 views

How to debug 'something went wrong' in magento2

I installed magento2 2.2.10 version and installed custom modules. At begining it works finely after adding products , customers and place an order then it's not loading any admin grids(customers , ...
0
votes
3answers
727 views

Billing name order in billing_name column in sales_flat_order_grid table

Can someone please tell me when a record is pushed into the "sales_flat_order_grid" table? How can I switch first name and last name in "billing_name" column of this table?
0
votes
2answers
713 views

Error: Export orders to CSV - Correlation Name

I am getting the following error when trying to export orders to CSV but am none the wiser on how to fix it! EDIT: I am using an observer to add a Country column please see my module below, how can I ...
0
votes
0answers
24 views

Magento 2.3.3 | Order data migration - This order no longer exists

I was facing problem in order's data migration, sales order grid was showing empty after data migration process. I followed this link's answers in order to fix it. Now order grid datas are showing but ...
0
votes
2answers
27 views

Changing time / date format on order grid (or all grids)?

I found no way so far to change the date / time format on the order grid (or even better all grids where its relevant). I guess some XML magic is required here. Please take a look at https://prnt.sc/...
0
votes
0answers
58 views

Magento 1.9.4.3 order grid filter error

We use the following module to load the SKU inside the order grid in the backend. https://github.com/vovsky/ExtendedGrid/ This worked perfectly before we updated to the latest Magento 1.9.4.3. When ...
2
votes
2answers
78 views

magento 2 order grid loading issue after data migration

PHP Fatal error: Uncaught Error: Call to a member function getAdditionalInformation() on null in /var/www/magento/vendor/magento/module-sales/Model/OrderRepository.php:172 Verified found that file ...
0
votes
2answers
871 views

Renderer function not work in magento grid

I don't know what is the problem with my code. Gird $this->addColumn('category', array( 'header' => Mage::helper('udropship')->__('Cateogry'), 'index' ...
0
votes
0answers
58 views

Magento 2 Could not acquire lock for cron group: default

We just migrated our Magento 1 site to Magento 2. At some during the process, the default cron group stopped running. This was after data migration and possibly right after the first test orders were ...
2
votes
2answers
649 views

Add custom product attribute to Order Grid

I have an custom product attribute shipper imported with all the products, which show that the product shipper. I want to show this attribute on the Order Grid with values to know that which order ...
5
votes
4answers
1k views

(Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous

I added sku, country_code and product name in the order grid. All works fine but when I filter Orders by Created at it throws following error Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[...
0
votes
1answer
730 views

Custom filter in the sales order admin grid giving Invalid block t

I've been able to filter custom added column like 'seller name ' its get from seller id of product. other filters are working. $this->addColumn('seller_id', array( 'header' => Mage::...
0
votes
1answer
970 views

How to get the order html table and shipping address on success page?

I'm working on a customized success page and I would like to get that same table from cart to display on success page, I mean, it should contain product thumb, product name with configurable options (...
0
votes
2answers
1k views

Displaying columns in Sales Order Grid

I have the following code to show some extra columns in the sales order grid. It correctly shows the columns and data, but when I try to click an order it says "No order exists". I wondered if anyone ...
1
vote
2answers
59 views

Magento2.3.2 During data migration I got Only enties mismatch error . Only orders data in not migrated

My migration is from Magento 1.9.1.0 to Magento 2.3.2. I ran the below command : php -dmemory_limit=-1 bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-opensource/1....
0
votes
1answer
1k views

How to add column in admin sales order grid magento 2

I want to add SKU column, customer first name and last name in admin sales order grid. Please guide me how can I achieve this?
3
votes
4answers
2k views

Magento 2: how can I remove columns in exported csv from order grid?

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv. Payment Method Total Refunded Customer ...
0
votes
1answer
16 views

Magento 2: How to differentiate the app and web based orders?

How to identify whether the order is placed from an app or website? I want to add one custom column in admin sales order grid. And the column displays the values for order source(app or website order)...
10
votes
3answers
4k views

Magento2.1 ui grid, remove or clear filter issue (after removing filter, result row apply to whole collection)

I created ui grid in magento 2.1.0 and facing issue while removing filters or clear all filters from ui grid. My filtered result occupies whole grid means same row repeated in the whole grid after ...
4
votes
1answer
2k views

Create order programmatically for the items on cart on checkout page

I am successfully creating the order in the Magento dashboard with the below code. //for order $id=3; // get Customer Id $customer = Mage::getModel('customer/customer')->load($id); $transaction = ...
7
votes
2answers
2k views

Magento 2 + Custom column added sku on grid not showing data in export file

I have added sku column on sales order grid using following steps, Package\Company\view\adminhtml\ui_component\sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:...
0
votes
0answers
49 views

Magento 2 orders grid not loading

We have migrated data from M1 to M2.3.1 EE successfully but facing an issue below when open orders grid at magento2 admin end. Attention Something went wrong. Something went wrong with ...
6
votes
2answers
2k 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"?>...
4
votes
2answers
1k views

How to create custom grid like sales order in magento2?

How to create custom grid like sales order gird with new,edit,save,delete,status,massdelete..etc in magento2.?
0
votes
1answer
722 views

Magento 2 Add new column tracking/mobile number to sales grid

Hello guys I need your help to know how to add new column "tracking/mobile number" to sales grid.
0
votes
1answer
1k views

Product name and order shippment method, on the order grid

I'm trying to add the Product Name, Product SKU, and Order shipment method, to the Sales Order Grid. this is how my function looks: protected function _prepareCollection() { echo $collection = ...
0
votes
1answer
799 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 ...
7
votes
3answers
6k views

Add More Mass action in Order grid in magento2

I want to create delete order functionality in magento2, but i am not able to add mass action in order grid. please help me how to create delete order functionality in magento2. Please help me if any ...
0
votes
1answer
70 views

Get order_id in UI Component GRID in a new Sales View Tab

After a lot of tries, I couldn't manage to get an order_id to an Admin Grid Data provider. This is the code I have To add a new tab to order view view/adminhtml/layout/sales_order_view.xml <?...
0
votes
1answer
685 views

Add custom column to the Order Grid for export

I want to add some custom field like sku to add in order grid to export along with the order. I follow this link Add custom product attribute to Order Grid to do this, but this didn't work in this ...
1
vote
0answers
32 views

How to create Filter for custom field in Sale Order Grid magento 2

This is my grid sale order grid have custom field Ready To Ship This is my error Because Ready ship not in database. I just check condition to return Yes/No Now, how can filter custom field Ready ...
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 ...
0
votes
0answers
17 views

Magento 2.2 option products of bundle are considered as simple product in pagination My Order

With reference to the question Magento 2 option products of bundle are not showing in my orders magento core I have removed the following line to get Bundle products option list my order grid. ...
0
votes
1answer
267 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 ...
5
votes
1answer
131 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
24 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. ...
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 ...
2
votes
1answer
228 views

Magento 2 Admin Grid Date Filter

Using Magento 2.3.1 When admin locale is en_GB it processes dates wrong. For example filtering orders by date. The date pickers work correctly so the 1st May comes out as 1/5/2019 but Magento ...
0
votes
0answers
76 views

Magento 2 Migration: Volume Check Failed, sales_order_grid Source

[2019-05-29 00:10:23][WARNING]: Mismatch of entities in the document: sales_order_grid Source: 91764 Destination: 0 In Data.php line 145: Volume Check failed
0
votes
2answers
129 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
22 views

Magento 2.2.3 order listing page too slow in admin

I am using Magento 2.2.3 it is in production mode. The order listing page in admin loads very slow. I have been facing this issue since long. To debug this I have also tried enabling query log ...
0
votes
0answers
24 views

Set a default filter for Order Grid

How can I set a default filter for Order Grid programmatically? I read many different answer but they don't work properly.
0
votes
5answers
3k views

Show SKU and Product Name in Sales_Order_Grid?

I have been stuck for hours trying to add both Product Name and SKU to the Sales Order Grid in Magento. I have created the joins and added the columns but the no data is being displayed and can't ...
0
votes
1answer
74 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 ...
1
vote
1answer
125 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 ...
2
votes
1answer
98 views

I can see attribute in Catalog -> Products grid but how to Shown Product attribute in Sales -> Orders grid in magento 2

I have created a custom attribute "item location" for every product. It was created in Stores -> Attributes -> Product, then assigned to the default attribute set. So every item has its own ...