Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [customer-grid]

Questions specific to the admin panel customer grid

0
votes
0answers
15 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
43 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
33 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
50 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
39 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
54 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
45 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
52 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
57 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
14 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
20 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
112 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
150 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
432 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
127 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
161 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
38 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
16 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 overrid the existing grid /customer/index and remove some ...
0
votes
1answer
43 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
35 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
228 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
40 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
288 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
64 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 ...
0
votes
1answer
239 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
358 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
62 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
2k 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
231 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
493 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
105 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
1k 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. ...
2
votes
3answers
1k 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
53 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
88 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
471 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
239 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
118 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
384 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
444 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
326 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
112 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
771 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" ...
1
vote
2answers
711 views

Add column in Customer grid based on module's Model

Need to add a custom column in Customers grid from the status in the Module's Model. i was using this code config.xml <adminhtml> <rewrite> <customer_grid>...
3
votes
1answer
629 views

Add Company Name to customers grid

I need to show Company Name in customers grid. I followed exemple here: Add Company column to Customers Admin Grid with Observer and these are the files I created Config file: <?xml version="1.0"?...
0
votes
1answer
54 views

Extending Mage_Adminhtml_Block_Sales_Order_Create_Customer_Grid

I'm trying to add a few custom columns to the Magento sales order create customer grid (where you either select for a customer or add a new customer prior to adding an order in Magento Admin). I've ...