Getting Started

Welcome to the Advanced Reports Documentation. Whether you are new or an advanced user, you can find useful information here.

Next steps:

How to install extension

  1. Login to Magento backend.
  2. Go to System > Tools > Compilations.

    If Compiler Status is Enabled, disable the compilation by clicking the button Disable in the upper right corner.

  3. Backup your store database and web directory.
  4. Download extension from your Personal Account.
  5. Unzip the extension locally.
  6. Copy contents of the folder step1 to the root directory of Magento store.
  7. Copy contents of the folder step2 to the root directory of Magento store.
  8. Completely clear the site cache.

    Go to System > Cache Management. Click button Flush Magento Cache. If you want to clear the cache manually, you need to remove a folder /var/cache at the server.

  9. Logout from Magento backend and login again.
  10. Setup a cron job for Magento. See How to Setup Cron for Magento.
  11. Go to System > Configuration > Mirasvit Extensions > System, at form Installed Extensions press the button Run validation tests for all extensions for check extension installation and configuration.
  12. If compilation was enabled before installation, you need to run recompilation process to enable compilation. Go to System > Tools > Compilation and click on Run Compilation Process.
    If you did not disable compilation and store is down after installation, follow the link and make next steps to recover the store.

Next steps:

General Settings

All settings for tuning-up Advanced Reports extension are located at System -> Configuration -> Advanced Reports. It can be also accessed via shortcut Advanced Reports -> Settings -> Configuration.

There are three sections:

Appearance

Option Description
Display Advanced Reports under native Reports If option is enabled, Advanced Reports tab will be displayed in the dropdown list of the native Magento Reports menu. If disabled, Advanced Reports link will be displayed separately on the Magento panel menu.
Replace Dashboard link to Advanced Dashboard If option is enabled, Advanced Dashboard will replace native Magento Dasboard. In another case, Advanced Dashboard tab will be displayed in the drop-down list of the native Magento Dashboard menu button.

Configuration

Option Description
Process Orders Defines a statuses, which order should have to be displayed in Reports.
Display addresses in the Customers report Displays addresses in Customers Report. Note: Can decrease performance, if customer collection is too large.
Group data by time of Defines, which timestamp should be used for Orders grouping - when Order Created or Last Order Update.
Add Customer Group filter to Dashboard widgets Defines whether Customer Group should be displayed on Dashboard widgets. If enabled, you can filter Dashboard widgets by customer group.

Time Configuration

Option Description
Additional time offset, hours Using this setting you can control the offset for the time options available at the date range filter in the reports and at the dashboard. For example, setting it to 5 will cause the today's date range start instead of 00:00:00 to 00:05:00.

Please, when configuring Orders Reports options, pay attention to the following release specifics:

Advanced Reports <= 1.0.30

By default, reports (except Sales -> Orders report) contain orders only with "complete" status. Sales > Orders report contains "Status" column and filter by orders statuses

Advanced Reports >= 1.0.31

By default, reports contain orders with all statuses

Email Notifications

Our extension can send emails with different types of the report notifications.

To configure them, visit Dashboard -> Advanced Dashboard or User Dashboard. Click the Email Notification link, located just near Add Widget button, to enter Notification Pane.

To configure Email Notification you need to have at least one defined Widget.

Email Notifications Pane consists of two sections, as shown on this screenshot:

email

Email section defines notification itself:

  • Is Active - whether notification is active and sent on specified event.
  • Email Subject - subject of that notification.
  • Email To - comma-separated list of notification recipients.
  • Widgets - a list of widgets, data from which should be included to notification.

Extension sends Email Notification reports without data charts, only with raw data.

Here is list of standard widgets, data from which can be included to the notification:

  • Sales Metrics

    • Number of Orders
    • Number of Ordered Products
    • Grand Total
    • Subtotal
    • Discount
    • Invoiced
    • Refunded
    • Shipping Amount
    • Tax Amount
    • Gross Profit
    • Average Number of Ordered Products
    • Average Grand Total
    • Average Subtotal
    • Average Discount
    • Average Invoiced
    • Average Refunded
    • Average Shipping Amount
    • Average Tax Amount

     

