Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
2
votes
0answers
177 views

magento 2 product custom attribute in Items Ordered Section

Please find the below requirement which i want. I have created a product attribute seller_demo dropdown and assigned to a product This attribute i need at sales order Items Ordered table like ...
1
vote
0answers
381 views

Filtration problem in order grid

I add a custom column to order grid but after that filter not working correctly and throws an error every time: A technical problem with the server created an error. Try again to continue what you ...
1
vote
1answer
485 views

Get all taxes in the orders grid

I have a list of taxes in Magento 1.9 and I need to display all this available taxes in the admin Order Grid. I found all this taxes in database in the sales_order_tax. Is there any way to display all ...
0
votes
1answer
380 views

Can't retrieve entity config: customer/group_collection

I'm trying to add Customer Group in the Order Grid. Please help. Below is my config.xml /app/etc/modules/Example_SalesGrid.xml <?xml version="1.0" encoding="UTF-8"?> <config> <...
0
votes
1answer
866 views

Magento 2 - Add tax_amount to Orders/Invoice grid

I would like to add the tax_amount to the orders and invoices grids to be able to have them in the export files. I found some documentation and tutorials on telling how to add a custom column, with a ...
0
votes
2answers
1k views

How to extend sales order grid using event observer?

I was extending my magento sales order grid and I was having an error with it because of a conflict with the other extension on rewriting the grid.
0
votes
0answers
545 views

1.9 custom category grid filter and sorting not work

I created to the category edit page a custom tab which allow the user to select one block and set for it a position. In my database I added a link table with the block_id, category_id and position. ...
1
vote
1answer
64 views

Magento 2 : Load/Get Orders by Direct Queries

