Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
1
vote
2answers
738 views

How to display customer email in order grid? [closed]

I need to display customer-email and product-name in admin panel order grid but my code return error.
1
vote
1answer
6k views

Adding new custom mass order status action

I am using Magento 1.9.1 . I am working on a new extension which is adding new custom mass status action here: Here is my code: /app/code/local/VivasIndustries/MassCustomStatusses/etc/config.xml : ...
1
vote
3answers
6k views

how to add customer's shipping address detail in Admin > Sales > Order grid

I trying to add customer's shipping address detail in Admin > Sales > Order grid with following code in protected function _prepareCollection() $collection->getSelect()->join(array('Shipping'=...
1
vote
1answer
3k views

How to get the Order Remote IP?

Nope, Mage_Sales_Model_Order $order->getRemoteIp() doesn't work. It always gives me null. By when I check sales_flat_order table I can see remote_ip field. I just only need to check if the order ...
1
vote
3answers
4k views

add new column with custom attribute in sales > order grid in Magento ver. 1.9.3.3

Magento ver. 1.9.3.3 I am trying to add columns with **custom product attribute **(like publisher which was created by me) in Admin > sales >order. Copied app/code/core/Mage/Adminhtml/Block/...
0
votes
1answer
602 views

Having problem to add new column in admin >sales > order grid ,product name is repeating

I am try to add columns in Admin > sales >order by overriding method. Copied app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php to app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid....
0
votes
1answer
2k views

Add Customs column to Admin > sales >order [duplicate]

i am try to add columns in Admin > sales >order by overriding method. Copy app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php to app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php. add ...
1
vote
2answers
5k views

How to add & remove column in admin > sales > orders

