Questions tagged [reports]
Magento Reporting Functionality
297
questions
0
votes
2
answers
23
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,779
0
votes
0
answers
49
views
Notify for qty below 0 not showing in low stock report
When notify for qty below 0 is set nothing shows in low stock report (items on backorder not shown eg salable qty -1). But if I set to qty below 1 it will show any item that has a qty of 0
- 35
0
votes
0
answers
9
views
Create Backorder Report
Would like to create a report on what current products have been backordered. For example show any product that has a salable qty below 0 eg Test-Product qty -1
Similar to the low stock report would ...
- 35
0
votes
0
answers
15
views
How to associate report's data with store view currency?
I have an issue
Is there an ability to present the report's data into its currency belonging to the store view?
My project has 3 currencies (EUR & USD and GBP ). EUR for one store view, GBP for ...
0
votes
0
answers
11
views
How to get a Report with shipping/delivery zip code and sales amount not including freight/shipping?
Magento 2.4.2-p1
Smartwave Porto theme
extensions from Amasty
Because of complicated new sales tax rules in Colorado, we need a Sales Report which would show all orders (ideally with subtotals but ...
- 306
0
votes
2
answers
20
views
Cannot generate advanced report
I'm using Magento 2.3.2, and I would like to generate Advanced Report.
However, it always show 404 like this
I've followed this guide, however it still shows 404
https://docs.magento.com/user-guide/...
- 196
0
votes
0
answers
32
views
How to add filter for particular field in Product Ordered Report Grid in magento 2
I have added a new custom column in Reports->Products->Ordered Grid and populated the corresponding data by following this link How to debug Reports > Products > Products Ordered ...
- 2,408
1
vote
1
answer
149
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 /...
- 416
0
votes
0
answers
15
views
Coupon code is applied, but not saved in the table, prevented from generating reports
I'm placing an order in magento 1.9 and I'm using coupon, the coupon code used isn't being saved in the coupon_code field of the sales_flat_order table, so I can't issue the report. I performed a test ...
0
votes
0
answers
35
views
Registered coupon does not display in report filter
I'm having a hard time generating coupon report used in Magento 1.9
accessing Reports -> Sales -> Coupons, I select a date period, order status I keep "any", empty lines = "no&...
0
votes
0
answers
27
views
Magento Tax Report doesn't match with TaxJar Analytic
I have had a problem with Tax report. The Magento report is different from TaxJar analytic report. I tried to review one-by-one transactions.
Refund transaction.
Order created at.
The response from ...
- 1,190
0
votes
1
answer
253
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
346
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 ...
- 815
0
votes
0
answers
29
views
Magento 2 : Get model collection between a Specific Date Range [ Report ]
I Create admin grid without ui component using block and I want to add Date Range to the grid filter to get the collection between a two specific date.
What I've Done
What I want to do
Norsys\...
- 11
1
vote
0
answers
56
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
65
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
...
- 177
1
vote
1
answer
40
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
121
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 ...
- 35
0
votes
0
answers
96
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 ...
- 814
2
votes
1
answer
776
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,816
1
vote
0
answers
18
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,069
0
votes
1
answer
16
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
100
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 ...
- 293
1
vote
1
answer
641
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::...
- 135
0
votes
1
answer
395
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
- 77
1
vote
3
answers
366
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-...
- 513
0
votes
2
answers
493
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,735
1
vote
0
answers
34
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.
...
- 907
0
votes
1
answer
69
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!!
- 1,973
2
votes
2
answers
1k
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
142
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,779
0
votes
1
answer
473
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 '...
- 907
0
votes
2
answers
194
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,779
1
vote
1
answer
544
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?
- 133
1
vote
0
answers
10
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,254
2
votes
0
answers
106
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 ...
- 389
4
votes
1
answer
867
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 ...
- 135
0
votes
1
answer
227
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
71
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?
- 702
2
votes
0
answers
81
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,187
0
votes
0
answers
59
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, ...
- 701
0
votes
1
answer
60
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 ...
- 701
11
votes
3
answers
608
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
982
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
65
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
3
votes
2
answers
5k
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.
- 461
1
vote
0
answers
18
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
51
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
696
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
1k
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