The following sales file fields can be used in tab-delimited (TXT), comma-separated (CSV) and XML files.
Note that field names are case-insensitive in tab-delimited and comma-separated files but case-sensitive in XML files and that all sales files supplied to Feefo must be UTF-8 encoded (see Saving UTF-8 Files for more details).
Click on the links in the table for a more detailed description of each field:
Field name for a TXT or CSV file | Field name for an XML file | Required or optional | Brief description |
merchant identifier | merchant_identifier | Required | Your unique Feefo identifier |
name | name | Required | The customer's name |
email | email | Required | The customer's email address |
date | date | Required | The date of the sale |
description | description | Required | The description of the item purchased |
order ref | order_ref | Required | Your order reference number |
product search code | product_search_code | Required | An identifier for the product |
gtin | gtin | Required (if assigned) | The Global Trade Item Number (GTIN) |
mpn | mpn | Optional (not needed if gtin supplied) | The Manufacturer Part Number (MPN) |
mobile | mobile | Optional | The customer's mobile phone number (UK, US, IE and ZA numbers only) |
parent product ref | parent_product_ref | Optional | An identifier for the product's parent search code |
feedback date | feedback_date | Optional | A specific date on which the feedback for this order should be sent out |
customer ref | customer_ref | Optional | Your customer's reference number |
amount | amount | Optional | The price paid for the item bought |
currency | currency | Optional | The currency of the amount field |
product link | product_link | Optional | The URL to the product page for the product |
tags | tags | Optional | A list of service levels for analysing the data |
locale | [Option not available] | Optional | The customer’s locale |
product attributes | product_attributes | Optional | A list of additional product attributes that the customer can rate for a product |
image link | [Option not available] | Optional | The full URL starting with http or https to the product's main image |