Change Log

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

Advanced Reports