Questions tagged [reports]

Magento Reporting Functionality

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

Facing issue with from date and to date with Central Standard Time (America/Chicago)

I am facing an issue with from date and to date in reports with Central Standard Time (America/Chicago) Locale. I am trying to get the bestseller report after selecting from and to date when I click ...
0
votes
0answers
16 views

Magento 1.9 order total as zero in sales orders reports

We have multiple websites with single store view and every websites have different currency, time zones. My default website set the AUD currency. I tried with generating the sales order reports based ...
0
votes
0answers
8 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.
0
votes
0answers
9 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 ...
0
votes
0answers
11 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
1answer
24 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?
2
votes
0answers
25 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: "...
0
votes
0answers
14 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, ...
0
votes
1answer
22 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 ...
11
votes
3answers
151 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 ...
0
votes
0answers
15 views

Sales order report per currency

We are using the M1 default sales order reports for our internal reports. However we have three different sites (language purpose) sharing the same base currency, but they can all have up to three ...
0
votes
2answers
45 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,...
0
votes
1answer
30 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 ...
0
votes
2answers
116 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
12 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
29 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
154 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
204 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
14 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
240 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
30 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
80 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
31 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
71 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
72 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
161 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
557 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
28 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
381 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
45 views

Magento : How to Solve Fatal Error SetDateRange() [closed]

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
845 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
209 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
45 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
1answer
21 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
3
votes
1answer
1k 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 ...
3
votes
1answer
121 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
273 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
342 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
1k 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
57 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
193 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
149 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
143 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
137 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
57 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
218 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
472 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"...