Skip to main content

Back Office Item Sales Report

January 9, 2024

Description

How to run an Item Sales report in the Back Office

What's in this article?

The Item Sales report pulls all of your items with sales activity in the selected date range. You can use this report to find out how well specific items are selling over a specific time period. By selecting a single category, you can see how well the items in that category are selling over a specified time period as well. 

To run the Item Sales report

  1. In the Back Office, select Results tab.
  2. Select Reports subtab.
  3. In the left navigation, select Item Sales.
  4. Select your date range.
  5. Select Filter by options from the dropdown list to filter by All Categories (default) or a particular category.
  6. Click the Show Variations button to display any item variations, including their quantity sold. 
  7. Click the refresh icon.

    Item Sales report selections window showing date range field and filter menus

The report shows:

  • The Net Sales Amount per item, which is calculated by multiplying the Avg. Price and the Sold Quantity. Keep in mind the Avg. Price may not always equal the Current Price because of “prompt for price” items and price overrides. 
  • You can also view the Margin for each item, as well as subtotals by category, as well as grand totals.
Fields of information available in the Item Sales report, and their descriptions
FieldDescription
CategoryThe name of the category
Item NameThe name of the item/kit
VariationsThe variations for the item
Current PriceCurrent price of an item
Net Sales: Avg. PriceAverage price of an item
Net Sales: Sold QtyItem sold quantity
Net Sales: Weight QtyItem weight quantity
Net Sales: Amt.Item total sale amount
Net Sales: CostItem cost price
Net Sales: MarginTotal margin sale amount
Did you find this article helpful?