Running a report
Running the vendor report with a date range, filtering the summary and table, downloading the result as Excel or CSV.
The report running page is where you prepare the report you selected from the Reports catalog, review the result on screen, and download it as Excel or CSV. The page works the same way for three reports: Order report, Order aging, and Packages without a carrier. The report is generated only from the orders of your vendor account.
Accessing the screen
Select Vendor Panel › Reporting › Reports from the left menu and click the card of the report you want to run.
The report page URL includes the selected date range and the fact that the report has been run. You can bookmark this URL to reopen the same report with one click or share it with your team members. Each vendor user who opens the link will see their own data as the report runs automatically.
If the URL specifies a report that does not exist, the Reports catalog opens. If your account is not linked to a vendor, the page shows a warning instead of the report, such as "Order report is exclusive to vendor accounts."
Screen sections
- Title — The report name and a short description; on the right, the All reports button returns to the catalog.
- Parameter card — In Order report, date range selection and Run button; in the other two reports, a description of the report scope and the Run button.
- Progress card — Visible while the report is being prepared.
- Result — Report info line, summary indicators, (in aging) a chart, and the result table.
If the report has not been run yet, Report not run yet is shown instead of the result.
Running the report
Order report: selecting a date range
- Choose one of the preset ranges: Today, Last 7 days, Last 30 days, Last 90 days, This month, or Last month. When the page first opens, Last 30 days is selected.
- Optionally, change the days individually in the from and to fields. If the selected range matches a preset range, that button appears selected.
- Press the Run button.
The line below the date fields checks the range:
- If valid, it shows: You can select up to N days. The order service provides data in 30-day chunks, so this range will be queried in … parts. (limit 180 days). More parts increase report duration.
- If invalid, the line turns red and Run is disabled:
| Warning | Reason | What to do |
|---|---|---|
| Select a start and end date. | One or both dates are empty. | Fill in both dates. |
| The date is not valid. | The entered date does not exist in the calendar. | Select a valid date. |
| The start date cannot be after the end date. | Dates are in reverse order. | Set the start date before the end date. |
| The start date cannot be in the future. | The start date is after today. | Select today or an earlier date. |
| The range can be at most N days. Run the report in parts for longer periods. | The range exceeds 180 days. | Split the period into 180-day parts and run the report separately for each. |
Dates are based on Istanbul calendar days; date fields do not allow selecting future days.
Order aging and Packages without a carrier
These two reports do not have date selection; their scope is fixed and described on the parameter card:
- Order aging — Your open packages from the last 360 days; excluding cancelled ones. Age is calendar days from the order date to today (Istanbul).
- Packages without a carrier — Your open packages from the last 15 days (Received, Picked, Packed, Invoiced); excluding cancelled ones.
Press the Run button to prepare the report.
While the report is preparing
After pressing run, a Preparing report card with a progress bar appears. The card first shows Connecting to the order service…, then progress in the format N / N parts completed · N requests · N packages read. While preparing, Run is disabled.
If you want to cancel, press the Cancelled button on the card; preparation stops and the page returns to the unrun state.
Running again
When the result is displayed, the button changes to Run again. Pressing it reruns the report with current data. In Order report, changing the dates and pressing it runs the report with the new range.
The prepared result is cached briefly: returning to the same report with the same range opens instantly without re-querying. Press Run again to see the most up-to-date data.
Result
Report info
At the top of the result, the report metadata is shown: Created: … · Range: … – … · N requests · N packages. The preparation time and range are in Istanbul time.
If the result exceeds 20,000 rows, a warning appears: Result truncated at … rows; list is incomplete. Select a shorter date range. In this case, the report and summary indicators cover only the first 20,000 rows; in Order report, narrow the range and run in parts. The two reports without date selection have fixed ranges and cannot be narrowed; if you see this warning, contact support.
Summary indicators
| Report | Indicator | Meaning |
|---|---|---|
| Order report | Order | Number of orders in the range; below it, N packages shows the package count. |
| Order report | Qty | Total product quantity. |
| Order report | Return rate | Ratio of returned quantity to total; below, … returned · … cancelled quantities. |
| Order report | Sale total | Total sales amount; Excluding cancelled lines. |
| Order aging | Open packages | Number of open packages waiting; below, distribution by status. |
| Order aging | Waiting 7+ days | Number of packages waiting 7 or more days. If greater than zero, the card appears with a warning color. |
| Order aging | Longest waiting | How many days the oldest open package has been waiting. |
| Packages without a carrier | Without a carrier | Number of open packages without an assigned carrier. If greater than zero, the card appears with a warning color. |
| Packages without a carrier | Longest waiting | How many days the oldest of these packages has been waiting. |
Aging chart
In the Order aging report, if there are open packages, the Packages by waiting time chart appears. Each bar represents the number of packages in a waiting bucket: 0, 1, 2 … 6 days individually, then "7–13 days", "14–20 days", "21–29 days", and "30+ days". Buckets up to 6 days are blue, 7–20 days yellow, 21+ days red.
Below the chart, the Show bucket: line has a badge for each bucket with packages. Clicking a badge filters the table to show only packages in that bucket; clicking the same badge again removes the filter.
Filtering and searching in the result table
The toolbar above the table filters only the displayed result; it does not rerun the report and applies instantly.
| Field | Purpose | Tip |
|---|---|---|
| Search the table | Searches the typed text in columns. | The displayed status name and date formats (e.g. dd.mm.yyyy hh:mm) are searched; Refunded / Cancelled columns' Yes/No values are not searched. Case and Turkish İ/ı differences are ignored. |
| Status | Filters rows by package status (All statuses). | Visible only if multiple statuses exist in the result. |
| Waiting time | Filters rows by waiting bucket (All durations). | Visible only in Order aging report; works like the chart badges. |
| Clear filters | Removes search, status, and bucket filters together. | Visible only if filters reduce the number of rows. |
On the right, the row count is shown: N rows when all rows are visible, … / N rows when filtered.
Table columns
When first opened, the Order report table is sorted from newest to oldest order, Order aging from longest waiting package, and Packages without a carrier from oldest order. Clicking a column header sorts by that column; empty values always appear last in both directions. The Bucket column sorts by waiting time; the Status column sorts by the system code, not the Turkish name, so it may not appear alphabetical. For large results, the table scrolls internally and performs smoothly even with thousands of rows.
Order report (one row per product line):
| Column | Meaning |
|---|---|
| Order date | Date and time the order was placed (Istanbul time). |
| Order no / Package no | Order and package numbers. |
| Status | Package status (colored badge). |
| Product name, SKU, Barcode | Product on the line. |
| Qty / Total | Quantity and total amount for the line. |
| Customer, Phone, Email | Customer information. |
| Address, District, City | Delivery address. |
| Carrier, Cargo key, Tracking no | Shipping information. |
| Tracking link | Shipping tracking page; Track link opens in a new tab. |
| Shipped at / Delivered at | When the package was shipped and delivered. |
| Refunded / Cancelled | Shows Yes badge if the line was refunded or cancelled, otherwise No. |
Order aging: Age (days), Bucket, Order date, Order no, Package no, Status, Qty, Carrier.
Packages without a carrier: Order date, Age (days), Order no, Package no, Status, Customer, Phone, Email, Address, District, City.
Empty cells appear as —. Below the table is the note: Times are Istanbul time. Clicking a row opens the package detail. Clicking a row opens that package's detail page in My Orders.
Actions
Exporting (Excel / CSV)
- Press the Export button in the table toolbar.
- Choose the format from the menu:
- Under All results (N rows), select Excel (.xlsx) or CSV (.csv) to download all rows.
- If filters reduce the row count, under Only filtered (N rows), select Excel (.xlsx) or CSV (.csv) to download only the visible rows.
The file downloads immediately. The filename includes the report and range (e.g. siparis-raporu-2026-09-01_2026-09-25). The file columns match the on-screen table; status, bucket, and Yes/No values are in Turkish text. Excel files have proper cell formatting for dates and numbers. CSV files are UTF-8 encoded with semicolon (;) separators; dates are text in Istanbul time; text starting with = has a leading apostrophe (') to prevent Excel formula execution; phone numbers and numbers remain as is.
If there are no rows, Export is disabled. If the Excel file cannot be created, a The file could not be created notification appears; try again after a few seconds or use CSV.
Returning to the catalog
The All reports button to the right of the title returns to the Reports catalog.
Common situations
- "No orders in this range" is shown. You have no orders in the selected range. Choose a different range. In aging, You have no open packages waiting, and in the shipping report, All your open packages have a carrier are good news: no pending work.
- "No rows match the filters" is shown. The report has data but no rows match the search or filters. Press Clear filters.
- "Report could not complete in time" error. The range is too long or there are too many orders. Try a shorter date range.
- "Order service is not responding" error. Press Retry after a while. If the problem persists, share the Technical detail text in the error box with support.
- "Report parameters invalid; check date range." error. Reselect dates and press Run.
- "You do not have permission to view this report." error. Your account lacks permission to run this report; contact your administrator.
- "Order service not defined in this setup." or "Report could not be prepared." errors. The report cannot currently run in this setup. The Retry button reruns the report with the same settings; if the problem persists, share the Technical detail text with support.
- Report appears incomplete. If the warning "Result truncated at … rows" appears at the top, the result is cut at 20,000 rows; split the range into parts.
Related screens
- Reports — Report catalog and scope of each report.
- My Orders — Details and shipping operations for packages in the report.
- My Return Packages — Tracking returned packages.
- My Cancellation Requests — Customer cancellation requests.