TABLE OF CONTENTS
Introduction
When preparing your product catalogue for Feefo, it's essential to include the correct fields to ensure smooth data processing. This article outlines the required and optional fields for tab-delimited (TXT) or comma-separated (CSV) files encoded in UTF-8 format. Please note that all field names are case-insensitive, and their order in the file does not impact processing.
Field name for a TXT or CSV file | Required or optional | Brief description |
Product Search Code (SKU) | Required | An identifier for the product |
Title | Required | The name of the product |
Product Description | Optional (Defaults to duplicate the Title if not provided) | The description of the item purchased |
Image Link | Required | The URL to the product's main image |
URL | Optional (Defaulting to your website homepage if not provided) | The URL to the product page for the product |
Merchant Identifier | Required (Unless uploaded directly to the Feefo Hub) | Your unique Feefo identifier |
gtin | Optional (recommended) | The Global Trade Item Number (GTIN) |
*mpn | Optional (recommended if gtin is not supplied) | The Manufacturer Part Number (MPN) |
*brand | Optional (required if mpn is supplied) | The brand name of the product |
Product Category | Optional (recommended) | The Google category of the product |
Parent Search Code | Optional | An identifier for the product's parent search code |
Product Attributes | Optional | A list of additional attributes that the customer can rate for the product |
tags | Optional | A list of service levels for analysing the data |
Importance of GTIN, MPN, and Brand
* = 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.
Product Attributes
Product Attributes are used to extend the single product rating that Feefo requests for products. Rather than just a single rating, you might wish to ask for additional more targeted feedback regarding certain qualities of the purchased items.
Each attribute listed in the product attributes field is separated by a comma which are then shown on the feedback form as separate questions for each attribute. For example, if the product is a t-shirt, you may wish to ask about the fit, colour and quality of materials. In that case, the product attributes field for this product would be:
- Fit,Colour,Quality of materials
Different products can have different attributes. For example:
- A pair of shoes could have the attributes fit, comfort and value for money.
- A washing machine could have the attributes noise, effectiveness of wash and value for money.
- A laptop could have the attributes performance, features, build quality and value for money.
If some products have attributes defined and others don't, only the products with attributes will have the additional questions. Those products without attributes will only display the default product question.
Check out our article to understand Product Attributes more.
Conclusion
Ensuring your product catalogue contains the required and recommended fields, including GTIN, MPN, and brand, can significantly enhance product identification and matching. By incorporating product attributes, you can gather more targeted feedback from customers, resulting in valuable insights to improve your products and services.