Skip to main content

​
Opening the Item Sales report

  1. In Back Office, select Reports on the lefthand menu.
  2. Within the Reports dropdown, select the Item Sales report.
Reports menu in Back Office with the Item Sales report selected
  1. On the top left of the Item Sales report, set the desired date range.
Date range selector on the Item Sales report

​
Finding the top-selling items

The report is grouped by department and sub-department. Expand a line to see the individual items within it. To find the top-selling products for each department, click the Total Quantity column and select Sort Descending. Total Quantity column menu on the Item Sales report with Sort Descending selected
Products with no sales in the selected date range are excluded from the Item Sales report by default. To see items with no movement, open the View dropdown and switch Sales to Unsold Products.
View dropdown on the Item Sales report showing Sales and Unsold Products options

​
Viewing item sales by location

The Item Sales By Location report shows the same item sales grouped by aisle, section, and shelf instead of department. It uses each product’s primary location at the time of the sale, so you can still compare performance before and after moving a product to a new spot on the floor. Open it from Reports > Item Sales By Location. Item Sales By Location report with coverage tiles and net sales by aisle charts Filter by Date range, Department, or a specific Location (aisle or section). Four tiles summarize how well your location data covers your catalog and your sales:
  • Item Location Coverage — the percentage of your products that have a primary location assigned.
  • Items Without a Location — the count of products with no primary location assigned.
  • Sales Location Coverage — the percentage of net sales in the date range that came from located products.
  • Located Items With No Sales — the count of located products that didn’t sell during the date range.
Sales from products without an assigned primary location appear under No location throughout the report. Assign a primary location to a product to start attributing its sales to a specific aisle, section, or shelf.
The Net Sales by Current Primary Aisle chart breaks down net sales and share of sales by aisle, and Located Items With No Sales by Primary Aisle shows which aisles are holding the most located products that didn’t move during the period. The Items by Location table groups results by Aisle, Section, and Shelf (and by store, if you’re viewing at the banner level). Expand a row to see the individual products stocked there, along with Department, Sub-department, Units Sold, Net Sales, COGS, Margin ($ and %), On Hand quantity, and Additional Locations (how many other shelf locations also carry that product). Items by Location table expanded to show products under an aisle, section, and shelf Export the table to Excel using the download icon above it.