Help CenterHelp Center / Reports and insights · Reference
Units and sales per product over a period, with category, current stock and returns.
The Products Report adds up order lines per product. Unlike Trends › Top products, it lists every product ordered and lets you choose the order statuses.
Open Reports › Products. For the shared controls, see Detailed reports.
| Filter | Notes |
|---|---|
| Date Range | Opens on today. At most 366 days |
| Order Statuses | Opens with Order Placed only, which gives the quantities to prepare for new orders. Select Delivered for what was sold |
| Fulfilment location | Shops with several locations |
| Column | Meaning |
|---|---|
| #SL | Row number |
| Name, Barcode | The product |
| Unit Label | Only when your shop shows unit labels with order details |
| Quantity | Units ordered in the matching orders |
| Single Unit Value | Pack size with its unit, for example 500 g |
| Total Unit Value | Pack size × quantity, for example the total weight ordered |
| Unit | The product's unit |
| Sales | Each line's price × quantity, added up |
| Category | The product's category |
| Stock | Current stock quantity. Empty when zero or not tracked |
| Returned Qty, Refunds | Units returned and item refunds on those orders. Shown when returns are enabled for your shop |
| Avg Unit Price | Sales ÷ quantity |
The page shows 20 products at a time. Csv downloads every product. Barcodes are written so that a spreadsheet keeps their leading zeros.
The file is named "Products Report - " followed by the date range.