Magento 2 Experts — Hyvä Theme, Tailwind CSS & SEO from a Single Source ›

Magento 2 report builder: create custom reports right in the admin

Magento 2 Extension Magento 2.4.x Admin Tool

SKU: CUSTOMREPORTBUILDER1

  • Custom reports from orders, items, customers and products
  • Columns, filters and grouping per click, no SQL
  • CSV export with spreadsheet-injection protection
  • Email delivery via cron to fixed recipients on a schedule
Auf Lager
€179.00

Einmaliger Kauf · inkl. 12 Monate Updates · zzgl. MwSt.

No download, but personal setup

No download, but personal setup. This product is not a downloadable software package for self-installation. With your order, you commission Mironsoft to individually set up this module in your shop. We will get in touch with you within 2 business days — we'll sort out the details and payment together then.

This offer is aimed at business owners and companies running a Magento 2 shop.

Overview

Magento 2 report builder: analytics without developers and without SQL

Accounting wants revenue by tax rate, purchasing wants sales by supplier, sales wants the top customers of the quarter. The standard reports of Magento 2 answer only part of these questions, for the rest there are exports, spreadsheets or a request to the developers. That costs time and leads to numbers nobody can trace anymore. This page covers Magento 2 report builder in detail.

The Mironsoft Magento 2 report builder gives the departments a tool of their own: you choose a data source, tick columns, set filters, group and let totals be calculated. The report is saved, can be downloaded as CSV and sent automatically to recipients on a schedule. Everything runs in the Magento admin, structured and read-only, without free-form SQL. The module is an admin tool and does not affect the Hyvä frontend.

6 Features

Magento 2 report builder: the analysis your standard reports do not provide

Accounting, purchasing and sales need different numbers. Each team builds its own report and receives it regularly by email.

Data sources

Orders, order items, customers, products and credit memos as a starting point.

Columns and order

Pick fields per click, rename and sort them.

Filters and periods

Operators and relative periods such as last month or last 30 days.

Grouping and totals

Group by day, month, category or country with sum, count and average.

CSV export and email delivery

Download with one click or automatically via cron to a recipient list.

Permissions and safety

Access per report via ACL, read-only structured queries.

01Assembling a report

Build your own reports in Magento 2: from question to table in a few clicks

In the Magento 2 report builder you choose a data source, tick the columns you need and set filters, for instance order status complete, shipping country Germany and period last month. Optionally you group by day, month, category or customer group and let sums or averages be calculated. The report is saved under a name and appears in the admin menu.

  • Data source, columns, filters and grouping in one form
  • Relative periods that move on every run
  • Live preview of the first rows while building
Reports › Report Builder › Revenue by category
Source and filters
Order items · status complete · last month
Grouping
Category, sum of row total, item count
Sorting
Sum descending
Delivery schedule
Report: Revenue by category
Every Monday 07:00accounting@example.com
1st of each monthmanagement@example.com
FormatCSV, attachment
02Export and delivery

Export orders as CSV and send the report by email

Every report from the Magento 2 report builder can be exported as CSV with one click. Characters at the start of a cell are neutralized so the file opens safely in spreadsheet programs. You can also define a schedule: daily, weekly or monthly a cron job sends the report as an attachment to your recipient list. Long reports are generated in the background so the admin is not blocked.

  • CSV with protection against formula injection in spreadsheets
  • Schedule daily, weekly or monthly, recipient list per report
  • Background generation for large data sets
03Permissions and limits

Magento 2 report builder with permissions per report and clear limits

In the Magento 2 report builder each report gets its own ACL resource so you decide which admin roles may open it. Queries are structured and read-only, free-form SQL is deliberately not offered. The Magento 2 report builder does not replace a data warehouse; for very large data sets a narrow period filter is advisable. If a report contains personal data, the usual data protection rules for export and email delivery apply.

  • ACL resource per report
  • Read-only, structured queries without free SQL
  • Warning for reports with personal-data columns
System › Permissions
Role Accounting
Reports: Revenue by category, Credit memos
Role Purchasing
Reports: Stock by supplier
Role Support
no report permissions
Use cases