I have multiple Order Id in foreach loop, and I want to load or get orders by these order_ids. I have used this code if ($requestName == 'sales_order_grid_data_source') { if ($result instanceof $...
2
votes
1answer
1k views

grid column filter based on existing values

In Magento 2.1.8 I trying to add a custom column to the admin order grid, that contains the cc_type field. Long story short, I managed to make the column appear, display the correct data, and be ...
2
votes
1answer
900 views

magento 1.9 custom order grid condition

Am using Magento 1.9.3. Here am creating a custom order gird in admin->sales->order table, those columns following Coupon Code Sliver Exchange Declaration In Coupon Code is used to showing ...
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[...
-1
votes
1answer
84 views

Hide completed order in magento 1.9 order panel [duplicate]

Please can anyone help me with step to step on how to create an observer on this page: Hide completed orders from sales/orders I have created observer.xml in app/etc/modules/ with the code below: &...
0
votes
1answer
1k views

Unable to get order details using magento 2 rest api

I have created an order in magento 2. And magento gave me this message "Your order number is: 000000235. We'll email you an order confirmation with details and tracking info." Screen shot is ...
0
votes
2answers
428 views

View action open blank detail page for an order in adminhtml

I get from a 3rd party orders that I save into sales_flat_order, sales_flat_order_grid, sales_flat_order_payment and sales_flat_order_address I can see the orders I create into those table in order ...
8
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
1answer
553 views

Which data to fill to show order in grid order row

I get some data and save it to the sales_flat_order and sales_flat_order_address . My issue is that I can't see my order created on the Magento grid order. Which data I have to fill or add to see my ...
1
vote
1answer
56 views

How to add the item_ID value next to item_SKU value at Admin view order for items ordered block?

By default Magento 2.1.6 shows the item description and the item_SKU , but I also want to add/show the item_ID field to it's first column. Any idea how to add it?
4
votes
0answers
799 views

Add custom dynamic column in sales order grid Magento 2

This solution shows how to add custom column to sales order grid, but to add a custom column you need to add the column via xml,the problem is i need to read data collection to get available column ...
9
votes
1answer
6k views

Magento 2 Filter not working while Custom column added on Sales Grid Using Ui Component

I have added Custom column track_number into sales>>Order grid at Backend. <vendor_name>/Sales/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> ...
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
2answers
1k views

How to add searchable column “shipping methods” into Sales/Orders admin grid?

To make my admin Sales/Orders grid better I added column to the grid: and as on the picture above it shows order delivery method but ... how to create "delivery method" dropdown list to make it ...
0
votes
1answer
33 views

Get current grid name

How do we get Current grid name in our grid.phtml I want to check whether we are on sales order grid or not. if(Sales_order_grid){ Do some Action }
1
vote
0answers
63 views

E-mail and country code in admin sales

In my Magento Sales admin grid i would like to have an email and country so I created a code to make it possible: protected function _prepareCollection() { $collection = Mage::...
2
votes
0answers
114 views

Sales order collection error

I want to add custom product attribute to sales order grid, and here is my code below, $collection = Mage::getResourceModel($this->_getCollectionClass()) $vendor1_total = Mage::getResourceModel('...
3
votes
2answers
423 views

How to detect the Grid is filtered

I want to get increment id whenever filter is applied to the sales order grid.And When filter is cleared i need to revert the changes. This is what i have done so far: $collection = $this->...
1
vote
0answers
280 views

How do i use UI components in front-end in magento2

I want to show orders grid in my account section in Front-End. I have extended luma theme. I know it is possible to show admin grid in Front-End but, I don't have a breakthrough. Please assist me on ...
1
vote
1answer
236 views

add weight to order grid

I am trying to add a weight column to my magento order grid (I want the total weight of the order) I have this part _prepareColumns $this->addColumn('weight', array( 'header' => Mage::...
0
votes
1answer
47 views

Invalid Block issue in rewrite Sales Order Grid in Magento 1.8

I am getting error of Invalid block on Live site but same code is working in Local system. Can anyone help me in getting out from this ASAP. Below is my code: Config.xml <?xml version="1.0"?> ...
1
vote
0answers
211 views

Magento 1.x - Sales Order Grid join with custom attribute in customer_entity_varchar

I am trying to add a new column to the sales order grid populated with data from an attribute in the customer_entity_varchar table. I have created the module and the new column is showing correctly: ...
0
votes
1answer
764 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
491 views

Magento 2 add css to order grid on basis of custom column

I want to add css class and highlight the order from grid on the basis of my custom column value(Yes/No). Anyone please suggest solution. Below is my custom column : $setup->getConnection() ...
0
votes
0answers
1k views

Magento 2 : Update Custom Column Value in Sales Order Grid Table

I have added custom column in sales_order_grid table and values are showing in backend but how to update that column's value if customer has edited it from frontend order view? Anyone please help! ...
1
vote
0answers
58 views

Category Filter in add product option when creating order from backend

When i am creating an order from backend and clicking on add a product option its showing me all products and showing fields of id, product name, sku, price, select, qty to add ... what i want to do ...
2
votes
1answer
1k views

How can i get Tracking Number on Sales order grid

I need tracking number on sales order grid,
1
vote
1answer
256 views

show all order count of a customer in order grid

I want to show all the record of the customer who have multiple order in one row as per customer entered email in my order grid, any who have tried this earlier please suggest me the way.
2
votes
2answers
2k views

1.9 - Add custom column to Sales Order Create Grid

I've copied app/code/core/Mage/Adminhtml/Block/Sales/Order/Create/Search/Grid.php To app/code/local/Mage/Adminhtml/Block/Sales/Order/Create/Search/Grid.php And added ->addAttributeToSelect('...
1
vote
1answer
99 views

customer mail is not showing in custom sales grid

Here is my collection below.I tried to rewrite the sales order grid with adding another column as email .The column came but the result for the column email is not displaying in my custom grid. On ...
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
1answer
1k views

How to create a custom button in Order grid in Magento 1

I want to create a custom button in magento 1 backend in **order tab.** I want this button to be General(for all orders), but i can't find anything related to my issue. All i find it's this article ...
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 ...
2
votes
1answer
609 views

How to add product image in sales order grid?

How to add product image in sales order grid. Using Observer. I have to create custom module, in this module i have to add product image that selected in place order. i have to use observer for ...
1
vote
0answers
195 views

In Sales Order Grid Some Fields Data are Repeated

I Have Create Module That Add Some Field In Sales Order Gid, but That Field Data Are Repeated, When More Order Are Placed. Product Type, Quantity Ordered, Product Id, Product Name, Sku are repeated ...
2
votes
1answer
5k views

Magento 2: Add custom column to filter option in order grid?

I have created custom column in sales_order table in Magento 2. At the time placing order values is saved in that column. Now I want to this column to be available for filter option.
0
votes
2answers
843 views

Magento 1.9.3.2 add purchase order number to order grid

I am using Magento 1.9.3.2 and I have got payment method to show along wits order sku's following: https://www.atwix.com/magento/adding-sku-column-to-orders-grid/ But, I would also find it rather ...
1
vote
0answers
21 views

Display a custom text at the top of order grid

I have saved AWB no.s in my database and it is alloted according to a particular algorithm. I have specified a range of AWB no.s. From my order grid, I select the orders and allot AWB no.s to them. I ...
1
vote
0answers
193 views

add conditional filter to sales_order_grid collection (magento2)

I want to add a custom filter to the order collection, checking if some conditions are met. A helper method should return false/true, and then apply the custom filter if it returns true. The custom ...
1
vote
2answers
334 views

Display coupon code in order grid

I want to display the coupon code used, if any, in the orders grid. The field should be filterable and sortable. How can I achieve this ?
1
vote
1answer
41 views

Magento ver. 1.9.2.1 new order missing

Recently I transfer my hosting to Godaddy. They did a site migration for me. However, after the migration, there is a weird situation that when a new order comes in, I can see it when I first logged ...
0
votes
1answer
401 views

Ajax.Responders.register's onComplete Executes Before Ajax Complete

I'm trying to add background colors on the admin orders grid based on the order status in a Magento 1.9 install. I have colors coming fine on page load, but when the grid is reloaded with ajax if any ...
0
votes
1answer
307 views

Error sales order grid using column search

I created a custom module to extend the sales order grid with a SKU column. It works well, until you search in that specific column. Then I do receive a error message. How can I solve this? Then I ...

1 2
3
4 5
7