This module provides a reports dashboard for Drupal Commerce. It functions differently between Drupal 7 and Drupal 8/9, so please take a minute to review the distinctions before installing the module on your site.

Drupal 7

The screenshots on this page are from the Drupal 7 version. On Drupal 7, this module used the Views module to create a dashboard and reports by directly querying product and order objects in the database. These included:

  • Table-based reports for sales with filtering by order status and date ranges. The report can break sales down monthly, weekly and daily.
  • Table-based reports for customers, products and payment methods.
  • An advanced reports dashboard showing a summarized view for all the above reports, visualization done by Google Visualization API via Charts module.
  • The ability to export to CSV files when Views Data Export is enabled.

These reports may not function well with high sales volumes, because they query the raw data stored in the various Drupal entity and field tables. Additionally, they only reflect the current state of data in your database, meaning you will have a general idea of sales performance but not a full accounting for how refunds or cancelations impact past sales.

This version of the module includes a few submodules:

  • Tax reporting. Uses the Batch API to generate sales tax reports by extracting tax related price components from historical orders.
  • Geckoboard. Provides integration with Geckoboard allowing for reporting information about your revenue, sales, and orders. (Not tested on the 4.x branch.)
  • Stock. Provides detailed insights into current product stock and projected stock lifetimes.

Commerce Reports 7.x-4.x

The 7.x-4.x branch is an overhaul of the module decoupling the dependency of Visualization API, as it would have to be maintained simultaneously. It also replaces the granularity Views plugin the module provided with Views Date Format SQL and utilizes Date Popup from Date module. Review the README.txt for more information.

Development is organized on a third party kanban board to prioritize issues for release.

Commerce Reports 7.x-3.x

The 3.x branch of Commerce Reports was developed as part of the Google Summer of Code project Sales Reports for Drupal Commerce. This branch depends on the Visualization API.

Drupal 8

The Drupal 8 version is more of a utility module that site builders and developers can use to create custom reports and dashboards, though it comes with much less out of the box.

Its primary purpose is to define a system for generating report data in custom tables when orders are placed. Reports are then built by querying purpose built datasets as opposed to querying the entity and field tables directly, which can make report generation on high volume stores more performant. It also makes it easier to inspect and / or revise historical report events based on order updates.

Report types supported at present include orders, order items, promotions, and taxes with default Views for overall sales and for reporting sales by purchased product.

Supporting organizations: 
Drupal 8 port, maintenance

Project information

Releases