This article introduces Feefo's product catalogue and its schema, and provides instructions for creating, validating and uploading the file to the Feefo Hub.

A product catalogue is a file that contains a list of products and associated meta data. Customer purchases are submitted to Feefo and once uploaded, the products from the sale are matched to products in the product catalogue. If a match is made, the sale data is enhanced with the appropriate meta data resulting in a graphical and content-rich description throughout the Feefo Hub, in consumer emails and all reports. The available data fields are:

  • Product image.
  • Product title.
  • Product description.
  • Product category.
With the meta data in place, users of the Feefo Hub and consumers alike will benefit from product information similar to:
If you are planning any of the following advanced editing/data management operations, the solution is to use a product catalogue to:
  • Append additional data to sales that have already been uploaded to Feefo.
  • Bulk update product descriptions, tags, parent SKUs, URLs or product images.
  • Handle underlying SKU, URL, product image or other metadata fields when moving from one ecommerce platform to another.
  • Grouping or splitting up of existing reviews.

To find out more, please contact our Technical Team.

Every product in the catalogue is entered as a single line of data. Some of this data is required, some optional. The following product catalogue example shows two product entries with only the required fields listed.

Being required fields, all column headers must be included in every product catalogue but the order is not important. See the Product Catalogue Field Summary for a summary of both required and optional fields or click on the header links (in green) to see details for an individual field.         

product search code
title
description
image link
product link
merchant identifier
F-132
Feefo Short Sleeved Polo Shirt
Luxury Feefo polo shirt in black with yellow logo and tags
http://www.exampleretailmerchant.com/
mediafiles/F132hires.jpg
http://www.exampleretailmerchant.com/
item.aspx?id=F-132
example-retail-merchant
F-133
Feefo Long Sleeved Shirt
Luxury Feefo long sleeved shirt in yellow with black logo, pocket and edging
http://www.exampleretailmerchant.com/
mediafiles/F133hires.jpg

http://www.exampleretailmerchant.com/
item.aspx?id=F-133
example-retail-merchant

For completeness, the table below lists the optional fields for the same example. Where optional fields are included, even if it's just for one product, the column header needs to be included but the order is again not important. The headers also link to more details.                         

        
*gtin
*mpn
*brand
*product category
parent product ref
product attributes
tags
721864985000
FEE92365482
Feefo
Clothing > Mens > Polos > Black
polo shirt


Colour,Size,Value


colour=black,fabric=cotton
323456789976
FEE67420741
Feefo
Clothing > Mens > Shirts > Yellow
long sleeved shirt


Colour,Size,Value


colour=yellow,fabric=polycotton
* = Product catalogues that include globally recognised product naming identifiers such as gtin, mpn and brand, and support Google's product categorisation, offer additional identification and matching benefits that Google uses when adding stars. These fields will also become more important in Feefo's future releases so although not required at present, we recommend that they are populated for each product. 

Some product catalogue fields can be included when uploading sales files. If the same field for the same product has a different value in the sales file and product catalogue, the product catalogue values take precedence.

Once the product catalogue is complete:

  1. Check the file:
    • Ensure that all purchasable products are listed in product catalogue. 
    • Check that all products have data for the 'required' fields and verify if any optional fields are also needed.
    • Make sure there are no duplicate product search codes.
    • All fields are formatted as text and not numbers.
    • Verify that URLs are formatted correctly with each product link/image link having the correct http or https prefix.
    • Blank rows are not acceptable between products. 
    • Save the product catalogue as a UTF-8 TXT/CSV file.
  2. Validate all content in the product catalogue:
    • Login to the Feefo Hub.
    • Select Products > Manage Manual Catalogue.
    • Select Validate Only.
    • Select Browse and choose the product catalogue UTF-8 TXT/CSV file.
    • Ensure the validation completes without error and displays the ''File Name uploaded successfully" message.
    • If validation fails, repeat the above checks and verify that everything has been edited correctly. If the reason for failure cannot be found, contact our Technical Team.
  3. Upload the validated product catalogue:
    • In the Feefo Hub, select Products > Manage Manual Catalogue.
    • Select Validate and Upload.
    • Select Browse and choose the product catalogue UTF-8 TXT/CSV file.
    • Ensure the upload completes without error and displays the ''File_Name uploaded successfully" message.
This completes the Product Catalogue article.