Questions tagged [order-grid]

Questions specific to the admin panel order grid

103 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
734 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 ...
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 = ...
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.?
3
votes
0answers
17 views

Magento2.1 payment method and shipping method on my orders of buyer panel

I want to show shipping method and payment method of my orders in my orders on customer panel. i'm using magento 2.1
3
votes
0answers
368 views

Join sales/order and ordered items in grid column render Magento 2

I created a custom column in sales/order grid named Product name, They are coming fine on first time, When I am doing sorting Found : Column not found: 1054 Unknown column 'product_name' in 'order ...
2
votes
2answers
71 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
0answers
202 views

How to display customer telephone number on sales order grid table ? (Magento 2.2.0)

I want to display my customer telephone number checkbox here, so that I can see it in column section too, please guide how can I do this?
2
votes
0answers
174 views

'No shipping information available' in Sales Order admin

For few orders, shipping description in admin order grid shows 'No shipping information available'. I am using the magestore onestep checkout. All I've found is that some orders have an empty ...
2
votes
2answers
644 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
0answers
162 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 ...
2
votes
0answers
113 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('...
2
votes
0answers
395 views

Unable to refresh the page after generating PDF file in order grid

We have kept one button in mass action in orders grid, upon clicking it should generate a PDF file, which is working fine, but after generating PDF the should refresh automatically. That's we are ...
2
votes
0answers
272 views

Admin order grid: Column 'store_name' in where clause is ambiguous when filtering by store

I am getting this error when trying to filter the sales grid by store. I can fix this error by altering app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.phpand replacing if (!Mage::app()->...
2
votes
0answers
947 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? ...
2
votes
1answer
95 views

Order Export issues on Chrome

Magento 1.6.2.0. When exporting Orders from the grid view in magento, as CSV, the name of the file downloaded is appended with -, attachment. This seems at the minute to be only happening in Chrome. ...
2
votes
0answers
98 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 ...
1
vote
0answers
32 views

How to create Filter for custom field in Sale Order Grid magento 2

This is my grid sale order grid have custom field Ready To Ship This is my error Because Ready ship not in database. I just check condition to return Yes/No Now, how can filter custom field Ready ...
1
vote
0answers
24 views

How to transform a quote into an order from CALLBACK HOOKS, MAGENTO 2.3

I'm trying to integrate a payment gateway. And they provide a callback hooks i've set for them to return me the CartID (Quote's entity_id). But from here on, it feels like it isnt right for me to ...
1
vote
0answers
8 views

Is there any way to retain the entered customer billing/shipping addresses in magento admin once entered?

We see that the addresses of billing/shipping added to the order creation process gets erased if we remove all line items from the cart and then add back new product using "Add products by SKU" button....
1
vote
0answers
38 views

Magento 2.1.7 Create Shipping label popup in Order grid view

I am using Magento 2.1.7 inbuilt Fedex Create Shipping label in our client website. Is it possible to bring the "Create Shipping Label" side popup in Sales Order grid view? Currently, this button is ...
1
vote
1answer
277 views

How can i filter in sales order grid magento 2?

While i am using same code for filter it's working but i have break other grid like customer,invoice,cms page and get error "Not registered handle cms_page_listing_data_source" While i have moved di....
1
vote
0answers
36 views

How to add custom field beside Export To button in Magento2?

How to add custom field as shown in image in sales order admin grid in Magento 2?
1
vote
0answers
102 views

Update/Refresh Magento UI grid column data only with Javascript (No Ajax)

We have created Mass Action status updates in the grid. Updating the status using the mass action, an ajax call will be initiated and updated the data in the server. Another ajax call will refresh ...
1
vote
0answers
45 views

client order detail page total due issue magento 1.9

i am using magento 1.9 i have created a rule for if order price is less then $5000 add shipping charges $10. its working fine but what i need is when the rule is applied than plus $10 into total due ...
1
vote
1answer
23 views

Override value of magento order grid column

I want to show only first name in bill to and ship to magento order grid. app/code/local/Mage/Sales/Model/Resource/Order.php /** * Init virtual grid records for entity * * @return ...
1
vote
0answers
227 views

Include discount amount on subtotal in order export file Magento 2.2.2

I would like to export sales order from sales->Orders and the column subtotal(in csv and excel file) which should include the discount amount which we have apply while purchasing the product. for ...
1
vote
0answers
308 views

Error viewing Orders - Magento 2.2.5

When attempting to view an order in Magento 2.2.5 I receive the following error... Order View Information Changes have been made to this section that have not been saved. This tab contains invalid ...
1
vote
0answers
116 views

Change default select all to select all on this page in orders table in magento 2

I have local setup of Magento 2 Enterprise edition (ver:2.2.3) In the sales->orders table for mass action i need to select all on this page by default. Now if i click on the checkbox it selects all ...
1
vote
0answers
24 views

Problems on checkout with a particular product

I have one product that is a cause for concern when checking out. Whenever this product is in the cart the checkout throws many popup alerts. I'll link images to help with visuals as I go through ...
1
vote
1answer
20 views

Extending Admin Grid Using Foreach and Variables

I'm trying to modify the Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid (where products are searched for in Magento Admin Order Create) in an attempt to add some custom inventory fields. The ...
1
vote
0answers
379 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
0answers
55 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::...
1
vote
0answers
268 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
215 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::...
1
vote
0answers
196 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: ...
1
vote
0answers
55 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 ...
1
vote
1answer
229 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.
1
vote
0answers
183 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 ...
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
179 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
1answer
40 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 ...
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
901 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 ...
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 \...
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
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
323 views

Add subscriber status to flat order grid

I'm trying to add subscriber status to sales_flat_order_grid. I already got postcode working, but now I'm kind of stuck. This is what I've tried so far: startSetup(); // Add column to grid table $...
1
vote
1answer
331 views

Order grid fails to load in admin panel

Magento CE 1.8.0.0 on server running Apache & PHP5.4. Woke up this morning to discover our store's order grid had disappeared from our admin panel this morning without logging errors. I ...
1
vote
1answer
53 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?