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

Feed Specifications

The Feed Specification section of the IRP allows you to edit feed details as well as browse or edit the SQL query used to populate the feed.

The FeedSpecifications.aspx page appears as follows:

IRP Admin image

You can see the following details:

  • ID: The unique identifier for the feed specification, added automatically by IRP Admin.
  • Active: Only Active feeds will be active on the Feeds page.
  • Name: The Admin name of the feed.
  • Country ISO: The country ISO for the feed.
  • Type: The feed type - Product, Stock or Other.
  • Delimiter: How the data is delimited - tab (TSV), comma (CSV), pipe or XML (if the SQL in the Feed Specification outputs XML).
  • Columns in First Row: Whether or not this specification has columns in the first row (True/False).
  • Sales Last 30 Days: This is the total value of sales generated by this feed specification in the last 30 days.
  • Created: The date and time when the specification was created.
  • Added From IRP World: Whether or not this specification was added from IRP World (True/False).
  • Version: If available, this is the specific version of the specification.
  • Edit: Click this button to edit a specification. For more details, see the How To Add A New Feed Specification article in this section.

At the top of the page you can use the Download Feed Specifications button. You can click this button to update your specification list with the latest version from IRP World. This works by deleting the feed specifications which no longer exist in IRP World. This will also add any new feed specifications. There is also a 'Download Latest Feed Specifications' Common Task that automates this process. For more details, see the How To Add A New Feed Specification article in this section.

On the FeedSpecifications.aspx page you can see at a glance which specifications have been downloaded from IRP World by checking the 'Added From IRP World' column (True/False) and also the version number. When editing an IRP World feed specification, you can choose a specific version which, when saved, will not be overwritten when the latest version is downloaded via the button or common task but will in fact update the version selected if any changes are made to it.

Saving amount / percentage placeholders

Some feed specifications require a saving amount / percentage column to be displayed. Therefore, you can use the following savings amount and percentage placeholders alongside promotional pricing placeholders:

  • $$FINAL_SAVING$$ (This will always display a 0 if a saving is not available)
  • $$FINAL_SAVING_IF_PRESENT$$ (This will not display a value if a saving is not available)
  • $$FINAL_SAVING_PERCENTAGE$$ (This will always display a 0 if a saving is not available)
  • $$FINAL_SAVING_PERCENTAGE_IF_PRESENT$$ (This will not display a value if a saving is not available)

Notes on Google Shopping Feeds

The IRP can include the following attributes in Feed Specifications. Please contact your Systems Integrator and Google PPC Provider in order to upgrade your Google Shopping feed specifications in conjunction with your Shopping AdWords campaigns.

Season

The IRP includes Model Season as a custom attribute in Feed Specifications to enable grouping in Google Shopping AdWords Campaigns. The possible error values are:

  • NoUrlPartsPresent: The required column 'url_parts' is not present in the data returned.
  • NotInDataSource: 'url_parts' is present but it does not contain a value for 'Season'
  • IncorrectFormat: The value for 'Season' should be a number
  • ValueNotRecognised: The value returned from the data source is a number but does not match a defined value in the IRP. The possible correct values are AllWeather - IRP Default / No Season Set / All Seasons Apply Spring Summer Autumn Winter.

Margin

Values for Percentage Margin and Actual Margin can be included in Feed Specifications for return in Feeds. This provides bid optimization in Google Shopping ad campaigns.

Sales Rank

The IRP can interpret a value into the final output of feeds for a Sales Rank. This allows best-selling products to be identified.

Offer Status

Google Shopping Feed Specifications in IRP have the ability to include the Offer Status of each individual item as a Custom Label. Custom Labels are an excellent way of grouping and optimizing Google Shopping Ad Campaigns.

How To Guides (2)

Close
Close
How To Manually Add A New Feed Specification

To manually add and edit certain features of a feed specification, follow these steps:

  1. Go to Feed Management > Feed Specifications in the IRP Admin left navigation menu.
  2. Click the Add New Feed Specification button.
  3. Select either Download IRP World Feed Specification or Add New Feed Specification.
  4. If you selected 'Download IRP World Feed Specification' you can then select a specific Feed to download using the drop-down list, give it an Admin Name and click the Download Feed Specification button. Once the feed has downloaded, you will be able to edit it, as described for the manual method in the steps that follow.
  5. If you selected 'Add New Feed Specification' , fill in the information as follows:
    • Specification ID: This is the unique identifier for the feed specification and is added automatically by IRP Admin.
    • Active: Check this check box to make the feed active on the Feeds page.
    • Admin Name: Give the feed specification a name.
    • Country ISO: Select the country ISO for the feed.
    • Feed Channel: Select a feed channel.
    • Feed Type: Select a feed type of Product, Stock or Other.
    • Is Facebook Product Feed: Check this box if the feed specification is a Facebook Product Catalog Feed. This, along with setting the correct Country ISO above, is essential for Facebook Dynamic Product Adverts. For more details of how to configure Facebook Dynamic Product Adverts, see the Feeds help topic.
    • Is Google Shopping Feed: This is only used (and required) when Google Certified Shops is enabled via the Enable Google Certified Shops Application Setting. This will set this feed specification to the Google Shopping feed for this country. This must be selected for feeds that are submitted to Google that will be listed in Google Shopping results (this includes search feeds) when Google Certified Shops is enabled. If Google Shopping feeds are set up but not flagged then Google Certified Shops functionality will not work correctly. Only active feed specifications that are submitted to Google with shopping information should have this checked. Only one should be specified for each country ISO.
      NOTE: For more details of how to configure the Google Certified Shops feature, see the Feeds help topic.
    • Google Shopping StockID Suffix: Both Google Shopping feeds and Facebook Product Catalog feeds must include the suffix that is used to identify the stock item. This will be different for each country and is typically the country ISO. This is the value used for the @IdIdentifier parameter in the SQL code below. If no suffix is needed for this feed, this can be left empty.
    • Facebook Product Feed StockID Suffix: Both Facebook Product Catalog feeds and Google Shopping feeds must include the suffix that is used to identify the stock item. This will be different for each country and is typically the country ISO. This is the value used for the @IdIdentifier parameter in the SQL code below. If no suffix is needed for this feed, this can be left empty.
    • Delimiters/File Type: Specify how the data is to be delimited – tab (TSV), comma (CSV), pipe or XML (if the SQL in the Feed Specification outputs XML).
    • Include Headers: Check to specify if the first row of the feed should contain column names.
    • SQL Code: The SQL Definition for the feed (required).
    • Add New Placeholder: Placeholders allow you to place any unique content within feeds – i.e. a standard delivery message or marketing promotion that is relevant to clients on an individual basis. Some feeds allow this – some do not. For example, ‘Free Delivery UK on all Orders’, ‘Summer Sale Now On’. Placeholders will then appear under the feed section when you edit the feed. You will then be able to add the value of the placeholder. Define a Name and a Number for the placeholder and click 'Add Placeholder'.
  6. Click on the Insert Feed Specification button to save your configuration.
Open
How to Edit a Feed Specification Downloaded from IRP World

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