Report: Article list

The Article list (Artikel Liste) report shows every article that was sold in the last five calendar weeks, with its revenue and sales per week and a weighted weekly average. Recent weeks count more than older ones, so you quickly see which articles are currently selling well and need to be reordered.

Before you start

• Your user needs the permissions for Reports and Reports › Article list (Reporte › Artikel Liste). Ask your administrator if the menu entry is missing.
• The report is based on the order statistics of your company. They are imported with an import template of the type Bestell-Statistik (order statistics), see Import templates.
• Each article must exist in your article master data with the same article number (SKU). Sold items that cannot be found there are left out.

Step by step

1. Open Reports › Article list (Reporte › Artikel Liste) in the top menu.
2. The report determines all articles sold from the Monday four weeks ago until now and loads them in packages of 25. While loading you see the progress, e.g. "120 of 340 articles loaded" (… von … Artikeln geladen). Wait until all articles are loaded.
3. Evaluate the table:
   • Click a column header to sort.
   • Use the Manufacturer selection above the table to show only one manufacturer.
   • Type into the search fields below each column to filter that column.
4. Click the chart icon in front of an SKU to open the Single article report for this article in a new tab.

Columns

The table has three column groups. The second header row shows the totals of all loaded articles.

Column	Meaning
SKU	Article number. The chart icon opens the single article report.
Name	Article name from your master data.
Manufacturer (Hersteller)	Brand/manufacturer of the article.
90 days RRP (90 Tage UVP)	Average selling price over the last 90 days. In the totals row: the average across all articles.
Turnover (Umsatz) – CW …	Revenue per calendar week (KW) for the last five weeks, the current week on the right.
Sales figures (Absatzzahlen) – CW …	Units sold per calendar week. The small percentage above the week is its weight.
ø week, weighted (ø Woche, gewichtet)	Weighted average units per week (see below).

Below each article, one line per sales channel shows the same revenue and sales figures for that channel.

How the weighted weekly average is calculated

The four completed weeks are weighted from oldest to newest with 5 %, 10 %, 30 % and 55 %. The current, still running week is shown but not included. Weeks without sales are left out and the remaining weights are scaled up accordingly.

Example: 10 units in the oldest week, then 20, 30 and 40 units in the following weeks give (10 × 5 + 20 × 10 + 30 × 30 + 40 × 55) ÷ 100 = 33.5 units per week.

Good to know / Troubleshooting

Problem	Cause	Solution
The list stays empty	No order statistics in the last five weeks.	Import the order statistics, see Import templates.
An article you sold is missing	The SKU in the statistics does not match an article number in your master data.	Check the article number in the statistics file and in the article.
The manufacturer is empty	No brand is stored in the article or in the statistics.	Maintain the manufacturer in the article, see Brands.