Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

Magento2 Grid: Select all disabled with two dropdown filters

A client running a magento 2.3.2. store noted that he can not use the Select All when two Filters are enabled. This pertains to the Magento Grid with orders on the Sales page. The filters the client ...
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 ...
0
votes
0answers
16 views

Custom filter in order grid

I'm trying to add a new field to order grid with custom filter. Right now I managed to make it work, but I want to add my custom filtering rule. I added the column to db_schema.xml and in my module'...
0
votes
1answer
2k 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?
0
votes
0answers
18 views

Magento 2 in admin grid display order table data

Magento 2 in admin grid display order table data. How to display this? can you give me any suggestions please?
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 = ...
0
votes
1answer
892 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 ...
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
27 views

Magento 2 : Add product category filter in order grid

In admin I want to add product category filter in order grid so that admin can filter by category and processed the order. Please help me guys. Thanks
0
votes
1answer
804 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
21 views

How to show the column from sales_order in the sales grid admin Magento 2.3

I want to show the column and it's data from sales_order in the sales order admin panel magneto. How to show this.
0
votes
0answers
16 views

Something went wrong with processing the default view and we have restored the filter to its original state in order page

something went wrong alert is showing multiple times and blocking the order view. I have cleared the table ui_bookmark table multiple times and cleared cache. still issue persist. Plese suggest a ...
0
votes
0answers
13 views

UI Component: How to filter a custom column with data generated by logic?

I added a custom column named Payment Code to order listing page in admin: <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
0
votes
1answer
754 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 ...
0
votes
3answers
780 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?
1
vote
2answers
186 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 ...
10
votes
3answers
3k 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
17 views

Missing some orders in order grid magento1

I'm using paypal payment method in Magento 1 and some of the order are missing in the grid view but it is available when I find threw transaction record. For instance the order id is 1111 now if I ...
0
votes
2answers
740 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 ...
2
votes
2answers
993 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 ...
2
votes
3answers
391 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 ...
2
votes
1answer
1k 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 ...
0
votes
1answer
743 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
0answers
15 views

magento 2 backend order grid search

While trying to look for orders in the backend and using the search function on the sales order grid i noticed that the search function can only find an order when searching for the full field. for ...
0
votes
1answer
1k 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
0answers
9 views

How to make Sales Order Grid “status” Filter working with custom Default Status Filter

I have added status filter to order grid using filterUrlParams method by passing the status value in url. But I am facing issue when i am trying to apply status filter, its gives no result. I need to ...
0
votes
0answers
89 views

“Something went wrong with processing the default view and we have restored the filter to its original state” when filtering orders?

After updating from 2.2.3 to 2.3.2 I am getting the error Something went wrong with processing the default view and we have restored the filter to its original state. whenever I try to filter orders. ...
0
votes
1answer
64 views

Magento 2 Multiple Sales Order Grid(Duplicate) as per order Status

I am looking for solution for multiple sales order Grid as per order status. One grid will have all pending order and another grid for Processing orders. Please have a look attached screenshot. how ...
0
votes
0answers
11 views

purchase orders are processed in grid table view but in of detail order it shows completed in magento 1.9

I am using magento 1.9.In history some entries are looks processing but in details of this purchase order it is completed.All entries are from last year. How may I get resolution for this.
0
votes
2answers
63 views

Magento 2 Getting error when switching order grid to show 200 rows per page in admin

In Admin->Sales->Orders, I can view orders with no problem, but as soon as I choose to display 200 rows, I got the following error, Something went wrong with processing the default view and we have ...
1
vote
0answers
38 views

Add customer orders count to orders grid

I'm trying to add customer total orders to orders grid in magento 1 admin. There is a lot of solutions already answered, but they all count orders only for registered customers and it is not working ...
2
votes
1answer
40 views

Magento2 admin panel ordered product link

How to add products link in magento2 sales=> order tab in admin panel? Also I want to add custom attribute to order grid in admin panel. for example want to add type(custom attribute) to admin panel ...
0
votes
0answers
66 views

The store that was requested wasn't found. Verify the store and try again in orders grid Magento 2

When I navigating to Admin dashboard -> Sales -> Orders. I am having this issue "The store that was requested wasn't found. Verify the store and try again." I cannot able to see my orders list, I can ...
2
votes
1answer
104 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
29 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
14 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
2answers
131 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
0answers
70 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
126 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
93 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 ...
0
votes
2answers
1k 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' ...
5
votes
4answers
2k 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[...
1
vote
2answers
92 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....
4
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
40 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)...
12
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 ...
0
votes
0answers
148 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 ...
5
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"?>...
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 = ...
7
votes
3answers
7k 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 ...

1
2 3 4 5
7