i have to remove Bill to Name column & add two new columns product title name (which describe the product Name of Product) & Payment Method(which describe the payment method at the time of ...
1
vote
2answers
3k views

How to add new column to sales_flat_order_grid with default value

I used following method and it's working fine for me. <?php $installer = $this; $installer->startSetup(); $installer->addAttribute("order", "barcode", array("type"=>"varchar","...
1
vote
1answer
2k views

Default to 100 orders in sales order admin page

Could someone help me with this, I need to change the default number orders being showed in the Admin panel/Sales/Order view page. Currently it starts from 20 per page. I want to maintain that but ...
1
vote
2answers
193 views

Magento Order Grid filters

I added some columns to my Order grid (Product SKU, name and quantity and shipping method) but since that some filters in my grid doesn't work like Purchased and Total Qty (It redirects to Dashboard). ...
0
votes
1answer
1k views

Fatal error: Call to a member function getPdf() on a non-object in controllers\Mage\Adminhtml\Sales\OrderController.php

I am getting this following error in a module am developing to print custom invoice/pdf. The code is working upto the controller part, but when it tries to call the model an error is occurring there. ...
1
vote
2answers
1k views

Editing Magento Admin and User order detail page

This is a cross-post from stackoverflow, where nobody has been able to help so far. I'm trying to add a minimal, manual "track shipment" system in Magento. Here's what I'm trying to do: I'd like to ...
0
votes
1answer
676 views

Restrict Order Grid to Specific Status for User

How would I restrict access to only show completed orders in the admin for one user or role? This employee only needs to see new pending orders, and I don't want this employee to be able to look back ...
2
votes
2answers
3k views

Override Mage_Adminhtml_Block_Sales_Order_Grid

I'm trying to override the Mage_Adminhtml_Block_Sales_Order_Grid class, but no success with that. My config.xml file: <?xml version="1.0"?> <config> <modules> <...
1
vote
1answer
1k views

How to show only one record in order grid for the same Order ID for parent configurable product and child simple product?

In order grid, two records with same Order ID are shown when the product is configurable product that has child product so-called simple product. I only want child product (simple product). I don't ...
0
votes
2answers
2k views

Custom sales/order attribute in admin grid [duplicate]

How would I add a custom field to the order grid? I have the following code by looking at other questions but after I have ran the code the new field is not showing up. require_once('app/Mage.php'); ...
6
votes
3answers
21k views

add column to sales/orders grid

I'm trying to add a column to the sales/order grid in the backend. I've found some wonderfull tutorials, but I can't get it to work. This is the tutorial I'm following.. http://www.atwix.com/magento/...
1
vote
3answers
7k views

get all order list for logged in customer in magento

I'm trying to generate the list of past ordered products for logged in customer. My attempt so far. <ul> <?php $OrderProducts = Mage::getResourceModel('sales/order_collection') ...
0
votes
1answer
2k views

Add the 'Short Description' to the 'items ordered' table within a sales order admin view

Is it possible to add the 'Short Description' to the 'order view' within the 'Sales admin page'. Primarily in the 'items ordered' table so; [Product][Item Status][Original Price][Price][Qty]...etc ...
3
votes
2answers
5k views

Add custom css class to backend grid cell under certain conditions

I am looking for a way to add a custom css class to a backend grid cell when it has a specific value. I know I have the option to use a renderer and I also could use the frameback_call options in ...
21
votes
4answers
36k views

Add Column to Admin > Sales > Orders Grid

How can I add a column to the grid in the Admin section under Sales > Orders?
1
vote
2answers
2k views

Magento order grid purchased from store on one line

this is not the most constructive question for Magento development. But this is certainly one that keeps me boggled ... On the magento order grid in the backed we see that an order takes up multiple ...
1
vote
1answer
2k views

How to add a column Total row in a magento grid at the end

How to display total row at the end of sales order grid.see below image
1
vote
1answer
1k views

Is there a way to speed up multiple Joins in Magento Order Grid?

I am having an issue with load times in the Sales_Order_Grid after join creating three joins to add additional columns. This has significantly increased loading times and I was wondering if there is ...
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 ...
1
vote
2answers
702 views

How to create 1 order to allow multiple choices of 1 product with varied quantity?

I have a requirement where -- I would like people to be able to order 1 product + its multiple variations in varied quantity. This can be termed as Bulk Order or Grouped Order -- but below is a table ...
1
vote
0answers
2k views

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sfoa.postcode' in 'field list' [closed]

I am getting the above error on the Customer/Orders tab in Magento admin which is related to a module that is adding columns to the sales_order_grid. I chosen the Observer method since there is ...
0
votes
1answer
848 views

Is there any way to see order source in Orders table in magento admin?

I've google it, but I found only one thread in Magento Forum http://www.magentocommerce.com/boards/viewthread/40399/ but their forum engine always returns "Your message field is empty" error. That's ...
2
votes
1answer
555 views

Prepend table alias to sort by column name?

I am using the sales_order_grid_collection_load_before event in order to append a filter to the collection. However, in my case, I need to JOIN sales_flat_order table. The problem is that the ordering ...
1
vote
1answer
6k views

How to solve “SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'where clause'”

I am trying to extend the sales order grind in Magento in order to show Product Name, SKU, And Billing email. I've had to use an Observer since there is a module currently rewriting the Grid. I have ...
0
votes
3answers
3k views

How to add “SKU” and “Product Name” to sales order grid?

I am trying to add "sku" and "product name" to sales order grid with filtering. I have created my joins but the columns are empty and I'm not sure what I have done incorrectly here... Trying to get ...
4
votes
1answer
704 views

show extra column items grid order

I have added a extra column in sales_flat_quote_item table. Populating the column during checkout works fine. But showing the values of the extra column on the order details page in admin does not ...
1
vote
2answers
1k views

Add Discount Field In Order Grid

Hello Guys I am not Getting How to add discount field In Magento Admin grid. Also Please explain how to add custom table value Display In order Grid.
1
vote
1answer
2k views

Admin Panel order grid: Multiple sort conditions?

I am wondering if it's possible to specify multiple sorting conditions for the order grid in the Admin Panel. Let's say for example I wanted to sort all orders first by their Bill to Name and then ...
2
votes
3answers
4k views

add complete address in default columns in order grid

I want to add complete address in default "Bill to Name" and "Ship to Name" columns in order grid in Magento admin. I am attaching screen-shot for more explanation. Please suggest me how can I ...
1
vote
1answer
280 views

Do have sales_flat* tables a lifecycle like catalog_product_flat* tables?

I'm quite new to magento development and could not find any information on this theme. I know that the catalog_product_flat* tables are indexed and are only existing, if magento is set to use flat ...
4
votes
1answer
387 views

addColumn() or addAttribute() ? What is the best for performance, migration & usability?

What is the best method of adding new attributes to the sales and/or quote tables in magento via an install script: use: addColumn() or use addAttribute() ? So the main questions are : What is ...
4
votes
3answers
2k views

How to remove Export option from Sales/Order grid?

I want to remove the following from sale order grid: New Order RSS Export to: MassAction block for a particular admin user role. I currently use adminhtml_block_html_before event to remove the ...
1
vote
1answer
1k views

magento display custom attribute in sales order grid

For: Simple Product As you can see the image i displayed the color attribute in dropdown in view page. now the customer can select the color. after they clicking buy now i need to save the color in ...
1
vote
1answer
2k views

Sales Order grid new column order comment show recent comment only

In magento CE 1.7.0.2 Add new column to sales order grid which have a most recent order comment. Following code used to add column protected function _prepareColumns() { parent::...
14
votes
3answers
15k views

Add new column to sales_flat_order_grid

How can I add a new column to the sales_flat_order_grid table and ensure that values are properly inserted there? The "source" for the new column is a custom column we've added to sales_flat_order, ...
16
votes
4answers
18k views

Add Column to a grid (observer) - Column ‘store_id’ in where clause is ambiguous issue

I'm adding a column to the order grid using observer approach: On the event -> sales_order_grid_collection_load_before I'm adding a join to the collection On the event -> ...
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
2answers
3k views

Add new field to administration orders grid

I am building my first Magento plugin that will hook into the event of when an order is placed, and export the order to a third party web service. Now, rather than creating a separate table to store ...
0
votes
1answer
2k views

Sort orders by SKU in order overview

This question concerns the grid in: sales->orders->[select an order]->Information. At the bottom you can see a grid with the orders. I would like to sort them by SKU. In: /app/code/core/Mage/Sales/...
1
vote
1answer
994 views

'sales_flat_order_grid' shows wrong data

In my clients store there are 4 orders that are displaying wrong data, all four consecutive orders are displaying the same billing and shipping name in the order grid, all other data is correct. I've ...