IRP Service Marketplace

Service Marketplace (1)

IRP Shopper

Admin Users (2)

Advanced Pricing (3)

Application Settings (14)

Common Tasks (1)

Customers (5)

Data Imports / Exports (10)

EPOS (15)

Integration (4)

Interface & Design (25)

Interface Translations (9)

Interventions (1)

Languages (1)

Live Chat (4)

Loyalty Schemes (3)

Orders (12)

Payment Processing (16)

PPC & SEO (13)

Price Adjustments (2)

Price Match (2)

Products (17)

Programming Utilities (3)

Promotions (4)

Questions & Answers (1)

Referrals (2)

Reviews (1)

Search (5)

Security (6)

Server Management (12)

Shipping (11)

Site Help (2)

Site Scripts (1)

Statistics (4)

Stock Control (11)

System Logs (3)

Telesales (3)

Trade Site (8)

Web Services (1)

IRP Marketing Cloud

Email Marketing (10)

Feed Management (6)

Orders Tracking (3)

IRP Marketplaces

Marketplaces (5)

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:

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.

Tags:

Feed Specifications

Feed Management

How To Add A New Feed Specification

First Row Contains Columns

Delimiters

Feed Types

SQL Definition

Google Certified Shops

Google Shopping Feed

Facebook Product Feed

Facebook Dynamic Product Adverts

Is Google Shopping Feed

Google Shopping StockID Suffix

Download XML Feeds

Download Feed Specifications From IRP World

Columns In First Row

Added From IRP World

IRP World Auto Download Setting

Feed SQL Definition

Notes on Google Shopping Feeds

Offer Status in Google Shopping Feeds

Margin in Google Shopping Feeds

Season in Google Shopping Feeds

Sales Rank in Google Shopping Feeds

Saving Amount / Percentage Placeholders in Feed Specifications

How To Guides (2)

How To Manually Add A New Feed Specification

Copy URL

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

Go to Feed Management > Feed Specifications in the IRP Admin left navigation menu.
Click the Add New Feed Specification button.
Select either Download IRP World Feed Specification or Add New Feed Specification.
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.
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'.

Click on the Insert Feed Specification button to save your configuration.

How to Edit a Feed Specification Downloaded from IRP World

Copy URL

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:

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 country ISO.
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.