Mon–Thu 08:00–17:00, Fri until 15:00

Bargteheide 04532 408 99 95Göttingen 0551 890 64 000
Shopware plugins

Shopware statistics plugin: customer analysis, returns and CSV export in the admin

By Redaktion Web Labels Published

Laptop showing a statistics dashboard with line and bar charts next to a stack of return parcels: Shopware statistics plugin with customer analysis and returns report

The statistics that ship with Shopware 6 show orders and revenue for the last few days. They do not tell you which regular customers have not ordered for a year, who sends almost everything back or which items drive your returns. That is why we built the Shopware statistics plugin “WL Dashboard Statistik”. It adds customer analysis, returns, gross profit and a CSV export to the admin, and it is free.

What the Shopware statistics plugin reports

After installation the admin has its own menu item “WL Dashboard” with nine reports. The dashboard itself gets new cards that replace Shopware’s standard statistics. The screenshots show the German admin; the plugin interface is available in 29 languages, including English.

Report Question it answers
Customer check Which regular customers have not ordered for 4, 6 or 12 months?
Customer statistics Who returns a lot, cancels often or pays late?
Returns How much revenue is left after returns, and where do they come from?
Product statistics Which items sell, and which come back?
Revenue analysis Revenue by country, payment method, customer group, category, device
Voucher usage Which campaign brings new customers who buy again?
Abandonment analysis Where do customers drop out during payment and checkout?
Product check Items without a purchase price, without an image or priced below cost
Mailings Opens and orders after automated e-mails

Revenue analysis in the Shopware 6 admin with the WL Dashboard menu expanded: product check, product statistics, customer check, customer statistics, revenue analysis, returns, voucher usage, abandonment analysis and mailings

All screenshots in this article come from the admin of a client shop. We replaced the shop name, customers, e-mail addresses, items and manufacturers. The figures are real.

The dashboard: gross profit, orders and revenue

The dashboard shows gross profit for the current week, month and year, each compared with the same period of the previous year up to today. Gross profit here means net merchandise revenue minus cost of goods, with returns already deducted. Shops without maintained purchase prices switch the cards to net revenue in the settings.

Gross profit card on the Shopware dashboard: current week, current month and current year compared with the previous year, with the monthly gross profit trend below

Below that are two cards for orders and revenue. They separate cleanly placed orders from failed payments and abandoned orders and show gross and net revenue before and after returns. The periods range from today to 90 days. In the settings you define which payment states count as revenue and whether open invoices and prepayment are included.

Dashboard cards for orders and revenue: 276 cleanly placed orders in 30 days, gross and net revenue, returns and the daily trend

Customer check: regular customers you are losing

A customer who used to order regularly and has gone quiet does not stand out in day-to-day business. The customer check counts exactly these customers: regular customers with at least two orders who have not bought anything for 4, 6 or 12 months, broken down by customer group. Below that are the customer accounts that registered and never ordered.

Product check and customer check cards on the Shopware dashboard: 410 of 1,150 regular customers have not ordered for 12 months, broken down by customer group, plus 210 customer accounts without an order

In the example shop, 410 of 1,150 regular customers have not ordered for twelve months. One click on the tile opens the list. Sorted by revenue, you see at once who is worth the effort: at the top is a trade customer with 70 orders and just under €75,000 in net revenue whose last order was almost a year ago. A customer like that does not get a newsletter. You pick up the phone.

List of regular customers without a new order in the Shopware admin, sorted by net revenue, with customer group, number of orders, first and last order and the CSV export button

You can filter the list by period and customer group, search it and export it as CSV. That gives you the recipient list for a win-back campaign in two minutes, split into trade, catering and retail customers. For the plugin, a customer is an e-mail address, so guest orders and account orders from the same address are counted together.

Customer statistics: who sends a lot back

