You currently have no notifications!
Close Menu

How can we help you?

Tell us more about your query, we'd be happy to help.
How did you hear about us?:
IRP Shopper
Common Tasks (1)
Interventions (1)
Languages (1)
Questions & Answers (1)
Reviews (1)
Site Scripts (1)
Subscriptions (1)
Web Services (1)
IRP Freshdesk
Training Videos
Peer Support

SQL Editor

You can find this section under Programming Utilities > SQL Editor in the IRP Admin left navigation menu.

This section shares some functionality with the Reports section. You can use the SQL Editor to:

  • Add a Report
  • Edit a Report
  • Run a Report
  • Download Report Data
  • Run SQL

Reports allow you to pull information from your IRP database on any aspect of your IRP instance with a few exceptions for sensitive information such as passwords, card details, and so forth. You can create and run Reports within the IRP or export them as a delimited text file, which can then be opened with your spreadsheet software for formatting and further analysis. To create reports, you will require knowledge of the SQLprogramming language and an understanding of the structure of your IRP’s database.

If your Admin User account has DBA access, you will be able to create and run SQL scripts to pull data from the database quickly.

We strongly advise you speak to your Support Team with regards to setting up and editing Reports or running SQL scripts.

How To Guides (6)

How To Add a Report
How To Edit a Report
How To Download Report Data
How To Run a Report
How To Run a SQL Script
How To Add an Email Report
Live Market Data
Today v Yesterday 0.07%
April 2024 v April 2023 9.60%
YTD 2024 v 2023 13.16%
Arts and Crafts 0.24%
Baby & Child 0.14%
Cars and Motorcycling 1.00%
Electrical & Commercial Equipment 0.23%
Fashion Clothing & Accessories 0.50%
Food & Drink 0.22%
Health and Wellbeing 0.04%
Kitchen & Home Appliances 0.41%
Pet Care 0.31%
Sports and Recreation 0.23%
Toys, Games & Collectables 0.32%

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