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.
- 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.
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 |
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:
- 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.
- 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.
- 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.