The customer statistics rate every customer with risk points from 0 to 100. The points are based on the return rate by value, cancellations, late or missing payments for invoice and prepayment, and failed payments. At the top of the page you set the score and the number of orders from which someone counts as a problem customer.

Customer statistics in the Shopware admin: 8 problem customers, revenue received, returns, cancellations, average payment time and risk points, with filters for region, age and customer group on the left

Below the key figures, the block “Das System sagt” (the system says) sums up what stands out in full sentences. In the example shop, eight customers, 0.4% of all customers, cause 85.9% of the return value. The comparison by region, age, customer group and salutation shows whether these customers differ from the rest.

The block Das System sagt in the customer statistics: 8 problem customers cause 85.9 percent of the return value, with the comparison by region and age against all customers below

One click switches from problem customers to good customers. There you see which customers buy a lot, keep everything and pay on time, and what this group has in common.

Newsletter exclusion list as CSV

If you send a discount to all recipients, it also goes to the customers who will send half the order back again. That is why the list of problem customers has its own export, “CSV Newsletter-Ausschluss”. The file contains e-mail address, name, customer number, risk points and the reasons. You import it into your newsletter tool as an exclusion list for the next discount campaign.

List of problem customers with customer group, region, age, orders, revenue after returns and return rate, and the button for the newsletter exclusion CSV

The plugin changes nothing in the shop itself. It blocks nobody and sets no flag on the customer account. Because the rating is an assessment of individual customers, you should have your privacy policy reviewed before you exclude customers from campaigns on this basis.

Returns: what is left of your revenue

The returns page compares order value with returns and shows the revenue received, which is what actually remains after returns. It also shows returned units, cancellations and the number of customers with a return. Two charts show the monthly trend in euros and in units.

Returns report in the Shopware admin: order value, returns, revenue received, units returned, cancellations and customers with a return for the last 12 months

Below that the plugin breaks returns down by region, age, customer group, country, payment method, return reason, manufacturer and category. The example shop sells goods that rarely come back; the rate is 1% of units. In fashion or footwear the same page looks different, and the table by manufacturer quickly becomes the most important one in the whole admin.

Return reasons and returns by manufacturer with units sold, units returned, rate and net return value

Items that often come back

The table “Retournierte Artikel” (returned items) at the bottom of the page lists every item with units sold and returned, rate, return value and the number of customers who sent it back. The last column matters more than it looks. 570 returned units from a single customer are one large order that fell through. The same quantity spread over 200 customers would be a problem with the item: wrong measurements in the description, a photo that promises too much or a defect at the manufacturer.

Table of returned items with item number, units sold, units returned, rate, net returns and number of returning customers, variants combined

Variants can be combined, and you sort by units, value or rate. The export is called “CSV Retourenartikel”.

Product statistics: sales and returns per item

The product statistics show units, net revenue, average price, returns and the number of buyers for every item sold. You can filter by manufacturer and category and by the same customer attributes as in the customer statistics. That way you find out what your good customers buy or which items mainly go to problem customers.

Product statistics in the Shopware admin: 1,702 items, 70,992 units sold, 710 units returned, with the item list showing net revenue, average price and return rate

Which campaigns pay off: vouchers and abandoned orders

Whether a discount campaign achieved anything is shown under voucher usage. For each campaign you see uses, revenue, discount granted and the average order value. Two columns make the difference to a plain voucher list: how many new customers the campaign brought in and how many of them ordered a second time.

Voucher usage in the Shopware admin: orders with a voucher, total discount, order value with and without voucher, new customers via voucher and their repurchase rate, with the campaigns compared below

In the example shop the order value with a voucher is €211, without one €410. On the other hand, new customers who came through a voucher ordered a second time slightly more often than the rest. Whether that adds up is for each shop to decide. With the figures it becomes a calculation rather than a feeling.

The abandonment analysis shows where orders are lost: at payment, in the checkout or in open carts. The plugin names what stands out. In the example it is a payment method where 13% of orders are abandoned while the average is 2.1%.

