TABLE OF CONTENTS


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 search code

An identifier for the product's parent search code

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

Further Reading


This defines the language of the Feefo emails that you send to a customer including the feedback request email, the merchant response emails and any follow-up emails.


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

Local

Bulgarian

bg

Chinese (Simplified)zh_CN
Chinese (Traditional - Hong Kong)zh_HK
Czechcs
Danishda
Dutchnl
Englishen
English (US)en_US
Finnishfi
French (Canadian)fr_CA
French (European)fr
Germande
Greekel
Hungarianhu
Indonesian*in
Italianit
Japaneseja
Koreanko
Lithuanianlt
Norwegianno
Polishpl
Portuguese (Brazilian)pt_BR
Portuguese (European)pt
Romanianro
Russianru
Slovaksk
Spanishes
Swedishsv
Thaith
Turkishtr

Conclusion


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.