Questions tagged [order-grid]

Questions specific to the admin panel order grid

Filter by
Sorted by
Tagged with
3
votes
2answers
2k views

Convert SQL Select to Magento getCollection statement

I have a complex sql select query that I want to load as collection so as to display the data in a custom grid but I'm not able to convert the query into Magento's equivalent getCollection statement. ...
3
votes
3answers
2k views

Deleted orders are not removed from grid

When I delete an order, it is still listed in orders grid. When I attempt to open it, I get the message This order no longer exists. This behaviour was seemingly introduced by a Magento update: I ...
0
votes
1answer
866 views

Adding Customer Email to adminhtml order grid breaks the ability to search

There are a couple of questions relating to adding a custom email field to the order grid. For example, this and this. However, both these create a problem when you try and filter. What happens is ...
2
votes
1answer
884 views

Prevent Magento from auto-completing orders

We have a scenario where we fulfill orders via an API. Previously the logic has been tied to the invoicing process, so that when an invoice is created, the fulfillment logic is executed. If there were ...
3
votes
2answers
2k views

How to add telephone number to the Sales Order Grid using an observer

In the Order Grid, I want to add the telephone number which customers used in order -> shipping or billing. I can add the title in the grid but I don't know how get the phone number. The event that ...
4
votes
2answers
2k views

magento Add Coupon code at sales order grid

I want to add coupon code in sales order grid . As we know Sales order gird build from sales_flat_order_grid table Coupon_code column is exist in sales_flat_order table not sales_flat_order_grid ...
2
votes
0answers
99 views

Add Comment to Sales Report

I have a custom report based on the tutorial at http://wrightcreativelabs.com/create-a-custom-magento-report-product-skus-in-new-orders/. The report is working well as is. Now I'm trying to add a ...
2
votes
2answers
1k views

Custom Admin Grid Without Database

I created a grid in the Magento admin, but the functionality like sort, filter and search doesn't work and that is because I didn't use a database table to get the information. I use a web service ...
1
vote
1answer
2k views

Date problem in magento sales grid

I have added the delivery date column to Order Gird, showing good. But it's showing less than one day. Example: Actual date is 24th Dec 2014. But it's showing 23rd Dec 2014. From database also ...
1
vote
2answers
762 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
608 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
685 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') ...
1
vote
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
705 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
874 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
559 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
705 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
390 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::...

1 3 4 5 6 7