Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
2
votes
2answers
253 views

While Exporting CSV from Sales > Order Grid, I am getting error - “You cannot define a correlation name 'order' more than once”

When I try to export csv in Sales > Order Grid, I am getting You cannot define a correlation name 'order' more than once Trace: #0 /www/Myproject/htdocs/lib/Varien/Db/Select.php(281)...
0
votes
1answer
242 views

Create custom order CSV per order with header record and detail record

I am working on Magento ver 1.9.2.3, And I want to export a order csv per order in header record and detail record format. What i have done till now I have created a custom module which export ...
0
votes
1answer
50 views

How to prevent going to order view in order grid view (list view)?

In the magento Sales > Orders view where it lists all orders. I am trying to prevent the redirection when clicking on the order row (admin/sales_order/view/order_id/{orderID}) I would like to keep ...
1
vote
0answers
102 views

How to get custom risk attribute in sales order grid

I'm trying to display the custom attribute in sales order grid using left join. If I had the joinLeft query I'm getting "No records found in sales order grid" $collection = Mage::getResourceModel($...
1
vote
0answers
42 views

How to obtain customer attribute in sales order grid? [duplicate]

I have made a customer attribute as 'sales_executive' and it is displayed in add new customer form in admin. It is also displayed in customer grid by adding a add column and but now I want to display ...
0
votes
2answers
731 views

How to get custom customer attribute value in sales order grid?

I have made customer attribute 'sales_executive' which shows proper value in customer grid. Now i want to show the same value in sales order grid by adding column. How to add this column and get value ...
0
votes
1answer
489 views

Magento2 - Creating Purchase Order Grid based on Sales Order Grid

I have successfully replicated part of the default Magento Sales Order Grid to display and filter another grid, this one regrouping the purchase orders instead. I chose to replicate the Sales Order ...
2
votes
1answer
40 views

how to change mode Grid in backend

i would like to know if anybody has already change the mode of grid. By defaut, in list of orders, we have this mode : is it possible to get this display :
3
votes
1answer
1k views

Magento 2 , How to add “Company Name” column to “Customer Grid”

When we going to create a new order manually from backend, I need to add a "Company Name" column w.r.t. customer. Also need to add filter for the same. Please help.
1
vote
1answer
215 views

How can i add Country Name or flag Display on Ordered page Panel Grid?

I need to show Country Name or flag on ordered page, How can i add custom field on ordered panel grid?
1
vote
1answer
907 views

Magento - Extending Mass Action Grid Filters (“Select All”, “Select None”) to Sales > Orders Grid

I am trying to extend the filters on the Sales Order Grid. For example I would like to add "Select Pending", "Select Cancelled" etc filter in the grid. Any help in this regard would be greatly ...
1
vote
1answer
68 views

Grid Image Not Showing properly

I have used below code for Grid Products Image in shopping cart tab, Its showing same image in all products, Please help , Kindly check attached snap-shot for more detail. $this->addColumn('Image',...
2
votes
0answers
952 views

Magento 2 : Add New Grid Mass Action based on condition

I am working on one custom extension and need to add new mass action in Sales Order grid. But I need to add this mass action based on one condition. I am working in Magento 2.1.1 How can I do this? ...
19
votes
5answers
29k views

Magento 2 How to Add a New Column to Orders Grid

I've added a new column to the table sales_order called export_status, now I want to add new order grid column with the data from the new sales_order column. I've managed to add column to the ...
0
votes
1answer
475 views

Backend order grid modification inducing filtering error

I added columns in the backend order grid using protected function _prepareCollection() { $collection = Mage::getResourceModel($this->_getCollectionClass()); $collection->getSelect()-&...
3
votes
1answer
694 views

Magento2 Add Quote ID in Sales Order Grid

I am trying to display quote id of an order in the sales order grid. New field is getting displayed in the grid. However the value of the quote id is not getting populated in the grid against each ...
1
vote
0answers
905 views

Payment Method Column in Admin Orders Table Grid

I have weird problem, I am trying to show the payment methods in a separate column in admin order grid, the problem is below code is working perfectly in localhost, however in the live server it is ...
0
votes
1answer
1k views

Magento custom column in grid doesn't show shipping method chosen in the Order grid

I have installed Magento CE 1.9.2.4 in one of my sites in Local system. Now I have overrided Mage_Adminhtml_Block_Sales_Order_Grid class into local codepool for adding custom columns of ...
2
votes
1answer
31 views

help with custom order grid

I am trying to make a grid with all the orders containing the same product grouped together (all the orders only have one product in them) any ideas how to achieve this? this is what i have so far the ...
0
votes
2answers
880 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' ...
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 ...
1
vote
0answers
241 views

Magento2 updating custom field in order creates new grid row

I've created a custom attribute in Magento2 Order grid and sales_order table. Now when I am saving Order info using OrderRepositoryInterface, it creates a new blank row in order grid. I am using \...
0
votes
1answer
140 views

How to add Total Row in Order Grid

I have installed magento 1.9.2.3 version. My client requirements is to take the Order Amount total in a Day. Let say he want to know how many order comes in a day and what is the Order Amount. ...
1
vote
1answer
1k views

Unable to search orders in admin order Grid by custom column(s) created

I had created 4 custom fields for the Order: pgs_order_website_names pgs_aramex_reference pgs_aramex_shipped pgs_aramex_shipped_date I had copied Grid.php to local/Mage/ class ...
0
votes
2answers
2k views

Magento 2 - How to remove options from mass action in sales order page in admin?

I want to remove Print Invoices and Print Shipping Labels from mass action select menu available on order view page. I tried adding <action name="pdfinvoices_order"> <argument name="...
1
vote
1answer
771 views

The requested Payment Method is not available in magento order grid backend

I recently changed Website Payments Pro (Includes Express Checkout) (Email Associated with PayPal Merchant Account,API Username,API Password,API Signature) in magento backend. below error code I get ...
0
votes
1answer
302 views

Magento2.1.0 Order Grid not displaying Search and Filter option in Admin

I recently have upgraded the Magento2.0.7 to Magento2.1.0, once after upgrade, i couldn't able to see the Filter and search section in admin order grids other modules like products are having filters. ...
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
1answer
891 views

Displaying data in custom order grid

Using How to create a custom grid from scratch article, I have created a custom order grid in Magento admin. Previously I had added one custom column with name 'my_data' in sales_flat_ordertable. ...
1
vote
1answer
37 views

Magento order grid: is it a new or an existing customer?

Magento order grid: is it a new or an existing customer? Question: Is there a way to mark or colour the order in the order grid based on the question: is it a new or an existing customer? - or how ...
1
vote
1answer
127 views

Amasty order grid

I am using a amasty extension https://amasty.com/order-flags.html to set specific data to my orders and there are 2 columns on the order screen i dont want my employees to see I was thinking i ...
1
vote
2answers
2k views

Display a product attribute on orders page in admin

I am using this custom module https://bitbucket.org/vovsky/adding-custom-product-attribute-to-quote-and-order-items-in/downloads related article https://www.atwix.com/magento/custom-product-attribute-...
2
votes
1answer
674 views

Display Billing Company in Sales Order Grid

I'm trying to add Billing Company and Shipping Company to the Sales Order Grid (Magento CE 1.9.0.1) but everything I have tried appears to have no effect - I don't even see the new column with empty ...
2
votes
2answers
410 views

Loop through the items in order grid

I need to change the order grid in the admin area, and add in a column for Margin (ie, total margin on each order). I have set up code\local\MageWorx\Adminhtml\Block\Orderspro\Sales\Order\Grid.php ...
2
votes
1answer
562 views

Remove/cancel a particular product from all pending orders in admin

I am doing a magento project in which i have to select all pending order at once and move to complete status from the order management page in admin. I have done this modification and it is working ...
0
votes
0answers
430 views

Datetime render issue on Magento admin grid

In our Magento EE dashboard sometimes DateTime column of grids (orders, customer orders) showing incorrect values, this only sometimes, not all times. Maybe it depends on the session, maybe it has the ...
1
vote
0answers
3k views

Magento 2 better way create custom grid

I found 2 website reference for creating custom grid. https://ranasohel.me/2014/04/20/creating-magento2-adminhtml-grid/ 2.http://www.mage-world.com/blog/grid-and-form-in-magento-2-admin-panel-part-1....
1
vote
1answer
2k views

Mass Action in Order Grid

I want to create new mass action inside Order grid which will create new Shipment but I have problem with my action. When I click submit button my action don't work but only redirect me on homepage. ...
0
votes
1answer
227 views

Export report not showing fields

I want to export order report in csv. With following content Order Date Order Day Order Id Ip Address Customer Name Customer Group Billing Name Billing Address Billing City Billing Postcode Billing ...
1
vote
0answers
76 views

Magento 1: how can I fix the middlename bug in the sales order grid? [duplicate]

Ok so this is basically a follow up on this issue on a Magento 1.9.2.4 : Magento 1.9.2.0: table "sales_flat_order_grid" contains extra space in customer's name value I tried to make the ...
0
votes
1answer
790 views

Adminhtml order grid add column

I would like to add column to the backend order grid. I then followed this tutorial : Tuto on this model, I then tried to add a second column : the client company I tried : <?php class ...
6
votes
2answers
474 views

Hide completed orders from sales/orders

In sales/orders is it possible to hide completed orders ? using something like filters. or can I filter the status column with more than one status ?
7
votes
2answers
848 views

Magento: Filter huge sales order collection

I am trying to filter a huge collection of sales order. There are more then 5 million records in it. Below is my code to get the order collection and also i puts some joins to get the desired columns ...
0
votes
2answers
2k views

Change Order Grid Overwrite Problem

I try to change Order Grid, but I don't know where I have a problem ... There is my files: app/code/local/My/Module/etc/config.xml <?xml version="1.0"?> <config> <global&...
0
votes
1answer
306 views

Zip code to order grid backend

I currently use a extention to display the payment method and SKU inside the grid. I want to expand this with adding the zipcode. How should I expand my code? CODE: app/code/local/Atwix/...
5
votes
1answer
2k views

Export a field from custom model grid with a diferent render to Csv

I created a custom column on sales order grid. It works as well but a used a custom render on a field (like this). When I export the grid to CSV, the file contains the raw value, but I need apply ...
0
votes
1answer
165 views

Filtering Sales Grid by SKU - SQL Error

When trying to filter the sales order grid by sku i get the following SQL error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that ...
0
votes
1answer
303 views

Error adding “Invoice ID” to sales grid

I added in the invoice ID to the order grid using the code below which shows them fine! However when I try and search by Invoice ID I get the following error. Any help is appreciated! BUMP: Still ...
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.?
1
vote
2answers
90 views

How to add a custom customer attribute to the sales grid

I have a custom customer attribute named "sage_account_number" and I would like to add this to the sales grid. Could someone advise how I would add this? I have tried $collection->getSelect()-&...