User's Guide

Knowledgebase

Quick Links
 
This article applies to: ML8, MultiStore

Custom Report

From the Orders menu, click Reports → Custom Report

If the built-in reports don't meet the needs of your site, the store admin can create custom reports and run them through this page. The reports are simply SQL commands stored in the database, which can be run at any time. This page does not allow the creation of those reports, nor does it do any nice formatting of them.

Adding a Custom Report

First you'll need to add your custom report to the database through a SQL query.

Values to be used:

- Name: Name of your custom report
- Description: Description of your custom report
- SQL Command: SQL query to call/populate your SQL report

Note: For beginners with SQL consult w3schools 'Introduction to SQL'

Sample Query:

INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Test Report', 'Test Description of our report', 'SELECT Email, BillingZip FROM ORDERS')

Once you've submitted your query to the database it's time to test your custom report. In the admin go to ORDERS > REPORTS > CUSTOM REPORTS. Select your report from the drop down box and it will be populated in a datagrid below