Questions tagged [customer-grid]

Questions specific to the admin panel customer grid

Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

Magento2 : Added order count column on customer grid but giving error when using filters

I am trying to get the order count on customer grid Grid Code: namespace Test\CustomerGrid\Model\Plugin\ResourceModel\Customer; class Grid { public static $table = 'customer_grid_flat'; ...
0
votes
0answers
7 views

Show Hide columns in customer grid based on Configuration Values

I have created 2 config options(Yes/No) for my customer attribute, now I want to show/hide based on Config options, like yes then visible and No then not, the thing is I am displaying data in grid ...
0
votes
0answers
41 views

Magento 2.2.8 : Customers Grid date filter returns wrong results

Using Magento 2.2.8 Locale en_GB Customer Since Date Format : DD/MM/YYYY Admin Section : All Customers Grid Trying to filter : Customer Since: 02/01/2020 - 02/02/2020 The results are not correct. ...
0
votes
0answers
26 views

How to call custom grid in modal window?

I am creating functionality where admin can set product's price specifically for a customer, I created custom tab in the product edit page, where if someone click on add specific customer modal ...
0
votes
2answers
42 views

How to filter with custom field on customer grid Magento 2

I have created a custom field in the filter on the customer grid using customer_listing.xml. Now, the issue is How can I filter with the custom field? Where do I need to do the operation? Please ...
0
votes
0answers
23 views

Magento 2 add a button in customer edit in admin

I want to add a button in customer edit page in admin I want to click the button and call what’s in my block But I don’t know how to do this In my block for now I called getValue()
0
votes
0answers
29 views

Show Last url and IP address in Online customer Grid Magneto 2

I need to show Customer IP and Last url in Customers Now Online Grid magento 2 How can i achieve this.? Thanks in advance.
0
votes
0answers
16 views

Customer Grid Index: Update on Schedule finally supported?

The official documentation mentions, that the Customer Grid Index (customer_grid) cannot be "Updated on Schedule" via the cron. It links to a support article, which concerns Magento 2.2.2. But is ...
1
vote
1answer
53 views

Magento 2: Error when clicking custom column on grid

I have created a custom column updated_at on customer grid. I have displayed it with data. But when I click the column header, this error pops out (Something went wrong with processing the default ...
0
votes
2answers
202 views

Magento 2 - Displaying Data on backend customer grid

I need help with this line of code. public function prepareDataSource(array $dataSource) { if (isset($dataSource['data']['items'])) { foreach ($dataSource['data']['items'] as & $item) ...
0
votes
0answers
23 views

Magento 2 show availability date and time

I am trying to create a page with a calendar and show time where customers can pick. https://github.com/Roomify/bat I was looking here but wasn’t sure how to implement it. Is there any other way or ...
0
votes
2answers
129 views

How to debug 'something went wrong' in magento2

I installed magento2 2.2.10 version and installed custom modules. At begining it works finely after adding products , customers and place an order then it's not loading any admin grids(customers , ...
0
votes
1answer
32 views

How to add last logged in and last order date information to customer grid?

Using Magento ver. 2.2.6, how can I add new columns to customer grid showing the last logged-in activity and Last order date?
1
vote
0answers
147 views

Magento 2: After migration, Customer reindex is not working

This is the issue I face on indexing from terminal. column 'created_in' used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat` Kindly help me to ...
0
votes
1answer
39 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
73 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
95 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
1answer
111 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 ...
2
votes
1answer
202 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
212 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
68 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
378 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
141 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
173 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 ...
1
vote
1answer
236 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
27 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 ...
4
votes
0answers
192 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
337 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 ...
4
votes
1answer
1k 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:...
1
vote
1answer
281 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
50 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
1answer
87 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
61 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## +-----------------+----------...
2
votes
2answers
604 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
53 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
2answers
737 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
122 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
734 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
620 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
85 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
6k 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
312 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
841 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
401 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
3k 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
56 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
102 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
81 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
712 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\...