Skip to content
Illustration: Glass bar sculpture with trend line and report

Focused analysis in JTL-Wawi

Statistics and Reports

Use statistics management in JTL-Wawi to bring together the business data you need to make decisions. Start with your business question: do you want to examine revenue, profit, sales volumes or orders? Then choose suitable templates, narrow down the data with filters or view dedicated statistics for individual items, customers and suppliers.

Key takeawayYour question determines the report

First, define the business question your statistics should answer. Then select the metric, time period and data you need. The reports and display options available depend on your JTL-Wawi version and the data you have. Check how these options can help you answer your question.

Report types and templates

Choose the right metric to examine revenue, contribution to profit, units sold or order volumes. Statistics management in JTL-Wawi offers reports on revenue, profit, sales volumes and the number of orders. Each metric describes a different aspect of your business: high sales volumes do not automatically mean high profits. The number of orders alone does not tell you how much revenue they generate, either.

Templates help you view business data by time period or organisational unit without building every report from scratch. JTL provides templates organised by year, company, shop or platform, for example. You can also create your own templates. The templates and customisation options available depend on your JTL-Wawi version, so start by reviewing the existing templates.

  • Analyses of revenue, profit, sales quantities and order counts
  • Templates by year, company, shop or platform, plus custom templates
  • Available templates and adjustments depend on the JTL-Wawi version

Filters and display

Filters let you focus on the data relevant to your question rather than analysing the entire available dataset. You define which data to include in the statistics. You can save the configured report for later reuse. Give it a clear name so you can recognise what it was designed to examine.

Charts help you compare values and track changes over time. Bar charts are useful for comparing individual values, while line charts show trends. The available chart types and display options depend on your installed JTL-Wawi version. Choose a view that presents your data clearly. Whether specific display options, such as two-dimensional or three-dimensional views, are supported depends on your current version and setup.

Schematic illustration

Build a report in four steps

From choosing a metric to saving a view, tailor the report to your question.

  • Choose a metric

    Decide whether you want to examine revenue, profit, sales volumes or the number of orders.

  • Select a template and time period

    Choose a suitable template and define the period you want to examine.

  • Apply filters

    Narrow down the data selection to match your question.

  • Choose and save a view

    Choose a display format or ranking and save the configuration if your version supports it.

Rankings for items and customers

Rankings show you, for example, which items you sell most often or which customers are particularly important according to your chosen measure. They sort items or customers by the selected reporting criterion. Charts and tables help you understand positions, trends and changes. Whether rankings are available for every report depends on your current version and the selected report; we will gladly check compatibility for your specific setup.

A customer ranking can help you select and reward customers with targeted promotions or coupons. First, define what makes a customer particularly important to your business. A clear criterion is essential for interpreting the ranking meaningfully. The ranking provides a basis for selecting customers for this kind of promotion. It does not, however, set up the promotion or coupon, or run the promotion.

Item, customer and supplier statistics

Individual statistics help you focus on a specific product, customer or supplier. For items, you can view data such as sales figures, purchase prices and storage duration in charts or tables. Select the report type, time period and a suitable template, such as one with a breakdown by customer group. This lets you examine an item from the perspective relevant to your current decision.

Customer statistics show how many orders a customer has placed during the selected period and their share of your company's revenue and profit. You open these statistics from the customer details. The results relate to your business relationship with that person or customer account. Reliable interpretation requires correctly assigned transactions and properly maintained data for the calculations.

Supplier statistics help you examine which supplier delivers faster or at a lower cost in a given context. From the supplier details, you can open reports on delivery speed, purchasing terms and price trends over time. This requires the relevant data and a version that supports these reports. Wherever possible, compare similar items and terms so that differences in what is supplied or in the terms do not distort the results.

  • Items: sales figures, purchase prices and storage duration
  • Customers: orders within the period and shares of revenue and profit
  • Suppliers: delivery speed, purchasing terms and price trends

Terms explained

Metric
A metric describes a measurable aspect of your business, such as revenue, sales volume or the number of orders.
Report template
A report template provides a predefined structure for examining your business data.
Filter
A filter uses defined criteria to determine which data is included in a report.
Ranking
A ranking sorts items or customers by a selected criterion.
Storage duration
Storage duration describes how long goods remain in stock. The specific calculation depends on the report.

Good to know: requirements & limits

  • The templates, metrics, views and save options available may depend on your JTL-Wawi version and, where applicable, edition. This also applies to the data types and views available in item statistics.
  • Missing or incorrectly assigned business transactions can limit the reliability of the results.
  • Profit reports must be interpreted in the context of the underlying calculation logic and the costs included.
  • Comparisons require compatible time periods, data selections and assessment criteria. Before reusing a saved report, check whether its restrictions still suit your current analysis.
  • Statistical patterns and anomalies reveal differences or trends, but do not automatically explain their causes.

Contact

Let’s discuss your project.

Free initial consultation on JTL-Wawi, JTL-Shop, JTL-WMS and hosting.