TABLE OF CONTENTS

• Introduction
• Downloading the Sample Sales File
• Sales File Structure
• Column Headers and Order
• Required and Optional Fields
• Sales Upload History
• Error Messages  
• Conclusion

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:

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

Sales Upload History

Within the sales upload history and multiple sales upload tab you will see the information related to source, the  progress status and the ability to view or download the file.

1. Log in to your Feefo account.
2. In the left-side navigation bar, click on "Sales".
3. Choose "Sales Upload History."
4. On the right-hand side of the page, you'll find a list of the files uploaded.

Error Messages  

After uploading a sales file, you will be able to see a report highlighting any issues that may have arisen. This includes:

• Calculated Number of orders – This will indicates how many emails will be sent out. 
• Products rejected – This highlights what lines were rejected due to products not being in the product catalog.

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.