A NEW ERA OF INTELLIGENT QUANTITATIVE ECOMMERCE - THAT WORKS FOR YOU ECOMMERCE - THAT WORKS FOR YOU
Knowledge Base
+
Admin Messages (1)
+
Common Tasks (1)
+
Insights (1)
+
Interventions (1)
+
Languages (1)
+
Questions & Answers (1)
+
Reviews (1)
+
Site Scripts (1)
+
Web Services (1)

Feed Specifications

How Tos (2)

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:

Feed Specifications Page

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).
  • 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.aspxpage 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.

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)

When you click the Edit button on the FeedSpecifications.aspx page for a feed specification that has been downloaded from IRP World, you will see the following screen:

Edit IRp World Feed Specification

The sections are described in the sections that follow.


IRP World Options Section


Here you can see the following details:

  • IRP World Auto Download Setting: Select the IRP Version you want to view - the Latest version or a Specific version. The version selected will not be saved unless you click the 'Update Feed Specification' button. If you select the option 'Specific...' you can go on to pick a particular version.
  • IRP World Version: Select the IRP Version you want to view. The version selected will not be saved unless you click the 'Update Feed Specification' button.

Feed Specification Details Section


Here you can see the following details:

  • Active: Only Active feeds will be active on the Feeds page.
  • Admin Name: The Admin name of the feed.
  • Country ISO: The country ISO for the feed.
  • Feed Channels: The Feed Channel (required).
  • Feed Types: The Feed type - Product, Stock or Other.
  • Is Facebook Product Feed: If the feed specification is a Facebook Product Catalog Feed. This, along with setting the correct Country ISO above, is essential for Facebook Product Dynamic Ads.
  • Is Google Shopping Feed: This is only used (and required) when Google certified shops is enabled. 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 countryISO.
  • Delimiters / File Type: How the data is delimited - tab (TSV), comma (CSV), pipe or XML (if the SQL in the Feed Specification outputs XML).
  • Include Headers: If the first row of the Feed should contain column names.

Feed SQL Definition Section


This shows the SQL Definition for the Feed.


Copy Into Custom Feed Section


Click the Copy button beside 'Create New Feed'. This will duplicate this feed from IRP World entirely, which will allow you to edit it. The IRP World Feed specification will still be active, but this will allow you to custom the feed specification as well.


Copyright © 2018 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy
IRP Commerce is a Trading Name of Export Technologies Limited, a Deloitte Fast 50 Company six times: 2010, 2011, 2012, 2013, 2014 & 2018   Deloitte.