Questions tagged [reports]

Magento Reporting Functionality

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 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
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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/...
user avatar
  • 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 ...
user avatar
  • 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 /...
user avatar
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 ...
user avatar
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&...
user avatar
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 ...
user avatar
  • 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.
user avatar
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 ...
user avatar
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\...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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.
user avatar
  • 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?
user avatar
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 ...
user avatar
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::...
user avatar
  • 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
user avatar
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-...
user avatar
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 ...
user avatar
  • 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. ...
user avatar
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!!
user avatar
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..!
user avatar
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-...
user avatar
  • 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 '...
user avatar
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?
user avatar
  • 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?
user avatar
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.
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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?
user avatar
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: "...
user avatar
  • 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, ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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,...
user avatar
  • 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 ...
user avatar
  • 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.
user avatar
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 ...
user avatar
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)...
user avatar
  • 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.
user avatar
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 ...
user avatar

1
2 3 4 5 6