Reports
Picqer offers various reports that give you insight into your operations. For example, which products sell best or are returned most often. There are also reports that show what your team is working on and what still needs to be done.
On this page, you’ll find an overview of the most important reports in Picqer. We distinguish between real-time insights and reports that show what happened during a specific period.
You can find Reports in the menu at the bottom left. Only administrators and users with the “View reports” permission can access them.
Real-time insight
Tower
Today
This report shows how your team is performing today and what still needs to be done. You can also view the report for another day, for example to see how things went yesterday.Reports
The reports below all show what happened during a (usually self-selected) period. You can also export these reports to Excel for a more in-depth analysis.
Best selling products
This report shows which products were sold the most. It helps you identify your top sellers as well as the products you may want to remove from your product range.
Most returned products
This report provides insight into the products that were returned most often during a specific period. You can also filter the products based on supplier or fulfilment customer.
Old stock
This report shows your current inventory and how many products were received in the last 30 days. This lets you see how many products are newer or older than 30 days. Useful for companies with high stock turnover and (rapidly) changing prices.
Order revenue and costs
This report shows, per order (order number and date), the total revenue (with or without discount) and the total cost price of the products. This way you know exactly how much you earned per order. You can apply a start and end date filter to show orders within a specific period.
Picklists processed
This report shows an overview of the picklists processed during a specific period. Additionally, providing insight into the selected carriers and shipping profiles.
Products never sold
This report shows products that were never sold in a selected period. This complements the first report, where you can see which products sell well. You could use this report to gain insight before starting a clearance sale, for example.
Products on unshipped picklists
This report contains data for products that have been picked on a picklist that is currently still open. You’ll see the picklist number, order number, the number of picked products, the cost price, and the sales price.
Products received via purchase orders
Among other things, this report will show how many units of a specific product you received per supplier, as well as the total amount.
Receipts processed
This report shows an overview of the receipts that were processed during a specific period. Among other things, it gives you insight into the number of products and lines per receipt.
Returns processed
This report shows an overview of the returns that were processed during a specific period. It contains the number of products and lines per return.
Revenue per month
This report gives you insight into monthly revenue, the number of orders placed in a month, and the number of unique customers who placed an order. You can also apply a start and end date filter here. Leave these fields empty to view the total revenue.
Revenue per customer
This report shows the total revenue, number of products, and number of orders per customer. The report will give you insight into key customers and the customers generating the most revenue. Just like the previous report, you can specify a start and end date or leave these fields empty to show the total revenue per customer.
Revenue per customer per product
This report shows the revenue per customer per product such as the amount of units sold, total revenue. When selecting this report, you can specify a start and end date. If you don’t enter a date, Picqer shows the total revenue per customer, per product.
Revenue per customer per product tag
This report gives you insight into the total revenue per customer per product tag, for the selected period. Even if you don’t use product tags, this report will still show the revenue per customer per product.
Shipments
This report shows an overview of the shipment details made during a specific period.
Warehouse settings
Per warehouse and per product, view details about your stock and stock strategy. View desired stock levels, available stock, total stock and expected stock.
Storage usage
This report shows the number and type of locations currently in use per product.
Tag revenue per month
This report gives you insight into revenue per tag per month. If tags are added to products or customers, Picqer will show the total monthly revenue for those tags. For instance, if you have multiple webshops in Picqer, the tags let you see the revenue per webshop per month. This makes it easy to compare how product groups perform compared to each other.
Warehouse sales
This report shows the amount of shipped units per product, per warehouse, based on the time of shipping. This is useful if you have products on consignment from your supplier and need to report monthly what you sold and delivered. This way, you can quickly see which products from a particular supplier sell best. Optionally, you can manually enter a supplier to show only that supplier’s sales.