Second section is called Schedule and contains notification sending details:

  • Cron job - is the cron task, which actually sends notification.
  • Current Time - displays current time.
  • Last Sent - date of last notification sending.
  • Day - days of week, when notification should be sent. Selecting all days makes notification daily, and only one of them weekly.
  • Time - time, when notification should be sent. Selection all positions makes notification half-hourly, only odd or even positions makes hourly, and only one defines daily or weekly (depending on previous option).

Geo Data

The report Sales By Geo-data requires import geo data (postcodes).

If you did not find GEO-Data file for required country - just wait, our extension will automatically fetch GEO-Data for unknown post codes.
Every hour, extension will fetch information for 100 postal codes. To check actual number of unknown post codes go to Advacned Reports -> Settings -> Import Geo Data.

Once files were acquired, do the following:

  • Upload selected files to magento folder [magento base path]/media/advr at your server.
  • Go to Advacned Reports -> Settings -> Import Geo Data.
  • Select files and press button Import Geo Data.

Please import only required countries data for better performance.

Advanced Reports

Toolbar Filter

Most reports contain additional filter in the toolbar. The set of possible filters are divided into the groups: "Orders", "Order Items", "Product", "Other".

toolbar_filter

The group "Orders" includes filters by parameters that describe the order or group of orders. Examples of these filters: "Order Status", "Number of orders", "Number of refunded orders", "Total Qty Ordered", "Discount Amount", "Shipping Amount", "Tax Amount", "Total Refunded", "Total Invoiced", "Total Invoiced Cost", "Grand Total", "Subtotal", average values of parameters that were described above, "Customer Name (Full, First, Last)", "Customer Email", "Customer Group", "Coupon Code", "Shipping Method" etc.

The group "Order Items" includes filters by parameters that describe the order products. Examples of these filters: "Qty Ordered", "Qty Refunded", "Row Total", "Amount Refunded", "Tax Amount", "Discount Amount", "Gross Profit", "Cost".

With the same or similar names with the filters of the previous group, the actions of these filters are different.

Filters of group "Product" allow you to group the reports by "Product SKU", by "the time of product creation", by "the time of its last edition", by set of attributes and by all attributes of the products in the store (name, brand, color, weight, etc.).

Filters group "Other" also describe the order or group of orders. Examples of these filters: "Country", "State/Province", "City", "Postcode", "Customer Company", "Payment Method", "Sales Rule Title/ID", "Tax Identifier/Title/Rate" etc.

We strongly recommend that you apply filters of groups "Orders", "Other" to the "Sales" reports.

Applying filters of groups "Order Items" or "Product" to "Sales" reports, we can get "not quite" the expected results. Indeed we receive orders which contain the product if we apply filter "product" or "order item" to the "Sales" report. However, the values obtained will characterize orders (with taxes and shipping that apply to whole orders), rather than individual products in the orders.

We recommend that you apply filters of groups "Order Items", "Product" to the "Products" reports.

For example, we need to apply a filter based on the product attribute for a report that works with orders.

Let's take as an example to analyze the sales of products with the attribute "color"(black).

Sales report how to use filter by product attribute in sales reports

In such a non-recommended situation, we can be 100% sure of the right number of orders. We have the ability to view these orders by clicking link "View orders".

Let's see the information on orders for Dec 2, which contain products with the attribute color = black.

Orders with general statistics how_to_see_full_order_statistics_with_filtering_by_product_attribute

Please note that you can not add additional filters to the received report. In this case, the filtering, added in the initial report, will be lost.


Managing Columns

Each report has an special feature, that allows you to add a synthetic field (i. e. calculated from other fields).

It is accessible via Manage Columns button at the button pane just below date filters. Press that button to bring Columns Manager:

