Questions tagged [customer-grid]

Questions specific to the admin panel customer grid

Filter by
Sorted by
Tagged with
0
votes
1answer
30 views

Magento 2 Add column in customer grid with name approve_account

I want to add a column in the customer grid with the name approve_account, it is not displaying in the gird. when I change the name (approve_account) to different names like approve_accounts it ...
1
vote
1answer
35 views

Magento 2: Is it possible to add search column in ui component?

How can I add filter row in customer grid just like fixed PHP grid using UI component? I don't want to change any other things of UI component grid.
0
votes
0answers
25 views

How to save custom attribute value in event customer_save_after_data_object Magento2

I added a custom attribute value that is displayed on the customer grid and on the customer view page (adminhtml), but when I want to change and save an attribute from customer grid that works in the ...
0
votes
0answers
19 views

Magento2: add youtube video to custom module

I want to add youtube video in a Magento 2 module. The video needs to be inserted in the magento admin grid system and render its thumbnail in the grid
0
votes
1answer
66 views

Set default filter for Customer grid during order creation in Magento2

I added a Customer Group column in Customer grid during order creation for Magento2, Then I filtered this grid base on Customer Group. Customer grid filtered and it is working fine but module ...
1
vote
1answer
49 views

Add a new column of “Customer Group” in a Customer grid during order creation

I want to add a Customer Group in a Customer grid during order creation For Magento2. I made [vendor]\[module]\view\adminhtml\layout\sales_order_create_customer_block.xml like this: <?xml ...
2
votes
1answer
55 views

How to Spilt Address in Customer grid CSV Export

While exporting customers by going to Customer->All Customers-> Export CSV from grid, billing & shipping addresses are shown as full address. Instead of full address, I need to have separate ...
1
vote
2answers
45 views

How to write Nested Query in Grid Collection _initSelect method

I want to Apply this Query using $this->getSelect() method SELECT * FROM (SELECT * FROM customer_grid_flat ORDER BY enroller_id, entity_id) customer_grid_flat, (SELECT @pv := '$id') ...
3
votes
1answer
67 views

Magento 2: New Customers display issue in Admin Customer Grid

In Magento 2.1.8, Customer Grid is populating from table customer_grid_flat rather than customer_entity. This is for fastest retrieval of data. But the problem is customer_grid_flat never gets ...
0
votes
1answer
61 views

Magento 1 - Add VAT NUMBER column in Manage Customers Grid

I want to add a column in Manage Customers Grid app/code/core/Mage/Adminhtml/Block/Customer/Grid.php with the VAT Number of customers. Now i have ID, Name, Email, Telephone, Country etc. I need ...
1
vote
0answers
90 views

Magento 2 Frontend UI grid not display

I am working in magento 2.2 I want show the customer list in the frontend / vendor panel. When accessing the url and check the response customer data is fetching in JSON format but customer grid is ...
0
votes
1answer
80 views

Render Column for Widget Grid Column (Sales Order Select Customer Grid )

I need to render email address for all customer while creating new order from admin. Adding renderer class for other grids is simple, But how to add renderer class when creating column using Magento\...
0
votes
0answers
15 views

Magento 2 How to filter Email verification status in customer grid search

I have enabled email confirmation for customers registering to my website. I can find the status in the Admin customer Grid but cant filter them by search. How can I achieve this, Is there a back end ...
0
votes
0answers
21 views

Unable to get custom customer Address attribute value to customer grid

I've created custom customer address attribute through admin panel. Attribute value is inserting in customer_address_entity_int table. I'm able to see custom attribute in grid options but attribute ...
3
votes
0answers
144 views

Indexer stuck at processing Design Config Grid, Customer Grid, and Catalog Search

My indexer always stuck at processing for Design Config Grid, Customer Grid, and Catalog Search i already ran php bin/magento indexer:reset , but when the cron indexer run the result still the same, ...
0
votes
0answers
185 views

Magento Customer Grid Custom attribute can't export csv and export xml