Abandonment analysis in the Shopware admin: abandonment rate, open revenue, recovered and lost orders, and notes on payment methods with an above-average number of abandoned orders

For checkout abandonment and mailings the plugin records additional data. Both are switched off after installation and should only be activated after consulting your data protection officer.

CSV export for every report

Every page has its export buttons at the top right. The export always contains the state you currently see, with all filters applied. The files use semicolons as separators and are saved in UTF-8, so Excel opens them directly.

  • Customer check: lapsed regular customers and registered customers without an order
  • Customer statistics: customers, report and newsletter exclusion list
  • Returns: report and returned items
  • Product statistics: items with sales and returns
  • Revenue analysis: orders and report
  • Voucher usage: campaigns and customer groups
  • Abandonment analysis: report

Compatible with Pickware

Many Shopware shops handle warehouse and returns with Pickware ERP. The plugin is built for that: a return order reduces the revenue of the original order as soon as it is booked as received or completed in Pickware. Announced returns and credit notes are shown separately, and the return reasons also come from Pickware. For gross profit the plugin uses the last purchase price from supplier orders before the order date.

We have been a Pickware partner since 2019 and have already set the plugin up for our Pickware clients on Shopware 6.7. You can read more about our work with Pickware on the page Pickware partner agency.

The plugin runs just the same without Pickware. A fully refunded order then counts as a return, and the purchase price comes from the order or from the item.

Technical details in brief

  • Shopware 6.7
  • Interface in 29 languages, following the language of the admin user
  • Selection of the sales channels that are included in the figures
  • Visibility can be limited to individual admin users
  • Reports are stored and refreshed in the background, so the pages open quickly even in shops with a very large number of items

Free, with updates right in the admin

The plugin costs nothing. You get it from us together with our plugin manager, which is also free. It makes sure that new versions appear in the Shopware admin under Extensions as usual and can be updated there. You do not have to upload zip files when a new version is released.

Through the plugin manager we provide further free plugins, for example spam protection for Shopware 6 without captchas.

Send us a message via the contact form and tell us which Shopware version you use and whether Pickware is in place. If you are missing a report or need an extension of your own, you will find everything under Shopware plugin development.

FAQ

What does the Shopware statistics plugin cost?

Nothing. You get "WL Dashboard Statistik" from us free of charge. The plugin manager that delivers the updates to your admin is free as well. Send us a message via the contact form.

Which Shopware version does the plugin require?

The plugin runs on Shopware 6.7. There is currently no version for Shopware 6.6 because the administration is built differently there.

Does the plugin work with Pickware?

Yes. With Pickware ERP the plugin uses the return orders and purchase prices from Pickware. We have been a Pickware partner since 2019 and have already set the plugin up for our Pickware clients on Shopware 6.7. It also runs without Pickware; fully refunded orders then count as returns.

Which reports can I export as CSV?

Every list and every report has its own CSV export: lapsed regular customers, the customers in the customer statistics, the newsletter exclusion list, items, returned items, orders, voucher campaigns and the abandonment analysis. The export always contains what you currently see with your filters, separated by semicolons and encoded in UTF-8 so that Excel opens the file directly.

Does the plugin block customers with many returns in the shop?

No. The plugin only reports and writes nothing to the shop. You get a list that lets you, for example, exclude individual recipients from a discount campaign in your newsletter. Whether and how you do that is your decision.

How do I get updates for the plugin?

Through our free plugin manager. It is set up once in your shop. After that, new versions appear in the Shopware admin under Extensions as usual and can be updated there with one click.

All questions and answers

Planning something similar?

Tell us briefly about your system and your goal. We will get back to you with questions or a proposal.

Request a project

More articles on this topic

All articles: Shopware plugins
Up to 80% government funding

Before you go …

Leaving without a personal consultation?

In a short call we work out what makes sense for your shop or website and what the next step looks like.

Get in touch