In this article we will show you how to better understand your Product sales report data once it has been exported to a CSV file.

If you want to know how to use your Product sales report, you can consult the dedicated article here.

To export the CSV file, click on the Export button above your report and a popup will appear once the download is complete.

 

 

Once downloaded, you will be able to see the information in the spreadsheet.

Note: the export will take into account the filters you’ve applied in the dashboard of the Product report.

 

The CSV file content will be filtered according to the following settings :

  • Training Mode Toggle

  • Period or Time Slot 

  • Stores (in base you have multiple stores)

  • View by either Product / Store / Product Type / Category / Menu / Meal / Sellers / Option / Product With Option 

 

Choosing a ‘view’ of your report is important for the precision of the analysis you need. 

Each row in the spreadsheet represents the sales grouping depending on the information you have selected as shown on the image below : 

  • If you select Product or Store, the sales will be grouped according to these two categories

  • If you choose Menu, the sales will be grouped by Store, Menu and Product sold within the menu

  • If you select Category, the sales will be arranged by Store, Category and Product within this category

  • If you opt for the Meal view, the sales will be arranged by Store, Meal and Products sold within the meal

  • If you select Type, the sales will be grouped by Store, Product Type and Product of this Product type

  • If you select Options, the sales will be grouped by options 

  • If you select Product with options, the sales will be grouped by Product and display options sales within this product.

 



 

CSV extract will include columns with your sales data (Currency, Unit of measure, Quantity, Purchase Price excl Tax, Discounts, Sales incl Tax, Sales excl Tax, Tax amount, Gross Margin). 

(Above table is symbolic.)


Each report includes unique columns to any export (some additional columns can vary depending on the ‘view’ selected): 

Product / option = Name of the Product or Option

SKU = SKU of the Product

Quantity = Quantity sold

Discounts = Total discounts on the product

Purchase Price excl Tax = cost excl Tax of the product x quantity

Sales incl Tax = sum of the sales of the product with Tax Amount with discounts deducted

Sales excl Tax = sum of the sales of the product without Tax Amount with discounts deducted

Tax Amount = sum of the Tax Amount of the sales of the product with discounts deducted

Gross Margin = Sales incl Tax - Costs excl Tax

Net Margin = Sales excl Tax - Costs excl Tax