Magento Customer Grid Custom attribute can't export csv and export xml, Showing error, how to add custom attributes to the customer export. PHP Fatal error: Uncaught TypeError: Argument 2 passed ...
3
votes
1answer
587 views

Add a custom attribute in grid customer magento 2

I have created an attribute type: select but i can't display it in the grid customer. the code of my customer_listing.xml <column name="customer_status"> <argument name="data" xsi:...
0
votes
0answers
160 views

Column not found: 1054 Unknown column 'billing_telephone'

I have to create two grid customers filtred according to group so i have created my own grid but i have this error :SQLSTATE[42S22]: Column not found: 1054 Unknown column 'billing_telephone' in 'order ...
0
votes
0answers
26 views

How to filter the grid customer according to group_id magento 2

I have two customer groups and I have created two sub menu under All customers and 2 controllers. I want to create two grids so that I will have the list of customers that belong to group 1 in grid 1 ...
1
vote
0answers
202 views

delete columns from grid customers

I added the sequence module_customer to my layout module and overrided the customer_listing.xml <?xml version="1.0" encoding="UTF-8"?> <!-- /** * Copyright © Magento, Inc. All rights ...
0
votes
1answer
39 views

Override the grid of customer magento 2

I want to override the grid of customer to delete some columns from and add others so how to proceed. I overrided the customer_listing.xml but no result
0
votes
0answers
22 views

How to override the grid of all customer Magento 2

I have two group of customer and i want to have too grid so i decided to create a second grid that list the customer of local group and to override the existing grid /customer/index and remove some ...
0
votes
1answer
57 views

Extend customer grid using customer_listing.xml issue

I'm using magento v2.2.5 and i tried to add new column in magento 2 grid by extending customer_listing.xml like this: <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
1
vote
1answer
42 views

Add new column from custom table to magento 2 customer grid

I'm using magento v2.2.5 and i have a custom table that one of the column i need to show in magento 2 grid customer column, my custom table look like this: ##membership## +-----------------+----------...
1
vote
2answers
278 views

Magento 2 - Custom Customer attribute in order create select customer grid

I am trying to add a custom column in sales create order customer grid. When admin trying to place order from back end ,after create order button click we get a customer grid . I have added a new ...
1
vote
1answer
43 views

Filter Magento2 customer grid before it's loaded

I'm using magento 2.2.5 and i have a custom database table which contain customer_id, i want all the customer in this custom table won't be shown at magento2 admin customer grid. my custom table ...
2
votes
1answer
389 views

Magento 2.2.2: Customer Grid Indexer not working

While re indexing got an error: PHP Fatal error: Uncaught Error: Call to undefined method Magento\Customer\Model\Indexer\Source::addAttributeToSelect() in /var/www/html/ncsmokehouse/vendor/magento/...
2
votes
0answers
79 views

Magento: 2 Broken image in wysiwyg after overriding the file

I have override the file vendor/magento/module-customer/Model/Indexer/Source.php in this path Magenticians\Moduleproduct\Model\Indexer\Source.php just adding one function public function ...
1
vote
1answer
321 views

Customer export not working after creating custom attributes in magento 2.2.5

I have created a custom attribute named "Approve Account" while export getting below error. Fatal error: Uncaught TypeError: Argument 2 passed to Magento\Framework\View\Element\UiComponentFactory::...
1
vote
2answers
420 views

Filter customers by custom attribute in admin grid

I added custom attribute to customer and now I want to filter customers by that attribute in admin grid (admin->customers). I want to user see only customers which custom attribute has specific value. ...
0
votes
1answer
65 views

Customer admin grid new customer add where form customer attribute get in ui grid in magento2?

In default Account Information label working but in my side it's not display see: Do anyone know the flow for it?
2
votes
2answers
3k views

Add custom column and filter to customer grid from joined table in magento 2

I need to add custom column and filter in the customer grid in Magento 2 admin. The column attribute is from different modules. There are many solutions for sales order grid, but none (or incomplete) ...
1
vote
0answers
252 views

Magento 2 | customer grid error

I added a custom customer attribute to the customer_grid and now it displays following error: Something went wrong with processing the default view and we have restored the filter to its original ...
5
votes
2answers
541 views

Change Sort Order of Edit Action Customer Grid Column

I want to move edit action column beside customer name programmatically in customer grid like this: how to do it from custom module? i've tried this, but still not working app/code/Namespace/Module/...
1
vote
1answer
131 views

Magento 2 How to remove phone column in customer grid programmatically

in customer grid there is a phone column like this: i can filter this column or choose to hide/show this column from setting, i need to remove this phone column from grid and filter, is there a way ...
2
votes
2answers
2k views

Magento 2: Add attribute to customer grid

I want to show an custom attribute in the customers grid. I created the customer attribute via upgrade script. The attribute is shown in adminhtml_customer so I can save values for this attribute. ...
3
votes
3answers
2k views

Magento 2. Remove column from customer grid (admin)

How does one remove a given column from customer grid (admin) ? Edit: I wish to remove the column not hide it. Edit 2 Setting the following is not working. 'is_searchable_in_grid' => false, ...
2
votes
0answers
54 views

Add a custom button to Customers Grid

I am trying to add a custom button to the Customers Grid but I have not been able to do it using a di.xml Anyone available to point me in the right direction?
1
vote
0answers
91 views

Manipulate customer grid column data in csv(export)

I added a custom column in customer grid i.e subscriber_status which is showing correctly. In DB the actual value saved as either 1(subscribed) or 3(unsubscribed). Currently I am able to manipulate ...
2
votes
1answer
75 views

Issue while reindexing customer_grid 2.1.7

I have migrated the data from m1.9 to m2.1.7 but I find that customers are not loaded into the grid where I checked the table customers are present. As I googled I tried to update the indexer_status ...
0
votes
1answer
519 views

Magento2: New Customer grid column breaks the export functionality

I am working on a Magento2 extension. I added a column called "exported_to_stannp" to my customer grid using the following code: app\code\Namespace\Module\Setup\InstallData.php use Magento\...
0
votes
1answer
263 views

Display number of orders in customer grid

I want to display the total of order for each customer, in the customer grid (Back Office). Currently, I succeed to display the total, only if there is at least 1 order. In _prepareCollection() : $...
0
votes
0answers
121 views

Magento 1.9 : How to add popup window in custom tab grid adminhtml

Popup window on adminhtml grid signature column now plase check it screen short
0
votes
1answer
396 views

Magento2 :getting empty customer grid with No Such Entity message after migration

After migration from Magento 1.9 to 2.1.6, I am getting empty Customer Grid in Admin Panel with No Such Entity message. I can see the customer data in customer_entity table, but grid show No such ...
1
vote
1answer
466 views

Magento 2 : override customer grid collection

I want to override customer grid collection to filter by customer group. How to add customer group filter on Customer grid?
0
votes
1answer
338 views

How to create actions column use layout block magento2

I use layout block to create grid page, but it does't inclue actions column so can I create dropdown actions edit and delete use layout block file Grid.php $this->addColumn( 'actions', ...
0
votes
1answer
2k views

Magento 2 Customer Listing action: get customer's telephone

I have a module where I have added an additional action on admin panel, under Customers -> All Customers grid. I show the new action by populating file: view/adminhtml/ui_component/customer_listing....
2
votes
2answers
1k views

How to Join custom table to customer grid collection and show new column in Grid in Magento2

I want to add new column to customer grid and that new column is from my custom new table how to do it in Magento2
2
votes
0answers
120 views

Magento 2: How to add customer grid in custom module tab?

I want to add customer grid in custom module's tab in Magento 2.1 How can I achieve this?
2
votes
1answer
796 views

Base table or view not found: 1146 Table customer_entity_date

I created a custom attribute type date for customer in Magento 2 like this: $code = 'date_custom'; $insertData = array( "type" => "date", "backend" => "", "label" ...