Questions tagged [reports]
Magento Reporting Functionality
281
questions
0
votes
0answers
18 views
Magento 2 : how to work Advanced Reporting
I am using Magento 2.2.9
I need to use Advance Reporting functionality
Can any one guide me how its work and how its setup to use
Magento 2 dashboard admin
here is user guide (https://docs....
1
vote
1answer
142 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::...
0
votes
1answer
33 views
magento 2 how to override product views report for custom admin report
Please tell me all the steps to override product view report in my custom module, i am new in magento so i don't know how to do that, thank you
0
votes
0answers
18 views
Magento 2 - how to print MySQL query for Mirasvit Report module?
To print out the all SQL query for the reports which were generated by the Mirasvit Reports?
Currently using the DB logger which generates lots of data while debugging.
<preference for="Magento\...
1
vote
2answers
66 views
Magento 2.3 Unable to override Model: Magento\Reports\Model\ResourceModel\Report\Collection
Hello I am trying to override below function in below class using di.xml.
Below is my code not working:
di.xml
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
0
votes
2answers
47 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 ...
1
vote
0answers
16 views
Report interval date column issue - M2
Admin panel > Reports > Products > Ordered
It's magento's default report and result data is showing in 3rd date it's actually of 4th date.
Issue is, Data is showing in one day previous in grid.
...
0
votes
0answers
6 views
“Ordered Products Report” Appears to be rounding sales to the nearest 10?
I'm trying to understand my best selling products through my website, but the "Ordered Products Report" appears to be presenting "estimates" with best sellers all having 250 units sold, followed by 50+...
0
votes
1answer
33 views
How I can Get Best Seller Products also all catalog products in grid Magento2.3.3?
I want to Get bestseller report in Product first show all filter getting then rest of it in grid.
I want in magento2.3.x version in. Any one have idea? Thanks in advance!!
2
votes
2answers
124 views
Magento 2: Change the bestseller report count more than 5 items
How to change the bestseller report items number more than 5 items Magento 2?
Thank In Advance..!
0
votes
0answers
20 views
Magento2: How can I apply filter on each column for custom report
I have created one custom report.
As per Magento default, they do not provide a filter on each column in the report grid they provide only date range fields.
I want a filter on all columns along ...
0
votes
0answers
15 views
Magento2: Date Interval Issue in Custom Report
I am creating a custom product viewed report.
I am facing issue in interval column.
Below is my collection
$collection = $this->customreportsFactory->create()->getCollection();
$collection-...
0
votes
1answer
60 views
Magento2 - Ordered Products Report sorting columns
Magento Admin > Reports > Products > Ordered
I have created new columns(SKU) using the help of these two links in the report grid.
Magento 2 ordered product report
HOW TO ADD COLUMN TO '...
0
votes
2answers
38 views
Magento2: How to remove PERIOD option from the report?
I am creating a custom report.
I don't need Period and Empty Rows Option from the report.
How can I remove it?
0
votes
0answers
69 views
How to show saleable quantity in Magento Low Stock Report
Today I have encountered a problem with one of our magento store. Below are the store configuration.
Magento 2.3.2 (Migrated from Magento 1.9.4.2)
Backorders are allowed in our store.
Product X has ...
1
vote
1answer
130 views
Magento 2: Can we show lifetime sales on the basis of processing order?
Currently, Lifetime sales on Magento admin dashboard are showing on the basis of complete orders. Can we show it on the basis of processing orders?
0
votes
0answers
10 views
Facing issue with from date and to date with Central Standard Time (America/Chicago)
I am facing an issue with from date and to date in reports with Central Standard Time (America/Chicago) Locale.
I am trying to get the bestseller report after selecting from and to date when I click ...
0
votes
0answers
62 views
Magento 1.9 order total as zero in sales orders reports
We have multiple websites with single store view and every websites have different currency, time zones. My default website set the AUD currency. I tried with generating the sales order reports based ...
1
vote
0answers
9 views
Magento 2 i want to customize default magento report to time wise
I want to customize Magento default 'Ordered Products Report' filter with time.
1
vote
0answers
25 views
Magento Analytics
I'm trying to debug an error with Magento Analytics.
If I try to reauthorize the user in System --> Integrations I have the following error.
Ideas to debug?
Api are working with another shipping ...
0
votes
1answer
53 views
Magento 2 - Render cost price in low stock report - Many can use this
We have a shop, where we want a low stock report with cost prices, so we can see how much we need to pay for these products before buying them.
What I want is to add an extra column with the cost ...
1
vote
1answer
33 views
Magento 2 error report add prefix in file name
How i can add prefix for error report file name located in /var/report/?
Like : prefix_979188230854
Any suggestions please?
2
votes
0answers
38 views
Magento 1.9.4.1 logged in customer can not show product page, it is showing 404
I have upgrade magento 1.9.4.1 from Magento 1.9.1.0 now a guest customer can visit the product page, but when the logged-in customer visit the product page it is showing the error as below:
"...
0
votes
0answers
19 views
Customer logged in report on magento2.3
Want to have a report to know each customer how many times logged in my Magento 2.3 site.
If customer A comes 3 times in a day it should count just once not 3.
I want to sort them by day, a weak, ...
0
votes
1answer
31 views
Empty shoping cart every night magento2.3 automatically
I want to clear shopping cart of all customer every night 00:00. Mean that in advanced reporting and abandoned product in cart and mini cart and cart page and checkout, every thing will disappear on ...
11
votes
3answers
241 views
View product count not updating
There are 3 different tables that stores product viewed count
report_viewed_product_aggregated_daily
report_viewed_product_aggregated_monthly
report_viewed_product_aggregated_yearly
If I want to get ...
0
votes
0answers
23 views
Sales order report per currency
We are using the M1 default sales order reports for our internal reports. However we have three different sites (language purpose) sharing the same base currency, but they can all have up to three ...
0
votes
2answers
217 views
Finding the parent id of an product
I have a requirement to create a cross sales report(Which combination of the product is most purchased by a customer with it order count), But i want to avoid those orders contains parents and child,...
0
votes
1answer
32 views
Magento Shipping country ID is shown as NULL in the reports
I'm using PostgreSQL in my data ware house for reporting purposes, and for a certain report I have to show the sum of revenue for each month grouped by country. When i pulled the report the ...
1
vote
2answers
1k 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.
1
vote
0answers
15 views
Report of Out of Stock Products
How do I get a report of all products that are Out of Stock on Magento 1.7.0.2? Currently our Quickbooks and Magento do not communicate so I rely on our sales team to inform me when products are out ...
0
votes
0answers
33 views
Difference between Sales order and database
In Magento 1.9 when generating a Sales order report (Report -> Sales -> Orders) for February I expect the same value total in invoiced column compared to running below:
select sum(base_total_invoiced)...
1
vote
1answer
265 views
Advance reporting is not working for Magento 2
Advanced reporting is not working for Magento 2.
I have followed all the steps as per the Magento guideline.
But the advance reporting is still not working.
2
votes
1answer
435 views
Magento 2 ordered product report
Report -> Product -> Ordered
I want to add new column Brand (f_brand) in report grid.
I am unable to find any Grid.php or something like this file.
Can anyone help me on this? Which file I ...
0
votes
3answers
485 views
No Orders in Reports > Sales - Orders
I can't find any record in Reports Orders (reports/report_sales/sales/) even if I tried to place some order from the store.
0
votes
0answers
114 views
Magento 2.2.5 Error in Exception Log Every Night
I'm getting an error in exception.log every night.
Error is
main.CRITICAL: Directory "/tmp/analytics/tmp" cannot be created {"exception":"[object] (Magento\Framework\Exception\FileSystemException(...
1
vote
1answer
125 views
Change currency showed in reports - Magento 2
Hi all Magento Wizards,
I have a question regarding the currency shown in reports. I have a Magento webshop where my base currency is Euro. I have multiple websites and store views, which have ...
0
votes
1answer
138 views
SKU Report for null attribute values
I am getting all product sku's that does not have a attribute value
'image_link'.
I have written this code in magento :
$products = Mage::getModel('catalog/product')
->getCollection()
->...
2
votes
2answers
255 views
How to get customer Phone number in Abandoned Cart?
Currently I'm getting Customer name, email and product amount, price in Abdandont cart reports.
I am getting reports on following page in Magento ver. 1.9.2.4 Admin panel.
System > Shopping Basket > ...
1
vote
1answer
1k views
Magento 2.2.5: Warning: Cannot modify header information - headers already sent by [custom_theme registration.php]
I'm developing a custom theme and running into errors. The theme has been tested and working on various servers but, for some reason, since uploading to siteground I get the following error (file ...
2
votes
2answers
583 views
Ordered Products Report Not Grouping
When I run the Ordered Products Report in Magento backend, the generated report lists all products ordered and their ordered quantity -- however, they don't seem to be grouped correctly by SKU. I have ...
2
votes
0answers
51 views
Magento : How to Solve Fatal Error SetDateRange() [closed]
When I try to filtering report by date range in admin, It show me error like this.
Fatal error: Call to a member function setDateRange() on boolean in
app/code/core/Mage/Reports/Model/Report.php
...
0
votes
1answer
1k views
Magento 1.9: export a list of orders with specific data
I need to create report or export orders list as csv file, on a specified date range, where each of them have these data:
order id
date
import
products quantity
payment method
I am tried to Reports&...
0
votes
1answer
231 views
Order Total Report showing blank while export in CSV or XML in Magento2.2.2
Go to Reports -> Customers -> Order Total Report apply filter its shows the record as according to filter but when you export the CSV or XML its showing the blank data
0
votes
1answer
32 views
How get list of customer which bought just once (in the last x month) in Magento?
How get list of customer which bought just once (in the last x month) in Magento?
Like:
bought once in last 12 months
bought once in last 9 months
bought once in last 20 months
bought once in ...
3
votes
1answer
70 views
How get customers that didn't bought in last X months in Magento?
I want to get customers list that didn't bought in last X months in magento 1 or 2?
Like:
Last 12 months
Last 9 months
Last 20 months
Last 36 months
0
votes
1answer
23 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
3
votes
1answer
2k views
Magento 2.2.2 Advanced Reporting Not working
I went through this process https://docs.magento.com/m2/ce/user_guide/reports/advanced-reporting.html
but yet I still get 404.
Anyone have any idea what else could be?
Thank you.
1
vote
1answer
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 ...
3
votes
1answer
136 views
How to create a admin report grid?
I am about to create an admin grid, which shows the report like
>
take every single order from the beginning of the site
for every month we want to know how many total orders that were in
...
