Questions tagged [reports]
Magento Reporting Functionality
0
votes
2answers
53 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
10 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
24 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
105 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
91 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
0answers
12 views
Why Tax Report is showing blank everytime when we do filter in Magento-2.1.12?
I want to generate tax report in magento-2.1. I will click on Tax through Reports->Sales->Tax . We will select filter and click on Show Report . But it always show blank .Please tell me why it ...
0
votes
2answers
118 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
30 views
Looking for a report by product SKU of items sold - bundle items by SKU
Hoping to be able to pull a report of items sold by SKU, with bundle items sold listed individually.
Right now I am able to pull a report of items sold in a period of time, however bundles are ...
0
votes
0answers
23 views
Coupon used in Invoice but doesn't show up in Sales Coupon Report
I have an order that has been completed, this order is created at 07 DEC 2018:
The coupon is successfully used, but when i tried to show sales coupon report from the 01 DEC 2018 until 31 DEC 2018, it ...
0
votes
0answers
63 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(...
0
votes
0answers
26 views
Magento 1.9.2. - Dashboard: Add each month as a date range of current year in the order report
Now I have the standard Magento filters but I would like to see the reports of orders of every single month of the current year.
I tried to edit function public function getChartUrl() in Graph.php, ...
1
vote
0answers
58 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
58 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
1answer
138 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 > ...
0
votes
1answer
411 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 ...
0
votes
0answers
24 views
Reports data mismatch
I have the multi-website store (websites for UK, US and EU countries), catalog price scope is set to website.
Base currencies of my store are as follows :
For UK store : GBP,
For US store : USD and
...
1
vote
1answer
329 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
43 views
Magento : How to Solve Fatal Error SetDateRange() [on hold]
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
710 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
192 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
29 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
42 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
0answers
15 views
remove null row from admin export-report
I generate day report from Magento-admin ( Reports->product->order)
I get empty row in that report.
I don't want that row so how i can remove it from report?
0
votes
1answer
20 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
2
votes
1answer
954 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
1k 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 ...
2
votes
1answer
111 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
...
0
votes
1answer
237 views
Sales Report by Country
I have customers from Germany, Austria, & Switzerland all using the same Store & StoreView.
Is there any way to get a sales report filtered by country?
Maybe with a short script or something?...
2
votes
0answers
307 views
Magento 2: Sales Order report show wrong data
Orders Report gives wrong results when compared with the actual orders. For example, in Dec 22,2017, there are total 5 orders having "complete" status.
But when I view orders report after applying ...
0
votes
1answer
919 views
Magento 2: How to add custom filters in Orders Report?
I have added new checkbox called "Split by Country" as a filter in Orders Report section.
File:
vendor/magento/module-reports/Block/Adminhtml/Filter/Form.php
$fieldset->addField(
'...
1
vote
1answer
55 views
Magento module Custom Magento Reports blank page? [closed]
I try to install magento (in version 1.9.3.7) module from GitHub Custom Magento reports using sql. I have install module via modman from this guide (install via modman): How to install module in ...
1
vote
1answer
152 views
If a product is listed in multiple categories, can I track through which category was it added to cart /sold?
In my Magento 2.1.8 installation, I have few special categories like recommended-by-site-owner AND prices-soon-to-increase. I add few products to these categories on my site every week and remove few ...
1
vote
0answers
142 views
Magento 1.9 admin grid custom report displays same collection data in all rows
I am developing a customised grid report which gives result as per the given time period for specific order status. As a result I am getting same collection in all rows instead of getting a result ...
4
votes
0answers
135 views
Magento 2.1.5 - Sales Order reports show missing data
I am having issue with order sales report its skipping some data from monthly order report, Some order dates are missing in reports but in order gird it displays same dates order
Magento: 2.1.5
...
1
vote
0answers
126 views
Problem in creating custom reports for inventory forecasting
I have followed this https://magento.stackexchange.com/a/14783/34850
& copied as it is & then made several changes like name space, grid(columns/field names) & query but somehow not ...
1
vote
0answers
55 views
Problem with Custom Reports on Magento
Something happen with one of the stores. When i try to open the Custom Report for the Orders, and i've got nothing. Like its listing only the column names, but nothing else. like:
2016-01-19T07:36:...
1
vote
1answer
207 views
Magento 2 overriding Block Class Function
I just want to override vendor/magento/module-backend/Block/Dashboard/Orders/Grid.php
I added this line $collection->addAttributeToFilter("status",["neq"=>"failed"]);
Core overriding is ...
1
vote
0answers
409 views
M2.2.2 Advanced Reporting
I have enabled Advanced reporting in my Admin according to http://docs.magento.com/m2/ce/user_guide/reports/advanced-reporting.html but where do I check the subscription status if it is still "pending"...
0
votes
1answer
32 views
Magento 1.9.3.4 All report pages missing in navigation dropdown
I can't view any reports in this Magento Backend:
Reports are activated in the System Configuration but the only report in the reports dropdown is "Paypal Settlement reports".
Any ideas what is ...
1
vote
0answers
40 views
Missing intervals in order reports
magento 2.1.9
i am currently missing 7 days worth of order reports, we have attempted to use aggrgated data but still no luck. we know we have sales orders on these days
2
votes
0answers
33 views
I got error when hit back button
When I open a specific product it loads fine, but if I hit the browser back button, I get an error. I have no idea why this happens or where start to check.
This happens always after loading that ...
0
votes
1answer
421 views
Sales Order reports Missing data
Sales data missing from order reports but sales appear in the order grid
Magento ver. 2.1.9
we have some days they are showing some days and some that are show all the correct orders but some show ...
4
votes
0answers
1k views
How to create a custom Report in Magento2 [closed]
How to create a custom Report in Magento2. Please provide any sample code / link.
2
votes
0answers
430 views
How to resolve this error on frontend : “Invalid header value detected”
I am finding the following error on front-end after running the command
bin/magento setup:static-content:deploy in putty
There has been an error processing your request
Exception printing is ...
1
vote
0answers
43 views
How to create custom reports for catalog in Magento 2.1.8
I need to create a report of products with all the fields in Magento 2.
Is there any free Magento 2 extension available to get the product wise report?
0
votes
2answers
26 views
Help understanding layout files and where action links to
I'm working on creating a custom report and rather than just cut and paste code I'm trying to understand how magento layout files work better.
Magento 1.9
I'm looking at a report Products -> Most ...
2
votes
0answers
51 views
Distinct maintenance page from report
When I push my website in maintenance (with maintenance.flag), that send a 503.
When the website has a report, that send a 503 (/src/errors/processor.php, function processReport()).
I want to make a ...
0
votes
1answer
462 views
Create custom inventory report
I'm trying to create some custom inventory reports without luck. I started with this tutorial.
Creating new completely custom reports
I have followed everything to the letter and started over several ...
0
votes
1answer
133 views
How get the total revenue of a product
I am trying to get a report about the total sales for a specific product.
More specific, I get the total sold items for this product but I want to get the total revenue too. However, I observe that ...
1
vote
1answer
737 views
Magento 1.9 — Add SKU column to Sales Orders Report
I am trying to add a SKU column to the Sales > Orders column. After looking at the article below, I was going to change the copy of core sales order grid (app/code/local/Mage/Adminhtml/Block/Sales/...
