A NEW ERA OF INTELLIGENT QUANTITATIVE ECOMMERCE - THAT WORKS FOR YOU ECOMMERCE - THAT WORKS FOR YOU
Knowledge Base
+
Admin Messages (1)
+
Common Tasks (1)
+
Insights (1)
+
Interventions (1)
+
Languages (1)
+
Questions & Answers (1)
+
Reviews (1)
+
Site Scripts (1)
+
Web Services (1)

Reports

How Tos (7)

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, Private Sales 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.

Reports Screen

The main Reports.aspx screen appears as follows:

IRP Reports screen

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 Screen

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: Quick Access Reports button. When you click the button you see the main Quick Access Reports lightbox:

Reports Quick Access Panel

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.



How To Guides (7)


Copyright © 2018 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy
IRP Commerce is a Trading Name of Export Technologies Limited, a Deloitte Fast 50 Company six times: 2010, 2011, 2012, 2013, 2014 & 2018   Deloitte.