Skip to main content

Questions tagged [column]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
13 votes
1 answer
18k views

Add varchar column to order address

I am trying to add a few varchar fields to the sales/order_address table but am coming up against a column definition error. I have the following code: $oInstaller->getConnection() ->...
David Manners's user avatar
10 votes
1 answer
11k 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"?> ...
Ronak Chauhan's user avatar
9 votes
4 answers
11k views

Magento 2 : Change Admin grid column width

I have added an admin grid using UI component in my custom module. Now I want to change the column width of admin grid. This is the code that I am using for adding column in admin grid : <...
E.B's user avatar
  • 1,010
8 votes
1 answer
8k views

Magento : How to Check if Mysql Column Exists?

I want to prevent error that column in database table exits. How can I add column to table only if column does not exist?
Oboroten's user avatar
  • 239
8 votes
6 answers
25k views

Magento 2 - How to add a custom column in customer grid

I am using below code to add a column in customer grid in admin. /app/code/Namespace/Module/view/adminhtml/ui_component/customer_listing.xml <?xml version="1.0" encoding="UTF-8"?> <listing ...
piyush_systematix's user avatar
7 votes
1 answer
2k views

Remove column from Order grid based on condition

I want to remove status column from Magento admin panel order grid. I use below code to remove the status column in my sales_order_grid.xml file. Reference <listing xmlns:xsi="http://www.w3....
Jaimin Sutariya's user avatar
6 votes
3 answers
24k 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/...
user3564566's user avatar
6 votes
3 answers
9k views

Adjust Columns width/size in Product Grid in Magento Admin

