Questions tagged [reports]

Magento Reporting Functionality

Filter by
Sorted by
Tagged with
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 ...
Chris's user avatar
  • 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 ...
Rubel Parvaz's user avatar
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 ...
Amruta's user avatar
  • 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 ...
Gaz Smith's user avatar
  • 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
jayp's user avatar
  • 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 /...
Nirav Joshi's user avatar
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 [...
David Buik's user avatar
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 ...
Daniel's user avatar
  • 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 ...
Ravi Soni's user avatar
  • 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/...
Luan Tran's user avatar
  • 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 /...
Kuldeep Sharma's user avatar
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.
Mehta Prem's user avatar
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 ...
Wakar Ahamad's user avatar
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 ...
main525's user avatar
  • 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 ...
Plastikschnitzer's user avatar
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 ...
Jeffrey Marks's user avatar
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 ...
Shaun's user avatar
  • 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 ...
Geat's user avatar
  • 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 ...
Sameer Bhayani's user avatar
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.
Ansar Husain's user avatar
  • 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?
Richard's user avatar
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 ...
web master's user avatar
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::...
Manjunath's user avatar
  • 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
Arjun Soni's user avatar
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-...
Dinesh Rajput's user avatar
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 ...
Softec's user avatar
  • 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. ...
Jimit Bhavsar's user avatar
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!!
Magento2 Devloper's user avatar
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..!
Robert Baum's user avatar
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-...
Ravi Soni's user avatar
  • 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 '...
Jimit Bhavsar's user avatar
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?
Ravi Soni's user avatar
  • 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?
Vinod Kumar Clix's user avatar
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.
Chirag Gondaliya's user avatar
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 ...
domfitty's user avatar
  • 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 ...
Manjunath's user avatar
  • 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 ...
Martin Jørgensen's user avatar
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?
mahmoudismail's user avatar
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: "...
Utsav Gupta's user avatar
  • 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, ...
MGPM's user avatar
  • 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 ...
MGPM's user avatar
  • 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 ...
Muhammad Wasif's user avatar
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,...
Sandeep's user avatar
  • 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 ...
Sandeep's user avatar
  • 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.
gajjala sandeep's user avatar
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 ...
Randy Anderson's user avatar
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)...
Andreas's user avatar
  • 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.
user77355's user avatar
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 ...
Atif Ameer's user avatar
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.
xdev's user avatar
  • 193

1
2 3 4 5 6