Notifications
You currently have no notifications!
Search
Menu
Close Menu

How can we help you?

Tell us more about your query, we'd be happy to help.
Reference:
How did you hear about us?:
 *
 *
 *
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

Import Reviews

You can find this section under Data Imports/Exports > Import Reviews in the IRP Admin left navigation menu.

You use this section to import product reviews in bulk to the IRP. This is a useful feature in IRP as it allows you to import large numbers of reviews effortlessly. All you need to do is complete a template file and then upload it to the IRP.

Note that some details are required — you need at least ONE of: country, language, model, name, rating or review.

When you have completed the straightforward process of configuring the template, you can stage and upload the data with the click of a button.

Overview video

Note: Currently videos are not maintained in line with each software release and therefore features may work slightly differently from the way they are shown.

DataImportReviews.aspx page

The DataImportReviews.aspx page appears as follows (note that this shows a staged data file and your screen will look different if you have not yet uploaded a data file):

Import Reviews

As shown in the screen capture above, there are two tabs:

  • Import Reviews: You use this tab to upload your completed reviews file, stage the data and then import it to the IRP.
  • Create Template Import File: You use this tab to set up and download a template file for importing the reviews.

For more details, refer to the How To Import Reviews article in this section.

How To Guides (1)

Close
Close
How To Import Reviews

To import reviews in bulk, follow these steps:

First, create the review template file:

  1. Go to Data Imports/Exports > Import Reviews in the IRP Admin left navigation menu.
  2. Click the Create Template Import File tab.
  3. The Download Template File screen appears - you can download either a custom template file or select the columns to appear in the template file:
    • Download Custom Template File: These template files contain the key fields associated with IRP review data. Use the radio buttons to download a template file with your review data in the columns or without your review data (blank). Any data will come directly from your IRP. You can download the files in one of the following formats:
      • CSV (Comma Delimited Text File)
      • TSV (Tab Delimited Text File)
      • Pipe (Pipe Delimited Text File)
      • XLSX (Microsoft Excel 2007 - ) Note that, for files containing in excess of 20000 rows, it is often more efficient to use a flat file (.tsv, .csv or .txt) rather than a Microsoft Excel file.
    • Select Columns for Template File: You can customise these template files by selecting fields from the database tables. Alternatively you can check the Select All Columns box. You MUST include prerequisite fields in the file. Any data will come directly from your IRP. You can download the files in one of the following formats:
      • CSV (Comma Delimited Text File)
      • TSV (Tab Delimited Text File)
      • Pipe (Pipe Delimited Text File)
      • XLSX (Microsoft Excel 2007 - ) Note that, for files containing in excess of 20000 rows, it is often more efficient to use a flat file (.tsv, .csv or .txt) rather than a Microsoft Excel file.
    • Use the 'Date From' and 'Date To' boxes to restrict the file to only include records created during this date range.
    • Click the Download button when you are finished.
    • You can then edit the data in the file, as necessary, and save it for staging and importing.

Next, upload the review template file and stage the data temporarily before fully importing it:

  1. Click the Import Reviews tab.
  2. The Upload Reviews screen appears, as follows:
    Import Reviews
  3. In Step 1: Upload and Stage Reviews Import File, click the Browse button to find the file that you created earlier.
  4. Click the Upload and Stage button to upload the file to the IRP and stage the data.
  5. In the Step 2: Reviews Import Options section, configure the following settings:
    • Language where not Specified: If you didn't specify a language ISO in the uploaded template file, the language that you select here will be set against the imported data set.
    • Country where not Specified: If you didn't specify a country in the uploaded template file, the country that you select here will be set against the imported data set.
    • Name where not Specified: If you didn't specify a name in the uploaded template file, the name that you select here will be set against the imported data set. If no name is available, you should use 'Anonymous'.
    • Whether to import new Reviews as 'Approved' or leave them in the holding stage of 'Unapproved' where the Approved Status has not been specified. Reviews will NOT appear on the website's front-end unless they have been approved.
  6. At the bottom of the screen, the Sample of Staged Reviews section shows the details from the staged data set. This includes all of the columns that you selected for the data set when you created the template.
  7. Back up at the Import Staged reviews section, click the Import Reviews button to import and display the reviews on the IRP:
    Import Reviews button
Live Market Data
Today v Yesterday 1.06%
April 2024 v April 2023 9.71%
YTD 2024 v 2023 13.21%
Arts and Crafts 0.39%
Baby & Child 0.05%
Cars and Motorcycling 0.16%
Electrical & Commercial Equipment 0.04%
Fashion Clothing & Accessories 3.53%
Food & Drink 1.38%
Health and Wellbeing 2.23%
Kitchen & Home Appliances 0.23%
Pet Care 0.42%
Sports and Recreation 0.16%
Toys, Games & Collectables 0.77%

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