Magento 2 Customer Grid Columns with Revenue, Last Order and Filters
SKU: CUSTOMERGRIDCOLUMNS1
- columns for revenue, order count, last order and average
- customer group, source and newsletter status in the list
- filter, sorting and export (CSV/XML) for all new columns
- precalculated figures, update via cron and CLI
Einmaliger Kauf · inkl. 12 Monate Updates · zzgl. MwSt.
Magento 2 Customer Grid Columns: revenue, last order and more right in the customer list
With the Magento 2 Customer Grid Columns from Mironsoft the customer list in the admin shows additional columns: total revenue, number of orders, date of the last order, average cart value, customer group, registration source and newsletter status. All new columns can be filtered, sorted and exported. The values are precalculated in a table of their own so that the list stays fast even with many customers. The module uses the standard grid technology of Magento and changes no core structure.
Revenue and orders
Total revenue, order count and average cart value appear as columns of their own in the customer list.
Last order
Date and amount of the last order show at a glance who has not bought anything for a long time.
Group and origin
Customer group, registration source, store view and newsletter status complete the list.
Filter and sorting
Every column can be filtered, narrowed by ranges and sorted.
Export
The additional columns appear in the CSV and XML export of the grid.
Precalculated figures
An index table keeps the values current without burdening the customer list on every call.
Why the standard customer list shows too little for practical work
The Magento customer list shows name, email, group, phone and sign-up date. Sales and support need answers to other questions, though: who has bought nothing in the last 90 days? Who ordered above a certain amount? Which new customers came from which store view? To answer that you open every customer record one by one or export orders to a spreadsheet. That is why operators look for Magento 2 Customer Grid Columns with meaningful figures.
With additional columns and filters the list becomes a working tool: you sort by revenue, filter by inactivity and export the result for a campaign. The Magento 2 Customer Grid Columns thus replace manual evaluations in daily work.
Magento 2 Customer Grid Columns with revenue, order count and last order
For every customer the Magento 2 Customer Grid Columns calculate total revenue, number of orders, date of the last order and average cart value. You define which order statuses count, and cancelled orders can be excluded. Amounts appear in the base currency. The calculation runs in the background via cron, and after each order only the affected customer is updated.
- Total revenue, count, average, last order
- Counting order statuses configurable
- Update per customer after a new order
Filter the Magento 2 customer list: inactive, big spenders, new customers
Every new column has a matching filter: numeric ranges for revenue and order count, date ranges for the last order, selection lists for group, source and newsletter. You combine the filters freely and save the view as a bookmark in the grid. That way you find customers who spent more than 500 euros but have not ordered for half a year in two clicks.
- Range filters for revenue and count
- Date range for last order
- Saved views in the grid
Export additional columns and reuse them for campaigns
The new columns appear in the grid export as CSV or XML, in the order of the chosen view. A filtered export delivers, for instance, all inactive big spenders for a reactivation campaign. The output contains only fields the admin user may see according to the ACL. Personal data belongs in an export only as far as it fits your purpose; the legal review lies with the shop operator.
- CSV and XML export with new columns
- Filtered export for campaigns
- Output according to ACL permission
Configuration, cron and performance of the Magento 2 Customer Grid Columns
Under Stores › Configuration › Mironsoft you switch single columns on or off, define the counting order statuses and choose whether cancelled or refunded orders are deducted. A command on the command line recalculates the figures for all customers, for example after a data import. Because the values are precalculated, the list stays quick even with a very large number of customers.
- Columns switchable individually
- Full recalculation via CLI command
- Precalculated values for a fast list
Where the Magento 2 Customer Grid Columns help in sales and support
Four evaluations that begin with the Magento 2 Customer Grid Columns and a look into the customer list.
Reactivation
Customers with high revenue and a long pause are filtered, exported and approached specifically.
Spotting top customers
The list sorted by total revenue shows regulars who deserve a personal contact.
Retailer care
Sales sees revenue and last order per retailer group and plans visits and calls.
Support on the phone
Support recognises at once whether a new customer or a long-standing buyer is calling.
Magento 2 Customer Grid Columns: standard list or module compared
The difference in evaluation and effort.
| Topic | Without the module | With Mironsoft Customer Grid Columns |
|---|---|---|
| Revenue per customer | Not in the list | Column of its own, sortable and filterable |
| Inactive customers | Search orders one by one | Filter by date of the last order |
| Export | Standard columns only | New columns in CSV and XML export |
| Performance | Calculation on opening | Precalculated values, fast list |
| Handling | Several menus and tables | Everything in one view |
How we set up the Magento 2 Customer Grid Columns for you
The process after your order.
Briefing
You name the figures you want and the counting order statuses, and we define columns and filters.
Installation
We install the module and set up the Magento 2 Customer Grid Columns with columns, cron and limits.
Initial calculation
We calculate the figures for your customer base and check samples against orders.
Testing
We test the Magento 2 Customer Grid Columns with filters, sorting, export and the update after new orders.
Handover
Your team gets an introduction to columns, views and export.
Scope compared with order grid, customer tags and activity timeline
The extended order grid from Mironsoft improves the order list, customer tags assign keywords to customers, and the activity timeline shows events of a single customer record. The Magento 2 Customer Grid Columns instead concern the customer list itself and deliver figures across all customers.
The modules complement each other in the same backend. No frontend JavaScript is loaded, so your Hyvä shop stays untouched.
No download, but a personal setup
The extended customer columns are not listed here as a finished download file for self-installation. The purchase is a commission: after the purchase we get in touch, install the module in your backend and set up columns and figures together with you.
Frequently asked questions
Everything important about columns, filters, export and how the purchase works.
How can I show revenue per customer in the Magento 2 customer grid?
Can I filter customers by the date of their last order?
Which orders count for the figures?
Are the new columns exported as well?
Does the customer list become slow with many customers?
How current are the values?
Can I switch off single columns?
Who sees the additional columns?
Do the Magento 2 Customer Grid Columns change the Hyvä frontend?
Can I download and install the module myself?
Recently Viewed Products
Magento 2 Customer Grid Columns – Mironsoft