What teams use the Magento 2 report builder for

Three everyday examples from different departments.

Accounting and controlling

A monthly revenue report by tax class, country and payment method, sent as CSV to accounting on the first of each month, without anyone having to remember.

Purchasing and range

Sales by supplier and category over the last 90 days show which items deserve shelf space and which do not, as a weekly email to purchasing.

Sales and customer care

Top customers by revenue, orders of one country or credit memos per month: the answer is in the report, not in a question to IT.

Comparison

Standard reports versus the Magento 2 report builder

AspectMagento standard reportsCustom Report Builder
Columns and filtersFixedFreely selectable, with operators and relative periods
GroupingOnly a few variantsBy day, month, category, country, customer group
SharingManual exportCSV and automatic email delivery on a schedule
Access protectionBlanket via rolesOwn ACL resource per report
Effort for new analysesDeveloper or manual export workThe department clicks the report itself
Process

Setting up the Magento 2 report builder in five steps

  1. 1

    Collect questions

    We collect the ten most important analyses of your departments with you.

  2. 2

    Installation

    Mironsoft installs the module, adds the admin menu entry and the permissions.

  3. 3

    Build first reports

    Together we build the first reports and check the numbers against known values.

  4. 4

    Set up delivery

    Schedules, recipient lists and export format are defined.

  5. 5

    Assign permissions

    Each admin role gets access to the reports it needs.

Differentiation

Differentiation from related Mironsoft modules

The Advanced Reports module delivers fixed analyses such as revenue, bestsellers or abandoned carts. The Custom Report Builder is the construction kit for when an analysis is not covered there. Both can run side by side.

The Admin Action Log is another task as well: it records changes in the backend, the Magento 2 report builder analyzes shop data.

04How the purchase works

No download — personal setup instead

Custom Report Builder is not listed here as a ready-made download file for self-installation. The purchase is a service commission: we get in touch with you after the purchase, install the module in your shop and set up the first reports, recipient lists and send times together with you and agree on admin permissions.

Important to know

Your purchase does not include a download link. We will get in touch with you within 2 business days — we'll sort out the details and payment together then. This offer is aimed at business owners and companies running a Magento 2 shop.

FAQ

Frequently asked questions

Everything you need to know about how it works, setup and how the purchase works.

Do I need SQL knowledge for the Magento 2 report builder?
No. Everything is configured via forms. Free-form SQL is deliberately not provided.
How does this differ from the standard reports?
Standard reports are fixed, the Magento 2 report builder is not. Here you define data source, columns, filters and grouping yourself and save the result as your own report.
Can reports arrive automatically by email?
Yes, via schedules (daily, weekly, monthly) with a recipient list and CSV attachment. This requires a running Magento cron.
How large can reports be?
Large exports run in the background. For very extensive analyses a narrow period filter or an external BI tool is recommended.
Can I control who sees which report?
Yes, each report has its own ACL resource that you assign to individual admin roles.
How can I create my own reports in Magento 2?
With a report builder: choose a data source, set columns and filters, save. The report then appears in the admin and can be exported.
How do I export filtered orders as CSV in Magento 2?
In the report you set the filters, for example status and period, and click export. Alternatively a schedule sends the file automatically.
Is the Magento 2 report builder suitable for Hyvä shops?
Yes. It is a pure admin tool and independent of the frontend theme.
Are the reports safe against manipulation?
Queries are structured and read-only, there is no free-form SQL. Exported cells are protected against formula injection in spreadsheets.
Can I download and install the module myself?
No. This is not a download product. After the purchase we install and configure the module for you personally in your shop.
Write Your Own Review
You're reviewing: Magento 2 report builder – Mironsoft Custom Report Builder
loader
Loading...

You submitted your review for moderation.

This form is protected by reCAPTCHA - the Google Privacy Policy and Terms of Service apply.

Magento 2 report builder – Mironsoft Custom Report Builder

Magento 2 report builder – Mironsoft Custom Report Builder

€179.00