Reporting

Through the Reporting system, various reports are included out-of-the-box to help management and other personnel to make informed decisions.  The default reports include:

• Sales ReportReport provides an overview of a site's sales performance over a period of time. - this report provides an overview of a site's sales performance over a period of time
• Shipping ReportReport providing the shipping method, number of orders and total shipping cost over a period of time - this report provides the shipping methodA shipping method manages a set of information and rules that determines the shipping cost and displays it on the front-end public site while a customer checks out an item from his/her shopping basket. The shipping fee is added to the total price of the purchase. A shipping method is mapped to a shipping provider visible to a back-end administrator in Commerce Manager. This allows the public site to display friendly names such as "Ground Shipping" to the customer and this is mapped to a provider such as UPS. Therefore, when a customer picks "Ground Shipping," he/she will be using UPS., number of orders and total shipping cost over a period of time
• Best Sellers ReportReport used to determine which products sold the most in terms of quantity and total revenue over a period of time. this report is used to determine which products sold the most in terms of quantity and total revenue over a period of time
• Low Stock ReportReport used to determine which products are running low in inventory. If a product's inventory is less than its reorder minimum quantity, it will be included in this report. - this report is used to determine which products are running low in inventoryThe procedure of checking the availability in one or more warehouses for a specific product..  If a productA product represents various forms of merchandise that you can display and purchase from the public site, including Products, Variations/SKUs, Bundles, Packages and Dynamic Packages.'s inventory is less than its reorder minimum quantity, it will be included in this report.

The display of these reports can be generated by Start and End date/time and filtered by Day/Month/Year.  In addition, they can be exported to Excel or PDF format, or printed.

SQL Reporting Services

Since the Commerce Manager utilizes SQL databases, custom reports can be created using Microsoft SQL Server Reporting Services.  Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizationsGroups or sub-groups of registered users and customers. An organizational unit is a "child" or subsidiary of a "parent" organization. Within Commerce Manager, you can assign an organization as a parent of another organization. For example, the parent company Company X, and the organizational units are Company X West and Company X East. Organization units include regional branches or departments or you could name them by business categories such as "Computer and Electronics" or "Clothing and Accessories." Organizations can be structured into a tree structure with sub-units with different levels of permissions assigned to each. So for example, you can set up your company as a parent level organization while your departments such as Sales & Marketing, IT/Development, and Operations as organization units. With this scenario, you can allow users in each departments to have access to only relevant subsystems, screens and functionality within Commerce Manager. Same as "organization units". to deliver relevant information where needed across the entire enterprise. Read through the resources below to get familiarized with Reporting Services and how you can create custom SQL reports to display data from your EPiServer Commerce site.

• Reporting Services Features
• Using SQL 2008 Reporting Services and Report Builder 2.0 to Create Custom SQL Reports
• Download Report Builder 2.0
• Reporting Services and ReportViewer Controls in Visual Studio
• Reporting Services Components and Tools
• Reporting Services Configuration How-To Topics

Version: EPiServer Commerce 1 R2 SP2| Last updated: 2012-09-20 | Copyright © EPiServer AB | Send feedback to us