IRP Shopper
Common Tasks (1)
Open
Interventions (1)
Open
Languages (1)
Open
Questions & Answers (1)
Open
Reviews (1)
Open
Site Scripts (1)
Open
Web Services (1)
Open
Training Videos
Peer Support

Reports

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.aspx page

The main Reports.aspx page appears as follows:

IRP Reports page

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

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)

Close
Open
How To Add or Edit a Report
Open
How To Use Parameters In Reports
Open
How To Run a Report
Open
How To Download Report Data
Open
How To Add a Report to your Quick Reports
Close
How To Add or Edit a Data Feed Report

You can create reports to allow third parties, who do not have access to your IRP, to access your data. This allows them to access authorised and specific information relating to Customers, Products, Orders and so forth.

These reports tend to be used for smaller bespoke third-party companies as the big companies such as Google, Affiliate Window, Ciao, Clix Galore and so forth are covered in the Feeds section.

To set up a Data Feed Report, follow these steps:

  1. Go to Programming Utilities > Reports in the IRP left navigation menu.
  2. To add a new Data Feed Report, click the Add New Report button at the right side of the page.
    To edit an existing Data Feed Report, click the Edit button at the right side of the report that you want to edit.
  3. Enter or edit the following details:
    SettingDescription
    Report Details
    Report ID The unique IRP identifier for this report. This is generated automatically when adding a report.
    Report Title The title/name used to identify this report within your IRP. We advise that titles include the area and the operation. For example, a report that will return Order Data for the last 24 hours database could be called 'Data Feed - Orders Over Last 24 Hours'.
    Report SQL The Microsoft SQL Code for this report. The format of the Data Feed will be defined by the third party. This will define what fields are required and in order and any other features such as column headers being output, all fields being encased in quotation marks and so forth.
    You must ensure that the data being retrieved by the report is valid and in the correct format. If you have any questions, please contact your Support Team.
    Report Type This should be set to Public.
    Description Description of this report to be displayed to Admin Users.
    Public Download Options
    Allow Download Must be checked for Data Feed Reports.
    Username Used to identify user/system for report. Can be any value (e.g. default) or specific (e.g. affiliateWindow). This will be required in the URL.
    Password Used to identify user/system for report. Can be any value (e.g. defaultPassword) or specific (e.g. affiliateWindowPassword). An optional password for downloading this report. If included, this will be required in the URL. The password provides an opportunity for additional security.
    Format The File Format/Delimitation Method used to separate fields in the file. Note that this field is accessible only  when editing a Data Feed Report.
    Feed URL The public download URL for this Data Feed Report. Note that this field is accessible only  when editing a Data Feed Report.
    Quick Access Users
    Note that this section is available only when editing a report. It allows you to modify which users have access to a report in their Quick Reports panel.
    To grant a user access to this report in their Quick Reports panel, highlight their username in the Non-Added Admin Users column and click the Add >>> button.
    To remove a user's access to this report in their Quick Reports panel, highlight their username in the Added Admin Users column and click the Remove >>> button.
    Quick Reports can be accessed by clicking the button in the bottom navigation of the IRP Admin.
  4. At this point it is a good idea to test that the SQL query is valid and is returning the required information. To do this, click the Run Report button.
    Any errors with the query will be highlighted at the top of the page:
    If the query is valid, it will run and the results will be displayed in the Report Results section once finished. You can then decide if any changes need to be made to the SQL Script.
  5. When you are happy with the current SQL Script, click the Insert Report oar the Update Report button to save it.
  6. You must now copy/update the URL from which the Data Feed can be accessed. Once the report has been saved, click the Edit button at the right side of the report row. Scroll to the Public Download Options section and copy the Feed URL value. Paste the value into an external editor window.
  7. The URL will consist of the following components and will be generated automatically based on the information you have set in the Public Download Options section:
    URL ComponentDescriptionExample
    Domain Your Domain Name with the Feed.aspx path. http://www.yourIRP.com/Feed.aspx?
    Report ID The unique IRP identifier for this report. ReportID=105
    Username The Username defined in the Public Download Options section. &Username=ExampleUsername
    Password The Password defined in the Public Download Options section, if any. &Password=ExamplePassword
    File Name The Name of the File that will be created. This can be modified within the URL. &FileName=reportID105_
    Append Date Whether or not the File Name will have a timestamp added to it. &AppendDateToName=true
    &AppendDateToName=false
    Save Defines whether the data will be output in the browser (false), or downloaded (true). We advise that the default value of 'true' is used. &Save=true
    &Save=false
    Format The Format defined in the Public Download Options section. &Format=comma
    &Format=tab
    &Format=pipe
    File Extension The corresponding File Extension to match the Format defined in the Public Download Options section. &Extension=csv
    &Extension=tsv
    &Extension=txt
    URL Feed Example:
    http://www.yourIRP.com/Feed.aspx?ReportID=105&Username=ExampleUsername&Password=ExamplePassword
    &FileName=reportID105_&AppendDateToName=true&Save=true&Format=tab&Extension=tsv

    Note that you can change these settings as necessary, as long as an accepted value shown in the table above is used, and the feed should be entered as one continuous URL.
  8. Test that the feed works by copying the URL into the address bar of your browser and pressing the Enter key on your keyboard. If the report has been set up correctly and the feed URL is correct, the file should download.
Open
How To Add or Edit an Email Report

Copyright © 2021 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Reporting and Data Requirements, IRP Privacy Policy and IRP Cookie Policy

IRP Commerce Limited, Concourse 3, Catalyst, BT3 9DT, UK. Company Number: NI 041856. VAT Number: GB 888249658
A Deloitte Fast 50 Company eight times: 2010, 2011, 2012, 2013, 2014, 2018, 2019 & 2020