TABLE OF CONTENTS


Introduction


Feefo's platform allows you to import sales information to collect valuable feedback from your customers. To ensure smooth processing, Feefo recommends using a tab-delimited (TXT) or comma-separated (CSV) data file encoded in UTF-8 as the preferred format for importing sales data. This article provides an overview of the sales file format, how to download a sample sales file, and the required and optional fields to include in your sales data.



Downloading the Sample Sales File


To get started, Feefo offers a sample sales file that you can download directly from the Feefo Hub. Follow these steps to access the sample sales file:


  1. Log in to your Feefo account.
  2. In the left-side navigation bar, click on "Sales".
  3. Choose "Upload Multiple Sales."
  4. On the right-hand side of the page, you'll find the download link for the sample sales file.


Sales File Structure


A sales file contains multiple order lines, with each line representing a given sale. For instance, if a sale consists of four items, the file should include a header line with four order lines, one for each item. Each order line must include several required fields and may include optional ones if needed.


Below is an example of a sales file with two sales entries, featuring only the required fields:


merchant identifiernameemaildatedescriptionorder refproduct search code
examplesupplier-comJohn Smithjohn@email.com11/01/2010Falcon Mach V
92888132
examplesupplier-comHarriet Jonesharriet@email.com11/01/2010Konica Minolta Z20
92896133



Column Headers and Order


In every sales file, you must include the column headers as shown in the shaded row of the example table above. However, the order of the columns is not critical for successful data processing. Feefo's platform will effectively handle the data regardless of the column order.



Required and Optional Fields


To ensure complete and accurate sales data, you must include the required fields in each order line. Additionally, you have the option to include relevant optional fields when necessary. Click to view the Sales File Field Summary


Note: 

If any errors have been flagged during the upload, you can identify the cause and solution in the handling data upload errors article


Conclusion


Feefo's preferred format for importing sales information through a tab-delimited or comma-separated data file ensures efficient data processing on their platform. By including the required fields and optionally relevant ones, you can collect valuable customer feedback, analyse the data, and make informed decisions to enhance your products and services. Feel free to use the provided sample sales file as a reference when preparing your data. For any questions or assistance, Feefo's support team is available to guide you throughout the process.