Columns Manager

This popup grid contains a list of additional columns, that can be shown on your report. Each row is a column definition, which will be calculated from columns of current table, and consists of the following parameters:

  • Visible - defines, whether column should be displayed on the Report.
  • Header - is the sensical name of this additional columns.
  • Expression - is the SQL expression, that calculates value of synthetic column.
  • Position - is the position of this column in data table.

Some of these columns are already marked - they are displayed by default on your Report.

You can also pick up a row and alter it as you need, entering to Header name of custom column, and to Expression proper SQL expression. Read more about SQL calculation expressions.

Mark it as Visible and press Save Configuration button to make your custom column appear in Report.

Warning:If you changed a column, and accidentally made a mistake - on configuration saving error will be thrown.

Just reload this page again: our extension automatically will detect an error and return column to its default state.

Sales Reports

Extension provides a wide range of sale reports using various tools for analysis and improving sales.

Go to Advanced Reports -> Sales. There are the following reports available:

Extension allows to show reports for all websites and separately for each store view. You can analyze your product sales on the Chart.

  • Grand Total - total amount of the sales revenue for a selected period
  • Gross Profit - the difference between the amount paid and the cost of products
  • Subtotal - the order value without shipping costs and taxes
  • Refunded - the amount of refunded money
  • Tax - the amount of taxes
  • Shipping - the amount of money, paid for shipping
  • Discount - the amount of the used discounts
  • Items Ordered - number of purchased products
  • Number of Orders - number of orders

    The averages of these parameters

Extension allows to show reports for different Store views, vary report period, compare attributes and values.

Sales

General sales report. It allows to see the net sales, discounts, returns etc. The use of such a tool will enable you to group data by days, weeks, months, years.

sales_main


UP

Orders

The report allows you to see all the information related to the orders: totals, discounts, refunds, taxes, shippings, etc.
The report contains information about the customer (name, email, customer group), state and status of the order, payment type, tracking number and purchased products.

sales_orders


UP

Sales By Hour of Day

Hourly sales report. You can detect the hours during of which personnel of your shop is overloaded at the maximum extent. This will allow you to plan the working hours as well as perform possible updates in your shop.


UP

Sales by Day of Week

Weekly sales report.


UP

Sales by Customer

The report allows you to analyze the customer sales information (number of purchases, quantity of ordered products, Grand Total, Discounts, Refunds, Taxes, Shippings, etc).
The report contains the customers who have made purchases in the analyzed period.

You can see more detailed information about all customers at the Customers report

sales_customer


UP

Sales By Customer Group

The sales report generated over different user groups. Using such tool, you can determine the efficiency extent of your work with different user groups. sales_group


UP

Sales By Country

The report that reflects sales volumes in different countries achieved during definite period of time.

sales_country


UP

Sales By Geo-data

Advanced Geo Report is based on the postal codes. We can use the billing or shipping addresses as the basis of the report.
The report displays data grouped by countries, administrative units (states, provinces), cities, zip codes. Multiple display modes.

sales_geo sales_geo2 sales_geo3 sales_geo4


UP

Sales by Category

The report contains information about the sales of products of different categories. The report allows to analyze product categories and to consider further marketing company.

sales_category


UP

Sales By Payment Type

The report allows you to define the popularity extent of different payment methods.

sales_payment_type


UP

Sales By Credit Card Type

The report allows you to define the popularity extent of different credit card types.

sales_payment_type


UP

Sales By Tax Rates

The report displays the sales information for different tax rates. The report can be useful in the analysis of sales in several countries (with different tax rates) or different products (physical, virtual, services) etc. sales_tax_rate


UP

Sales By Coupon

The report, which allows you to gain knowledge regarding which coupons are the most favorable in terms of sales volume, and which ones should be elaborated in a better way.


UP

Sales By Shopping Cart Price Rules

The report allows you to analyze statistics for Cart Price rules. Allows to analyze the effectiveness of the Cart Price rules conditions.

