Feefo’s preferred format for importing sales information is a tab-delimited data file encoded in UTF-8. If you're unsure about encoding, see Saving UTF-8 Sales Files.

A sales file can contain many thousands of order lines, with each order line for a given sale having its own separate line in the file. For example, if a sale contains four items, the file needs to contain a header line with four order lines, one for each item, with each line featuring several required fields plus, if needed, any optional ones too.

The following sales file example shows two sales entries with only the required fields listed:

                                                                    
merchant identifiername
email
date
description
order ref
product search code
examplesupplier-comJohn Smithjohnxxxxxx@xxxxxx.com11/01/2010Falcon Mach V92888132
examplesupplier-comHarriet Jonesharrietxxxxxx@xxxxxx.com11/01/2010Konica Minolta Z2092896133

The column headers in the shaded row in the table above need to be included in every sales file but the column order is not important. Clicking on the green text will take you to a more detailed description of each field. The table above lists the required fields and for completeness, the table below lists the optional fields for the same example: 

                                                                                         
gtin
mpn
mobile
parent product ref
feedback date
customer ref
amount
currency
product link
tags
locale
product attributes
721864985325
GO12345OOGLE
+447748123456laptop12/01/2010Reference110GBPhttp://www.exampleretailmerchant.com/product_info.php?products_id=132store=Cardiff,department=ComputersenPerformance,Value,Usability
323456789012
F9A6C544321EBOOK
+447805654321camera12/01/2010Reference215GBPhttp://www.exampleretailmerchant.com/product_info.php?products_id=133store=Petersfield,department=PhotographyfrPerformance,Value,Usability


Where optional fields are included in a file, as for the required fields, the column headers need to be included but the order is not important. Again clicking on the green text above will take you to a more detailed description of each field.

A full explanation of the required and optional fields is given in Sales File Fields Summary.

Sales files can also be sent to Feefo in XML (Extensible Mark-Up Language) format, the structure being similar to the below example. For comparison purposes, this example shows the same data as the combined required and optional sales file example above. Note that ‘locale’ is not an option in XML files and so is not included in the XML example.

<items> 
    <item>
        <name>John Smith</name>
        <email>johnxxxxxx@xxxxxx.com</email> 
        <date>11/01/2010</date>
        <mobile>+447748123456</mobile>
        <feedback_date>12/01/2010</feedback_date> 
        <description>Falcon Mach V</description> 
        <merchant_identifier>examplesupplier-com</merchant_identifier>
        <tags>store=Cardiff,department=Computers</tags> 
        <product_search_code>132</product_search_code> 
        <order_ref>92888</order_ref> 
        <product_link>http://www.exampleretailmerchant.com/product_info.php?products_id=132</product_link>
        <product_attributes>Value,Appearance</product_attributes>
        <amount>10</amount>
        <currency>GBP</currency> 
        <customer_ref>Reference1</customer_ref>
        <gtin>721864985325</gtin>
    </item>
    <item><name>Harriet Jones</name>
        <email>harrietxxxxxx@xxxxxx.com</email>
        <date>11/01/2010</date>
        <mobile>+447805654321</mobile>
        <feedback_date>12/01/2010</feedback_date> 
        <description>Konica Minolta Z20</description>
        <merchant_identifier>examplesupplier-com</merchant_identifier>
        <tags> store=Petersfield,department=Electrical</tags> 
        <product_search_code>133</product_search_code> 
        <order_ref>92896</order_ref> 
        <product_link>http://www.exampleretailmerchant.com/product_info.php?products_id=133</product_link>
        <product_attributes>Value,Appearance</product_attributes> <amount>15</amount>
        <currency>GBP</currency>
        <customer_ref>Reference2</customer_ref>
        <gtin>323456789012</gtin>
    </item>
</items>

Once the sales file is in the correct format, it can be uploaded to Feefo by:

Introduction To Sending SalesSaving UTF-8 Sales Files