Questions tagged [custom-reports]
Questions related to reports that is developed using any custom module
22
questions
0
votes
1
answer
124
views
Adding magento 2 order attribute
I want to create an order attribute that creates a field in sales_order_item table also.
I want to insert some product-related data in this table which I want to filter later in sales report.
- 836
1
vote
2
answers
2k
views
How to get all products info from database by SQL Query in Magento 2.3?
I want to get the below data of all products by SQL Query.
SKU
Product name
Website
Attribute set
Quantity per source
Sellable quantity
visibility
Price
Status
I have used this extension:
https://...
- 554
0
votes
0
answers
131
views
Magento 2: Hide empty rows for custom report
I've created a custom report in the Magento 2 backend.
Everything is working great, but by default the results grid shows "We can't find records for this period" for any days where there's ...
- 834
1
vote
1
answer
946
views
How to create custom report for category data in Magento 2?
I am trying to create a report for categories.
Vendor/Module/registration.php
<?php
\Magento\Framework\Component\ComponentRegistrar::register(
\Magento\Framework\Component\ComponentRegistrar::...
- 177
1
vote
1
answer
490
views
Magento 2 Remove Total from report table
I have overridden the Sales report in my custom report file but I want to remove footer which is automatically added that I don't need how to remove that footer
My layout xml file is
<?xml ...
- 107
0
votes
2
answers
604
views
Magento 2 require to create SQL query for the custom report
I would like to generate Magento native report as follows:
Can anybody provide the SQL query for above table ?
Column Name CustomerGender = customer attribute
Column Name Group = Customer Group ...
- 2,055
4
votes
2
answers
5k
views
Data showing in Grid but not in export file Magento2
I have created a custom report,
Used below code in my ui_component listing file.
<column name="custom_tax_code" class="Vendor\Module\Ui\Component\Listing\Column\Quantity">
<argument name="...
- 1,929
1
vote
1
answer
172
views
Show shipping amount for entire order in custom report Magento2
I have created the custom sales report,
used below code in my listing.xml file,
<column name="shipping_amount">
<argument name="data" xsi:type="array">
<item name="...
- 1,929
2
votes
1
answer
1k
views
Magento 2: Display Payment Method in Custom Sales report grid
I have created the custom sales report to show required fields on the grid,
Used below code to show payment method,
Vendor/Module/view/adminhtml/ui_component/salesfinacereport_manage_listing.xml
&...
- 177
1
vote
0
answers
173
views
magento 2 Customer Report unable to set Interval(Period like 2019), Customer Group, Numbers of Orders, Average Order Amount, Total Order Amount
I am trying to create custom report and want to display admin grid with columns as below:
Interval(Period),Customer Group,Numbers of Orders,Average Order Amount,Total Order Amount
I have run the ...
- 543
1
vote
0
answers
442
views
Magento 2 help validate function to count bundle product child items of an order
I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped.
The tricky part is, magento formats line items ...
- 330
0
votes
0
answers
144
views
Get the list of most seller combined products with its orders
I want to get the most frequently sold product combinations, along with number of orders ( and Orders if possible).
I have customized the Magento tables for my warehouse activities and the sample ...
- 115
1
vote
0
answers
113
views
Display record count in custom report on the basis of row count. Magento 1.9 custom report
In my Custom Report.
I have created a collection which count is 25.
But After this I have applied some joins on that by another collection.
but on which I have made join is returning 25 records.
...
4
votes
2
answers
6k
views
Create Custom report in admin using Magento 2.1.9
I want to create a custom report using the custom table section in the admin under the reports menu. COuld you please help me out.
- 491
1
vote
1
answer
72
views
Custom report without using collection
I have a request which to make custom report, and data for the report need to calculate by helper function and will generate a data array with row and columns.
Is there any solution to let data array ...
- 31
2
votes
2
answers
907
views
Custom report from SQL query
I want to get order total of the month January 2019 for complete orders
I need to know tables related to this query, or if someone can share query that would be great.
- 1,457
3
votes
1
answer
984
views
How to add sales order table custom value to magento 2 report from a custom module
I created a custom module to check the ad code (measure the marketing traffic) value from the url and add to the order. I added a column to the sales order table and save the ad value when user place ...
- 109
1
vote
0
answers
64
views
How to customize 'Order Total Report' (REPORTS > Customers > Order Total) in magento 2.2.6
I need to achieve this:
In 'Order Total Report' (REPORTS > Customers > Order Total) add new
columns, 'ID', 'Affiliate ID', 'Total BVP Purchase'.
'ID' ==> will display Customer ID
'Affiliate ID' ...
- 41
1
vote
0
answers
1k
views
How to create custom reports in custom menu in admin magento 2? [closed]
Actually i want create custom report based on sales ,product and custom data from custom module in admin side with graph
- 305
8
votes
2
answers
14k
views
Magento 2 - I need to create simple custom report with date range and other column filter (filter should be outside of grid)
I need to create custom report which is just like magento default reports. I go through the Internet I found this https://github.com/degdigital/magento2-customreports but In this report data is ...
- 8,594
0
votes
1
answer
47
views
Is it possible to track the quantity of clicks I have on my store?
I need to develop a report module on my store and I need to track the quantity of clicks the site have.
is it possible :
to get the quantity of clicks
And/or the quantity of clicks on a given time
1
vote
1
answer
2k
views
How to create custom reports in Magento2?
Now the real question
I need to create custom reports based on conditions.
Sales Report
Marketing Report
Customer Report
Product Report
. Example:
Conditions:
How many products or list of ...
- 1,065