> ## Documentation Index
> Fetch the complete documentation index at: https://help.vori.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Generate a Report of the Top-Selling Items per Department

> Use the Item Sales report to see top-selling items by department or by aisle, section, and shelf across a selected date range.

### 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](https://mintcdn.com/vori/m34ZwSskBSRTrnXJ/images/image-png-may-29-2025-07-15-44-1798-pm.webp?fit=max\&auto=format\&n=m34ZwSskBSRTrnXJ\&q=85\&s=797a39e85ad8452137760cc9bdcd90a9)

3. On the top left of the Item Sales report, set the desired date range.

![Date range selector on the Item Sales report](https://mintcdn.com/vori/m34ZwSskBSRTrnXJ/images/image-png-may-29-2025-07-18-54-4215-pm.webp?fit=max\&auto=format\&n=m34ZwSskBSRTrnXJ\&q=85\&s=e40e325d1759ea9760d56e50285aa7de)

### 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](https://mintcdn.com/vori/L_LZygBrn0sr7mUM/images/item-sales-sort-total-quantity.webp?fit=max\&auto=format\&n=L_LZygBrn0sr7mUM\&q=85\&s=b1ffcca78c190867221baa545e121637)

> [!NOTE]
>
> 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](https://mintcdn.com/vori/L_LZygBrn0sr7mUM/images/item-sales-view-unsold-products.webp?fit=max\&auto=format\&n=L_LZygBrn0sr7mUM\&q=85\&s=51b42ea9aece54237770a6cfab207e22)

### 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](https://app.vori.com/retail/reporting/sales/item-sales-by-location)**.

![Item Sales By Location report with coverage tiles and net sales by aisle charts](https://mintcdn.com/vori/MgBMcybFqdcr_U7c/images/reporting/item-sales-by-location-overview.png?fit=max\&auto=format\&n=MgBMcybFqdcr_U7c\&q=85\&s=33e976830ab0b1800a19595c365d7eb7)

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.

> [!NOTE]
>
> 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](https://mintcdn.com/vori/MgBMcybFqdcr_U7c/images/reporting/item-sales-by-location-items-table.png?fit=max\&auto=format\&n=MgBMcybFqdcr_U7c\&q=85\&s=aace89685d47b5da7e25ea8dde3bad4d)

Export the table to Excel using the download icon above it.


## Related topics

- [Compare Purchases and Sales with Item Sell-Through](https://help.vori.com/reporting/inventory-and-purchase-reports/compare-purchases-and-sales-with-item-sell-through.md)
- [Frequently Asked Questions](https://help.vori.com/faqs.md)
- [View Reports on the Handheld](https://help.vori.com/reporting/sales-and-product-performance/view-reports-on-the-handheld.md)
