Notifications
You currently have no notifications!
Search
Menu
Close Menu
IRP Shopper
Common Tasks (1)
Open
Interventions (1)
Open
Languages (1)
Open
Questions & Answers (1)
Open
Reviews (1)
Open
Site Scripts (1)
Open
Subscriptions (1)
Open
Web Services (1)
Open
IRP Freshdesk
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 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:

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
Open
How To Add or Edit a Data Feed Report
Open
How To Add or Edit an Email Report
Live Market Data
Today v Yesterday 0.55%
March 2024 v March 2023 10.19%
YTD 2024 v 2023 15.62%
Arts and Crafts 0.39%
Baby & Child 0.85%
Cars and Motorcycling 0.97%
Electrical & Commercial Equipment 0.45%
Fashion Clothing & Accessories 0.31%
Food & Drink 0.10%
Health and Wellbeing 0.17%
Home Accessories and Giftware 0.11%
Kitchen & Home Appliances 2.09%
Pet Care 0.77%
Sports and Recreation 0.86%
Toys, Games & Collectables 0.57%
NI ECOMMERCE REPORT - HIDDEN IN PLAIN SIGHT?
NI REPORT - HIDDEN IN PLAIN SIGHT?
Download

Copyright © 2023 IRP Commerce. Use of this website constitutes acceptance of the IRP World Acceptable Use Policy, IRP World Terms of Use, 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