You can find this section under Programming Utilities > Reports in the IRP Admin left navigation menu.
Reports allow you to pull information from your IRP database on any aspect of your IRP instance, including Models, Stock, Orders, Admin Users, Discounts, Vouchers and so forth. You can create and run reports within the IRP or you can export them as a delimited text file which you can then open with your spreadsheet software for formatting and further analysis.
Note that to create reports, you will require:
- Knowledge of the SQL programming language.
- An understanding of the structure of your IRP’s database.
Some examples of reports include:
- Best selling products over date range.
- Customers who have ordered from a specific category over date range.
- Orders in which a particular voucher code was used.
- Active models with inactive stock items.
- Update model details in bulk.
This list is in no way exhaustive — you can access and update all aspects of your IRP in this section (with a few exceptions for sensitive information such as passwords, card details and so forth). We strongly advise you to speak to your Support Team with regards to setting up and editing reports.
You can use the Reports section to:
- Search for existing reports in the IRP
- Add a new report
- Edit an existing report
- Run a newly-created or existing report
- Download report data for subsequent processing in your spreadsheet application
- Add reports to the ‘Quick Reports’ panel. This allows you to quickly find and run reports that you use on a frequent basis.
Note that email reports are also one of the Segmentation features in the IRP Marketing Cloud (M-Cloud) section.
Reports.aspx page
The main Reports.aspx page appears as follows:
You can use the Search bar to find any existing report. You can search by Report ID and, if one is found, you will automatically be directed to the edit page for the report. If you expand Other Options you can filter by Report Type (Unknown, Private, Public, Delete Insert Update, Correction, Email, System, TradeTalk or All).
The main grid shows any existing reports in your system. From here you can run, download or edit reports. See the How To articles in this section for more information.
Quick Access Reports page
You will not see the ‘Quick Reports’ panel until you have added your name to at least one report in the ‘Quick Access Users’ section of the ReportEdit.aspx page (see the How To Add a Report to your Quick Reports article for details). When you have added your name as a Quick Access User, the Reports button appears in the bottom nav of IRP Admin: . When you click the button you see the main Quick Access Reports window:
SQL parameters
You can create parameters for use in your reports. This can make it easier for other Admin Users to quickly configure and update reports. For details, see How To Use Parameters In Reports.
Track when reports were processed by a third party
Functionality is included to track when the last successful processing of a report was carried out by a third party. A parameter called 'UpdateLastProcessedTime', set to true, can be added to a report Feed URL. This will update the report by setting the 'Last Successful Third Party Processing' field to the current time. A success message will be displayed on update. In the case that an error occurs, an error message will instead be displayed.