sales_cart_price_rule


UP

New vs Returning Customers

The report allows to make a comparative analysis of the purchases made by new customers and returning customers. The dependence of the number of purchases on time reveals the period of attraction of new customers.
It allows to analyze the reasons for the increased customer base. Accordingly, there is an opportunity to identify ways to retain customers.

new_returning_customers


UP

Registered vs Unregistered Customers

The report allows to make a comparative analysis of the purchases made by registered and unregistered customers.

registered_unregistered_customers


UP

Sales by Shipping Method

The report contains information about the popularity of different shipping methods. sales_shipping_method


UP

Average Shipping Time

The report allows to analyze the shipping time.

average_shipping_time


Previous:

See next:

UP

Products Reports

Extension allows to analyze product sales for each store view and provide next data reports:

If you tick on Include child products, report will include child products

Products/Bestsellers

Bestsellers provides information regarding the best-selling products, which can be sorted on an amount of sold products, sales volume, discount etc. Go to Advanced Reports > Products > Bestsellers
Extension allows to show reports for all websites and separately for each store view. You can analyze your product sales on the Chart. Add additional columns to compare next values:

  • Total - total amount of the sales revenue for a selected period
  • Refunded - the amount of money, refunded for a certain product
  • Discount - the amount of the used discounts for a certain product
  • Tax - the amount of taxes paid for a certain product
  • Quantity Refunded - quantity of the product refunds
  • Quantity Ordered - quantity of the product orders
  • Unique Guest Visits - quantity of the guest visitors (non-registered customers)
  • Unique Customer Visits - quantity of registered customers who have visited the product page

You can display the chart for any of the parameters of the report

catalog_product


UP

Sales by Attribute

Sales by product attributes (by manufacturer, brands, colours etc.) is the unique report of a kind, allows to derive grouped data on any attribute of a product of interest. For instance, you can get information with regard to sales on each brand, category, colour or supplier.
You can analyze sales on the Charts. Add additional columns to the chart for sale statistics analysis: click on the buttons under the chart to compare next values:

  • Total - total amount of the product sales revenue for a selected atrribute
  • Refunded - the amount of money, refunded for a certain attribute products
  • Discount - the amount of the used discounts for a certain attribute products
  • Tax - the amount of taxes paid for a certain attribute products
  • Quantity Refunded - quantity of the attribute product refunds
  • Quantity Ordered - quantity of the attribute product orders

For example, you can analyze store sales by attribute Color: product_sales_attribute

The order may include several products with different values of this attribute. This means that such an order will be added to each attribute value of the product. That is the order will be counted several times and the total number of orders is more than the actual number of orders. For example, we have an order #1 with the products with color "red" and "blue" and the order #2 with a product of the "green" color. As a result, the report will show for each of the colors "number of orders = 1" (the sum = 3 that is greater than actual number = 2).


UP

Sales by Attribute Set

The report contains information on product sales related to different attribute sets

product_sales_attribute_set


UP

Low Stock

The report allows you to monitor the availability of products in stock. The report contains information on the number of products in a inventory and quantity of orders at a selected period of time. You will be able to see which products run out, to evaluate the end time, to draw conclusions about product orders for the store.

If you tick on Show All Products, the report will show all the products (including products that were never sold). Filter the time of sales is disabled in this mode.

low_stock.png

Sold Items

This report lists all the sold items separately together with its order and customer details, so you can quickly find out what product a specific customer has ordered and in which order. The report also contains sales details of this item in the order.

sold_items.png

Previous:

See next:

UP

Customers Reports

Extension allows to make customer analysis.

Customers

The report contains detailed information about customer: name, email, customer group, address, company, the date of account creating, the number of orders, the date of last order, purchased products.