I just wonder why the size/width in Product Grid in the admin panel is not adjusting. I created a local copy of the grid.php from the core file. I tried editing the sizes of the column (/app/code/...
KiD Cajes's user avatar
  • 375
6 votes
1 answer
8k views

Magento 2 Grid custom column value in Ui Listing

I followed this link How to display Yes/No values in admin grid (Magento2)? to get the dynamic custom column value where the column field in grid was app/code/Vendor/Theme/view/adminhtml/...
Verdu's user avatar
  • 1,730
5 votes
1 answer
7k views

Hide a grid's column ( backend )

I just want to have the column in the grid but not visible. Is it possible ? any parameter I should pass to addColumn()
Fra's user avatar
  • 6,985
5 votes
1 answer
1k views

Magento2 how to set default columns in admin grid

You guys would be knowing that magento provides columns control in admin grid made using ui component. In that you can add all columns but only few can be displayed by default when grid load initially....
Pratik Navapara's user avatar
4 votes
1 answer
6k views

Add a column to quote item table

I want to add a column to the sales_flat_quote_item (and ..._order_item) table through an install script, but when I go to the table sales_flat_quote_item (or ..._order_item) in my database - the ...
Syspect's user avatar
  • 1,283
4 votes
2 answers
167 views

Is the column `Action` very important?

Is the column Action very important to being displayed in admin grids? It is actually doing exactly the same thing as "click on selected row" a'm I right ? So if I hide it will it affect anything ? ...
Rob D. A.'s user avatar
  • 867
4 votes
2 answers
3k views

Making rows clickable in Adminhtml Cms Block Grid?

We have inherited a development stage Magento site, where a lot of the blocks on the frontend are horribly misspelled. We are having to go through each block and edit them. One thing we noticed is ...
DWils's user avatar
  • 871
4 votes
2 answers
1k views

Are truncate, nl2br, and escape real UI Component Column Configurations

In Magento 2.1, the review_listing UI component contains column configurations that look like this #File: vendor/magento//module-review/view/adminhtml/ui_component/review_listing.xml <column name="...
Alana Storm's user avatar
  • 44.4k
4 votes
1 answer
2k views

How to set filter_index for a column which is not in the database table?

My code is as follows. Everything works fine except the filteration of new column which shows abandoned cart item names comma separately. I have overridden the block ...
Sukeshini's user avatar
  • 9,965
4 votes
4 answers
6k views

Magento2: 3columns Layout only renders 2columns-right

I have the following layout in Magento2: <?xml version="1.0"?> <page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="3columns" xsi:noNamespaceSchemaLocation="../../../../../../....
tester's user avatar
  • 251
3 votes
2 answers
1k views

How to add Email address in sales orders admin grid?

Trying to add email address into the grid in sales but once added can't search by order number. Throwing error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'increment_id' in where ...
Rob D. A.'s user avatar
  • 867
3 votes
2 answers
3k views

Magento 1: admin product grid column value disappear on name search

I'm facing an interesting problem regarding a custom modification to the backend Catalog Product grid. NB: I'm currently using a module adding columns to this grid via an observer. Nevertheless, the ...
Raphael at Digital Pianism's user avatar
3 votes
2 answers
3k views

Make column unique in install schema script

I want my column to be unique. It is not an EAV attribute. I have seen some tutorials, where indexes are unique, but I am not sure it is not the same, as making column unique (or am I wrong?). Is ...
Bartosz Kubicki's user avatar
3 votes
1 answer
1k views

Magento 2 bar disappeared in Sales Order Grid after adding column

My custom module adds a column to the Sales Order grid. The problem is that the bar above the Grid disappeared. This is shown in the screenshots. With my module: Without my module: In order to add ...
Vixent's user avatar
  • 349
3 votes
3 answers
2k views

Magento2 remove columns from admin sales order view page items grid

Can anyone let me know how to remove existing columns from Admin->Sales->Order->View->Items Grid? Moreover, I also need to add a new column in the same grid, please find attached screenshot for your ...
bhargav shastri's user avatar
3 votes
1 answer
4k views

Disable filter for column in Magento 2 grid component

There is a great explanation of the Grid Component but I cannot find how to disable filter for a column. I need only ordering for my column because value for this column is calculated. <column ...
Alex Gusev's user avatar
  • 2,019
3 votes
1 answer
827 views

How to add a mini log-in form in the left bar of home?

English is not my native language so apologies in advance for bad grammar. I am building a Magento page, but I need a mini-login form showing at the left-bar if the user is not logged in. If it is, ...
Yaren's user avatar
  • 155
3 votes
1 answer
2k views

Add custom column to grid that can be exported

I want to add a column to sales order invoice grid, that should be exported as it is shown in the grid.The column is a calculated column, based on the row data, so there is no explicit database entry ...
Creepin's user avatar
  • 335
2 votes
1 answer
11k 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.
Abhishek's user avatar
  • 939
2 votes
3 answers
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 ...
Lalit Kaushik's user avatar
2 votes
1 answer
4k views

Magento 2 add row total column in grid

I want to add row total of column in grid,I need hint/suggestion.I used this tutorial for creating a grid in magneto2 https://ranasohel.me/2014/04/20/creating-magento2-adminhtml-grid/. I used ...
Niraj Patel's user avatar
2 votes
1 answer
2k views

Magento 2 adminhtml custom column sorting ascending and descending

I made a custom column in sales_order_invoice_grid to display some additional data. This works fine but when clicking on the given column it does not react on any sorting mechanism like descending and ...
xhallix's user avatar
  • 692
2 votes
2 answers
5k views

Where is <div class="col-left sidebar"> located

on my site I have div class="col-left" and it should be div class="col-left sidebar col-left-first" For some reason I change it in the 3columns.phtml and it sill doesn't seem to be ...
Lawrence's user avatar
2 votes
2 answers
2k views

how i can get the column value of admin user table in magento 2

Hi I have created a new column in the admin users table using this answers Magento2: How to add new column in admin_user table? Now I want to get the column value when admin user logged in How i can ...
prabhakaran7's user avatar
  • 1,087
2 votes
2 answers
115 views

I want to put category name in product page left column top, what to do?

I want to add category name in product page left column top, I have created new page called 2columns-left-product.phtml to display a product purpose. Now, I want to display a category name in left ...
Vijayakumar's user avatar
2 votes
2 answers
4k views

Advanced Report - Sales Report : Adding Attribute Column

how to add attribute column in Sales Report? I use the Advanced Report of AheadWorks and I've tried to make the attribute column but do not know how to join the sales table with the attribute table. I'...
Andhi Irawan's user avatar
2 votes
1 answer
2k views

How to set custom value to identity column of a table in Magento 2

I have a custom table with identity column id and text column otherColumn and I'm trying to add a row into the table with my custom value. $model->setOtherColumn($otherColumnValue)->save(); ...
Nausif's user avatar
  • 1,554
2 votes
1 answer
2k views

Grid column not showing in admin grid on Magento 2

I have created a custom module for backend with 3 columns like this: PostAction.php located in vendor\namespace\Ui\Component\Listing\Column class PostActions extends \Magento\Ui\Component\Listing\...
Alin Lupoiu's user avatar
  • 2,672
2 votes
2 answers
555 views

Change order of columns in tab "Products" of category

I would like to change the order of columns in tab "Products" of the categories, "SKU" should be after "ID". I have put a local.xml in app/design/adminhtml/default/default/layout/local.xml containing ...
dakota259's user avatar
2 votes
1 answer
225 views

Include Additional/Joined Data in Grid Column

I've got a Module that allows someone to add products to a warehouse. In the products listing under the warehouse, I've got the product_id, stock etc. What I would like is for the product_id to be ...
Dan Hanly's user avatar
  • 724
2 votes
1 answer
2k views

Magento : Filtering Date Issue on Custom Grid

This is my column code: $this->addColumn( Mage::getModel('catalog/product')->formatUrlKey($key), array( 'header' => Mage::helper('core')->__($label), 'index' =>...
Attila Naghi's user avatar
  • 4,023
2 votes
1 answer
104 views

why won't this populate my 'sku' column in my Grid.php

I'm trying to figure out how to get my Collection to populate the 'sku' column of my Grid.PHP. protected function _prepareColumns() { $this->addColumn('sku', array( 'header'=> ...
thetimmer's user avatar
2 votes
1 answer
287 views

Magento 2: How to increase the column max length?

I want to increase the customer firstname max length so I have updated the length of that column using my custom module dbschema.xml. After updating the length, I can see the updated length in ...
MagentoDev's user avatar
2 votes
1 answer
787 views

product displayed in one column only instead of 2 column on phone in magento 2.3

when you view a category on desktop shows 3 column but on mobile phone it shows product only one column instead of two column of the page. whats wrong with magento 2.3.0 check the link on mobile ...
shezan's user avatar
  • 53
2 votes
0 answers
111 views

How to make 4 column layout file in magento

I want to make custom layout like 4 column to show on front end. it gives default 1 column ,2 columns with right bar,2 columns with right bar and 3 columns. which types of changes in xml file??
Anikesh Shahi's user avatar
2 votes
1 answer
137 views

Are status tables needed in Magento 2?

So I'm creating an admin grid and one of the fields is a dropdown select: <?php namespace Vendor\Module\Ui\Component\Listing\Columns; class Status implements \Magento\Framework\Option\...
treyBake's user avatar
  • 141
2 votes
2 answers
2k views

Sorting a custom column - Customer Grid

I have added in order count and last order date to the customer grid which is working fine, however it is not sortable or filterable in the grid. I have done some searching but can't seem to find a ...
KiwisTasteGood's user avatar
2 votes
2 answers
336 views

Why can i use getData('custom_column') but not getCustomColumn()? [closed]

This one has bugged me just enough to post this.. So imagine we are getting a row from the database on a custom table like so: $row = $this->getCollection()->addFilter('quote_id', 1)->...
jesus g_force Harris's user avatar
1 vote
1 answer
453 views

Magento 1.9 - How to add serial number in sales orders list & invoice list?

How to add serial number for both order list and invoice list, sales->order sales->order->invoice If i add below code in -> app\design\adminhtml\default\default\template\sales\order\view\items....
zus's user avatar
  • 175
1 vote
2 answers
6k views

Trying to filter by 'In Stock' or 'Out of Stock' on product admin grid

I have successfully been able to get whether a product is 'In Stock' or 'Out of Stock' in the Magento admin product grid using an observer in the way set out below. However when I try to filter by 'In ...
Adam Moss's user avatar
  • 1,329
1 vote
2 answers
717 views

how to put filtration in first order in left column magento

I want to change the magento left column block. I have Compare products Community poll filtration My Cart i want to change the order's to Filtration Compare products my cart community poll My ...
Vijayakumar's user avatar
1 vote
1 answer
1k views

Set 2columns-left on any page of the website

So this is it. I want to set the 2columns-left to any page of Magento. Not even 1 1column. I want to do this because I've just installed a plugin which adds the category navigation on the left column ...
aleixrav's user avatar
  • 317
1 vote
1 answer
169 views

Magento2: Duplicate 2 tables in an overwritten method

I'm overwriting a method to change the configuration of the table, the problem is that this column doubles it, magento adds the column of the overwritten file and the original file, if I delete the ...
chdzma's user avatar
  • 952