Change Log for Advanced Reports

1.2.17

(2023-03-01)

Fixed

Fixed the issue with charts not working.

1.2.14

(2021-03-11)

Fixed

Fixed the issue with data in the Sales by Customer report.

1.2.13

(2019-07-10)

Fixed

Fixed issue with filters by ctegory name and product name.

1.2.12

(2019-07-10)

Fixed

fix: Cannot access protected property $joinedTables

1.2.11

(2019-03-12)

Fixed

'Last login at' column for customer-related reports

1.2.10

(2019-03-11)

Fixed

Customer group column shows 'Not logged in' for all customers in exported file [#138]()

1.2.9

(2019-01-11)

Fixed

Problems running cron jobs

1.2.8

(2018-12-25)

Fixed

Error displaying report with php 7.2

1.2.7

(2018-12-19)

Features

New report Sales by Months

Fixed

Fixed issue with the ignored checkbox on the dashboard.

1.2.6

(2018-11-12)

Fixed

Problem with filter by Credit Memo #133

1.2.5

(2018-10-05)

Features

Ability to filter Bestseller widget by categories and select all report's columns

1.2.4

(2018-10-05)

Features

Ability to filter Bestseller widget by categories and select all report's columns

1.2.3

(2018-10-04)

Fixed

Magento menu displays empty item when Advanced Reports are displayed under native Reports item

1.2.2

(2018-10-04)

Fixed

Widgets are getting mixed up after viewing dashboard from mobile device

1.2.1

(2018-09-28)

Improvements

Auto-correct wrong column expressions after browser refreshes

1.2.0

(2018-09-24)

Features

Ability to view Sales report based on Orders, Invoices and Credit Memos

Fixed

Use sales source date (order/invoice/credit memo) for date range filter

1.1.4

(2018-09-18)

Fixed

Widgets do not displayed with non-english locales #127

1.1.3

(2018-09-17)

Fixed

Error by cron updating GEO-data

1.1.2

(2018-09-03)

Improvements

Display 'View Orders' action in 'Sales by Shopping Cart Price Rules' report

1.1.1

(2018-08-31)

Fixed

Date range intervals show incorrect date in report filter

Documentation

Info about 'Sold Items' report

1.1.0

(2018-08-16)

Features

New report 'Catalog > Sold Items'

1.0.54

(2018-08-14)

Fixed

Additional time offset setting has no effect

Documentation

Translate GEO data for Germany
Troubleshoot for case when region part is not highlighted on a map in the Sales by Geo-data report

1.0.53

(2018-08-13)

Improvements

Use shipping address state for Geo report as the fallback, if state has not been downloaded

1.0.52

(2018-08-10)

Improvements

Use free daily quote instead of keys for downloading info about unknown postcodes

Fixed

Filter Invoice report by invoice creation date range instead of order creation date
Attribute detailed report does not consider 'include child products' option

1.0.51

(2018-08-07)

Improvements

Add order increment numbers column to Catalog > Bestsellers report
Ability to view placed orders from Product Details report
Ability to use all the available product attributes as columns in Bestsellers report

1.0.50

(2018-08-02)

Improvements

Add billing address column to the Sales > Orders report

Documentation

Modify column's expression to subtract the refunded amount from the order's grand total

1.0.49

(2018-07-30)

Fixed

Some catalog reports are not displayed: do not treat strings as numbers

1.0.48

(2018-07-24)

Improvements

Add Shipping Address column to Sales > Orders report
Shipping telephone column for Sales > Orders report

Fixed

Update API codes for fetching geodata and update unknown post codes

1.0.47

(2018-07-17)

Improvements

Shipping City column for Sales > Orders report

Documentation

Information about automatic GEO-Data fetching

1.0.46

(2018-06-25)

Improvements

Ability to filter records by multiple SKUs

1.0.45

(2018-06-22)

Fixed

Do not duplicate rows at Sales > Orders report

1.0.44

(2018-06-12)

Fixed

Consider filters when exporting orders in Sales \ Orders report

1.0.43

(2018-06-08)

Fixed

Handle different type of errors for custom columns expressions

1.0.42

(2018-06-07)

Features

Ability to set custom expressions for columns

1.0.41

(2018-05-30)

Fixed

Persist all report toolbar options across different reports

1.0.40

(2018-03-28)

Fixed

Menu is overlapped with a column's value in Sales by Customer report

1.0.39

(2018-03-20)

Improvements

Payment Method column for Invoices report

1.0.38

(2018-03-15)

Improvements

Correctly format exported values, specifically of type 'number'

1.0.37

(2018-03-07)

Fixed

Error in 'Sales \ Invoice' report
Wrong format of 'Gross Profit' values in 'Sales \ Invoice' report
Report error if product attribute code contains the dash character
Report chart 'save image' button does not work
Report 'Sales \ Orders' shows all orders on a single page

1.0.36

(2018-02-22)

Fixed

Capitalize folder names, error displaying reports

1.0.35

(2018-02-19)

Fixed

Export orders including filters in Sales \ Orders report

1.0.34

(2018-01-24)

Bugfixes

Error displaying customer report
Fix error 'undefined index'

1.0.33

(2018-01-24)

Bugfixes

Wrong values due to grouping by invoice date #100

1.0.32

(2017-12-12)

Improvements

Accelerated Bestseller widget
Documentation

1.0.31

(2017-12-11)

Improvements

Changed default behaviour of "Process Orders" configuration item. Now, by default, the reports contain orders with all statuses

Features

Added filter by AdminPanel/Frontend orders

1.0.30

(2017-12-05)

Improvements

Modified the time zone accounting method

1.0.29

(2017-11-22)

Improvements

Added "Sales by Coupon" widget
Accelerated "Lowstock" widget

Fixed

Fixed "quarter" and "previous quarter" time intervals
Fixed a method for determining the New/Returned customer for "Not Logged In" customer
Compatibility with MySQL 5.7 default mode 'ONLY_FULL_GROUP_BY'

1.0.28

(2017-10-13)

Improvements

Added filter by category level to "Sales by Category" widget
Added filter by "products" column to Customer > Customers report
Added "Conversation rate" column to Products/Bestsellers report
Added "Is Active" column to "Sales by Category" report
Added column "View Orders" to "Sales by Country" report
Added column "View Orders" to "Sales by Customer" report
Added drop-down menu to the filter by payment type

Fixed

Fixed "Products" column in "Customer > Customers" report for the case when the product was removed from admin panel
Renamed a column "Credit Card Type" to avoid duplication

1.0.27

(2017-07-18)

Features

Reduce time for advr_geo_copy_unknown cron task
Added ability to see orders with a specific coupon (to "Sales by Coupon" report)

Improvements

Group Sales by Customer report by customer email

Fixed

Properly count totals - totals wrong when order have multiple invoices

1.0.26

(2017-06-08)

Improvements

Optimized SQL queries for "Bestsellers and "Low stock" widgets

Fixed

Fixed an issue with Sales by Category widget

1.0.25

(2017-05-31)

Improvements

Accelerated "Catalog" reports
Added filtering and sorting to the Invoice column of "Sales > Orders" report
Added time filtering to Visits columns of "Catalog > Products/Bestsellers" report
Added ADVR translate file
Added the ability to build the geo-report for both the billing address and the shipping address
Added "Not Logged In" group to Sales > Orders report
Added "Sales by Shipping Method" widget
Added "Sales by Customer Group" widget
Added "Sales by Category" widget
Added dashboard filter by "Customer Group"

Fixed

Fixed links to the orders at Orders report with group data by Date of Invoice creating
Added rounding of column Average Items Ordered
Added "Sales by Shipping Method" report to ACL
Modified method of acounting of bundle child products ("Catalog > Products/Bestsellers" report)
Fixed an issue with the date "2017-01-01" with grouping by week at Sales reports
Fixed an issue with column sorting in "Sales by Category" report
Fixed an issue with account of virtual products in "Bestsellers" widget

1.0.24

(2017-01-18)

Improvements

Added "Total" to Sales > Orders report

Fixed

Fixed problem with viewing the details of a large number of orders

1.0.23

(2016-12-02)

Improvements

Use browser's local storage to keep status of dashboard lock
Apply store filter to Reviews report
Catalog reports unified

1.0.22

(2016-11-28)

Improvements

Added documentation

1.0.21

(2016-11-11)

Features

Added Google JS Geo Keys
Added widget "Low Stock"
Added ability to show all products in Low Sales report

Fixed

Fixed an issue where the filter by order status is applied for the "Orders" report (affects from 1.0.17)

1.0.20

(2016-10-25)

Fixed

Fixed labels for Geo-data report

1.0.19

(2016-10-25)

Fixed

Added export callback to created_at column

1.0.18

(2016-10-06)

Fixed

In some cases the chart widgets show charts and data from another chart widgets (affects all)

Improvements

Apply all the filters when clicking the link 'View Orders' at the 'Sales' report

1.0.17

(2016-09-13)

Features

Added the ability to start week on Sunday in "Sales by Day of Week" report

1.0.16

(2016-08-19)

Features

Added ability to filter reports by invoice date

Fixed

Fixed an issue with calculation the quantity of ordered products at the report Sales by Category
Fixed week period when report shows by week

1.0.15

(2016-07-19)

Fixed

Fixed filter data storage when changing localization

1.0.14

(2016-07-19)

Fixed

PHP Fatal error: Redefinition of parameter $row in callback method (affects all)

1.0.13

(2016-06-17)

Features

Added sorting of "Products/Bestsellers" report by "Gross Profit" (in percents)

1.0.12

(2016-06-03)

Features

Added "Sales By Credit Card Type" report
Added Registered vs Unregistered Customers report

Fixed

Corrected the calculation of order quantity in Customer / Customer report

1.0.11

(2016-05-19)

Fixed

Corrected link to the product page in Bestseller widget (affects from 1.0.10)

1.0.10

(2016-04-21)

Features

Added "Sales by Tax Rates" report

Fixed

Corrected dashboard response
Fixed failure of timezone accounting

Improvements

Ability to set sort order and direction for widget bestsellers

1.0.9

(2016-04-08)

Improvements

Added Morocco Geo Data

1.0.8

(2016-03-30)

Improvements

Added Average Price column to Product/Detail report
Performance improvement for the customers report

1.0.7

(2016-03-21)

Fixed

Fixed issue of loading widgets (affects from 1.0.6)

1.0.6

(2016-03-17)

Fixed

Problem with currency if the report contains orders in different currencies

1.0.5

(2016-03-11)

Features

Ability to choose sort field and direction for widget 'Last search terms'
New report 'Sales by Shopping Cart Price Rules'

Fixed

Use correct type for datetime fields

Improvements

Test for checking existence of the extension 'Enhanced Admin Grids'
Ignore tz for widget 'Bestsellers'

1.0.4

(2016-03-09)

Features

Ability to manually send widget notifications

1.0.3

(2016-02-17)

Fixed

Wrong sort order in order-related widgets

Improvements

Column gross profit for report Sales / Orders

1.0.2

(2016-02-15)

Fixed

Wrong values if customer has multiple addresses (affects from 1.0.1)
Use given attribute instead of the column sales_order_table.created_at
Wrong values in report Sales by Category (affects from 1.0.1)
Fixed an issue with json decode (PHP7)
Fixed an issue with notification time set (11:30AM, 12:00AM)

Improvements

Display chart for report Advanced Reports / Sales / Orders
Sort widgets from left to right, from top to bottom and use this order for notifications
Columns 'Created At' and 'Updated At' for product-related reports
Show chart at the report lowstock and allow to include childs
Added ability to select columns for bestsellers widget
Added Bestsellers widget to dashboard

1.0.1

(2015-05-29)

Fixed

Fixed an issue with js error in report sales/orders (add_filter_by does not exists)
Fixed issue with filter by product name
Fixed an issue while filtering reports, when filter data contains empty string or null or false
Color issue with column chart
New column Product Cost
Issue with address columns in the report Customers > Customers

Improvements

Report: Sales by Shipping Method
Rows with totals for report Orders/Plain

Was this page helpful?

Your feedback about this content is important.
Let us know what you think.