Questions tagged [reports]
Magento Reporting Functionality
296
questions
1
vote
0
answers
59
views
Pound sign formatting issue in CSV reports
We have a client running on Magento 2.4 and their store's currency is British Pounds (GBP).
When they export any sales reports from the Reports menu (eg Reports > Sales > Orders) the pound ...
- 1,389
0
votes
1
answer
37
views
sales by payment type reports display in dashboard in magento 2
Block->
<?php
namespace \Block;
use Magento\Payment\Api\PaymentMethodListInterface;
class AllPayment extends \Magento\Framework\View\Element\Template
{
protected $_paymentConfig;
protected ...
- 17
0
votes
0
answers
54
views
Advance Reporting not working
I have followed all the instruction to activate advance report
Also Magento Analytics user integration Status is “Active” and generated token But still facing the same error.
We can’t find what you’re ...
- 1
1
vote
0
answers
40
views
Magento 2 sales report missing 4 days
My Magento 2 sales report has just randomly missed 4 days out this month (17th,18th,19th,20th) Even though there is sales data for them days, all in processing just like the other days. There is ...
- 109
1
vote
1
answer
89
views
Magento 2 How to add Customer attribute to Reports => Customer => Order Total grid
I had created new customer attribute Reward ID and I need this custom attribute in the Reports => Customer => Order Total grid and csv.
Please let me know how can i do this.
Thank you
- 11
0
votes
2
answers
73
views
AbstractCollection class of Module Reports is not overriding
I am trying to override this class
Magento\Reports\Model\ResourceModel\Report\Collection\AbstractCollection
This is a simple class not abstract class
Here is some code example of core class
<?php
/...
- 59
1
vote
1
answer
545
views
Magento 2.4.4 READONLY You can't write against a read-only replica
The website keeps going down throwing error.
{"0":"READONLY You can't write against a read-only replica.","1":"#1
Cm\RedisSession\Handler->read() called at
[...
- 141
2
votes
1
answer
196
views
What is the intention for the currency calculation in the orders report?
In order to display reports Magento relies on the aggregated data in sales_order_aggregated_created and sales_order_aggregated_updated. In the aggregated data the total of each order are multiplied by ...
- 2,199
0
votes
2
answers
304
views
Magento2: Date showing wrong on grid column
I created one grid and showed the date there. Database data and grid values are not matched. Grid value showing 1 back date instead of same as database.
Below is my DB table value:
And below code ...
- 1,809
0
votes
3
answers
101
views
Cannot generate advanced report
I'm using Magento 2, and I would like to generate Advanced Report.
However, it always shows 404 like this
I've followed this guide, however it still shows 404.
https://docs.magento.com/user-guide/...
- 196
1
vote
2
answers
436
views
How to Get Most Viewed Product Collection in Magento 2?
how to get the most viewed product collection in your Magento 2 store?
I try with multiple codes but unfortunately, I am not getting any solution.
I try to create a MostViewedProducts.php file in the /...
- 414
0
votes
1
answer
681
views
How to Get Sales Order Report Collection Programmatically in Magento 2
I want to get sales order report collection programmatically. I don't know by which class I can able to fetch. Can anyone please help me?
I want to get same records which display in screenshot.
- 97
0
votes
1
answer
998
views
How to include pending orders into Magento 2 'Order Report' table 'sales_order_aggregated_created'?
I have to run 'pending' order status report, as checked by default Magento 2 doesn't allowed to run pending reports as this doesn't make any sense.
Magento 2 ignoring to list pending order status into ...
- 825
1
vote
0
answers
150
views
Magento 2 - Product View Report Count
How does Magento2 count the views of products in the Product Views Report, is it by browser session or per account (login in different accounts using the same browser, each account counts as 1)?
If by ...
- 11
0
votes
1
answer
243
views
Ordered products report exclude orders with status closed
the default Magento2 report from ordered products excludes orders with status canceled. I also want to exclude status closed.
/app/code/Magento/Reports/Model/ResourceModel/Product/Sold/Collection.php
...
- 197
1
vote
1
answer
48
views
Need a Magento 2 report
I'm looking for a specific report. We need a monthly report of orders that includes the customer's name/address and what they purchased. (Magento 2.3.6) I don't see this in the standard reports. My ...
1
vote
0
answers
221
views
Magento 2.3.4 low stock report only showing items when stock level is 0 and marked as in stock then saved manually
When the qty of a product is 1 and is sold it doesn't show up in the low stock report, when that same product is marked as shipped it doesn't show up in the low stock report but when I manually save ...
- 47
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
2
votes
1
answer
1k
views
Magento 2.3.4: Product Views Report Not Working
I am using Magento 2.3.4, I have issue with product view reports. All reports are working well, except product view.
I have checked Time Zone as well as refreshed statistics lifetime. I tried all ...
- 1,864
1
vote
0
answers
26
views
Products in cart reports magnto2 backend
When i go to reports -> products in cart i am getting price 0 and product name blank.
- 3,399
0
votes
1
answer
99
views
Generating a Price report
Is there a way I can generate are report showing all the product prices, showing what the normal RRP is, and if there is a sale price on an item what the sale price is?
- 1
2
votes
1
answer
198
views
CSP Reports being thrown, even after allowing links in whitelist
I created a new module to allow urls, and have them not make noise about csp.
I have a csp_whitelist file under /etc, and I've added all of my links to it (and cleared the cache), but the warnings ...
- 313
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
0
votes
1
answer
517
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
- 107
1
vote
3
answers
565
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-...
- 543
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
1
vote
0
answers
61
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.
...
- 969
0
votes
1
answer
98
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,054
2
votes
2
answers
2k
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..!
- 43
0
votes
0
answers
200
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-...
- 1,809
0
votes
1
answer
677
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 '...
- 969
0
votes
2
answers
310
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?
- 1,809
2
votes
1
answer
807
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?
- 143
1
vote
0
answers
14
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,314
2
votes
0
answers
144
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 ...
- 399
4
votes
1
answer
1k
views
Add Shipping country in Sales Order report Magento2
I am trying to add Shipping country as extra column and filter,
how that can be achieved. can anyone help me on this.
referred the below Url, but which was not helpful for me.
Magento 2: How to add ...
- 177
0
votes
1
answer
263
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
1
answer
83
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?
- 742
2
votes
0
answers
84
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:
"...
- 1,243
0
votes
0
answers
104
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, ...
- 741
0
votes
1
answer
102
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 ...
- 741
11
votes
3
answers
799
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 ...
- 130
0
votes
2
answers
2k
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,...
- 115
0
votes
1
answer
96
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 ...
- 115
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
0
answers
25
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
0
answers
57
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)...
- 323
1
vote
1
answer
785
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.
- 11
3
votes
1
answer
2k
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 ...
- 133
1
vote
3
answers
2k
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.
- 193