In contrast to the report "Sales by Customer" you can see all customers (including those who haven't made any purchases)

customers_customers

Previous:

See next:

UP

Reviews Reports

Reviews

The report shows the dynamics of the number of customer reviews. There is a possibility of extending the functionality of the report.

reviews_reviews

Previous:

UP

Dashboards

Advanced Reports extension allows to place widgets with key metrics to the dashboard of your store. Our versatile widgets will help you to track your sales performance at your fingertips.

There are two dashboards are available from Dashboards menu:

  • Advanced Dashboard (Global) - main dashboard, which configures to show global sale reports.
  • User Dashboard - additional dashboard, which allows to set up reports for the users special requirements.

You can replace native Magento Dashboard menu button with Advanced Dashboard. In this case Advanced Dashboard will be named just Dashboard. Refer to General Settings for more info.

Automatic sending reports to emails is configured at separate Email Notifications for each Dashboard.

Each Dashboard consists of one or more Widgets, as shown on examples below.

dashboard1 dashboard2

There are two available Widget types:

  • Sales Metrics (grand totals, subtotals, discounts, refunds, shipping, tax, number of orders, number of ordered products, average values etc.). You can select different time intervals for the report such as today, yesterday, week, month,quarter, year, lifetime etc. Similarly, you can select the previous period for comparison.
    Sales Metrics can be seen at Widgets 1, 2, 3, 4 on the Example 1
  • Sales Chart (grand totals, subtotals, discounts, refunds, shipping, tax, number of orders, number of ordered products, average values etc.)
    Sales Charts can be seen at Widgets 5, 6, 7 on the Example 1 and widgets 6 at the Example 2

You can also check out the following additional examples:

  • Orders by Status (widget 10 at the Example 1 and widgets 4 at the Example 2)
  • Sales by Country (widgets 5 at the Example 2)
  • List of Latest Orders (widget 8 at the Example 1)
  • List of Latest Search terms (you can sort widget by "search term", "number of results", "number of uses(popularity)", "recent use"). Widget 9 at the Example 1
  • Bestsellers (you can sort the widget in any direction on any of its columns).
  • Low stocks

Widgets 1 and 2 (Example 2) are sorted by the quantity of ordered products in the direction of decreasing and widget 3 (Example 2) is sorted in the direction of decreasing of Gross Profit.

When you hover the mouse over the graphic widget you can see the numerical values of the parameters (ex. widget 7(Example 1) - Grand Total = 2,385 for 09 Sep, 2016; widget 4(Example 2) - The number of "complete" orders = 10(38,5%))

Widgets 1-3 (Example 2) show bestsellers widget for customer group general (w.1 - sales for lifetime , w.3 - sales for 2016), for not logged and other groups (w.2).

Widgets 4 and 5 (Example 2) show orders by status and sales by country widgets for different customer groups.

Refer to Widgets section to know, how to create new Widget.

Dashboards Permissions

Extension allows to set view and action permissions for the different users.

To set permissions, visit System -> Permissions -> Roles and do the following:

  • Create a new Role and open Role Resources tab.
  • Tick on the Advanced Dasboard (Global), Actions and Manage to allow user view and make actions over the Advanced Dashboard widgets.

permission

Actions permission allows you to add new widgets and change their position or size on the dashboards.

Widgets

Widgets can be flexibly configured to receive the most important information for analysis on your dashboard.

Widgets can be created with Add Widget button. It will bring up Widget creation dialog:

widget

There are the following parameters:

  • Widget - widget type. There are the many possible widgets, each with their own parameters. Read more below.
  • Title - sensical title for the Widget.

Rest of parameters depend on precise widget type. There are the following possible Widgets:

  • Metrics - this is the most common Report, which allows you to have order statistics. Expand to see required parameters:

    • Metric - which order property should be used for report. There are all totals available, such as Number of Orders, Grand Total, Invoiced, Refunded, Shipping Amount and so on. You can also select here Average metrics.
    • Period - a period, which should be analyzed to calculate selected metric.
    • Compare with - comparison period. There are four pre-defined values:
      • Previous Period
      • Same Period Last Week
      • Same Period Last Month
      • Same Period Last Year

     

  • Sales By Coupon- analyzes orders, where Coupon was used. Expand to see required parameters:

    • Period - a period, which should be analyzed to calculate selected metric.
    • Number of Coupons - quantity of last used Coupons, that should be included to the Report.

     

  • Sales By Customer Group - analyzed orders from customers group point of view

    • Period - a period, which should be analyzed to calculate selected metric.
    • Columns - additional columns, that should be displayed on the widget.
    • Sort By Field - select a field, on which internal data table should be sorted. This field should be selected in previous data control.
    • Sort Direction - sorting direction. Can be either descending (DESC) or ascending (ASC).

     

  • Chart - a curved-line chart, that displays order property's dynamics.

    • Metric - which order property should be used for report. There are all totals available, such as Number of Orders, Grand Total, Invoiced, Refunded, Shipping Amount and so on. You can also select here Average metrics.
    • Range - a period, which should be analyzed to calculate selected metric. There are four pre-defined values:
      • Day
      • Week
      • Month
      • Year
    • Number of Values - quantity of last values of selected Metric, that should be analyzed and turned into curve chart.

     

  • Last Orders - a short summary of last placed orders

    • Number of Orders - quantity of orders, that should be analyzed and turned into table widget.

     

  • Sales By Category - analyzes sales from products categories, that were bought.

    • Period - a period, which should be analyzed to calculate selected metric.
    • Columns - additional columns, that should be displayed on the widget, such as Level (Nesting Level), Number of Orders, Qty Ordered, Qty Refunded and so on.
    • Category level - nesting level, that should be used in calculations.
    • Sort By Field - select a field, on which internal data table should be sorted. This field should be selected in previous data control.
    • Sort Direction - sorting direction. Can be either descending (DESC) or ascending (ASC).

     

  • Orders By Status - analyzes orders by their transitional status.

    • Period - a period, which should be analyzed to calculate selected metric.

     

  • Sales By Country - creates a pie chart, from which country order was placed.

    • Period - a period, which should be analyzed to calculate selected metric.

     

  • Sales By Shipping Method - analyzes sales by shipping methods.

    • Period - a period, which should be analyzed to calculate selected metric.
    • Columns - additional columns, that should be displayed on the widget, such as Shipping Method, Number of Orders, Invoiced, Refunded and so on.
    • Sort By Field - select a field, on which internal data table should be sorted. This field should be selected in previous data control.
    • Sort Direction - sorting direction. Can be either descending (DESC) or ascending (ASC).

     

  • Low Stock - analyzes products inventory.

    • Number Products - products with lowest inventory, that should be analyzed.
    • Columns - additional columns, that should be displayed on the widget, such as SKU, Name, Stock Quantity, Stock Availability and so on.
    • Sort By Field - select a field, on which internal data table should be sorted. This field should be selected in previous data control.
    • Sort Direction - sorting direction. Can be either descending (DESC) or ascending (ASC).

     

  • Bestsellers - analyzes best-performing products of your store

    • Period - a period, which should be analyzed to calculate selected metric.
    • Number Products - products with highest sales, that should be analyzed.
    • Include child products - allows to analyze separately elements of Configurable, Bundle or Grouped products.
    • Columns - additional columns, that should be displayed on the widget, such as SKU, Name, Qty Ordered, Qty Refunded and so on.
    • Sort By Field - select a field, on which internal data table should be sorted. This field should be selected in previous data control.
    • Sort Direction - sorting direction. Can be either descending (DESC) or ascending (ASC).

     

  • Search Last Terms - displays last search stats as table.

    • Number of Search Terms - defines a number of search queries, that should be analyzed.
    • Sort By Field - select a field, on which internal data table should be sorted. There are four possible values:
      • Recent Use
      • Search Term
      • Number of Uses
      • Results
    • Sort Direction - sorting direction. Can be either descending (DESC) or ascending (ASC).

     

You can also remove or edit widget anytime. For that just move your mouse to the right upper corner of desired widget, and you will see small popup actions menu: Remove, Refresh and Configure.

Important Note
Most Widgets feature Customer Group parameter, which allows you to create widgets for tracking performance of specific group, or their comparison. customergroupfilter

Upgrading

To upgrade extension follow next steps:

  1. Login to Magento backend.
  2. Go to System > Tools > Compilations.

    If Compiler Status is Enabled, disable the compilation by clicking the button Disable in the upper right corner.

  3. Backup your store database and web directory.

    If you have customizations, please, create a separate backup of app/code/local/Mirasvit before upgrading to the new version.

  4. Download new extension package from your Personal Account.
  5. Unzip the extension locally.
  6. Temporary disable extension. Check Temporary Disabling.
  7. Copy contents of the folder step1 to the root directory of Magento store.
  8. Copy contents of the folder step2 to the root directory of Magento store.
  9. Completely clear the site cache. Go to System > Cache Management. Click button Flush Magento Cache. If you want to clear the cache manually, you need to remove a folder /var/cache at the server.
  10. Logout from Magento backend and login again.
  11. If necessary adjust css styles to fit your store's frontend theme.
  12. If compilation was enabled before upgrade, you need to run recompilation process to enable compilation. Go to System > Tools > Compilation and click on Run Compilation Process.
    If you did not disable compilation and store is down after installation, follow the link and make next steps to recover the store.

Disabling

Temporary Disabling

To temporary disable extension, please, follow the next steps:

  • Disable Compilation Mode (if enabled).
  • Remove file app/etc/modules/Mirasvit_Advr.xml.
  • Remove file app/etc/modules/Mirasvit_Advd.xml.
  • If you have only one extension from Mirasvit installed, remove file app/etc/modules/Mirasvit_MstCore.xml.

  • Login in to Magento back-end and refresh site cache (if enabled).

Extension Removal

To uninstall extension, please, follow the next steps:

  • Disable Compilation Mode (if enabled).
  • Remove file app/etc/modules/Mirasvit_Advr.xml.
  • Remove file app/etc/modules/Mirasvit_Advd.xml.
  • If you have only one extension from Mirasvit installed, remove file app/etc/modules/Mirasvit_MstCore.xml.
  • Login in to Magento back-end and refresh site cache (if enabled).
  • Remove folder app/code/local/Mirasvit/Advr.
  • Remove folder app/code/local/Mirasvit/Advd.

Troubleshoot

  • Orders Grand Total and Gross Profit columns do not account refunded amount.

    By default Magento does not subtract the refunded amount from the order's grand total amount. So the module shows the default raw values.

    Solution:
    Since the version 1.0.42 we have added an ability to modify the columns' expressions used to calculate the result value.
    To account the refunded amount in the columns above, simply add the following code to the column's expression: - IFNULL(sales_order_table.base_total_refunded, 0).
    Here is how the result expression may look like for the Grand Total column in the Sales > Orders report: (sales_order_table.base_grand_total - IFNULL(sales_order_table.base_total_refunded, 0))

  • State, province or place is not highlighted on a map in the Sales by Geo-data report

    In some cases a row with a country's state (province or place) is displayed in the grid of a report, however, the corresponding part of a map is not highlighted.

    Solution:

    Google, in its documentation, states that a region code should be written in uppercase ISO-3166-2 compliant format. For example, for Germany, in order to highlight the state we can use either its Subdivision Name (Bayern) or a corresponding Code (DE-BY).

    For states our module uses the subdivision names, however, the practice proves, that not all the correctly formed subdivision names are always visible on a map. So, if it's true for you, you just need to use the appropriate Code instead.

    To change the subdivision name to code you can simply use the Magento translation mechanism, you can place the string below to your translation file:
    "Bayern", "DE-BY"

    Then clean the translation cache and refresh the report.

Change Log

Change Log

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

Advanced Reports