Sales File Field Summary

TABLE OF CONTENTS

Introduction
Required Fields
Optional Fields
Further Reading
Summary

Introduction

Feefo provides a straightforward method for importing sales information through tab-delimited (TXT) or comma-separated (CSV) data files, both of which should be UTF-8 encoded. This article aims to explain the various sales file fields you can use when uploading your sales data to Feefo's platform. Understanding these fields will ensure the smooth processing of your sales information, allowing you to collect valuable feedback from your customers.

Field names are in tab-delimited and comma-seperated files. All files must be UTF-8 encoded.

Required Fields

The following fields are required in your sales file:

Merchant Identifier: Your unique Feefo identifier. This informs the system which account the data should be uploaded to. To find your Merchant ID, click on your name in the top right corner of the Feefo Hub, where you'll find this information.

Field name for a TXT or CSV file	Brief description	Key points	Required or Optional
merchant identifier	Your unique Feefo identifier	This column tells the system which account to upload the data to. This will be the same for each line of data. To find your Merchant ID, click on your name in the top right corner of the hub where you'll find this information.	Required (optional if uploaded directly to the Feefo Hub or to a SFTP location for your single Feefo account.)
name	The customer's name	N/A	Required
email	The customer's email address	N/A	Required
date	The date of the sale/transaction	N/A	Required
description	The description of the item purchased	This column can be left blank if it’s not needed, although the header of the column will still need to be present.	Required
product search code	An identifier for the product	This is the SKU or ID number that you use to identify the product in your business. This is used to categorise the product reviews together and ensures that the right reviews are displayed on your website’s product pages. (If you’re only collecting service reviews, you can copy and paste the description). You can’t leave this field blank.	Required (If a product search code/SKU has been provided to Feefo with accompanying product information, such as URL, image, title, it will not need to be provided a second-time. Instead, Feefo can support the Product Search Code on a sale line alone, looking up the rest of the previously mandatory information.)

Optional Fields

In addition to the required fields, you have the option to include the following fields, based on your data needs:

Field name for a TXT or CSV file	Brief description	Required or Optional
order ref	Your order reference number	Optional, but strongly recommended. A randomised value will be provided otherwise.
gtin	The Global Trade Item Number (GTIN)	Required if assigned
mpn	The Manufacturer Part Number (MPN)	Optional (not needed if gtin supplied)
mobile	The customer's mobile phone number. This should be in the international format starting with a ‘+’, e.g. +447111111111 (UK, US, IE and ZA numbers only). If used, this column must be formatted as 'Text' to ensure the + symbol remains.	Required if assigned
parent product ref	An identifier for the product's parent reference	Optional
feedback date	A specific date on which the feedback for this order should be sent out	Optional
customer ref	Your customer's reference number	Optional
amount	The price paid for the item bought	Optional
currency	The currency of the amount field	Optional
product link	The URL to the product page for the product	Optional
tags	A list of service levels for analysing the data	Optional
locale	The customer’s locale	Optional
product attributes	A list of additional product attributes that the customer can rate for a product. Read more	Optional
image link	The full URL starting with http or https to the product's main image	Optional

As each line in a sales file can have a single locale defined, one sales file can upload sales data for customers with different locales resulting in the correct language emails being sent to each customer. If a sale does not have a locale defined or the value entered is not supported or is invalid, then those sales will use the language and country defined by a campaign, via Campaign Preferences.

If you're adding a locale value, be sure that the relevant language template within the campaign has also been updated, so your customers can see the emails as intended.

Locales supported for defining the language of Feefo emails are:

Language	locales
Bulgarian	bg_BG
Catalan (Spain)	ca_ES
Czech	cs_CS
Danish	da_DK
German	de_DE
Greek	el_GR
English (UK)	en_GB
English (US)	en_US
Spanish	es_ES
Finnish	fi_FI
French (Canada)	fr_CA
French (France)	fr_FR
Croatian	hr_HR
Hungarian	hu_HU
Indonesian	in_ID
Italian	it_IT
Japanese	ja_JP
Korean	ko_KP
Lithuanian	lt_LT
Latvian	lv_LV
Dutch	nl_NL
Norwegian	no_NO
Polish	pl_PL
Portuguese (Brazil)	pt_BR
Portuguese (Portugal)	pt_PT
Romanian	ro_RO
Russian	ru_RU
Slovak	sk_SK
Swedish	sv_SV
Thai	th_TH
Turkish	tr_TR
Chinese (China)	zh_CN
Chinese (Hong Kong)	zh_HK
Welsh	cy_GB

Summary

By understanding the sales file fields and including the required information in your tab-delimited or comma-separated data files, you can effectively import sales data into Feefo's platform. This process enables you to collect valuable feedback from your customers, allowing you to analyse the data and make informed decisions to enhance your products and services. If you have any questions or need assistance, Feefo's support team is available to guide you through the process and ensure a successful sales data upload.