Reports (ERP)
On the Reports page you generate evaluations of your shop at the click of a button: sales, inventory, customer value, finances, profit margin, and more. You simply pick a report type and a date range — SELLERLOGIC Commerce Services then compiles key figures, a chart, and a data table for you, which you can also download as a file. Frequently needed evaluations can be saved under their own name so you can run them again later with one click.
Note: The same Reports page can be reached in two places in SCS — here in the finance area and additionally in the settings area. The content is identical in both places: you always see all seven report types, not only the financial ones.
| Week | Orders | Gross Revenue | Discounts Applied | Net Revenue |
|---|---|---|---|---|
| Week 31 | 148 | EUR 11,420 | EUR 620 | EUR 9,076 |
| Week 32 | 161 | EUR 12,880 | EUR 710 | EUR 10,226 |
| Week 33 | 153 | EUR 11,960 | EUR 540 | EUR 9,596 |
/erp/reportsWhat can I do here?
- Choose one of seven report types: Sales, Inventory, Customer LTV, Acquisition, Financial, Profit Margin, or Purchase Funnel
- Set the evaluation period via quick presets (e.g. Last 30 days, This quarter) or freely with From/To dates
- Group time-based reports by Day, Week, or Month
- Generate the report with Run Report and view it as KPI tiles, a chart, and a Data Table
- Download the result via the CSV button as a spreadsheet file (CSV = a simple table format that opens in e.g. Excel)
- Save reports under a name of your choice with Save, optionally with a Schedule (daily, weekly, or monthly)
- On the Saved Reports tab, re-run saved reports via Load & Run or delete them
Step by Step
Create a report
- Open the Results tab and click one of the report type tiles, e.g. Sales.
- Under Date Range, choose a preset — or Custom to set From and To freely.
- For Sales, Acquisition, and Financial you can additionally choose between Day, Week, and Month under Group by.
- Click Run Report. After a short moment the key figures, the Chart, and the Data Table appear.
Download a report as a file
- First run a report (see above).
- Click the CSV button. The file downloads automatically and opens in any spreadsheet program.
Save a report
- Set the report type and date range as desired.
- Click Save. The Save Report window opens.
- Enter a Report Name (e.g. "Monthly Sales Report") and optionally pick a Schedule.
- Click Save.
Re-run a saved report
- Switch to the Saved Reports tab.
- On the desired card, click Load & Run — the saved settings are applied and the report starts. Use the trash icon to delete a saved report (with a confirmation prompt).
flowchart LR
A[Choose report type] --> B[Set date range]
B --> C[Run report]
C --> D[View KPIs, chart, and table]
D --> E[Download as CSV]
D --> F[Save report]
F --> G[Later: Load & Run]
Fields Explained
| Field | Meaning | Notes/Impact |
|---|---|---|
| Date Range | Quick selection of the evaluation period (e.g. Today, Last 7 days, This year). | With Custom, the From and To fields appear. The range may span at most 365 days. |
| From / To | Start and end date for a custom range. | The To date must be on or after the From date. |
| Group by | Determines whether time-based data is aggregated per Day, Week, or Month. | Only visible for the Sales, Acquisition, and Financial report types. |
| Run Report | Starts the evaluation. | While generating, "Running report…" is shown. |
| CSV | Downloads the result as a spreadsheet file. | Only usable after a report has been run. |
| Save | Opens the Save Report window. | Saves report type, date range, and grouping under a name. |
| Report Name | Freely chosen name of the saved report. | Required; example placeholder: "e.g. Monthly Sales Report". |
| Schedule | Optional recurrence for the saved report (No schedule, Daily, Weekly, Monthly). | The chosen schedule is shown on the saved report's card. |
| Data Table | Detail rows of the report result. | Up to 100 rows are displayed; below that, "Showing 100 of … rows" appears. A report processes up to 10,000 rows in total. |
Values & Status
Report types
| Value | Meaning | What happens next |
|---|---|---|
| Sales | Orders and revenue over time, incl. total revenue, order count, and average order value. | Shown as a bar chart over time; grouping by day/week/month available. |
| Inventory | Stock levels of your products, incl. figures such as Low Stock and Out of Stock. | Shows the top products by stock as a bar chart plus the detail table. |
| Customer LTV | Customer value over the whole relationship (LTV = "lifetime value", the total revenue a customer generates with you). | Shows your most valuable customers as a chart, incl. Lifetime Value, first and last order. |
| Acquisition | New customer acquisition over time: New Customers, Guests, and Registered. | Shown as a timeline; grouping selectable. |
| Financial | Financial overview with Gross Revenue, Net Revenue, Tax Collected, Shipping Costs, and Discounts Applied. | Shown as a timeline; grouping selectable. |
| Profit Margin | Profit and margin per product (margin = the share of profit in the selling price), incl. Total Cost, Total Profit, and Avg. Margin %. | Shows the top products by profit as a bar chart. |
| Purchase Funnel | The visitors' path from page view to purchase: Page Views, Product Views, Add to Cart, Checkout Started, Purchases. | Shown as a funnel bar chart with conversion rates. |
Date range presets
| Value | Meaning | What happens next |
|---|---|---|
| Today | Only the current day. | The report evaluates today only. |
| Last 7 days | The past 7 days up to today. | Short-term overview. |
| Last 30 days | The past 30 days up to today (default). | Standard evaluation window. |
| This month | From the first of the month until today. | Current month. |
| Last month | The complete previous month. | A closed monthly period. |
| This quarter | From the start of the quarter until today. | Current quarter. |
| This year | From January 1 until today. | Year-to-date overview. |
| Custom | Freely chosen range via From/To. | Maximum 365 days. |
Group by
| Value | Meaning | What happens next |
|---|---|---|
| Day | One row/bar per day. | Finest granularity, ideal for short ranges. |
| Week | Aggregated per calendar week. | Clearer for medium ranges. |
| Month | Aggregated per month. | Ideal for year-over-year views. |
Schedule (saved reports)
| Value | Meaning | What happens next |
|---|---|---|
| No schedule | The report is only run manually. | No recurrence stored. |
| Daily | The report is marked for daily recurrence. | The schedule is shown on the saved report's card. |
| Weekly | Recurrence once per week. | The schedule is shown on the saved report's card. |
| Monthly | Recurrence once per month. | The schedule is shown on the saved report's card. |
Frequently Asked Questions
Why do I see "No data available"?
There is no matching data in the chosen period — for example, no orders in the selected month. Choose a different period or another report type.
Why can't I evaluate a period longer than one year?
A report may span at most 365 days. For longer comparisons, simply run several reports one after another (e.g. one per calendar year).
The table shows only 100 rows — where is the rest?
For clarity, the browser view shows the first 100 rows; below it you will see e.g. "Showing 100 of 2,500 rows". Download the report as CSV to get all rows (up to 10,000).
Are saved reports with a schedule sent automatically?
The schedule is stored with the report and shown on its card. Whether and where an automatic delivery takes place may need to be set up separately — if in doubt, ask your SELLERLOGIC contact.
Can I change a saved report later?
Load it via Load & Run, adjust the date range or grouping, and save it again under the same or a new name. Delete reports you no longer need via the trash icon.