Sales Data Import allows you to manually import sales data into Quant, for example from an Excel spreadsheet.

You can find the import in the menu:  Imports → Sales Data.

This import enables you to:

• Import Sales Data for the new period.
• Overwrite sales data in a period in which sales data for products already exists.

Thanks to sales data, you can, for example, compile a number of analyzes in Quant or use them to optimize the layout of the store.

Analysis

1. Preparing the file for import

You can prepare the data that should be imported in Excel file that you can directly import to Quant.

Sales Data Excel File

The file must contain the Primary Product ID, External Store ID, and Date to which the sales data relates. Without any of this data, sales data will not be imported.

2. Process of import

The basic import procedure is described in the figure below:

Import process

For a detailed description of the import procedure, see the Import Procedure manual.

Setting basic criteria is described in the Import Criteria manual.

3. Verification

You can then check whether the data has been imported according to your expectations in the Sales Data Sets Overview analysis, which can be found in the Analyses / Sales Data Sets Overview menu.

Sales Data Sets Overview

You can learn more in the Sales Data Sets Overview manual.

If you want to delete sales data, you can use the tool in the Tools / Remove Sales Data menu, which allows you to either delete entire sales data sets or just part of it for a specific period.

To learn more about removing sales data, see How to remove sales data from Quant? manual.